question

Santosh-0377 avatar image
0 Votes"
Santosh-0377 asked Zoehui-MSFT answered

SSRS Report fails intermittently

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Zoehui-MSFT avatar image
0 Votes"
Zoehui-MSFT answered

Hi @Santosh-0377,

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


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.