KB: Capacity Reporting Management Pack rsErrorExecutingCommand error

In the Capacity reports window you receive the message: An error has occurred during report processing. (rsProcessingAborted) Query execution failed for dataset ‘DataSet_LinearRegression’. (rsErrorExecutingCommand).

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.

Solution:

The common language runtime (CLR) integration feature is off by default in Microsoft SQL Server, and must be enabled in order to use objects that are implemented using CLR integration. To enable CLR integration, use the clr enabled option of the sp_configure stored procedure as shown:

sp_configure 'clr enabled', 1
GO
RECONFIGURE
GO

You can disable CLR integration by setting the clr enabled option to 0. When you disable CLR integration, SQL Server stops executing all CLR routines and unloads all application domains.

If you are using SQL 2017+ then you also have to apply the steps below:

Execute on the DWH SQL instance. Change [SCOM DWH database] with the correct SCOM data warehouse DB name.

ALTER DATABASE [SCOM DWH database] SET TRUSTWORTHY ON;
GO

EXEC sp_configure 'show advanced options',1;
GO

RECONFIGURE;
GO

EXEC sp_configure 'clr strict security',0;
GO

RECONFIGURE;
GO

ALTER DATABASE [SCOM DWH database] SET TRUSTWORTHY ON;
GO