Update Rollup 6 for System Center 2019 Orchestrator

Introduction

This article describes the issues that have been fixed for Microsoft System Center 2019 Orchestrator. This article also contains the installation instructions for the hotfix.

The UR6 update for Orchestrator does not include any updates for the (deprecated) Orchestrator Web Features application.

However, UR6 update includes improvements to the new HTML5 web console and .NET 6 JSON based REST API (see migration steps and the associated blog post) that was released for 2019 customers. Migrate to the new API and console to enjoy the UR6 improvements (KB5035767_Microsoft.SystemCenter.Orchestrator.WebConsole_x64.msp and KB5035767_Microsoft.SystemCenter.Orchestrator.WebApi_x64.msp)

Issues that are fixed

OEDC.exe (Event Delivery Configuration) updated to use MSOLEDBSQL driver instead of SQLNCLI. Learn more about the drivers here.
Active Job list in Web console shows the complete list of all the jobs that are running.
Run SSH Command will not work with the latest version of Linux machines, which have newer cipher requirements. To run SSH command, download the latest binary of plink.exe from the official website (x64 version may be used). The binary should be renamed to SshClient.exe and placed at path C:\Program Files (x86)\Common Files\Microsoft System Center 2012\Orchestrator\Extensions\Support\SSH

Other Improvements and Features

The following improvements apply only to the new Web API and Web Console of 2019:

Web Console Filtering: You can now take advantage of the powerful filtering system, for enhanced experience in both the job view and instance view.
Initial load time of the navigation tree on the Web Console reduced with optimizations made in the API authorization cache. On large SCO instances, the navigation tree would sometimes show only a subset of entries. However, with the optimization, all the entries are rendered. Ensure to follow the steps below to reflect these changes:
- Locate web.config file at path 'C:\Program Files\Microsoft System Center\Orchestrator\WebApi' and add timeout environment variable.
  
  You may choose to increase this timeout if all runbooks and folders are still not loading properly by configuring the AuthCacheComputationTimeout parameter in web.config.
  <environmentVariable name="AuthCacheConfig:AuthCacheComputationTimeout" value="900" />
- Download the SQL script, open SQL Server Management Studio, connect to your Orchestrator database, and execute this script. We recommend backing up your Orchestrator database to prevent any data loss.

How to obtain Update Rollup 6 for System Center 2019 Orchestrator

Important 

Before you install this update, make sure SQL driver (MSOLEDBSQL) version 18.6.0 is installed on the Management server role. For detailed information, see Microsoft OLE DB driver for SQL Server.

Update packages for Orchestrator are available from Microsoft Update or by manual download.

Windows Update

To obtain and install an update package from Windows Update, follow these steps on a computer that has an Orchestrator component installed:

Select Start, and then select Control Panel.
In Control Panel, double-click Windows Update.
In the Windows Update window, select Check Online for updates from Microsoft Update.
Select Important updates are available.
Select the Update Rollup package, and then select OK.
Select Install updates to install the update package.

Manual download

Go to the following website to manually download the update package from the Microsoft Update Catalog:

Download the Orchestrator UR6 packages now.

For information about how to download Microsoft support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to obtain Microsoft support files from online services

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file.

Installation instructions for Orchestrator

Download the update packages that Microsoft Update provides for each computer. Microsoft Update provides the appropriate updates according to the components that are installed on each computer. Or manually download from the Microsoft Update Catalog.

After the Orchestrator updates are installed, reconfigure the Orchestrator database by using the existing database according to these guidelines.

Uninstall UR6

The Runbook Server, Runbook Designer, and Management Server and Web Console UR6 packages can be uninstalled using Control Panel > Add or Remove Programs > View installed Updates
Uninstalling the Web API UR6 package from Control Panel will reset all the configurations made to C:\Program Files\Microsoft System Center\Orchestrator\WebApi\web.config. You must either take a backup or uninstall the patch with this command from an Administrator PowerShell:

msiexec /l*v api-patch-unlog.txt /package '{57C1056A-1A87-438A-BEA7-5A3016F1B2C8}' /uninstall '{EC6EC3CD-7264-4709-B7A1-F7818B785D2C}'

The command line uninstallation will preserve web.config.