asked
Proxy Error The proxy server received an invalid response from an upstream server.The proxy server could not handle the request GET Reports/Reserved.ReportViewerWebControl.axd.Reason: Error reading from remote server
we are using SQL Server 2005 reporting services.when we are trying to export teh reports of 100-200 pages it will succeed with out any error.but when we try to export 400-600 reports then it was throwing the error : Proxy Error The proxy server received an invalid response from an upstream server.The proxy server could not handle the request GET Reports/Reserved.ReportViewerWebControl.axd.Reason: Error reading from remote server Apache/2.2.3 (Red Hat) Server at
09002reports.gi.telenor.com Port 80 the error in the ssrs logs: w3wp!webserver!b!03/17/2015-16:17:21:: i INFO: Processed report. Report='/09002CustomerPortal/mycalls_list', Stream='' w3wp!library!1!03/17/2015-16:19:07:: i INFO: Call to RenderNext( '/Service Line/Accenture/Production/AreaWise_Call_Detail_AuditTrail_(Daily)-v2' ) w3wp!library!13!03/17/2015-16:19:28:: i INFO: Call to RenderFirst( '/09002CustomerPortal/mycalls_list' ) w3wp!webserver!13!03/17/2015-16:19:29:: i INFO: Processed report. Report='/09002CustomerPortal/mycalls_list', Stream='' w3wp!library!10!03/17/2015-16:20:00:: i INFO: Call to RenderFirst( '/09002CustomerPortal/mycalls_details' ) w3wp!webserver!10!03/17/2015-16:20:00:: i INFO: Processed report. Report='/09002CustomerPortal/mycalls_details', Stream='' w3wp!runningjobs!e!17.3.2015-16:20:07:: i INFO: Adding: 1 running jobs to the database w3wp!reportrendering!1!03/17/2015-16:20:28:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException: An error occurred during rendering of the report., ; Info: Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException: An error occurred during rendering of the report. ---> Microsoft.ReportingServices.ReportRendering.ReportRenderingException: An error occurred during rendering of the report. ---> System.OutOfMemoryException: Insufficient memory to continue the execution of the program. at Microsoft.ReportingServices.Rendering.BIFFUtility.WorkBook.Write(Stream stream, String reportName) at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.Render(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions, CreateAndRegisterStream createAndRegisterStream) --- End of inner exception stack trace --- at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.Render(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions, CreateAndRegisterStream createAndRegisterStream) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(IRenderingExtension renderer, CreateReportChunk createChunkCallback, RenderingContext rc, GetResource getResourceCallback) --- End of inner exception stack trace --- w3wp!webserver!1!03/17/2015-16:20:28:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error occurred during rendering of the report. ---> Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException: An error occurred during rendering of the report. ---> Microsoft.ReportingServices.ReportRendering.ReportRenderingException: An error occurred during rendering of the report. ---> System.OutOfMemoryException: Insufficient memory to continue the execution of the program. w3wp!library!1!03/17/2015-16:20:28:: e ERROR: Found System.OutOfMemoryException exception: Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error occurred during rendering of the report. ---> Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException: An error occurred during rendering of the report. ---> Microsoft.ReportingServices.ReportRendering.ReportRenderingException: An error occurred during rendering of the report. ---> System.OutOfMemoryException: Insufficient memory to continue the execution of the program. w3wp!library!1!03/17/2015-16:20:28:: e ERROR: Terminating worker process please suggest is this default in 2005 how can i export al the reports at a time with out error. ![alt text][1] [1]: /storage/temp/2239-ssrserror.png
Are you able to check the SSRS logs?
https://msdn.microsoft.com/en-us/library/ms157403(v=sql.90).aspx If there are no reported errors there, then I would check the logs on the apache proxy
please check the error log where i found memory exception. please suggest what may be the cause.
If I am honest I have not come across this error and needed to debug it. However a quick good has directed me to a MS article. Follow the steps and feedback to us.
http://support.microsoft.com/en-us/kb/909678 Try/test the WorkingSetMaximum setting mentioned in the article, but do so with caution and in your test env (if possible). I would also monitor the memory consumption of the server while you are exporting the reports to see if you maxing out
will upgrade of SQL Server 2005 to SQL server 2008R2 will resolve the issue please suggest.
16 People are following this question.
