SSRS report System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown

Finance and Operations/AX
1

Hello,

We have a working ‘BOMConsistOf’ SSRS report in production and lately it has started timing out. So, I have made a couple of changes to the reports DP class and the Temp table to make it a Pre processing report

  1. Modified the BOMConsistOfDP class that extends from SRSReportDataProviderBase to SRSReportDataProviderPreProcessTempDB
  2. Modified the BOMConsistOfTmp table table type from in ‘Inmemory’ to ‘TempDB’

It runs for long but throwing the

System.OutOfMemoryException: Exception of type ‘System.OutOfMemoryException’ was thrown.
at System.Drawing.Graphics.FromHwndInternal(IntPtr hwnd)
at System.Drawing.Graphics.FromHwnd(IntPtr hwnd)
at Microsoft.ReportingServices.Rendering.RichText.RichTextRenderer.get_Dpi()
at Microsoft.ReportingServices.Rendering.RichText.RichTextRenderer.Render(Graphics g, RectangleF rectangle, PointF offset, IEnumerable1 highlights, Boolean unitsInMM) at Microsoft.Reporting.WinForms.RenderingTextBox.RenderRichText(RichTextRenderer richTextRenderer, Graphics graphics, RectangleF rectangle, PointF offset, List1 matches)
at Microsoft.Reporting.WinForms.RenderingTextBox.DrawContent(GdiContext context)
at Microsoft.Reporting.WinForms.RenderingItem.DrawToPage(GdiContext context)
at Microsoft.Reporting.WinForms.RenderingItemContainer.DrawContent(GdiContext context)
at Microsoft.Reporting.WinForms.RenderingTablix.DrawContent(GdiContext context)
at Microsoft.Reporting.WinForms.RenderingItem.DrawToPage(GdiContext context)
at Microsoft.Reporting.WinForms.RenderingItemContainer.DrawContent(GdiContext context)
at Microsoft.Reporting.WinForms.RenderingItem.DrawToPage(GdiContext context)
at Microsoft.Reporting.WinForms.RenderingItemContainer.DrawContent(GdiContext context)
at Microsoft.Reporting.WinForms.RenderingTablix.DrawContent(GdiContext context)
at Microsoft.Reporting.WinForms.RenderingItem.DrawToPage(GdiContext context)
…
…
etc

I am not sure if I am missing anything else in the process of converting to a pre processing report.

Have you ever run into something this?

Thanks!

2

Does it do the same thing in non production environments? If not, you might create a support ticket with MS and have them take a look at the infrastructure your instance is on.