KB 150983 – Capacity Reporting Management Pack rsErrorExecutingCommand error

KB 150983 – Capacity Reporting Management Pack rsErrorExecutingCommand error

 

Issue:

In some cases after importing the Capacity Reporting Management Pack, you might receive the error message “An error has occurred during report processing. (rsProcessingAborted) Query execution failed for dataset ‘DataSet_LinearRegression’. (rsErrorExecutingCommand) For more information about this error navigate to the report server on the local server machine, or enable remote errors” when trying to run one of the reports.

Cause:

This error is usually caused by a setting on the SQL server which hosts the SCOM data warehouse database. The setting on the SQL server prohibits the reports from executing the assembly needed for forecasting portion of the reports. For additional information please see the following Microsoft knowledge base article: https://msdn.microsoft.com/en-us/library/ms254506(v=vs.80).aspx

 

Solution:

To allow the reports to make use of (and execute) the assembly, the query below should be run on the SQL server which hosts the SCOM data warehouse database. This query can only be run by an account with sysadmin privileges.

 

sp_configure ‘clr enabled’, 1

GO

RECONFIGURE

GO