Environment :- SCOM 2019, SQL 2017, SSRS 2017.
SCOM 2019 report deployment is failing with the errors:-
Failed to deploy reporting component to the SQL Server Reporting Services server. The operation will be retried. Exception ‘DeploymentException’: Failed to deploy reports for management pack with version dependent id ‘684a5817-ab9a-19a8-2fc5-7a0088bfe831’. Failed to deploy linked report ‘Microsoft.SystemCenter.WebApplicationSolutions.Reporting.WebTestPerformanceReport’. The item ‘/Microsoft.SystemCenter.DataWarehouse.Report.Library/Microsoft.SystemCenter.DataWarehouse.Report.Performance’ cannot be found. —> Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item ‘/Microsoft.SystemCenter.DataWarehouse.Report.Library/Microsoft.SystemCenter.DataWarehouse.Report.Performance’ cannot be found.
Failed to deploy reporting component to the SQL Server Reporting Services server. The operation will be retried. Exception ‘DeploymentException’: Failed to deploy reports for management pack with version dependent id ‘b0d3479b-d13a-3b71-3fa5-f7fcafd82d7d’. Failed to deploy report ‘Microsoft.SystemCenter.DataWarehouse.Report.MostCommonEvents’. Thread was being aborted.
Failed to deploy reporting component to the SQL Server Reporting Services server. The operation will be retried. Exception ‘DeploymentException’: Failed to deploy reports for management pack with version dependent id ‘684a5817-ab9a-19a8-2fc5-7a0088bfe831’. Failed to deploy linked report ‘Microsoft.SystemCenter.WebApplicationSolutions.Reporting.WebTestPerformanceReport’. The item ‘/Microsoft.SystemCenter.DataWarehouse.Report.Library/Microsoft.SystemCenter.DataWarehouse.Report.Performance’ cannot be found. —> Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item ‘/Microsoft.SystemCenter.DataWarehouse.Report.Library/Microsoft.SystemCenter.DataWarehouse.Report.Performance’ cannot be found.
Failed to deploy reporting component to the SQL Server Reporting Services server. The operation will be retried. Exception ‘DeploymentException’: Failed to deploy reports for management pack with version dependent id ‘684a5817-ab9a-19a8-2fc5-7a0088bfe831’. Failed to deploy linked report ‘Microsoft.SystemCenter.WebApplicationSolutions.Reporting.WebTestPerformanceReport’. The item ‘/Microsoft.SystemCenter.DataWarehouse.Report.Library/Microsoft.SystemCenter.DataWarehouse.Report.Performance’ cannot be found. —> Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item ‘/Microsoft.SystemCenter.DataWarehouse.Report.Library/Microsoft.SystemCenter.DataWarehouse.Report.Performance’ cannot be found.
Failed to deploy reporting component to the SQL Server Reporting Services server. The operation will be retried. Exception ‘DeploymentException’: Failed to deploy reports for management pack with version dependent id ’62c5d977-1af6-c027-853e-9f03333ffd63′. Uploading or saving files with .PerformanceBySystem extension is not allowed. Contact your administrator if you have any questions. —> Microsoft.ReportingServices.Diagnostics.Utilities.ResourceFileFormatNotAllowedException: Uploading or saving files with .PerformanceBySystem extension is not allowed. Contact your administrator if you have any questions.
Resolution :- This is because of a security restriction in later builds of SSRS 2017. The fix is to open SQL Management Studio, connect to your Reporting Services instance, open the Properties of the instance, Advanced, and add . to the list for “AllowedResourceExtensionsForUpload” .