Update Rollup 9 for System Center 2016 Service Manager

Koskee seuraavia: 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 MSOLEDBSQL driver so that the customers may move from SQL Native Client. Manual steps are required to use MSOLEDBSQL driver with SQL Server Analysis Server (SSAS), which are provided in the next section.
• Fixes an issue where the query results were not localized if the language of the portal is non-English
• Fixes an issue where the user was not able to submit a service request if one of the lists contained an item with a plus ‘+’ sign
• The first item in the lists while submitting a service request is now not selected by default. This ensures that the right category item is selected by the user.
• Fixes an issue where few users were unable to submit requests via portal with an error ‘The given key was not present in the dictionary’.
• Supports the SCCM 1806, 1810, 1902, 1906, 1910 releases. However, there is a limitation that the size of the devices supported by SCCM should be less than 2 PB.

Steps to change provider in SQL Server Analysis Server


• Open SQL Server Management Studio and navigate to Databases>Analysis Service DB>Datasources>DW DB. Replace ‘Analysis Service DB’ with the name of your actual Analysis Service database, and ‘DW DB’ with the name of your actual Data Warehouse database.
• Right click on DW DB and click on properties
• In the properties tab change the provider name from ‘SQL Native Client’ to ‘MSOLEDBSQL’ in the connection string
• Under the Security Settings click on the Impersonation Info
• Provide the username and password if you are using windows authentication and click Ok.
• The properties pane now reflects the new provider name in the connection string
• Click Ok
• 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:
    1. Data Warehouse Server
    2. Primary Management Server
    3. Secondary Management Servers
    4. Self Service Portal Server
    5. 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 your portal server 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