LEDGER REPORT - RTC STOP WORKING - RECORDS MORE THAN 2.5 LAC
Ravi_Thakkar
Member Posts: 392
Hello All,
I am having a Database having more than 3 LACs of records for Printing in Ledger Report just for 1 Month Entries.
RTC is not able to view the report due to these much entries and showing an error as shown in attachment.
In Classic, getting 940 Pages.
Any suggestion regarding this?
I am having a Database having more than 3 LACs of records for Printing in Ledger Report just for 1 Month Entries.
RTC is not able to view the report due to these much entries and showing an error as shown in attachment.
In Classic, getting 940 Pages.
Any suggestion regarding this?
0
Comments
-
Refer to NAV 2009 SP1 Release note(This might not be the exact case you are facing but might be related):
Large reports can cause RoleTailored client to consume excess memory and then stop responding
Description: An enhancement was added to resolve an issue where large reports were causing Microsoft Dynamics NAV Server to stop responding. As a result, Microsoft Dynamics NAV Server is now stable when processing large reports. However, the RoleTailored client can now consume enormous amounts of memory when processing a large report and then stop responding.
An example is report 1001, Inventory Valuation. The design of this report requires all value entries to be sent to the client to produce the report. In processing a test database with 155,000 value entries, which is not especially large when compared to many production databases, the RoleTailored client required 1.4 GB of memory to hold the dataset in memory. The spooling process took 11 minutes. When the client finally tried to render the output, it stopped responding with no warning. Depending on what other processes are running, the report often cannot consume all rows and instead stops as the dataset is being sent to the client.
The Classic client renders this report in approximately one minute. The actual report is 10 pages long.
Workaround: Run large reports on the Classic client.CA Sandeep Singla
http://ssdynamics.co.in0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 610 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 253 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions