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:

  1. 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.

  2. 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.

  3. 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.

    • Note: This update contains both the x86-based and x64-based versions. Download the appropriate version for your system.

  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

  1. Restart all the consoles after the update is installed.

  2. If any customizations were backed up for the portal sidebar, merge the required changes in the updated Views\Shared\Sidebar.cshtml file.

  3. Restart the system that is hosting the portal server that is running IIS.

  4. 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};
  5. 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)
      
  6. Enable the job schedules by running the following commands:

    • $DW ='DWMS Servername'
      Get-scdwjob -Computername $DW | %{enable-scdwjobschedule -Computername $DW -jobname $_.Name}
  7. 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:

    1. Right-click a data source (such as DWDataMart), and then select Properties.

    2. 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.

    3. Under Security Settings. select Impersonation Info.

    4. If you are using Windows authentication, provide the username and password, and then select OK.

    5. Select OK.

    6. 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

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×