Unable to run large reports in DSP.
Issue:
When running very large reports in DSP, users are being logged out.
While running a couple of reports with over 700,000 records, DSP logs everyone out. However, the reports generated the correct number of records. Each report has about 20 columns and the file size is approximately 50 MB each.
Root Cause:
The IIS process is running out of memory due to limitations with IIS and moving bulk data. Typically, System.OutofMemory exceptions are observed within the Windows Application Log.
Resolution:
Run the reports in the background.
Running the reports in the background can be done by going to the vertical of an individual report and use the "Process" button which will submit just that report or rule in to the background queue rather than as a foreground job.
Additional note:
Generation of .xls formatted reports requires a large amount of memory. It is highly recommended to use .csv format instead.