locked
ReportServerStorageException / This SqlTransaction has completed; it is no longer usable. RRS feed

  • Question

  • Every once in a while we see this error in our SSRS server log:

    Outter Exception

    TypeName: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeClientDisconnectionException, Microsoft.ReportingServices.Diagnostics
    Message: A client has disconnected from the Report Server Web service application domain ReportServer_MSSQLSERVER_0-1-131124424211711718. No corrective action is required. An error code has been submitted to ASP.NET to release the connection. The error code is 800708CA.
    Source: RsHttpRuntime
    StackTrace:    at ReportingServicesHttpRuntime.BaseWorkerRequest.FilterAndThrowException(Exception e, String message)
       at ReportingServicesHttpRuntime.RsWorkerRequest.FlushResponse(Boolean finalFlush)
       at System.Web.HttpResponse.Flush(Boolean finalFlush)
       at Microsoft.Reporting.WebForms.ReportDataOperation.StreamToResponse(Stream data, HttpResponse response)
       at Microsoft.Reporting.WebForms.ExportOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)
       at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
       at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
       at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
    

    Inner exception

    TypeName: Microsoft.Reporting.WebForms.ReportServerException, ReportingServicesWebServer
    Message: This SqlTransaction has completed; it is no longer usable.
    Source: 
    

    What might cause this error in SSRS 2014?

    Friday, July 8, 2016 1:46 PM

Answers