SSRS 2008 does not provide a report

Question

I have several computers that can produce a large report without any problems, however several other computers cannot display reports and crash reporting services.

We have SQL Server 2008 R2 SP1, and we noticed that the memory usage of Reporting Services applications increases from 300 MB to 1.2 GB when rendering this report.

Here we have a log file when this report crashes:

rshost!rshost!4cf0!06/26/2013-10:33:38:: e ERROR: WriteCallback(): failed to write in write callback. rshost!rshost!4cf0!06/26/2013-10:33:38:: e ERROR: Failed with win32 error 0x03E3, pipeline=0x00000000063D2400. rshost!rshost!106c!06/26/2013-10:33:38:: e ERROR: HttpPipelineCallback::SendResponse(): failed async writing response. rshost!rshost!106c!06/26/2013-10:33:38:: e ERROR: Failed with win32 error 0x03E3, pipeline=0x00000000063D2400. httpruntime!ReportServer_0-1!106c!06/26/2013-10:33:38:: e ERROR: Failed in BaseWorkerRequest::SendHttpResponse(bool), exception=System.Runtime.InteropServices.COMException (0x800703E3): The I/O operation has been aborted because of either a thread exit or an application request. (Exception from HRESULT: 0x800703E3) at Microsoft.ReportingServices.HostingInterfaces.IRsHttpPipeline.SendResponse(Void* response, Boolean finalWrite, Boolean closeConn) at ReportingServicesHttpRuntime.BaseWorkerRequest.SendHttpResponse(Boolean finalFlush) library!ReportServer_0-1!106c!06/26/2013-10:33:38:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: RsWorkerRequest::FlushResponse., Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: An internal or system error occurred in the HTTP Runtime object for application domain ReportServer_MSSQLSERVER_0-1-130167083080132500. ---> System.Runtime.InteropServices.COMException (0x800703E3): The I/O operation has been aborted because of either a thread exit or an application request. (Exception from HRESULT: 0x800703E3) at ReportingServicesHttpRuntime.BaseWorkerRequest.SendHttpResponse(Boolean finalFlush) at ReportingServicesHttpRuntime.RsWorkerRequest.FlushResponse(Boolean finalFlush) --- End of inner exception stack trace ---; 

Any idea on what might cause this error? Why are these apperars in some computers and is everything alright in others?

Thanks in advance.

Answer 1

If you use Reporting Services server-side services (online interface) and the problem arises for end users (read-only your report), and most importantly, you are sure that the report is working correctly.

You can try to cache the report first. This can solve your problem, as well as make the end user happier, as the report will load very quickly.

Here you can read about caching: https://docs.microsoft.com/en-us/sql/reporting-services/report-server/caching-reports-ssrs

and here is some old caching setup instruction: http://bhushan.extreme-advice.com/caching-ssrs-reports/

By the way, you should also make sure that: - users have the same rights as you - files are updated and available to all users

It is hard to say what could be the problem. Try your luck with the cache if this does not solve the problem ... It will definitely bring your reports and the joys of your customers to a new level.

Cheers, Kacper