Thursday, September 5, 2013

The Report cannot be displayed. (rsProcessingAborted) MS CRM 2011, Report execution

one of my implementation i got the below error for the reports "The Report cannot be displayed. (rsProcessingAborted) ".
when i chekced the system reports working fine.
even if i created one more report with wizard also fine.
rollups on report server same as crm server.

i come to know my developer was using Stored Proc for the reports(SSRS).
but when i scaned the reports log i found the below...

e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: , Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'DataSet1'. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException:
System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object '<StoredProc_Name>', database 'Org_MSCRM', schema 'dbo'. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: The EXECUTE permission was denied on the object '<StoredProc_Name>', database 'Org_MSCRM', schema 'dbo'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

So from the log , i found that the user does not have access to the Stored Proc.
my report service was runnin gunder NT AUTHORITY\NETWORK SERVICE.
so i went to the stored proc and added the NT AUTHORITY\NETWORK SERVICE and gave execute permission.
to do this, go to the DB is sql studio -> Programability -> stored procudures-> right click on the Stored Proc -> properties -> Permissions -> click Search to add the NT AUTHORITY\NETWORK SERVICE and give Execute access.
then the report should execute.

No comments:

Post a Comment