locked
SSRS 2012 - ERROR: WriteCallback(): failed to write in write callback, Failed with win32 error 0x03E3,COMException (0x800703E3): The I/O operation has been aborted because of either a thread exit or an application request.(0x800703E3) RRS feed

  • Question

  • Hello,

    We are using ReportServer - 2012 , Report server mode - Native, productversion - 11.0.6594.0,  productlevel - SP3 and it is Developer Edition (64-bit).

    I am trying to generate a pdf report which has just 2K pages. But it is failing with below COMException.
    Your help would be greatly appreciated.

    The output from [dbo].[ExecutionLog3] table is as below-
    RequestType - Interactive, Format - PDF,
     ItemAction -Render, TimeStart-2017-05-17 07:31:33.887  , TimeEnd -2017-05-17 07:36:02.220, TimeDataRetrieval -133290, TimeProcessing -23992, TimeRendering -110940, Source-Live, Status -rsSuccess, ByteCount-5998294,  RowCount-24169

    When we try to generate the report directly from ReportServer, the pdf gets generated in just 5 minutes. But when we connect it though the ReportExecution2005.asmx service, we are getting below exception logged in ReportServerService log file -

    library!ReportServer_0-1!11a0!05/17/2017-07:14:45:: i INFO: Catalog SQL Server Edition = Developer
    crypto!ReportServer_0-1!11a0!05/17/2017-07:14:45:: i INFO: Initializing crypto as user: *****
    crypto!ReportServer_0-1!11a0!05/17/2017-07:14:45:: i INFO: Exporting public key
    crypto!ReportServer_0-1!11a0!05/17/2017-07:14:45:: i INFO: Performing sku validation
    crypto!ReportServer_0-1!11a0!05/17/2017-07:14:45:: i INFO: Importing existing encryption key
    library!ReportServer_0-1!11a0!05/17/2017-07:14:47:: i INFO: RenderForNewSession('/*******/*******)
    library!ReportServer_0-1!11a0!05/17/2017-07:17:26:: i INFO: Using folder D:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\RSTempFiles for temporary files.
    rshost!rshost!710!05/17/2017-07:19:21:: e ERROR: WriteCallback(): failed to write in write callback.
    rshost!rshost!710!05/17/2017-07:19:21:: e ERROR: Failed with win32 error 0x03E3, pipeline=0x00000001780A79A0.
    rshost!rshost!11a0!05/17/2017-07:19:21:: e ERROR: HttpPipelineCallback::SendResponse(): failed async writing response.
    rshost!rshost!11a0!05/17/2017-07:19:21:: e ERROR: Failed with win32 error 0x03E3, pipeline=0x00000001780A79A0.
    httpruntime!ReportServer_0-1!11a0!05/17/2017-07:19:21:: e ERROR: Failed in BaseWorkerRequest::SendHttpResponse(bool), exception=System.Runtime.InteropServices.COMException (0x800703E3): The I/O operation has been aborted because of either a thread exit or an application request. (Exception from HRESULT: 0x800703E3)
       at Microsoft.ReportingServices.HostingInterfaces.IRsHttpPipeline.SendResponse(Void* response, Boolean finalWrite, Boolean closeConn)
       at ReportingServicesHttpRuntime.BaseWorkerRequest.SendHttpResponse(Boolean finalFlush)
    library!ReportServer_0-1!11a0!05/17/2017-07:19:21:: 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 ReportServer_MSSQLSERVER_0-1-131394716606210788.  ---> System.Runtime.InteropServices.COMException (0x800703E3): The I/O operation has been aborted because of either a thread exit or an application request. (Exception from HRESULT: 0x800703E3)
       at ReportingServicesHttpRuntime.BaseWorkerRequest.SendHttpResponse(Boolean finalFlush)
       at ReportingServicesHttpRuntime.RsWorkerRequest.FlushResponse(Boolean finalFlush)
       --- End of inner exception stack trace ---;


    Wednesday, May 17, 2017 6:40 AM

All replies

  • Hi RoshaniPanchal,

    I had the same issue two months ago, by rendering report with the SSRS web services.

    The antivirus was failing the report generation (I guess it was randomly scanning some reports).
    Excluding the directory from the antivirus solved my issue.

    Hope that helps !


    Pierre Petesch

    If my post helped you to solve your issue, please mark it as answered.

    If you can't explain it simply, you don't understand it well enough.

    LinkedIn: 

    Wednesday, May 17, 2017 8:32 AM
  • Hi Pierre Petesch,

    Thanks for your reply.

    Since start we are able to generate small pdf files of 20 to 100 pages. But it is failing to generate the file with 2K pages.

    Do you still think the issue can be with Antivirus?

    Wednesday, May 17, 2017 10:26 AM
  • Hi RoshaniPanchal,

    In my specific case, I generated - on a daily basis - various reports through the web services (on both PDF and XLSX output formats).
    All these reports were stored on a server file system.

    Very few of them were not generated properly and the logs reported some strange errors like you mentioned:
    - "ERROR: Failed with win32 error"
    - "ERROR: HttpPipelineCallback::SendResponse(): failed async writing response"
    - "exception=System.Runtime.InteropServices.COMException (0x800703E3): The I/O operation has been aborted because of either a thread exit or an application request. (Exception from HRESULT: 0x800703E3)"

    I also suspected  the report size, but in a first step, I requested exclude to the directory from the antivirus.
    It appears that definitely fixed the issue and, since i never updated the RDL, the report size was not linked to this issue.

    EDIT

    Your logs also show that you have maybe reached the default timeout (9000).
    Try to update the web.config file of the ReportManager in order to increase this value:
    <httpRuntime executionTimeout="9000" />

    Hope that helps !


    Pierre Petesch

    If my post helped you to solve your issue, please mark it as answered.

    If you can't explain it simply, you don't understand it well enough.

    LinkedIn: 


    • Edited by Pierre Petesch Wednesday, May 17, 2017 10:55 AM Timeout setting
    Wednesday, May 17, 2017 10:45 AM
  • Hi Pierre,

    Unfortunately the solution did no work. We are still getting the same exception.

    Friday, May 19, 2017 1:06 PM
  • Hi again RoshaniPanchal,

    Sorry for the delay.

    It's may due to a timeout issue since your report takes a while to render (> 2m30):

    library!ReportServer_0-1!11a0!05/17/2017-07:14:47:: i INFO: RenderForNewSession('/*******/*******)
    library!ReportServer_0-1!11a0!05/17/2017-07:17:26:: i INFO: Using folder D:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\RSTempFiles for temporary files.

    Take a look to this article to check your current settings (for instance you maybe exceed the DatabaseQueryTimeout):
    https://social.technet.microsoft.com/wiki/contents/articles/23508.sql-server-reporting-services-timeout-settings.aspx

    Did you try to render the reports on another location ?

    BTW, rendering 2K pages in a PDF file sounds a lot for me. You maybe reached a limit regarding the rendering component.

    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/fbca93f7-18db-4581-af2f-afd4fe9b54de/ssrs-report-export-to-pdf?forum=sqlreportingservices

    Regards,


    Pierre Petesch

    If my post helped you to solve your issue, please mark it as answered.

    If you can't explain it simply, you don't understand it well enough.

    LinkedIn: 

    • Proposed as answer by Henry Jiang Thursday, June 1, 2017 8:42 AM
    Tuesday, May 23, 2017 9:08 AM