Operations Manager 2019 and 1807 reports fail to deploy

Applies to: System Center 2019 Operations ManagerSystem Center Operations Manager, version 1807

Symptoms


When you install System Center 2019 Operations Manager together with the latest version of SQL Server Reporting Services (SSRS) 2017, Operations Manager reports do not deploy.

When you open the Reporting view in the Operations console, and select any of the folders, the list of reports is empty. Additionally, error messages that resemble the following are logged in the Operations Manager event log:


Note This issue also occurs in System Center Operations Manager version 1807 when you upgrade to SSRS 2017, and then you remove and reinstall Operations Manager Reporting.

Cause


SSRS 2017 version 14.0.600.1274 and later versions include a new advanced setting, AllowedResourceExtensionsForUpload. This setting restricts the set of extensions of resources files that can be uploaded to the report server. This issue occurs because Operations Manager Reporting uses extensions that aren't included in the default set in AllowedResourceExtensionsForUpload.

Resolution


To fix the issue, use one of the following methods:

Method 1

Add *.* to the list of extensions. To do this, follow these steps:

  1. Start SQL Server Management Studio, and then connect to a report server instance that Operations Manager uses.

  2. Right-click the report server name, select Properties, and then select Advanced.
  3. Locate the AllowedResourceExtensionsForUpload setting, add *.* to the list of extensions, and then select OK.
  4. Restart SSRS.
     

Method 2

Use PowerShell script to add the extensions. To do this, run the following PowerShell script:


Note You have to populate the $ServiceAddress variable by using a valid address of your report service for HTTPS. If you don’t use HTTPS at all, change the script to use HTTP. The list of extensions in the script may not be exhaustive. Include your own extensions as appropriate.