Applies to: System Center 2022 Service Manager
Introduction
This article describes the new features and issues that are fixed in System Center Service Manager 2022 Update Rollup 3. This article also contains installation instructions and updated files for this UR.
All System Center Service Manager update rollups are cumulative. This means, you don't need to apply the URs in order; you can always apply the latest update. If you've deployed System Center – Service Manager and never applied an update rollup, you can proceed to install the latest one available.
Issues that are fixed
Service Manager 2022 Update Rollup 3 includes fixes for the following issues:
-
Resolved the crash of MonitoringHost on new processors and OS builds and due to GroupCalc issue.
-
Image in internal content for Knowledge articles are now displayed correctly.
-
Resolved the error in portal that encountered during the submission of Review decision with html tag characters.
-
Share button in the Self-Service Portal are not cropped anymore when non-English characters are encountered.
-
For instances where UR2 installation was failing, now you can apply UR3 which also provides bug fixes and enhancements available in UR2.
How to obtain Update Rollup 3 for System Center Service Manager 2022
Update packages for Service Manager are available for manual download. Go to the following website to manually download the update package from the Microsoft Download Center:
Installation instructions
Before the installation
Before you apply this update, follow these steps:
-
Exit all Service Manager-related applications before you apply this update. For example, exit the Service Manager console, the Self-Service Portal links, and the authoring tool.
-
Make sure that the Data Warehouse Server has successfully synchronized with the Management Server at least once, without any management packs in the Pending Disassociation, Pending Association, or Imported status.
-
If you have customizations in the portal sidebar, make a backup of the Views\Shared\Sidebar.cshtml file.
Installation
1. Make sure that the update is installed on the Service Manager components in the following order:
-
Data Warehouse server
-
Primary Management server
-
Secondary Management servers
-
Self Service Portal server
-
All Analyst consoles
2. Download the update to a target folder.
3. Open the target folder, and then right-click the downloaded file from step 2.
4. Select Run as administrator.
5. Accept the Microsoft Software License terms, and then follow the steps in the installation wizard.
Post Installation
-
Restart the System Center Data Access Service on the Primary Management Server and all Secondary Management Servers.
-
Restart all the Analyst consoles after the update is installed.
-
If any customizations were backed up for the portal sidebar, merge the required changes in the updated Views\Shared\Sidebar.cshtml file.
-
Restart the system that is hosting the portal server that is running IIS.
-
Restart the Data Warehouse management server.
Steps to change the provider in SQL Server Analysis Server
Important: Follow these steps only after you install the latest SQL driver (MSOLEDBSQL or the Microsoft SqlClient Data Provider for SQL Server) on the SQL Server Analysis Server role. For more information about how to install MSOLEDBSQL, see Microsoft OLE DB driver for SQL Server. For more information about SqlClient, see Overview of the SqlClient driver.
1. Open SQL Server Management Studio and connect to the Analysis Services role.
2. Expand Databases > [Analysis Service DB] > Data Sources.
-
Note: In this path, replace [Analysis Service DB] with the name of the actual Analysis Service database (usually DWASDataBase).
3. Repeat the following actions for all listed data sources:
-
Right-click a data source (such as DWDataMart), and then select Properties.
-
Under General, select Connection String, select Connection Manager, select the Providers list. and then change the provider name, as appropriate:
-
For .Net Providers, select .Net SQLClient provider, and then select OK.
-
For MSOLEDBSQL provider, change the provider name from SQLNCLI11 to MSOLEDBSQL.
-
Under Security Settings, select Impersonation Info.
-
If you are using Windows authentication, provide the username and password, and then select OK.
-
Select OK.
-
Restart SQL Server Analysis Service from Services.msc.
