Orchestrator: Runbook Designer throw error "The server threw an exception"

After installed Microsoft System Center Orchestrator 2019 Update Rollup 2, connection error when launch Runbook Designer.

Event ID 10007 found with error Application or service 'Orchestrator Runbook Service' could not be restarted.

I missed the Important section :

Microsoft OLE DB Driver already installed for SQL Server 2019.

One more step that need to be done. Reconfigure the Orchestrator database by using Data Source Configuration.

After completed the step below for Data Source Configuration. Runbook Designer is working good now.

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.

SCCM : Event ID 1130 Startup Script failed

Today troubleshooting SCCM GPO client push issue. Manually execute the batch script from local machine working fine, but it not working from GPO. 

First, check RSoP to ensure the GPO is deployed to the machine. ✅

Second, check Event Log and found error below: 

Event Log ID       : 1130

Source                  : GroupPolicy

Error                     : Startup script failed

Error Description : Access is denied

The root cause for this is access denied from the client machine to the Installer shared folder. 

After granted permission Authenticated Users - Read & execute to the folder, it work again ! ✅