Dynamics Community Forum Thread Details

(rsProcessingAborted) I just cannot understand it !

CRM2016 On Premisis

For some reason I am getting the dreaded rsProcessingAborted messag when trying to run a specific report. other reports run fine

I went back to basics, created a blank report in my VS project. Added an Image and uploaded it to CRM on the invoice entity. So far so good.

In Reports , I can run the report and it is displayed ok.

If I open an invoice and run the report I get the rsprocessing aborted

(part of report server log below )

The CRM is running on network/service

SQL Reporting Server running on network/service

the log is showing an error Select permission was denied

crypto!ReportServer_0-1!170c!01/11/2018-19:04:18:: i INFO: Initializing crypto as user: NT AUTHORITY\NETWORK SERVICE
crypto!ReportServer_0-1!170c!01/11/2018-19:04:18:: i INFO: Exporting public key
crypto!ReportServer_0-1!170c!01/11/2018-19:04:18:: i INFO: Importing existing encryption key
library!ReportServer_0-1!170c!01/11/2018-19:04:26:: i INFO: Entering StreamRequestHandler.ExecuteCommand - Command = Render
library!ReportServer_0-1!170c!01/11/2018-19:04:27:: i INFO: RenderForNewSession('/Operations_MSCRM/CustomReports/{c39e7eda-2bf2-e711-8461-00155d011b1f}')
processing!ReportServer_0-1!170c!01/11/2018-19:04:33:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: , Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'InvoiceHeader'. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException:
System.Data.SqlClient.SqlException: The SELECT permission was denied on the object 'Account', database 'Operations_MSCRM', schema 'dbo'. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: The SELECT permission was denied on the object 'Account', database 'Operations_MSCRM', schema 'dbo'.
   --- End of inner exception stack trace ---
   at Microsoft.Crm.Reporting.DataExtension.Common.ExceptionManager.HandleUnsafeException[TResult](Func`1 body)
   at Microsoft.Crm.Reporting.DataExtensionShim.Common.ICrmDbCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.Crm.Reporting.DataExtensionShim.Common.SrsExtCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.ReportingServices.OnDemandProcessing.RuntimeLiveQueryExecutor.ExecuteReader(IJobContext jobContext, DataSourceErrorInspector errorInspector, String commandText)

Quick Links

Leaderboard