locked
SSRS 2012 error while rendering report from report manager RRS feed

  • Question

  • Hi,

    We recently upgraded to SQL 2012 BI edition and found error few times while rendering reports from report manager. The error that was displayed in the browser was 

    SSRS Sys.WebForms.PageRequestManagerServerErrorException: An unknown error occurred while processing the request on the server. The status code returned from the server was: 0

    The following was found from the log file generated when this error occurred the last time.

    webserver!ReportServer_0-14!74a0!05/24/2016-11:28:30:: i INFO: Processed report. Report='/Internal/Operational/No Outbound Comms Agent Details', Stream=''
    library!ReportServer_0-14!6814!05/24/2016-11:28:31:: i INFO: Call to GetSystemPropertiesAction().
    rshost!rshost!294c!05/24/2016-11:28:31:: e ERROR: WriteCallback(): failed to write in write callback.
    rshost!rshost!294c!05/24/2016-11:28:31:: e ERROR: Failed with win32 error 0x03E3, pipeline=0x00000004FEBC8640.
    rshost!rshost!219c!05/24/2016-11:28:31:: e ERROR: HttpPipelineCallback::SendResponse(): failed async writing response.
    rshost!rshost!219c!05/24/2016-11:28:31:: e ERROR: Failed with win32 error 0x03E3, pipeline=0x00000004FEBC8640.
    httpruntime!ReportManager_0-15!219c!05/24/2016-11:28:31:: e ERROR: Failed in BaseWorkerRequest::SendHttpResponse(bool), exception=System.AppDomainUnloadedException: Attempted to access an unloaded appdomain. (Exception from HRESULT: 0x80131014)
       at System.StubHelpers.StubHelpers.GetCOMHRExceptionObject(Int32 hr, IntPtr pFrame, Object pThis)
       at Microsoft.ReportingServices.HostingInterfaces.IRsHttpPipeline.SendResponse(Void* response, Boolean finalWrite, Boolean closeConn)
       at ReportingServicesHttpRuntime.BaseWorkerRequest.SendHttpResponse(Boolean finalFlush)
    library!ReportManager_0-15!219c!05/24/2016-11:28:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: RsWorkerRequest::FlushResponse., Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: An internal or system error occurred in the HTTP Runtime object for application domain ReportManager_MSSQLSERVER2012_0-15-131085265479942678.  ---> System.AppDomainUnloadedException: Attempted to access an unloaded appdomain. (Exception from HRESULT: 0x80131014)
       at ReportingServicesHttpRuntime.BaseWorkerRequest.SendHttpResponse(Boolean finalFlush)
       at ReportingServicesHttpRuntime.RsWorkerRequest.FlushResponse(Boolean finalFlush)
       --- End of inner exception stack trace ---;

    I found the problem is not persistent. When I closed the browser window and tried to regenerate the report it worked without any issues.

    Any suggestions on why this happening and how to resolve this.

    Thanks,

    Gayatri

    Tuesday, May 24, 2016 1:51 AM

All replies

  • Hi Gayatri,

    How about you choose to use different browsers to see whether the issue exists? And how about you trying the same thing on the same server as Reporting Server?

    Thanks.


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Wednesday, May 25, 2016 11:09 AM