Posted 16 June 2020, 2:59 am EST - Updated 30 September 2022, 8:07 am EST
Hello I have a page report that runs out of memory when grabbing data that spans about 5 days before giving an out of memory error but the report needs to grab data for an entire month. It’s a rather large report containing 67 columns where a month typically can contain 150k rows of data.
I have seen release notes from previous releases addressing out of memory errors. My question is whether you know that one of the previous releases addresses this specific memory limitation?
This is the error that appears after 57 pages are generated in the report (screenshot included):
Exception details:
GrapeCity.ActiveReports.ReportException: An unexpected error occurred. Additional information: ‘Exception of type ‘System.OutOfMemoryException’ was thrown.’ —> System.OutOfMemoryException: Exception of type ‘System.OutOfMemoryException’ was thrown.
at GrapeCity.ActiveReports.Rendering.Components.TextBox.#Qm0()
at GrapeCity.ActiveReports.Rendering.Components.TextBox.get_CanSort()
at GrapeCity.ActiveReports.Layout.Utils.#YTz(ITextItem textBox, Boolean supportsInteractivity, Boolean supportsInteractiveSorting)
at #sxA.#xhQ.#nNh(ITextContentRange range, String contentText, Single boundWidth, Single boundHeight, Single minHeight, DeviceCaps caps, ITextMetricsProvider rootProvider)
at GrapeCity.ActiveReports.Layout.L2.TxtImpl.<>c__DisplayClassb7
1.#pw0(Int32 vspace) at GrapeCity.ActiveReports.Layout.L.<>c__DisplayClass2a
2.#tdW(Int32 space)at GrapeCity.ActiveReports.Layout.L.<>c__DisplayClass30
2.#vdW(Int32 space) at GrapeCity.ActiveReports.Layout.GridImpl.<>c__DisplayClass3b
1.#WfX(Int32 space)at GrapeCity.ActiveReports.Layout.L.<>c__DisplayClass12
2.#kdW(Int32 space) at GrapeCity.ActiveReports.Layout.L.<>c__DisplayClass2
2.#fdW(Int32 space)at GrapeCity.ActiveReports.Layout.L.<>c__DisplayClass2
2.#fdW(Int32 space) at GrapeCity.ActiveReports.Layout.L.<>c__DisplayClass5d
2.#35V(Int32 space)at GrapeCity.ActiveReports.Layout.L.<>c__DisplayClass2
2.#fdW(Int32 space) at GrapeCity.ActiveReports.Layout.L.<>c__DisplayClass2d
2.#udW(Int32 size)at GrapeCity.ActiveReports.Layout.L.<>c__DisplayClass2d
2.#udW(Int32 size) at GrapeCity.ActiveReports.Layout.L.<>c__DisplayClass73
1.#gnX(Int32 space)at GrapeCity.ActiveReports.Layout.L2.CanvasImpl.<>c__DisplayClass79
2.#bw0(Int32 space) at GrapeCity.ActiveReports.Layout.L.<>c__DisplayClass30
2.#vdW(Int32 space)at GrapeCity.ActiveReports.Layout.L.<>c__DisplayClass30
2.#vdW(Int32 space) at GrapeCity.ActiveReports.Layout.LayoutExtensions.#U.#Fw0.MoveNext() at System.Linq.Enumerable.<SelectManyIterator>d__14
2.MoveNext()at GrapeCity.ActiveReports.Extensions.EnumerableExtensions.d__13
2.MoveNext() at #sxA.#S2e.#WQA(ITargetDevice targetDevice, IEnumerable
1 pages, LayoutNotificationCallback callback)at GrapeCity.ActiveReports.Layout.LayoutEngine.BuildLayout(LayoutInfo layoutInfo)
at #GPr.#RLf.#NNf(IReport report, TargetDeviceCapabilities targetDevice, LayoutNotificationCallback callback)
at GrapeCity.ActiveReports.Export.Image.Page.ImageRenderingExtension.Render(IReport report, StreamProvider streams, NameValueCollection settings)
at GrapeCity.ActiveReports.Document.PageDocument.Render(IRenderingExtension renderingExtension, StreamProvider streams, NameValueCollection settings, Boolean forceDataRefresh, Boolean forceParameterDataRefresh)
— End of inner exception stack trace —
at GrapeCity.ActiveReports.Document.PageDocument.Render(IRenderingExtension renderingExtension, StreamProvider streams, NameValueCollection settings, Boolean forceDataRefresh, Boolean forceParameterDataRefresh)
at GrapeCity.ActiveReports.Document.PageDocument.Render(IRenderingExtension renderingExtension, StreamProvider streams, NameValueCollection settings, Boolean forceDataRefresh)
at GrapeCity.ActiveReports.Viewer.Win.Rdlx.RdlReport.<>c__DisplayClassf.#7yz()
at GrapeCity.ActiveReports.Viewer.Win.AsyncLoader.<>c__DisplayClass7.#cAz(Object param0, DoWorkEventArgs param1)
at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)