Q - I received the following error when running the line item auditing report for 1/1/15 to 11/30/15 for only the WEB-USER account:
Exception of type 'System.OutOfMemoryException' was thrown.
See example below. What should I do?
A - This report is over 10,000 pages. This kind of problem can occur when you have a large report like that. What happens is that our Report Viewer (.Net code) makes a memory request to the OS to load the report into the memory and the OS gives an error code of insufficient memory back to our .Net code. That's what you see here. If you restart your machine, there's a chance you can load this report into the report viewer again. This is because the OS may have a bigger continuous memory block after the reboot.
The other alternative is to use Notepad to look at the report. We have noticed that Notepad can handle memory better and is less likely to run into an insufficient memory issue. See the following example for using NOTEPAD to view the report: