question

sand143eep avatar image
sand143eep 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
ssrsssrs-2008ssrs-2008-r2ssrs-2005ssrs bids
ssrserror.png (92.8 KiB)
4 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sp_lock avatar image sp_lock commented ·
Ah yes. webconfig has a http timeout that could cause the issue There are also other timeout settings in the rsreportserver.config
1 Like 1 ·
sp_lock avatar image sp_lock commented ·
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
0 Likes 0 ·
Tim avatar image Tim commented ·
I have seen this with timeout setting somewhere. I can't recall if it was client or server side.
0 Likes 0 ·
sand143eep avatar image sand143eep commented ·
please check the error log where i found memory exception. please suggest what may be the cause.
0 Likes 0 ·

1 Answer

·
sp_lock avatar image
sp_lock answered
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
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sand143eep avatar image sand143eep commented ·
will upgrade of SQL Server 2005 to SQL server 2008R2 will resolve the issue please suggest.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.