SCSM : Data Warehouse Reporting MP Deployment Failed

Microsoft System Center Service Manager (SCSM) 2019 Data Warehouse Management Packs Deployment status was Failed for all the Report Library.

Below is the Operations Manager event logs for management pack error found on Data Warehouse Management Server.

Error Detail:

Deployment Execution Infrastructure has retried the maximum number of times and is giving up on this execution step.

MP Name: ServiceManager.ConfigurationManagement.Report.Library

Operation: Install

Error Message: Install 'Rpdl' operation failed from within 'install' rpdl store = http://servername/ReportServer/ReportService2005.asmx .... Uploading or saving files with .rpdl extension is not allowed.

Cause:

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

Resolution:

Add *.* to the list of extensions. 

1. Start SQL Server Management Studio, connect to report server instance.

2. Right click the report server name, select Properties and select Advanced.

3. Locate AllowResourceExtensionsForUpload settings, add "." to the list of extension then click OK.

4. No restart reporting services required.

5. Restart Deployment for the failed 

Hooray ! All Reports Library deployment are completed.

Reference: https://docs.microsoft.com/en-us/troubleshoot/system-center/scom/cannot-deploy-operations-manager-reports

SCSM: An error occurred while executing a custom action:_CreateSrsFolder_SC

Installing Microsoft System Center Service Manager (SCSM) 2019 Data Warehouse server today. 

 An error occurred while executing a custom action:_CreateSrsFolder_SC

1. Make sure SQL Server Reporting Services is running. (Release Notes)

2. Verify if able to access http://ServerName:80/ReportServer/ReportService2005.asmx

3. If prompt for login for http://ServerName:80/Reports, add server name to Internet Options Local Intranet.

That solved my problem and installation completed without error.

How to get SQL Server Product key from ISO

When installing SQL Server 2019 Reporting Service or 2017 and later, you will be ask to enter product key.

According to Microsoft article, product key can be retrieve from SQL Server 2019 installer.

Actually there is another way to get it.

When we run setup.exe from the media, the Product Key is picked from DefaultSetup.ini file located under Root\X86 or Root\x64 folder. This file is also used to make slipstream media (refer KB)

The file would look like below

Comment if you know other way to do this too.