Troubleshooting “The report cannot be displayed. (rsProcessingAborted)” Error Message in CRM

When you develop an SSRS report for CRM with Visual Studio Business Intelligence Studio and test the report working in Visual Studio, but not when uploaded to CRM, you will encounter the following error:

Reporting Error

The report cannot be displayed. (rsProcessingAborted)

Try Again | Close

Reporting Error

To find out the actual error, go to the SQL Reporting Services Server, and look at the log file in C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\LogFiles.

A couple of examples of actual errors:

webserver!ReportServer_0-11!348!07/22/2014-13:28:27:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has occurred during report processing. —> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. —> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset ‘SunSystemsData’. —> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException:
System.Data.SqlClient.SqlException: User does not have permission to perform this action. —> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: User does not have permission to perform this action.

Or …

processing!ReportServer_0-11!348!07/22/2014-13:26:28:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: , Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset ‘SunSystemsData’. —> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException:
System.Data.SqlClient.SqlException: The server principal “domain\svcsqlcrm” is not able to access the database “DB_EXT” under the current security context.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s