Произошла ошибка при обработке отчета rsprocessingaborted

null

Не удалось выполнить запрос для набора данных "DataSetAdminID". (rsErrorExecutingCommand)
----------------------------
Произошла ошибка при обработке отчета. (rsProcessingAborted)

При подготовке к просмотру на клиенте произошла ошибка. 
Произошла ошибка при обработке отчета. (rsProcessingAborted) 
Не удалось выполнить запрос для набора данных "DataSet0". (rsErrorExecutingCommand) 
Чтобы получить дополнительные сведения об этой ошибке, перейдите к серверу отчетов на локальном сервере или включите удаленный контроль ошибок 

Introduction:

rsProcessingAborted Reporting Error is one of the most dreaded error faced by SSRS report developers.

What could be the cause of this error? How to solve this? Why did this error originate?

These are few of the multitude questions that goes through the developers mind.

We have been in the same position. We had a business requirement where one of our client, using an Online CRM, had the same reporting issue as seen in the screenshot below;

Previously, we faced the same issue on our On-Premise machine and we have covered the steps to resolve this in one of our blog.

However, this situation was different as the client was using Online CRM!

How do we debug the ‘rsProcessingAborted’ error?

One of the ways to debug has been described below. It should help in most cases.

First and foremost, we need few things in place in order to debug this error;

Pre-Requisites:

• SSDT
• Reporting Extension

Once we have all the Pre-Requisites in place, then simply follow the steps mentioned below to resolve the error;

Steps to debug ‘rsProcessingAborted’ error:

• Download the RDL of the report.
• Open the downloaded RDL in the Visual Studio Shell (Integrated).
• And then after entering the valid credentials, click preview and Voila!

The above error description was more than enough for us to resolve the issue.

Conclusion:

Try to setup the report in the dev environment and execute it to debug the issue.

Generate Your Own New Leads Within Microsoft Dynamics 365 CRM

Contact us for a demo to know more about how Maplytics can help you to generate new leads from within Microsoft Dynamics 365 CRM.

Maplytics is a 5-star rated, preferred business app on the Microsoft AppSource that is Certified for Microsoft Dynamics 365 (CfMD) and comes with powerful features like Appointment Planning, Sales Routing, Territory Management, Heat Maps, Geo-analytical Dashboards and more that empower organizations to add more value to their CRM data, improve sales & service processes, and achieve high ROI.

Get your free trial from our Website or Microsoft AppSource!

‘If data is the new oil, location intelligence is ??”

I have created the SSRS report and it’s working fine in preview mode..When i am trying to deploy it’s giving me an error.

Can anybody please help me to resolve this issue? i am using the stored procedure.

An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for data set ‘Duration’. (rsErrorExecutingCommand)
For more information about this error navigate to the report server on the local server machine, or enable remote errors

запустил Trace вот что получил по отчетам

>Crm Exception: Message: An error occurred during report rendering., ErrorCode: -2147187924, InnerException: Microsoft.Reporting.WebForms.ReportServerException: Произошла ошибка при обработке отчета. (rsProcessingAborted) —> Microsoft.Reporting.WebForms.ReportServerException: Не удалось выполнить запрос для набора данных «DSMain». (rsErrorExecutingCommand) —> Microsoft.Reporting.WebForms.ReportServerException: Чтобы получить дополнительные сведения об этой ошибке, перейдите к серверу отчетов на локальном сервере или включите удаленный контроль ошибок
— Конец трассировки внутреннего стека исключений —
— Конец трассировки внутреннего стека исключений —

в Microsoft.Reporting.WebForms.ReportViewer.RenderReport(Boolean updateDocMap)
в Microsoft.Reporting.WebForms.ReportViewer.OnPreRender(EventArgs e)
[2013-03-12 16:43:11.420] Process: w3wp |Organization:922443b7-f070-e211-b3f1-d4bed9ae575e |Thread: 11 |Category: Application |User: 00000000-0000-0000-0000-000000000000 |Level: Error |ReqId: dfed4e07-af45-4e8c-9dfe-14e37f1918c5 | ErrorInformation.LogError ilOffset = 0x17
at ErrorInformation.LogError() ilOffset = 0x17
at ErrorInformation..ctor(Exception exception, Uri requestUrl, Boolean logError, IOrganizationContext context) ilOffset = 0x1F5
at ErrorInformation..ctor(Exception exception, Uri requestUrl, IOrganizationContext context) ilOffset = 0x0
at MainApplication.Application_Error(Object sender, EventArgs eventArguments) ilOffset = 0x81
at EventHandler.Invoke(Object sender, EventArgs e) ilOffset = 0xFFFFFFFF
at HttpApplication.RaiseOnError() ilOffset = 0x26
at ApplicationStepManager.ResumeSteps(Exception error) ilOffset = 0x82
at HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData) ilOffset = 0x5C
at HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) ilOffset = 0xFC
at ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType) ilOffset = 0x45
>MSCRM Error Report:
———————————————————————————————————
Error: Выдано исключение типа «System.Web.HttpUnhandledException».

Error Number: 0x8004832C

Error Message: An error occurred during report rendering.

