Skip to main content

Notifications

Microsoft Dynamics CRM (Archived)

(rsProcessingAborted) I just cannot understand it !

Posted on by 1,695

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

  • Verified answer
    Pete_N Profile Picture
    Pete_N 1,695 on at
    RE: (rsProcessingAborted) I just cannot understand it !

    Hi Scott

    The service account is NT AUTHORITY\NETWORK SERVICE .. how can I add that to the privreportinggroup

  • Suggested answer
    Aric Levin Profile Picture
    Aric Levin 30,188 on at
    RE: (rsProcessingAborted) I just cannot understand it !

    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.

  • ScottDurow Profile Picture
    ScottDurow 50,177 on at
    RE: (rsProcessingAborted) I just cannot understand it !

    This looks like your service account is not added to the PrivReportingGroup - normal users cannot query the Account table.

    See rajeevpentyala.com/.../privreportinggroup

  • Pete_N Profile Picture
    Pete_N 1,695 on at
    RE: (rsProcessingAborted) I just cannot understand it !

    I have tried with

    Domain Admin  / CRM Admin

    my own Login / System Admin

    Standard user

    all with the same result

  • Suggested answer
    Rawish Kumar Profile Picture
    Rawish Kumar 13,756 on at
    RE: (rsProcessingAborted) I just cannot understand it !

    are you trying with an admin user?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,151 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,993 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans