OutOfMemoryException at Export method

Hi Community

Our application builds reports via Crystal Report Server 2013 (latest SP) and .NET SDK (Business Objects 4.1).

Sometimes when there are too much data (> 1 500 000 records) to be returned in the report we see error like that:

System.OutOfMemoryException: Not enough storage is available to complete this operation.

at CrystalDecisions.ReportAppServer.Controllers.PrintOutputControllerClass.Export(CrReportExportFormatEnum exportFormat, Int32 Reserved)

at ReporterEngine.ReportObject.CrystalReport.ExportToMemory()

We know that storage is OK (and there is no problem with RAM) .

Restarting SAP Crystal Report Server sometimes helps to avoid error.

Can it be related to the fact that Crystal Report Server 2013 is 32 bit?

Does exist legible limitation for the data volume in report?

Could we adjust some settings to be able generate larger reports?

Regards

Ofir

former_member11696 · ‎2020 Aug 10

Often it's due to the export format, for example XLS can only handle 65k file size.

what are you actually going to do with that much data in one report....

1.5 million rows of data is a lot, look at filtering more and breaking the report into smaller parts..

It's not really out of memory, sort of. depends on a lot of factors.

Short story is don't use CR for archiving data, the DB Server is much better at doing that.

Former Member · ‎2020 Aug 25

Hi don.williams, would you answer my 2nd question please.

Former Member · ‎2020 Aug 12

Don, thank you very much for the answer.

But in order to provide reasonable answer to our customer could you tell a few more words about

"It's not really out of memory, sort of. depends on a lot of factors."

What are these factors? We need substantiate somehow the fact that there is no specific the boundary at which it begins throw OutOfMemoryException.