Error receiving large report using Reporting Services Execution Web service.

Question

I'm trying to generate a ad-hoc report using report genearation service via http request.

In ExecutionLog3 status of the report of RsSuccess and rendered successfully in 25min, but while wrting the report back to http response getting the following error,

rshost!1ecc!12/15/2023-01:14:52:: e ERROR: HttpPipelineCallback::SendResponse(): failed writing response.
rshost!1ecc!12/15/2023-01:14:52:: e ERROR: Failed with win32 error 0x0057, pipeline=0x000001ED009E83E0.
httpruntime!1ecc!12/15/2023-01:14:52:: e ERROR: Failed in BaseWorkerRequest::SendHttpResponse(bool), exception=System.ArgumentException: Value does not fall within the expected range.
   at Microsoft.ReportingServices.HostingInterfaces.IRsHttpPipeline.SendResponse(Void* response, Boolean finalWrite, Boolean closeConn)
   at ReportingServicesHttpRuntime.BaseWorkerRequest.SendHttpResponse(Boolean finalFlush)
library!1ecc!12/15/2023-01:14:52:: 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_SSRS_0-5-133470241171089232. ---> System.ArgumentException: Value does not fall within the expected range.
   at ReportingServicesHttpRuntime.BaseWorkerRequest.SendHttpResponse(Boolean finalFlush)
   at ReportingServicesHttpRuntime.RsWorkerRequest.FlushResponse(Boolean finalFlush)
   --- End of inner exception stack trace ---;
rshost!1ecc!12/15/2023-01:14:52:: e ERROR: HttpPipelineCallback::SendResponse(): failed writing response.
rshost!1ecc!12/15/2023-01:14:52:: e ERROR: Failed with win32 error 0x10DD, pipeline=0x000001ED009E83E0.

Tried to check the http request timeout / query timeout/ database timeout , Memory and Disk issues,

Every configuration seems to be correct.

Issue was happening in all format (pdf,csv,excel) and most of version of SSRS.

Seems like this issue related to a post form stackoverflow,

https://stackoverflow.com/questions/49366781/error-receiving-large-report-using-reporting-services-execution-web-service?newreg=9806c4905ab148c197f4a18671c10c4b

Is there any workaroud avaliable for this?

Answer 1

Hi @Karthikeyan G

I've done a search on this issue and the suggestion from many sites is to split the report. You can refer to the discussion in this thread: https://social.msdn.microsoft.com/Forums/en-US/66917afb-5c3f-420f-b761-90f15986c635/exception-while-generating-large-reports-using-ssrs?forum=sqlreportingservices. I didn't find a more efficient way to solve this problem.

You can also refer to this official document on processing large reports and try out the suggestions to see if they are useful: Process Large Reports.

If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

Best regards,

Aniya