SSRS/Asp.net Reportviewer - A client has disconnected from the Report Server Web service application domain ReportServer_MSSQLSERVER_0-76-132763499900827876

Abby Palcer 1 Reputation point
2021-09-17T15:42:50.297+00:00

I need help. I have never seend this before with SSRS and Asp.Net 4.0 Report Viewer.

I have a SSRS report, that will run all day everyday in Reporting Services.
That same report runs ocassionaly when I have it called through a Report Viewer through a 4.0 Asp.net App when it is deployed to a server.
If I run the same app locally on my machine, the report runs just fine. I can not recreate the error.

THe report on the server is very inconsitent. Sometime it runs and sometimes it does not. I have had issues with paging and exporting also.

This is the error that SSRS is logging. Is this the SSRS error or did I get my connection cut from the server where the App Sits? Or I am way off? Any help would be appreciated.

ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.ClosingRegisteredStreamException: An error occurred closing a registered stream. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeClientDisconnectionException: A client has disconnected from the Report Server Web service application domain ReportServer_MSSQLSERVER_0-76-132763499900827876. 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)
at ReportingServicesHttpRuntime.BaseWorkerRequest.SendHttpResponse(Boolean finalFlush)
at ReportingServicesHttpRuntime.RsWorkerRequest.FlushResponse(Boolean finalFlush)
--- End of inner exception stack trace ---
at ReportingServicesHttpRuntime.BaseWorkerRequest.FilterAndThrowException(Exception e, String message)
at ReportingServicesHttpRuntime.RsWorkerRequest.FlushResponse(Boolean finalFlush)
at System.Web.HttpResponse.Flush(Boolean finalFlush)
at Microsoft.ReportingServices.WebServer.HttpResponseStream.InternalFlush(Boolean finalFlush)
at Microsoft.ReportingServices.WebServer.HttpResponseStream.Close()
at Microsoft.ReportingServices.Library.BufferAndOutputStream.Dispose(Boolean disposing)
at System.IO.Stream.Close()
at Microsoft.ReportingServices.Library.StreamFactoryBase.CloseAllStreams(IEnumerable1 streams) --- End of inner exception stack trace --- at Microsoft.ReportingServices.Library.StreamFactoryBase.CloseAllStreams(IEnumerable1 streams)
at Microsoft.ReportingServices.Library.StreamFactoryBase.CloseRegisteredStreams()
at Microsoft.ReportingServices.Library.StreamFactoryBase.Dispose()
at Microsoft.ReportingServices.Library.WorkspaceManager`1.Pop()
at Microsoft.ReportingServices.Library.StreamRequestHandler.PerformStreamedOperation(StreamedOperation operation)
at Microsoft.ReportingServices.Library.StreamRequestHandler.RenderItem(ItemType itemType)
at Microsoft.ReportingServices.Library.StreamRequestHandler.ExecuteCommand()
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()

ASP.NET
ASP.NET
A set of technologies in the .NET Framework for building web applications and XML web services.
3,291 questions
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,814 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Joyzhao-MSFT 15,566 Reputation points
    2021-09-20T02:00:35.257+00:00

    Hi @Abby Palcer ,
    What version of SSRS are you using? Is your report relatively large? Does the data set query use stored procedures? Does the MULTIVALUE drop-down list in your report have more than 1000 parameters?

    This looks like a timeout somewhere, you could query the View ExecutionLog3 of the ReportServer database to see the different times in different parts of the process-TimeDataRetrieval, TimeProcessing, TimeRendering...
    Please share relevant information as much as possible.

    Only in SSRS 2008 R2 version, using page breaks will cause Internet Explorer to have an infinite loop/hang/timeout during print preview or PDF export.
    Best Regards,
    Joy


    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.

    0 comments No comments