web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Dynamics CRM 2016 Repo...
Microsoft Dynamics CRM (Archived)

Dynamics CRM 2016 Reporting Extensions - customized reports will not show - rsProcessingAborted

(0) ShareShare
ReportReport
Posted on by Community Member

Hello,

 

I’ve been stuck for a few days with this issue.

 

We have installed, on premises, Dynamics CRM 2016.

Our installation consists of 2 servers:

A dynamics server, where Dynamics CRM 2016, and all required components, has been installed.

A SQL server, 2014 SP1 x64, where a separate instance has been defined for dynamics database, and where Dynamics CRM 2016 Reporting Extensions has been installed.

 

2 different domain accounts have been defined:

We are accessing dynamics web with a dynamics1 account, who has been granted system administrator role.

Reporting Extensions service is running under a different dynamics2 account.

 

Everything works fine except for customized reports. I can create them, but when I try to execute, I will get the error above: rsProcessingAborted

 

Are there any possible configuration options to check? I’ve been trying different solutions offered, but nothing seems to solve the problem

 

Any help would be greatly appreciated.

 

Regards,

Diego

*This post is locked for comments

I have the same question (0)
  • Verified answer
    a33ik Profile Picture
    a33ik 84,331 Most Valuable Professional on at

    Hello,

    Turn on trace - support.microsoft.com/.../907490 , restart IIS, reproduce error and check trace folder for file. It should contain descriptive explanation what went wrong.

    If that will not give answer you should check reporting services trace. This article should help you - technet.microsoft.com/.../ms156500(v=sql.105).aspx

  • Community Member Profile Picture
    Community Member on at

    Hi!

    I'm sending some traces, but I cannot figure out what is happening, and how to solve it...

    [2016-09-07 13:09:17.518] Process: w3wp |Organization:00000000-0000-0000-0000-000000000000 |Thread:   18 |Category: Platform |User: 53d95704-393d-e611-80c7-00155d5a024d |Level: Error |ReqId: a6774018-c9b0-46cd-a8a6-a16f3d435ee1 | ExceptionConverter.ConvertMessageAndErrorCode  ilOffset = 0x208

    >Microsoft.Reporting.WebForms.ReportServerException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #E2DEB29D: Microsoft.Reporting.WebForms.ReportServerException: Error al procesar el informe. (rsProcessingAborted) ---> Microsoft.Reporting.WebForms.ReportServerException: Error de ejecución de consulta para el conjunto de datos 'DSMain'. (rsErrorExecutingCommand) ---> Microsoft.Reporting.WebForms.ReportServerException: Para obtener más información acerca de este error, vaya al servidor de informes en el equipo del servidor local o habilite los errores remotos

    >   --- Fin del seguimiento de la pila de la excepción interna ---

    >   --- Fin del seguimiento de la pila de la excepción interna ---

    >   en Microsoft.Reporting.WebForms.SoapReportExecutionService.ServerUrlRequest(AbortState abortState, String url, Stream outputStream, String& mimeType, String& fileNameExtension)

    >   en Microsoft.Reporting.WebForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension)

    >   en Microsoft.Reporting.WebForms.ServerReport.Render(String format, String deviceInfo, NameValueCollection urlAccessParameters, String& mimeType, String& fileNameExtension)

    >   en Microsoft.Reporting.WebForms.ServerModeSession.RenderReport(String format, Boolean allowInternalRenderers, String deviceInfo, NameValueCollection additionalParams, Boolean cacheSecondaryStreamsForHtml, String& mimeType, String& fileExtension)

    >   en Microsoft.ReportingServices.Rendering.HtmlRenderer.ViewerRenderer.SPBProcessingStub.GetNextPage(RPLReport& rplReport)

    >   en Microsoft.ReportingServices.Rendering.HtmlRenderer.HTML4Renderer.GetNextPage()

    >   en Microsoft.ReportingServices.Rendering.HtmlRenderer.HTML4Renderer.InitializeReport()

    >   en Microsoft.ReportingServices.Rendering.HtmlRenderer.ViewerRenderer.Render(HtmlTextWriter outputWriter)

    >   en Microsoft.Reporting.WebForms.LocalHtmlRenderer.Render(NameValueCollection deviceInfo, PageCountMode pageCountMode, ReportControlSession reportControlSession, CreateAndRegisterStream streamCallback, String& scrollScript, String& pageStyle)

    >   en Microsoft.Reporting.WebForms.ReportControlSession.RenderReportHTML4(NameValueCollection deviceInfo, PageCountMode pageCountMode, String& scrollScript, String& pageStyle)

    >   en 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)

    >   en 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)

    >   en Microsoft.Reporting.WebForms.ReportViewer.RenderReport(Boolean updateDocMap)

    >   en Microsoft.Reporting.WebForms.ReportViewer.OnPreRender(EventArgs e)

    [2016-09-07 13:09:17.518] Process: w3wp |Organization:00000000-0000-0000-0000-000000000000 |Thread:   18 |Category: Platform |User: 53d95704-393d-e611-80c7-00155d5a024d |Level: Error |ReqId: a6774018-c9b0-46cd-a8a6-a16f3d435ee1 | ExceptionConverter.ConvertMessageAndErrorCode  ilOffset = 0x208

    >System.Web.HttpUnhandledException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #72B0373D: System.Web.HttpUnhandledException (0x80004005): Se produjo una excepción de tipo 'System.Web.HttpUnhandledException'. ---> Microsoft.Crm.CrmException: An error occurred during report rendering. ReportId:{8CB45B4D-E074-E611-80CE-00155D5A024D} ---> Microsoft.Reporting.WebForms.ReportServerException: Error al procesar el informe. (rsProcessingAborted) ---> Microsoft.Reporting.WebForms.ReportServerException: Error de ejecución de consulta para el conjunto de datos 'DSMain'. (rsErrorExecutingCommand) ---> Microsoft.Reporting.WebForms.ReportServerException: Para obtener más información acerca de este error, vaya al servidor de informes en el equipo del servidor local o habilite los errores remotos

    >   --- Fin del seguimiento de la pila de la excepción interna ---

    >   --- Fin del seguimiento de la pila de la excepción interna ---

    >   en Microsoft.Reporting.WebForms.SoapReportExecutionService.ServerUrlRequest(AbortState abortState, String url, Stream outputStream, String& mimeType, String& fileNameExtension)

    >   en Microsoft.Reporting.WebForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension)

    >   en Microsoft.Reporting.WebForms.ServerReport.Render(String format, String deviceInfo, NameValueCollection urlAccessParameters, String& mimeType, String& fileNameExtension)

    >   en Microsoft.Reporting.WebForms.ServerModeSession.RenderReport(String format, Boolean allowInternalRenderers, String deviceInfo, NameValueCollection additionalParams, Boolean cacheSecondaryStreamsForHtml, String& mimeType, String& fileExtension)

    >   en Microsoft.ReportingServices.Rendering.HtmlRenderer.ViewerRenderer.SPBProcessingStub.GetNextPage(RPLReport& rplReport)

    >   en Microsoft.ReportingServices.Rendering.HtmlRenderer.HTML4Renderer.GetNextPage()

    >   en Microsoft.ReportingServices.Rendering.HtmlRenderer.HTML4Renderer.InitializeReport()

    >   en Microsoft.ReportingServices.Rendering.HtmlRenderer.ViewerRenderer.Render(HtmlTextWriter outputWriter)

    >   en Microsoft.Reporting.WebForms.LocalHtmlRenderer.Render(NameValueCollection deviceInfo, PageCountMode pageCountMode, ReportControlSession reportControlSession, CreateAndRegisterStream streamCallback, String& scrollScript, String& pageStyle)

    >   en Microsoft.Reporting.WebForms.ReportControlSession.RenderReportHTML4(NameValueCollection deviceInfo, PageCountMode pageCountMode, String& scrollScript, String& pageStyle)

    >   en 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)

    >   en 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)

    >   en Microsoft.Reporting.WebForms.ReportViewer.RenderReport(Boolean updateDocMap)

    >   en Microsoft.Reporting.WebForms.ReportViewer.OnPreRender(EventArgs e)

    >   --- Fin del seguimiento de la pila de la excepción interna ---

    >   en Microsoft.Crm.Web.Reporting.SrsReportViewer.ReportErrorHandler(Object sender, ReportErrorEventArgs e)

    >   en Microsoft.Reporting.WebForms.ReportViewer.OnError(Exception e)

    >   en Microsoft.Reporting.WebForms.ReportViewer.OnPreRender(EventArgs e)

    >   en System.Web.UI.Control.PreRenderRecursiveInternal()

    >   en System.Web.UI.Control.PreRenderRecursiveInternal()

    >   en System.Web.UI.Control.PreRenderRecursiveInternal()

    >   en System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

    >   en System.Web.UI.Page.HandleError(Exception e)

    >   en System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

    >   en System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

    >   en System.Web.UI.Page.ProcessRequest()

    >   en System.Web.UI.Page.ProcessRequest(HttpContext context)

    >   en System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()

    >   en System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

    I'll see now if I can fin anything about reporting services trace

    thanks!

  • Community Member Profile Picture
    Community Member on at

    and here the reporting services trace when the error occurs:

    Server stack trace:

      en System.ServiceModel.Channels.SocketConnectionInitiator.Connect(Uri uri, TimeSpan timeout)

      en System.ServiceModel.Channels.BufferedConnectionInitiator.Connect(Uri uri, TimeSpan timeout)

      en System.ServiceModel.Channels.ConnectionPoolHelper.EstablishConnection(Time

    webserver!ReportServer_0-1!1728!09/07/2016-16:31:03:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: Error al procesar el informe. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: Error al procesar el informe. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Error de ejecución de consulta para el conjunto de datos 'DSMain'. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException:

    Microsoft.Crm.CrmException: An unexpected error occurred.

    System.ServiceModel.EndpointNotFoundException: No se pudo conectar a net.tcp://dynamics/CrmSandboxSdkListener-w3wp. La duración del intento de conexión fue de 00:00:41.9930090. Código de error TCP 10060: Se produjo un error durante el intento de conexión ya que la parte conectada no respondió adecuadamente tras un periodo de tiempo, o bien se produjo un error en la conexión establecida ya que el host conectado no ha podido responder [2002:d51b:9705::d51b:9705]:808.

    System.Net.Sockets.SocketException: Se produjo un error durante el intento de conexión ya que la parte conectada no respondió adecuadamente tras un periodo de tiempo, o bien se produjo un error en la conexión establecida ya que el host conectado no ha podido responder [2002:d51b:9705::d51b:9705]:808 ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: An unexpected error occurred. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: No se pudo conectar a net.tcp://dynamics/CrmSandboxSdkListener-w3wp. La duración del intento de conexión fue de 00:00:41.9930090. Código de error TCP 10060: Se produjo un error durante el intento de conexión ya que la parte conectada no respondió adecuadamente tras un periodo de tiempo, o bien se produjo un error en la conexión establecida ya que el host conectado no ha podido responder [2002:d51b:9705::d51b:9705]:808.  ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: Se produjo un error durante el intento de conexión ya que la parte conectada no respondió adecuadamente tras un periodo de tiempo, o bien se produjo un error en la conexión establecida ya que el host conectado no ha podido responder [2002:d51b:9705::d51b:9705]:808

      en System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)

      en System.Net.Sockets.Socket.Connect(EndPoint remoteEP)

      en System.ServiceModel.Channels.SocketConnectionInitiator.Connect(Uri uri, TimeSpan timeout)

      en System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)

      en System.Net.Sockets.Socket.Connect(EndPoint remoteEP)

      en System.ServiceModel.Channels.SocketConnectionInitiator.Connect(Uri uri, TimeSpan timeout)

      --- Fin del seguimiento de la pila de la excepción interna ---

  • Verified answer
    a33ik Profile Picture
    a33ik 84,331 Most Valuable Professional on at

    I don't know Spanish but it seems that your Sandbox service is not available. Check that it works and available from SQL Server.

  • Community Member Profile Picture
    Community Member on at

    great! finally worked, the problem was in the firewall of the dynamics server, it was blocking the customized reports

    so only need to find the specific ports required to be left open...

    thanks a lot Andrii!

    regards,

    Diego

  • a33ik Profile Picture
    a33ik 84,331 Most Valuable Professional on at

    Diego,

    If my replies helped you can mark as answer to close this thread.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans