Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 262 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Integer DataItem issue
Kratos3064
Member Posts: 14
Hi,
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?
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?
0
Answers
The reason why it runs on your local machine could be that the server the dynamics nav instance runs on is limited in available ram
We have a TEST DB for the customer on the same environment and the reports run smoothly. Can this be some sort of application run-time issue for the current DB?
Thanks for the chart explaining it to me. It used to run, it stopped all of a sudden.
Edit: We've tried calling the table in a CU. Any form of setrange/setfilter on Integer table is not working.