Update Rollup 9 for System Center 2016 Service Manager

Applies to: System Center 2016 Service Manager

Introduction


This article describes the issues that are fixed in Update Rollup 9 for Microsoft System Center 2016 Service Manager. This article also contains the installation instructions for this update.

Improvements and issues that are fixed


  • Enables support for the MSOLEDBSQL driver so that users can move from SQL Native Client. Manual steps are required to use the MSOLEDBSQL driver together with SQL Server Analysis Server (SSAS). (See the next section.)
  • Fixes an issue in which the query results are not localized if the language of the portal is non-English.
  • Fixes an issue in which the user is not able to submit a service request if one of the lists contains an item that included a plus sign (+).
  • When you submit a service request, the new default is that the first item in the list is not selected. This makes sure that the right category item is selected by the user.
  • Fixes an issue in which some users cannot submit requests through the portal, and they receive a "The given key was not present in the dictionary" error message.
  • Supports the SCCM 1806, 1810, 1902, 1906, 1910, and 2002 releases. However, the size of the devices that are supported by SCCM is limited to less than 2 PB. 

Steps to change provider in SQL Server Analysis Server


Important:  Follow the below steps only after you have installed latest SQL driver (MSOLEDBSQL) on the SQL Server Analysis Server role, on the Data Warehouse Databases role, and on the Management Server role. For more information, see Microsoft OLE DB driver for SQL Server.

  1. Open SQL Server Management Studio, and navigate to Databases > [Analysis Service DB] > Datasources > [DW DB]. 

    Note In this path, replace [Analysis Service DB] with the name of the actual Analysis Service database, and [DW DB] with the name of the actual Data Warehouse database.
  2. Right-click DW DB, and then select Properties.
  3. On the Properties tab, change the provider name from "SQL Native Client" to "MSOLEDBSQL" in the connection string.
  4. Under Security Settings. select Impersonation Info.
  5. Provide the username and password if you are using Windows authentication, and then select  OK.

    Note The properties pane now reflects the new provider name in the connection string.
  6. Select OK.
  7. Restart SQL Server Analysis Service from services.msc.

How to obtain Update Rollup 9 for System Center 2016 Service Manager


Update packages for Service Manager are available by manual download.

Manual download

Go to the following website to manually download the update package from the Microsoft Download Center:


Installation Instructions for Service Manager


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.
  3. 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
  4. If you have customizations in the portal sidebar, edit the sidebar by using the steps in the "Customizing the left menu bar" section of Deploy the new Self-Service Portal.
  5. Make a backup of the Views\Shared\Sidebar.cshtml file.

Installation

  1. Download the update to a target folder. This update contains both the x86-based version and the x64-based version. Download the appropriate version for your system.
  2. Open the target folder, and then right-click the downloaded file from step 1.
  3. Select Run as administrator.
  4. Accept the Microsoft Software License Terms, and then follow the steps in the installation wizard.

After the installation

  1. Restart all the consoles as soon as the update is installed.
  2. If any customizations were backed up for the portal sidebar (as mentioned in "Before the installation" steps), 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.

Files updated in this update rollup


The following is a list of files that have changed in this update rollup. If you do not have all previous update rollups installed, files other than those listed here may also be updated. For a complete list of files that are updated, see the "Files Updated in this update rollup" section of all update rollups that were released after your current update rollup.

File Name

File Version

File Size

Microsoft.EnterpriseManagement.ServiceManager.Linking.Consumer.OperationalStore.dll

7.5.7487.210

103KB

Microsoft.EnterpriseManagement.ServiceManager.SLA.Common.dll

7.5.7487.210

219KB

Microsoft.EnterpriseManagement.UI.SdkDataAccess.dll

7.5.7487.210

2715KB

Microsoft.EnterpriseManagement.UI.ConsoleFramework.dll

7.5.7487.210

2045KB

Microsoft.EnterpriseManagement.ServiceManager.Application.Common.dll

7.5.7487.210

1742KB

Microsoft.Mom.CmdbInstanceSubscriptionDataSourceModule.dll

7.5.7487.210

316KB

Microsoft.EnterpriseManagement.ServiceManager.Connector.AD.dll

7.5.7487.210

101KB

Microsoft.Mom.ServiceCommon.dll

7.5.7487.210

134KB

Microsoft.Mom.Sdk.Authorization.dll

7.5.7487.210

177KB

Microsoft.EnterpriseManagement.DataAccessLayer.dll

7.5.7487.210

2481KB

Microsoft.EnterpriseManagement.Core.dll

7.5.7487.210

4007KB

Microsoft.EnterpriseManagement.NewSMPortal.SDKTransformer.dll

7.5.7487.210

73KB

Microsoft.EnterpriseManagement.NewSMPortal.SMPortalHelper.dll

7.5.7487.210

119KB

SelfServicePortalWebApp.dll

7.5.7487.210

70KB

Microsoft.EnterpriseManagement.Forms.CustomizationLibrary.dll

7.5.7487.210

169KB

