Recently a client of ours reported an issue with reports (Standard NAV Reports).
1. The rows received was always at 0.
2. After a while (approx 1:20 minutes), NAV threw an error which stated The Server "ServiceName" was unable to process the request. The application will close.
Googling the error showed this usually arises due to Language settings being other than En-US. We found out that both the Server and Client machines were set to the default language (En-US).
On investigating, we found out that some of the customized reports ran smoothly without any errors. Further investigation lead to Integer DataItem being the problem.
We took a standard NAV Report (Customer Top 10) which did not run, we made a copy of it to run tests. I then deleted the Integer DataItem and it was able to run again.
I tried to run Integer table (via Page) and it hung up but I was able to run it locally in my PC. What is the cause for this issue? How can it be resolved?