Out of Memory Exception Errors
Posted: Wed Oct 16, 2013 9:38 pm
We are getting the below error when exporting some of our reports to excel. We also get an 'OutOfMemoryException' error when we're running the report without exporting to excel also.
The report is big, the number of records returned is 100,000. We have switched on ReportCacheMode as well, to no avail.
We are using Stimulsoft version 2011.
What can we do to avoid getting this error?
Thanks
System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
at System.IO.MemoryStream.set_Capacity(Int32 value)
at System.IO.MemoryStream.EnsureCapacity(Int32 value)
at System.IO.MemoryStream.Write(Byte[] buffer, Int32 offset, Int32 count)
at Stimulsoft.Report.Export.StiExcelExportService.AddRec(Int32 com, Int32 len)
at Stimulsoft.Report.Export.StiExcelExportService.MakeWorksheetStream(StiPagesCollection pages)
at Stimulsoft.Report.Export.StiExcelExportService.MakeMainStream(StiReport report, StiPagesCollection allPages)
at Stimulsoft.Report.Export.StiExcelExportService.ExportExcel(StiReport report, Stream stream, StiExcelExportSettings settings)
at Stimulsoft.Report.Export.StiExcelExportService.ExportExcel(StiReport report, Stream stream)
The report is big, the number of records returned is 100,000. We have switched on ReportCacheMode as well, to no avail.
We are using Stimulsoft version 2011.
What can we do to avoid getting this error?
Thanks
System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
at System.IO.MemoryStream.set_Capacity(Int32 value)
at System.IO.MemoryStream.EnsureCapacity(Int32 value)
at System.IO.MemoryStream.Write(Byte[] buffer, Int32 offset, Int32 count)
at Stimulsoft.Report.Export.StiExcelExportService.AddRec(Int32 com, Int32 len)
at Stimulsoft.Report.Export.StiExcelExportService.MakeWorksheetStream(StiPagesCollection pages)
at Stimulsoft.Report.Export.StiExcelExportService.MakeMainStream(StiReport report, StiPagesCollection allPages)
at Stimulsoft.Report.Export.StiExcelExportService.ExportExcel(StiReport report, Stream stream, StiExcelExportSettings settings)
at Stimulsoft.Report.Export.StiExcelExportService.ExportExcel(StiReport report, Stream stream)