Error Details: An error occurred during report rendering.

Source File: Not available

Line Number: Not available

Request URL: http://crm.silumin.kz/SiluminTest/CR…ortviewer.aspx

Stack Trace Info: [ReportServerException: Чтобы получить дополнительные сведения об этой ошибке, перейдите к серверу отчетов на локальном сервере или включите удаленный контроль ошибок]

[ReportServerException: Не удалось выполнить запрос для набора данных «DSMain». (rsErrorExecutingCommand)]

[ReportServerException: Произошла ошибка при обработке отчета. (rsProcessingAborted)]
в Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)
в Microsoft.Reporting.WebForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension)
в Microsoft.Reporting.WebForms.ServerReport.Render(String format, String deviceInfo, NameValueCollection urlAccessParameters, String& mimeType, String& fileNameExtension)
в Microsoft.Reporting.WebForms.ServerModeSession.RenderReport(String format, Boolean allowInternalRenderers, String deviceInfo, NameValueCollection additionalParams, Boolean cacheSecondaryStreamsForHtml, String& mimeType, String& fileExtension)
в Microsoft.ReportingServices.Rendering.HtmlRenderer.ViewerRenderer.SPBProcessingStub.GetNextPage(RPLReport& rplReport)
в Microsoft.ReportingServices.Rendering.HtmlRenderer.HTML4Renderer.GetNextPage()
в Microsoft.ReportingServices.Rendering.HtmlRenderer.HTML4Renderer.InitializeReport()
в Microsoft.ReportingServices.Rendering.HtmlRenderer.ViewerRenderer.Render(HtmlTextWriter outputWriter)
в Microsoft.Reporting.WebForms.LocalHtmlRenderer.Render(NameValueCollection deviceInfo, PageCountMode pageCountMode, ReportControlSession reportControlSession, CreateAndRegisterStream streamCallback, String& scrollScript, String& pageStyle)
в Microsoft.Reporting.WebForms.ReportControlSession.RenderReportHTML4(NameValueCollection deviceInfo, PageCountMode pageCountMode, String& scrollScript, String& pageStyle)
в 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)
в 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)
в Microsoft.Reporting.WebForms.ReportViewer.RenderReport(Boolean updateDocMap)
в Microsoft.Reporting.WebForms.ReportViewer.OnPreRender(EventArgs e)

[CrmException: An error occurred during report rendering.]
в Microsoft.Crm.Web.Reporting.SrsReportViewer.ReportErrorHandler(Object sender, ReportErrorEventArgs e)
в Microsoft.Reporting.WebForms.ReportViewer.OnError(Exception e)
в Microsoft.Reporting.WebForms.ReportViewer.OnPreRender(EventArgs e)
в System.Web.UI.Control.PreRenderRecursiveInternal()
в System.Web.UI.Control.PreRenderRecursiveInternal()
в System.Web.UI.Control.PreRenderRecursiveInternal()
в System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

[HttpUnhandledException: Выдано исключение типа «System.Web.HttpUnhandledException».]
в System.Web.UI.Page.HandleError(Exception e)
в System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
в System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
в System.Web.UI.Page.ProcessRequest()
в System.Web.UI.Page.ProcessRequest(HttpContext context)
в System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
в System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

[2013-03-12 16:43:11.420] Process: w3wp |Organization:00000000-0000-0000-0000-000000000000 |Thread: 11 |Category: Platform |User: 00000000-0000-0000-0000-000000000000 |Level: Info |ReqId: dfed4e07-af45-4e8c-9dfe-14e37f1918c5 | FaultHelper.ConvertToFault ilOffset = 0x0
at FaultHelper.ConvertToFault(Exception exception) ilOffset = 0x0
at ErrorInformation..ctor(Exception exception, Uri requestUrl, Boolean logError, IOrganizationContext context) ilOffset = 0x24B
at ErrorInformation..ctor(Exception exception, Uri requestUrl, IOrganizationContext context) ilOffset = 0x0
at MainApplication.Application_Error(Object sender, EventArgs eventArguments) ilOffset = 0x81
at EventHandler.Invoke(Object sender, EventArgs e) ilOffset = 0xFFFFFFFF
at HttpApplication.RaiseOnError() ilOffset = 0x26
at ApplicationStepManager.ResumeSteps(Exception error) ilOffset = 0x82
at HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData) ilOffset = 0x5C
at HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) ilOffset = 0xFC
at ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType) ilOffset = 0x45
>TryConvertToFaultExceptionInternal: exception: System.Web.HttpUnhandledException
[2013-03-12 16:43:11.420] Process: w3wp |Organization:00000000-0000-0000-0000-000000000000 |Thread: 11 |Category: Platform |User: 00000000-0000-0000-0000-000000000000 |Level: Info |ReqId: dfed4e07-af45-4e8c-9dfe-14e37f1918c5 | ExceptionConverter.DumpExceptionRecursive ilOffset = 0x27C
at ExceptionConverter.DumpExceptionRecursive(StreamWriter streamWriter, Exception exception) ilOffset = 0x27C

это выборочно, в чем проблема, подскажите пожалуйста