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