Microsoft.EnterpriseManagement.ServiceManager.SharedResources.dll

7.5.7487.210

626KB

Microsoft.EnterpriseManagement.ServiceManager.UI.Administration.dll

7.5.7487.210

1037KB

Microsoft.EnterpriseManagement.Forms.CustomizationLibrary.resources.dll

7.5.7487.210

47KB

Microsoft.EnterpriseManagement.ServiceManager.UI.Administration.resources.dll

7.5.7487.210

478KB

Microsoft.EnterpriseManagement.UI.Extensions.resources.dll

7.5.7487.0

23KB

Microsoft.DataWarehouse.Interfaces.dll

13.0.1601.5

40KB

Microsoft.EnterpriseManagement.OperationsManager.dll

6.0.6278.0

2142KB

Microsoft.EnterpriseManagement.ServiceManager.Applications.ServiceCatalog.Tasks.dll

7.5.7487.210

695KB

Microsoft.EnterpriseManagement.ServiceManager.Applications.ProblemManagement.Forms.dll

7.5.7487.210

350KB

Microsoft.EnterpriseManagement.ServiceManager.ChangeManagement.Forms.dll

7.5.7487.210

159KB

Microsoft.EnterpriseManagement.ServiceManager.Datawarehouse.dll

7.5.7487.210

240KB

Microsoft.EnterpriseManagement.ServiceManager.Applications.ServiceRequest.Forms.dll

7.5.7487.210

277KB

Microsoft.EnterpriseManagement.ServiceManager.ActivityManagement.Forms.dll

7.5.7487.210

400KB

Microsoft.EnterpriseManagement.ServiceManager.Incident.Forms.dll

7.5.7487.210

550KB

Microsoft.EnterpriseManagement.ServiceManager.ChangeManagement.Presentation.dll

7.5.7487.210

87KB

Microsoft.EnterpriseManagement.ServiceManager.ReleaseManagement.Forms.dll

7.5.7487.210

338KB

Console.mpb

NA

1316KB

Administration.mpb

NA

1500KB

ActivityManagement.mpb

NA

532KB

ChangeManagement.mpb

NA

400KB

Incident.mpb

NA

980KB

ProblemManagement.mpb

NA

404KB

ReleaseManagement.mpb

NA

472KB

ServiceCatalog.mpb

NA

456KB

ServiceRequest.mpb

NA

508KB

Authoring.mpb

NA

824KB

Announcements.mpb

NA

560KB

Datawarehouse.mpb

NA

256KB

SLAManagement.mpb

NA

356KB

MakeForm.cshtml

NA

29KB

GenericSearch.cshtml

NA

11KB

Index.cshtml

NA

11KB

Article.cshtml

NA

13KB

ActivityDetails.cshtml

NA

22KB

RequestDetails.cshtml

NA

18KB

Sidebar.cshtml

NA

6KB

_Layout.cshtml

NA

12KB

SMAuth.dll

2.0.76.0 

1125KB

main.css

NA

46KB

sidenavigator.js

NA

18KB

header.js

NA

22KB

index.js

NA

24KB

Offerings.cshtml

NA

5KB

Microsoft.EnterpriseManagement.Core.resources.dll

7.5.7487.210

213KB

Microsoft.EnterpriseManagement.ServiceManager.Application.Common.resources.dll

7.5.7487.210

368KB

build_scdm_db.sql

NA

501KB

build_scdw_db.sql

NA

558KB

build_mom_db_postMPimportSM.sql

NA

46KB

build_sm_db.sql

NA

6898KB

SelfServicePortalResources.pt-BR.resx

NA

23KB

SelfServicePortalResources.cs.resx

NA

23KB

SelfServicePortalResources.da.resx

NA

22KB

SelfServicePortalResources.de.resx

NA

23KB

SelfServicePortalResources.el.resx

NA

26KB

SelfServicePortalResources.en.resx

NA

22KB

SelfServicePortalResources.es.resx

NA

23KB

SelfServicePortalResources.fi.resx

NA

23KB

SelfServicePortalResources.fr.resx

NA

23KB

SelfServicePortalResources.hu.resx

NA

23KB

SelfServicePortalResources.it.resx

NA

23KB

SelfServicePortalResources.ja.resx

NA

23KB

SelfServicePortalResources.ko.resx

NA

23KB

SelfServicePortalResources.nl.resx

NA

23KB

SelfServicePortalResources.no.resx

NA

22KB

SelfServicePortalResources.pl.resx

NA

23KB

SelfServicePortalResources.pt.resx

NA

23KB

SelfServicePortalResources.ru.resx

NA

25KB

SelfServicePortalResources.sv.resx

NA

22KB

SelfServicePortalResources.tr.resx

NA

23KB

SelfServicePortalResources.zh-CHS.resx

NA

22KB

SelfServicePortalResources.zh-CHT.resx

NA

22KB

Microsoft.EnterpriseManagement.Warehouse.Olap.dll

7.5.7487.210

194KB

Microsoft.EnterpriseManagement.DataAccessService.core.dll

7.5.7487.210

690KB