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

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.

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.