Share via

System Center Operations Manager - Exchange 2010 Reporting Error “An error has occurred during report processing”

  • Article

 

Recently I was doing a clean install of the new Exchange 2010 Management Pack for System Center Operations Manger 2007 R2 and ran into the following error when running reports for the first time.

-----------

Error Details:

Microsoft.Reporting.WinForms.ReportServerException: An error has occurred during report processing. (rsProcessingAborted) ---> Microsoft.Reporting.WinForms.ReportServerException: Query execution failed for dataset 'CalculateReportParameterDates'. (rsErrorExecutingCommand) ---> Microsoft.Reporting.WinForms.ReportServerException: For more information about this error navigate to the report server on the local server machine, or enable remote errors

--- End of inner exception stack trace ---

--- End of inner exception stack trace ---

at Microsoft.Reporting.WinForms.ServerReport.GetExecutionInfo()

at Microsoft.Reporting.WinForms.ServerReport.GetParameters()

at Microsoft.EnterpriseManagement.Mom.Internal.UI.Reporting.Parameters.ReportParameterBlock.Initialize(ServerReport serverReport)

at Microsoft.EnterpriseManagement.Mom.Internal.UI.Console.ReportForm.SetReportJob(Object sender, ConsoleJobEventArgs args)

Microsoft.Reporting.WinForms.ReportServerException: Query execution failed for dataset 'CalculateReportParameterDates'. (rsErrorExecutingCommand) ---> Microsoft.Reporting.WinForms.ReportServerException: For more information about this error navigate to the report server on the local server machine, or enable remote errors

--- End of inner exception stack trace ---

Microsoft.Reporting.WinForms.ReportServerException: For more information about this error navigate to the report server on the local server machine, or enable remote errors

After doing some research on this issue it turns this error is caused by the Data Warehouse reader account not having the correct permissions for some items in the data warehouse database. To resolve this you can run the the following SQL query to set the permissions needed.

Like always I suggest that you have a known good backup of the databases before making any changes to it.

Open SQL Management Studio and run the query below.

-----------

USE [OperationsManagerDW]
GO
GRANT SELECT, EXECUTE ON SCHEMA :: Exchange2010 TO “DOMAIN\DataReaderAccount”
GO
-----------

Replace the [OperationsManagerDW] with the name of your data warehouse if yours differs from the default install. Also you will need to replace DOMAIN\DataReaderAccount with the account that your SQL reporting services instance is running under. This should be the data reader account that was configured during the installation of SCOM Reporting.