locked
Dynamics CRM 365 On Premise Reports through Reporting Wizard not working. (An error has occurred during report processing. (rsProcessingAborted) RRS feed

  • Question

  • Hello , i am trying to create Report through Wizard it is giving me error in front end An error has occurred during report processing. (rsProcessingAborted) when i check event viewer in CRM App server i am seeing below error. 

    Event code: 3005 
    Event message: An unhandled exception has occurred. 
    Event time: 12/7/2017 8:57:04 AM 
    Event time (UTC): 12/7/2017 1:57:04 PM 
    Event ID: f0588f1f199c4261ac9a68fcf6012266 
    Event sequence: 1795 
    Event occurrence: 8 
    Event detail code: 0 
     
    Application information: 
        Application domain: /LM/W3SVC/1/ROOT-1-131571253834225259 
        Trust level: Full 
        Application Virtual Path: / 
        Application Path: C:\Program Files\Microsoft Dynamics CRM\CRMWeb\ 
        Machine name: D365WEBDEV 
     
    Process information: 
        Process ID: 9048 
        Process name: w3wp.exe 
        Account name: domain\svc_account 
     
    Exception information: 
        Exception type: CrmException 
        Exception message: An error occurred during report rendering. ReportId:{1B5C551B-4CDB-E711-9105-005056B95335}
       at Microsoft.Crm.Web.Reporting.SrsReportViewer.ReportErrorHandler(Object sender, ReportErrorEventArgs e)
       at Microsoft.Reporting.WebForms.ReportViewer.OnError(Exception e)
       at Microsoft.Reporting.WebForms.ReportViewer.OnPreRender(EventArgs e)
       at System.Web.UI.Control.PreRenderRecursiveInternal()
       at System.Web.UI.Control.PreRenderRecursiveInternal()
       at System.Web.UI.Control.PreRenderRecursiveInternal()
       at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

    An error has occurred during report processing. (rsProcessingAborted)
       at Microsoft.Reporting.WebForms.SoapReportExecutionService.ServerUrlRequest(AbortState abortState, String url, Stream outputStream, String& mimeType, String& fileNameExtension)
       at Microsoft.Reporting.WebForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension)
       at Microsoft.Reporting.WebForms.ServerReport.Render(String format, String deviceInfo, NameValueCollection urlAccessParameters, String& mimeType, String& fileNameExtension)
       at Microsoft.Reporting.WebForms.ServerModeSession.RenderReport(String format, Boolean allowInternalRenderers, String deviceInfo, NameValueCollection additionalParams, Boolean cacheSecondaryStreamsForHtml, String& mimeType, String& fileExtension)
       at Microsoft.ReportingServices.Rendering.HtmlRenderer.ViewerRenderer.SPBProcessingStub.GetNextPage(RPLReport& rplReport)
       at Microsoft.ReportingServices.Rendering.HtmlRenderer.HTML4Renderer.GetNextPage()
       at Microsoft.ReportingServices.Rendering.HtmlRenderer.HTML4Renderer.InitializeReport()
       at Microsoft.ReportingServices.Rendering.HtmlRenderer.ViewerRenderer.Render(HtmlTextWriter outputWriter)
       at Microsoft.Reporting.WebForms.LocalHtmlRenderer.Render(NameValueCollection deviceInfo, PageCountMode pageCountMode, ReportControlSession reportControlSession, CreateAndRegisterStream streamCallback, String& scrollScript, String& pageStyle)
       at Microsoft.Reporting.WebForms.ReportControlSession.RenderReportHTML4(NameValueCollection deviceInfo, PageCountMode pageCountMode, String& scrollScript, String& pageStyle)
       at Microsoft.Reporting.WebForms.ReportControl.RenderReport(ReportControlSession session, String viewerInstanceIdentifier, PageCountMode pageCountMode, Int32 pageNumber, InteractivityPostBackMode interactivityMode, SearchState searchState, String replacementRoot, String hyperlinkTarget, ScrollTarget scrollTarget, String alertMessage, DeviceInfoCollection initialDeviceInfos, String browserMode, Boolean sizeToContent)
       at Microsoft.Reporting.WebForms.ReportArea.RenderReport(ReportControlSession session, String viewerInstanceIdentifier, PageCountMode pageCountMode, Int32 pageNumber, InteractivityPostBackMode interactivityMode, SearchState searchState, String replacementRoot, String hyperlinkTarget, ScrollTarget scrollTarget, String alertMessage, DeviceInfoCollection initialDeviceInfos, String browserMode, Boolean sizeToContent)
       at Microsoft.Reporting.WebForms.ReportViewer.RenderReport(Boolean updateDocMap)
       at Microsoft.Reporting.WebForms.ReportViewer.OnPreRender(EventArgs e)

    Cannot create a connection to data source 'CRM'. (rsErrorOpeningConnection)

    For more information about this error navigate to the report server on the local server machine, or enable remote errors

     
     
    Request information: 
        Request URL: http://localhost:5555/PathClone/CRMReports/rsviewer/QuirksReportViewer.aspx 
        Request path: /PathClone/CRMReports/rsviewer/QuirksReportViewer.aspx 
        User host address: ::1 
        User: domain\UserAccount 
        Is authenticated: True 
        Authentication Type: Negotiate 
        Thread account name: domain\svc_account 
     
    Thread information: 
        Thread ID: 21 
        Thread account name: domain\svc_account 
        Is impersonating: False 
        Stack trace:    at Microsoft.Crm.Web.Reporting.SrsReportViewer.ReportErrorHandler(Object sender, ReportErrorEventArgs e)
       at Microsoft.Reporting.WebForms.ReportViewer.OnError(Exception e)
       at Microsoft.Reporting.WebForms.ReportViewer.OnPreRender(EventArgs e)
       at System.Web.UI.Control.PreRenderRecursiveInternal()
       at System.Web.UI.Control.PreRenderRecursiveInternal()
       at System.Web.UI.Control.PreRenderRecursiveInternal()
       at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
     
     
    Custom event details: 

    i have already tried to register SPN for App pool user and all required steps. 

    Thank you, 

    @Soni

    Friday, December 8, 2017 7:53 AM