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)
*This post is locked for comments
Hi Scott
The service account is NT AUTHORITY\NETWORK SERVICE .. how can I add that to the privreportinggroup
The error specified in the log file states:
The SELECT permission was denied on the object 'Account'. Regular users will not have access to the Account view, but only to the FilteredAccount view.
Is you query using the Account object? If so, change your query to use FilteredAccount.
Hope this helps.
This looks like your service account is not added to the PrivReportingGroup - normal users cannot query the Account table.
I have tried with
Domain Admin / CRM Admin
my own Login / System Admin
Standard user
all with the same result
are you trying with an admin user?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,151 Super User 2024 Season 2
Martin Dráb 229,993 Most Valuable Professional
nmaenpaa 101,156