Update Rollup 2 for System Center Service Manager 2019 (KB4558753)

Introduction

This article describes the issues that are fixed in Update Rollup 2 (UR2) for Microsoft System Center 2019 Service Manager. This article also contains the installation instructions for this update.

Issues that are fixed

  • When a user deletes a Service Offering (SO) category, Service manager will check whether there are SOs on that category, and prevent the category deletion. Also, the Service Manager Console will display an alert that prompts the user to delete the SO if the user wants to delete the category.

  • Surface devices that are imported by the System Center Configuration Manager connector will not be marked as virtual machines.

  • Users can still update other requests even if they are removed as affected users from one of their requests through the Self Service Portal.

  • Users can scroll correctly on all standard forms on the work items tab.

  • Made enhancements to the startup time of the SDK service.

  • Users can now read and update the manual activity from the Self Service Portal.

  • When a user opens manual activity from any IR/CR and runs the custom task, the task runs without errors.

  • Each Portal Trace log now shows Thread ID, Process ID, Date, and Time in UTC.

  • System Center Service Manager 2019 UR2 supports newer releases of Configuration Manager. For the latest information about the supported releases, see the "Supported coexistence" section of System requirements for System Center Service Manager.

  • This update enables support for the MSOLEDBSQL driver on all Management servers including Primary (Workflow), Data Warehouse, and Secondary Management servers. However, this is true only if the MSOLEDBSQL driver is installed. For more information about how to install the MSOLEDBSQL driver, see Microsoft OLE DB driver for SQL Server.

    NoteSQLNCLI has been deprecated.

  • Manual steps are required to change the provider in SQL Server Analysis Server. See the "Steps to change the provider in SQL Server Analysis Server" section.

How to obtain Update Rollup 2 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.

Known issues in this update

Symptom
Microsoft is receiving reports that workflows are delayed because the MonitoringHost.exe process is intermittently crashing. Event ID 1026 is also logged in the event viewer together with "UnauthorizedAccessException" exception information.

Resolution
Run this SQL script after you apply Update Rollup 2.

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 one time 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.

After the 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 is a list of files that have changed in this update rollup.
 

File name

File version

File size

Microsoft.EnterpriseManagement.NewSMPortal.SDKTransformer.dll

10.19.1035.101

74KB

Microsoft.EnterpriseManagement.NewSMPortal.SMPortalHelper.dll

10.19.1035.101

119KB

Microsoft.Mom.CmdbInstanceSubscriptionDataSourceModule.dll

10.19.1035.101

316KB

MakeForm.cshtml

Not applicable

29KB

Index.cshtml

Not applicable

14KB

Sidebar.cshtml

Not applicable

6KB

RequestDetails.cshtml

Not applicable

18KB

SelfServicePortalWebApp.dll

10.19.1035.101

71KB

Microsoft.EnterpriseManagement.UI.SdkDataAccess.dll

10.19.1035.101

2715KB

Microsoft.EnterpriseManagement.Core.dll

10.19.1035.101

4043KB

Microsoft.EnterpriseManagement.Core.resources.dll

10.19.1035.101

214KB

Microsoft.EnterpriseManagement.ServiceManager.ConfigurationManagement.Forms.dll

10.19.1035.101

111KB

Microsoft.EnterpriseManagement.ServiceManager.Application.Common.dll

10.19.1035.101

1743KB

Microsoft.EnterpriseManagement.DataAccessLayer.dll

10.19.1035.101

2481KB

Microsoft.EnterpriseManagement.DataAccessService.core.dll

10.19.1035.101

697KB

SelfServicePortalResources.resx

Not applicable

22KB

SelfServicePortalResources.pt-BR.resx

Not applicable

23KB

SelfServicePortalResources.cs.resx

Not applicable

23KB

SelfServicePortalResources.da.resx

Not applicable

23KB

SelfServicePortalResources.de.resx

Not applicable

23KB

SelfServicePortalResources.el.resx

Not applicable

26KB

SelfServicePortalResources.en.resx

Not applicable

22KB

SelfServicePortalResources.es.resx

Not applicable

23KB

SelfServicePortalResources.fi.resx

Not applicable

23KB

SelfServicePortalResources.fr.resx

Not applicable

23KB

SelfServicePortalResources.hu.resx

Not applicable

23KB

SelfServicePortalResources.it.resx

Not applicable

23KB

SelfServicePortalResources.ja.resx

Not applicable

24KB

SelfServicePortalResources.ko.resx

Not applicable

23KB

SelfServicePortalResources.nl.resx

Not applicable

23KB

SelfServicePortalResources.no.resx

Not applicable

22KB

SelfServicePortalResources.pl.resx

Not applicable

23KB

SelfServicePortalResources.pt.resx

Not applicable

23KB

SelfServicePortalResources.ru.resx

Not applicable

26KB

SelfServicePortalResources.sv.resx

Not applicable

23KB

SelfServicePortalResources.tr.resx

Not applicable

23KB

SelfServicePortalResources.zh-CHS.resx

Not applicable

22KB

SelfServicePortalResources.zh-CHT.resx

Not applicable

22KB

Microsoft.EnterpriseManagement.Warehouse.Olap.dll

10.19.1035.101

194KB

Config.xml

Not applicable

1KB

Microsoft.SystemCenter.Instrumentation.dll

10.19.1035.101

57KB

Microsoft.ApplicationInsights.dll

2.12.0.21496

378KB

Microsoft.EnterpriseManagement.Core.Cmdlets.dll

10.19.1035.101

208KB

Microsoft.SystemCenter.Telemetry.SMUTCConverter.dll

10.19.1035.101

25KB

Microsoft.EnterpriseManagement.ServiceManager.Sdk.dll

10.19.1035.101

282KB

Microsoft.EnterpriseManagement.ServiceManager.UI.Console.exe

10.19.1035.101

973KB

Microsoft.EnterpriseManagement.ServiceManager.Incident.Forms.dll

10.19.1035.101

550KB

build_scdm_db.sql

Not applicable

505KB

build_scdw_db.sql

Not applicable

569KB

build_sm_db.sql

Not applicable

6965KB

build_mom_db_postMPimportSM.sql

Not applicable

88KB

Microsoft.Windows.Library.mp

Not applicable

697KB

Microsoft.Windows.Peripheral.Library.mp

Not applicable

61KB

Microsoft.EnterpriseManagement.ServiceManager.Connector.Sms.mp

Not applicable

73KB

Microsoft.EnterpriseManagement.ServiceManager.Connector.Sms2011.mp

Not applicable

73KB

Microsoft.SystemCenter.InstanceGroup.Library.mp

Not applicable

37KB

System.AdminItem.Library.mp

Not applicable

53KB

ConfigManagementPack.mpb

Not applicable

380KB

System.Software.Library.mpb

Not applicable

80KB

System.Library.mp

Not applicable

53KB

Authoring.mpb

Not applicable

281KB

Incident.mpb

Not applicable

976KB


 

Need more help?

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

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×