SSRS disconnection Error

  • I keep getting this error randomly. No pattern to it and not a timeout issue. Seeing this even under a minute of report running.
    Scale out with 3 report servers, load balancing is working and overall running great. However, randomly getting this error.
    Happening with different reports as well. Just don't see any pattern of report, time or type of report.

    Any ideas would be appreciated!
    Thank you

    ReportServerHttpRuntimeClientDisconnectionException:
    A client has disconnected from the Report Server Web service application domain ReportServer_MSSQLSERVER
    No corrective action is required. An error code has been submitted to ASP.NET to release the connection.
    The error code is 800708CA. ---> System.Runtime.InteropServices.COMException (0x800708CA):
    This network connection does not exist. (Exception from HRESULT: 0x800708CA)

  • SqlServerDBA318 - Thursday, February 28, 2019 9:20 AM

    I keep getting this error randomly. No pattern to it and not a timeout issue. Seeing this even under a minute of report running.
    Scale out with 3 report servers, load balancing is working and overall running great. However, randomly getting this error.
    Happening with different reports as well. Just don't see any pattern of report, time or type of report.

    Any ideas would be appreciated!
    Thank you

    ReportServerHttpRuntimeClientDisconnectionException:
    A client has disconnected from the Report Server Web service application domain ReportServer_MSSQLSERVER
    No corrective action is required. An error code has been submitted to ASP.NET to release the connection.
    The error code is 800708CA. ---> System.Runtime.InteropServices.COMException (0x800708CA):
    This network connection does not exist. (Exception from HRESULT: 0x800708CA)

    Most likely it's timing out at somewhere. Try finding the pattern in the view ExecutionLog3 in the ReportServer database. Look through the different times for different parts of the process - TimeDataRetrieval, TimeProcessing, TimeRendering

    Sue

  • I wasn't thinking of those around the total time. I will check that out. Thanks!

  • Were you able to solve this error? I am receiving the same error without any real pattern showing itself. Thanks!

  • It turned out for me it was actually the user cancelling the report.

     

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply