Applies to: System Center 2019 Service Manager
Introduction
This article describes the issues that are fixed in Update Rollup 4 (UR4) for Microsoft System Center 2019 Service Manager. This article also contains the installation instructions for this update.
Issues that are fixed
- Workflows will execute successfully even if related entity changes are already groomed out.
- Provided an option to add a new setting “CalculateNotificationsCount" to the Portal’s web.config file. If it exists and its value is “false”, then the Portal’s main page can open faster because the "Notification circles" on the left menu will not be shown.
- Intensive tracing has been added to trace an issue during missing or duplicate indexes on FACT tables of DWRepository database.
- Personalization settings on Views will not be reset to default when re/connecting via RDP.
- Changes to the task pane width of an Incident form is persisted even when it is closed and reopened.
- No more console crashes when views are grouped and re/connected via RDP.
- No more console crashes when special characters are used in a task.
- The commandlet Set-SCDWRetentionPeriod will now correctly configure the provided data retention period.
- Fixed an issue where the SCOM CI connector incorrectly marks a CI as PendingDelete when this CI is removed in SCOM but is still discovered by other connectors like AD, SCCM Connector or SDKDefaultConnector.
- The issue with duplicating a notification template showing an error that it could not resolve an alias in the management pack definition has been fixed.
- The label "Last Updated" of Knowledge Article was incorrect in the Self-Service Portal and it has been corrected to "Created Date".
- Manual steps are required to change the provider in SQL Server Analysis Server. See below section "Steps to change the provider in SQL Server Analysis Server".
How to obtain Update Rollup 4 for System Center Service Manager 2019
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:
Download the Service Manager update package now.
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
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
Download the update to a target folder.
- Note: This update contains both the x86-based and x64-based versions. Download the appropriate version for your system.
Open the target folder, and then right-click the downloaded file from step 2.
Select Run as administrator.
Accept the Microsoft Software License terms, and then follow the steps in the installation wizard.
Post installation
Restart all the 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.
Disable all the Data Warehouse jobs. To do this, open the Service Manager shell, and then run the following commands:
-
$DW ='DWMS Servername; Get-scdwjob -Computername $DW | %{disable-scdwjobschedule -Computername $DW -jobname $_.Name};
-
Make the required changes in the following PowerShell script based on the data source views in your environment, and then run the script by using elevated privileges:
-
$SSAS_ServerName = "ssas servername" # - to be replaced with Analysis Service instance Name [System.Reflection.Assembly]::LoadWithPartialName("Microsoft.AnalysisServices") $Server = New-Object Microsoft.AnalysisServices.Server $Server.Connect($SSAS_ServerName) $Databases = $Server.Databases $DWASDB = $Databases["DWASDataBase"] #update DWDatamart dsv. Comment the below 3 commands if DWdatamart dsv is not present $DWASDB.DataSourceViews["DwDataMart"].Schema.Tables["OperatingsystemDim"].Columns["PhysicalMemory"].DataType = [decimal] $DWASDB.DataSourceViews["DwDataMart"].Schema.Tables["LogicalDiskDim"].Columns["Size"].DataType = [decimal] $DWASDB.DataSourceViews["DwDataMart"].Update([Microsoft.AnalysisServices.UpdateOptions]::ExpandFull) #update CMDatamart dsv.Comment the below 2 commands if cmdatamart dsv is not present $DWASDB.DataSourceViews["CMDataMart"].Schema.Tables["OperatingsystemDim"].Columns["PhysicalMemory"].DataType = [decimal] $DWASDB.DataSourceViews["CMDataMart"].Update([Microsoft.AnalysisServices.UpdateOptions]::ExpandFull) #update OperatingsystemDim $DWASDB.Dimensions["OperatingsystemDim"].Attributes["PhysicalMemory"].KeyColumns[0].DataType = [System.Data.OleDb.OleDbType]::Double $DWASDB.Dimensions["OperatingsystemDim"].Update([Microsoft.AnalysisServices.UpdateOptions]::ExpandFull + [Microsoft.AnalysisServices.UpdateOptions]::AlterDependents) #update LogicalDiskDim $DWASDB.Dimensions["LogicalDiskDim"].Attributes["Size"].KeyColumns[0].DataType = [System.Data.OleDb.OleDbType]::Double $DWASDB.Dimensions["LogicalDiskDim"].Update([Microsoft.AnalysisServices.UpdateOptions]::ExpandFull + [Microsoft.AnalysisServices.UpdateOptions]::AlterDependents)
-
Enable the job schedules by running the following commands:
-
$DW ='DWMS Servername' Get-scdwjob -Computername $DW | %{enable-scdwjobschedule -Computername $DW -jobname $_.Name}
-
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.
Open SQL Server Management Studio and connect to the Analysis Services role.
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).
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.
Files updated in this update rollup
The following files have been changed in this update rollup:
| File name | Version | File size |
|---|---|---|
| Microsoft.EnterpriseManagement.NewSMPortal.SDKTransformer.dll | 10.19.1035.137 | 74KB |
| Microsoft.EnterpriseManagement.NewSMPortal.SMPortalHelper.dll | 10.19.1035.137 | 119KB |
| Microsoft.Mom.CmdbInstanceSubscriptionDataSourceModule.dll | 10.19.1035.137 | 317kb |
| MakeForm.cshtml | Not applicable | 28.3kb |
| Index.cshtml | Not applicable | 13.6kb |
| Sidebar.cshtml | Not applicable | 5.57kb |
| RequestDetails.cshtml | Not applicable | 17.9kb |
| SelfServicePortalWebApp.dll | 10.19.1035.137 | 71.4kb |
| Microsoft.EnterpriseManagement.UI.SdkDataAccess.dll | 10.19.1035.137 | 2.65mb |
| Microsoft.EnterpriseManagement.Core.dll | 10.19.1035.137 | 3.94mb |
| Microsoft.EnterpriseManagement.Core.resources.dll | 10.19.1035.137 | 214KB |
| Microsoft.EnterpriseManagement.ServiceManager.ConfigurationManagement.Forms.dll | 10.19.1035.137 | 111KB |
| Microsoft.EnterpriseManagement.ServiceManager.Application.Common.dll | 10.19.1035.137 | 1.7mb |
| Microsoft.EnterpriseManagement.DataAccessLayer.dll | 10.19.1035.137 | 2.42mb |
| Microsoft.EnterpriseManagement.DataAccessService.core.dll | 10.19.1035.137 | 699kb |
| SelfServicePortalResources.resx | Not applicable | 21.6kb |
| SelfServicePortalResources.pt-BR.resx | Not applicable | 22.4kb |
| SelfServicePortalResources.cs.resx | Not applicable | 22.4kb |
| SelfServicePortalResources.da.resx | Not applicable | 22kb |
| SelfServicePortalResources.de.resx | Not applicable | 22.5kb |
| SelfServicePortalResources.el.resx | Not applicable | 25.8kb |
| SelfServicePortalResources.en.resx | Not applicable | 21.6kb |
| SelfServicePortalResources.es.resx | Not applicable | 22.4kb |
| SelfServicePortalResources.fi.resx | Not applicable | 22.1kb |
| SelfServicePortalResources.fr.resx | Not applicable | 22.4kb |
| SelfServicePortalResources.hu.resx | Not applicable | 22.6kb |
| SelfServicePortalResources.it.resx | Not applicable | 22.5kb |
| SelfServicePortalResources.ja.resx | Not applicable | 23kb |
| SelfServicePortalResources.ko.resx | Not applicable | 22.3kb |
| SelfServicePortalResources.nl.resx | Not applicable | 22.2kb |
| SelfServicePortalResources.no.resx | Not applicable | 21.9kb |
| SelfServicePortalResources.pl.resx | Not applicable | 22.6kb |
| SelfServicePortalResources.pt.resx | Not applicable | 22.2kb |
| SelfServicePortalResources.ru.resx | Not applicable | 25.1kb |
| SelfServicePortalResources.sv.resx | Not applicable | 22kb |
| SelfServicePortalResources.tr.resx | Not applicable | 22.2kb |
| SelfServicePortalResources.zh-CHS.resx | Not applicable | 21.5kb |
| SelfServicePortalResources.zh-CHT.resx | Not applicable | 21.6kb |
| Microsoft.EnterpriseManagement.Warehouse.Olap.dll | 10.19.1035.137 | 194KB |
| Config.xml | Not applicable | 701b |
| Microsoft.SystemCenter.Instrumentation.dll | 10.19.1035.137 | 57.4kb |
| Microsoft.ApplicationInsights.dll | 2.12.0.21496 | 377kb |
| Microsoft.EnterpriseManagement.Core.Cmdlets.dll | 10.19.1035.137 | 208KB |
| Microsoft.SystemCenter.Telemetry.SMUTCConverter.dll | 10.19.1035.137 | 25.9kb |
| Microsoft.EnterpriseManagement.ServiceManager.Sdk.dll | 10.19.1035.137 | 282KB |
| Microsoft.EnterpriseManagement.ServiceManager.UI.Console.exe | 10.19.1035.137 | 975kb |
| Microsoft.EnterpriseManagement.ServiceManager.Incident.Forms.dll | 10.19.1035.137 | 550KB |
| build_scdm_db.sql | Not applicable | 505kb |
| build_scdw_db.sql | Not applicable | 568kb |
| build_sm_db.sql | Not applicable | 6.8mb |
| build_mom_db_postMPimportSM.sql | Not applicable | 86.7kb |
| Microsoft.Windows.Library.mp | Not applicable | 696kb |
| Microsoft.Windows.Peripheral.Library.mp | Not applicable | 61.9kb |
| Microsoft.EnterpriseManagement.ServiceManager.Connector.Sms.mp | Not applicable | 73.9kb |
| Microsoft.EnterpriseManagement.ServiceManager.Connector.Sms2011.mp | Not applicable | 73.9kb |
| Microsoft.SystemCenter.InstanceGroup.Library.mp | Not applicable | 36.9kb |
| System.AdminItem.Library.mp | Not applicable | 52.9kb |
| ConfigManagementPack.mpb | Not applicable | 396kb |
| System.Software.Library.mpb | Not applicable | 80KB |
| System.Library.mp | Not applicable | 280kb |
| Authoring.mpb | Not applicable | 832kb |
| Incident.mpb | Not applicable | 0.98mb |
| WarehouseCoreMP.mpb | Not applicable | 324kb |
| Article.cshtml | Not applicable | 12.8kb |