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

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:

Download the Service Manager update package now

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


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!

×