Timeout issue for SSRS report from Application Service

Steve Valente 0 Reputation points
2024-03-27T21:41:24.1166667+00:00

Researching/debugging a problem with an Azure Application Service getting an error when making a call to SSRS with a larger resultset.

The error from the SSRS service error log is as follows:

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-167!3f7c!03/27/2024-13:30:07:: 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-167-133560194360371340. ---> System.Runtime.InteropServices.COMException: 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)

Trying to reproduce the call from Powershell using WebServiceProxy, I am getting the error "Exception calling "Render" with "7" argument(s): "The operation has timed out"".

Please advise as to the best way to troubleshoot this.

Need to find information on how to set Render timeout value for a service call to SSRS. RDL is set to "Allow the report to run indefinitely (no timeout)"

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,784 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. hossein jalilian 1,505 Reputation points
    2024-03-28T01:07:45.12+00:00

    Hello Steve,

    Thanks for posting your question in the Microsoft Q&A forum.

    Based on the error message , it seems there might be several factors contributing to this issue, please check these items:

    1. Test with a smaller dataset to isolate the issue.
    2. Optimize report execution for better performance.
    3. Investigate SSRS logs for insights into the error.
    4. Check network connectivity to ensure no interruptions.
    5. Adjust timeout settings for SSRS service calls.

    Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful