question

AbbyPalcer-4041 avatar image
0 Votes"
AbbyPalcer-4041 asked Joyzhao-MSFT answered

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

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(IEnumerable`1 streams)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.Library.StreamFactoryBase.CloseAllStreams(IEnumerable`1 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()

sql-server-reporting-servicesdotnet-aspnet-general
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

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

Hi @AbbyPalcer-4041 ,
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.


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.