SSRS Report fails intermittently

ns_97 1 Reputation point
2021-10-04T17:40:59.557+00:00

Having an issue with one of the report, We see the below error in the reportingService logs

rshost!rshost!4ff4!08/25/2021-21:44:10:: v VERBOSE: Destroying pipeline=0x000000039F9ABA20, callback=0x0000000398F23760 ...
rshost!rshost!4ab0!08/25/2021-21:44:10:: v VERBOSE: Destroying pipeline=0x000000039F9ABC60, callback=0x0000000398F22700 ...
rshost!rshost!51f8!08/25/2021-21:44:10:: v VERBOSE: Destroying pipeline=0x000000039F9ABB40, callback=0x0000000398F237C0 ...
rshost!rshost!59e0!08/25/2021-21:44:10:: v VERBOSE: HttpPipeline::DisconnectCallback: releasing pipeline=0x000000039F9AB5A0.
rshost!rshost!59e0!08/25/2021-21:44:10:: v VERBOSE: HttpPipeline::DisconnectCallback: releasing pipeline=0x000000039F9AB480.
rshost!rshost!3b78!08/25/2021-21:44:10:: v VERBOSE: State machine disconnected pipeline=0x000000039F9AB6C0, state=4 ...
rshost!rshost!128c!08/25/2021-21:44:10:: v VERBOSE: HttpPipeline::DoStateDisconnected: releasing pipeline=0x000000039F9AB900.
rshost!rshost!5f3c!08/25/2021-21:44:10:: v VERBOSE: Destroying pipeline=0x00000003981C8560, callback=0x0000000398F22780 ...
rshost!rshost!53f0!08/25/2021-21:44:10:: v VERBOSE: Destroying pipeline=0x000000039F9AB7E0, callback=0x0000000398F22460 ...
httpruntime!ReportServer_0-1!35e4!08/25/2021-21:44:10:: v VERBOSE: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeClientDisconnectionException: , Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeClientDisconnectionException: A client has disconnected from the Report Server Web service application domain ReportServer_I_0-1-132743756628017631. No corrective action is required. An error code has been submitted to ASP.NET to release the connection. The error code is 80070040. ---> System.Runtime.InteropServices.COMException (0x80070040): The specified network name is no longer available. (Exception from HRESULT: 0x80070040)
at ReportingServicesHttpRuntime.BaseWorkerRequest.SendHttpResponse(Boolean finalFlush)
at ReportingServicesHttpRuntime.RsWorkerRequest.FlushResponse(Boolean finalFlush)
--- End of inner exception stack trace ---;

We have increased the LB, SSRS timeouts but still the same error. Happens only when we run for large data, works fine if we run the report for a duration of day or 2. If we run greater then 3 days thats when we see the issue.

And sometimes report fails after a min or sometimes in seconds.

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,860 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 34,996 Reputation points
    2021-10-05T01:35:40.113+00:00

    Hi @ns_97 ,

    From the error message, most likely it's timing out at somewhere.

    Please try finding the pattern in the view ExecutionLog3 in the ReportServer database. Look through the different times for different parts of the process such as TimeDataRetrieval, TimeProcessing, TimeRendering ​to see the status of the request and how much time consumed at which part then decide the next step.

    In order to run large reports, there are two time-outs you must adjust: report execution time-out and the ASP.NET time-out.

    About SSRS report performance issue, you may take reference here.

    Regards,

    Zoe


    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues October

    0 comments No comments