When exporting a reporting services report to PowerPoint (PPTX) with 52 pages/charts we receive the error below.
The report worked fine until the page/chart count was increased. This report exports just fine to PDF and Excel. We have tried exporting to PPT and PPTX. Other smaller reports still work. The server has 4GB of memory but it is only using 2.5-3 GB of memory during the export process. We are running SQL Server 2008 on Windows Server 2003 as a virtual machine (VMware). When exporting to PDF it creates a file size 2.75 MB and Excel creates a file size of 1.19 MB.
We need to know as soon as possible if there is a limitations to this utility and its ability to export presentations to PPTX with 75 to 80 pages. The purchase order to buy this product has been put on hold.
Out of memory.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Exception: Out of memory.
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
[Exception: Out of memory.] [Exception: An error occurred during rendering of the report.] [Exception: An error occurred during rendering of the report.] Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension) +520 Microsoft.Reporting.WebForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension) +963 Microsoft.Reporting.WebForms.ServerReport.Render(String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension) +28 Microsoft.Reporting.WebForms.ServerModeSession.RenderReport(String format, Boolean allowInternalRenderers, String deviceInfo, NameValueCollection additionalParams, Boolean cacheSecondaryStreamsForHtml, String& mimeType, String& fileExtension) +85 Microsoft.Reporting.WebForms.ExportOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response) +150 Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context) +183 System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +181 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75