Update Rollup 13 for System Center 2012 R2 Operations Manager

This article describes the issues that are fixed in Update Rollup 13 for Microsoft System Center 2012 R2 Operations Manager. This article also contains the installation instructions for this update.

• When there are thousands of groups in a System Center Operations Manager environment, the cmdlet Get-SCOMGroup -DisplayName "group_name" fails, and you receive the following message:

  The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely complex queries or queries that reference a very large number of tables or partitions. Please simplify the query. If you believe you have received this message in error, contact Customer Support Services for more information.

• When you run System Center 2012 R2 Operations Manager in an all-French locale (FRA) environment, the Date column in the Custom Event report appears blank.

• The Enable deep monitoring using HTTP task in the System Center Operations Manager console does not enable WebSphere deep monitoring on Linux systems.

• When overriding multiple properties on rules that are created by the Azure Management Pack, duplicate override names are created. This issue causes overrides to be lost.

• After you install Update Rollup 11 for System Center 2012 R2 Operations Manager, you cannot access the views and dashboards that are created on the My Workspace tab.

• When the heartbeat failure monitor is triggered, a "Computer Not Reachable" message is displayed even when the computer is not down.

• The Get-SCOMOverrideResult PowerShell cmdlet does not return the correct list of effective overrides.

• When creating a management pack (MP) on a client that contains a Service Level (SLA) dashboard and Service Level Objects (SLO), the localized names of objects are not displayed properly if the client's CurrentCulture settings do not match the CurrentUICulture settings. In the case where the localized settings are English English, ENG, or Australian English, ENA, there is an issue when the objects are renamed.

• This update adds support for OpenSSL1.0.x on AIX computers. With this change, System Center Operations Manager uses OpenSSL 1.0.x as the default minimum version supported on AIX,  and OpenSSL 0.9.x is no longer supported.

Update packages for Operations Manager are available from Microsoft Update or by manual download.

Microsoft Update

To obtain and install an update package from Microsoft Update, follow these steps on a computer that has an Operations Manager component installed:

1. Click Start, and then click Control Panel.
2. In Control Panel, double-click Windows Update.
3. In the Windows Update window, click Check Online for updates from Microsoft Update.
4. Click Important updates are available.
5. Select the update rollup package and then click Ok.
6. Click Install updates to install the update package.

If your computer is running Windows Server 2016 or a later version of the operating system, follow these steps:

1. Click Start, and then click Settings.
2. In Settings, click Updates & Security.
3. On the Windows Update tab, click Check Online for updates from Microsoft Update.
4. Click Important updates are available.
5. Select the update rollup package, and then click OK.
6. Click Install updates to install the update package.

Manual download

Go to the following websites to manually download the update packages from the Microsoft Download Center:

 Download the Operations Manager update package now.

For information about how to download Microsoft support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to obtain Microsoft support files from online services

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file.

Installation notes

• This update rollup package is available from Microsoft Update in the following languages:
  • Chinese Simplified (CHS)
  • Japanese (JPN)
  • French (FRA)
  • German (DEU)
  • Russian (RUS)
  • Italian (ITA)
  • Spanish (ESN)
  • Portuguese (Brazil) (PTB)
  • Chinese Traditional (CHT)
  • Korean (KOR)
  • Czech (CSY)
  • Dutch (NLD)
  • Polish (POL)
  • Portuguese (Portugal) (PTG)
  • Swedish (SWE)
  • Turkish (TUR)
  • Hungarian (HUN)
  • English (ENU
  • Chinese Hong Kong (HK)

• Some components are multilanguage, and the updates for these components are not localized.

• You must run this update rollup as an administrator.

• If you don't want to restart the computer after you apply the console update, close the console before you apply the update for the console role.

• To start a new instance of Microsoft Silverlight, clear the browser cache in Silverlight, and then restart Silverlight.

• Install this update rollup package within a few hours after you install the System Center 2012 R2 Operations Manager server.

• If User Account Control is enabled, run the .msp update files from an elevated command prompt.

• You must have System Administrator rights on the database instances for the Operational Database and Data warehouse to apply updates to these databases.

• To enable the web console fixes, add the following line to the %windir%\Microsoft.NET\Framework64\v2.0.50727\CONFIG\web.config file:

  <machineKeyvalidationKey="AutoGenerate,IsolateApps"decryptionKey="AutoGenerate,IsolateApps" validation="3DES"decryption="3DES"/>

  
  Note Add the line under the <system.web> section, as described in the following article in the Microsoft Knowledge Base:

  911722 You may receive an error message when you access ASP.NET web pages that have ViewState enabled after you upgrade from ASP.NET 1.1 to ASP.NET 2.0

• The fix for the data warehouse BULK insert commands time-out issue that's described in Update Rollup 1 for System Center 2012 R2 Operations Manager adds a registry key. This key can be used to set the time-out value (in seconds) for the data warehouse BULK insert commands. These are the commands that insert new data into the data warehouse.

  Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:

  322756 - How to back up and restore the registry in Windows
  
  Note This key must be manually added on any management server on which you want to override the default BULK insert command time-out.

  Registry settings:

  Registry location: HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft OperationsManager\3.0\Data Warehouse

  DWORD name: Bulk Insert Command Time Out Seconds

  DWORD Value: 40
  
  Note Set this value in seconds. For example, for a 40-second time-out, set this value to 40.

• Reports for Downtime duration do not take business hours into consideration. Business hours are being calculated even when the Business hours check box is cleared. These updated RDL files resolve the issue.
  
  Note The updated RDL files are located on an updated Management Server in the following location:

  %SystemDrive%\Program Files\Microsoft System Center 2012 R2\Operations Manager\Server\Reporting
  
  To update the RDL file, follow these steps:
   
  1. Go to http://MachineName/Reports_INSTANCE1/Pages/Folder.aspx.
  2. On this page, go to the folder to which you want to add the RDL file. In this case, click Microsoft.SystemCenter.DataWarehouse.Report.Library.
  3. Upload the new RDL files by clicking the upload button at the top. For more information, see the Upload a File or Report (Report Manager) topic on the Microsoft Developer Network website.

Supported installation order

1. Install the update rollup package on the following server infrastructure:
   • Management server or servers
   • Audit Collection Services
   • Gateway servers
   • Web console server role computers
   • Operations console role computers
   • Reporting

   • Agent

2. Apply SQL scripts (see installation information).
3. Manually import the management packs.
4. Apply the agent update to manually installed agents, or push the installation from the Pending view in the Operations console.

Operations Manager update

To download the update rollup package and extract the files that are contained in the update rollup package, follow these steps:

1. Download the update packages that Microsoft Update provides for each computer. Microsoft Update provides the appropriate updates according to the components that are installed on each computer. Or download from the Microsoft Download Catalog.
2. Apply the appropriate .msp files on each computer.
   
   Note MSP files are included in the update rollup package. Apply all .msp files that relate to a specific computer. For example, if the web console and console roles are installed on a management server, apply the .msp files on the management server. Apply one .msp file on a server for each specific role that the server holds.
3. Execute the following Database SQL script on the Datawarehouse server against the OperationsManagerDW database:
    

   UR_Datawarehouse.sql

   
   Note This script is located in the following path:
   %SystemDrive%\Program Files\System Center 2012 R2\Operations Manager\Server\SQL Script for Update Rollups
4. Run the following database SQL script on the Database server against the OperationsManager database:
    
   Update_rollup_mom_db.sql
5. Import the following management packs:
   • Microsoft.SystemCenter.TFSWISynchronization.mpb, which has the following dependencies:
     • Microsoft.SystemCenter.AlertAttachment.mpb, which should be installed from the System Center Operations Manager 2012 R2 media.
     • Microsoft.SystemCenter.Visualization.Library.mpb
   • Microsoft.SystemCenter.Visualization.Component.Library.mpb
   • Microsoft.SystemCenter.Visualization.Library.mpb
   • Microsoft.SystemCenter.Advisor.mpb
   • Microsoft.SystemCenter.Advisor.Internal.mpb
   • Microsoft.SystemCenter.2007.mp
   • Microsoft.SystemCenter.Advisor.Resources.(LANGUAGECODE_3LTR).mpb
   • Microsoft.SystemCenter.SyntheticTransactions.Library.mp
   • Microsoft.SystemCenter.OperationsManager.Library.mp
   • Microsoft.SystemCenter.OperationsManager.Internal.mp
   • Microsoft.SystemCenter.Apm.Web.IIS10.mp, which has the following dependencies:
     • Microsoft.SystemCenter.Apm.Infrastructure.mpb
     • Microsoft.SystemCenter.Apm.Library.mpb
   • Microsoft.SystemCenter.Apm.Library.Resources.(LANGUAGECODE_3LTR).mpb
   • Microsoft.Windows.InternetInformationServices.2016.mp (this MP has to be downloaded separately from the Microsoft Update Catalog) which has the following dependency:
     • Microsoft.Windows.Server.2016.Discovery.mp (this MP has to be downloaded separately from the Microsoft Update Catalog)
   • Microsoft.SystemCenter.ClientMonitoring.Internal.mp, which has the following dependency:
     • Microsoft.SystemCenter.ClientMonitoring.Library.mp
   • Microsoft.SystemCenter.DataWarehouse.Report.Library.mp
   • Microsoft.SystemCenter.ClientMonitoring.Views.Internal.mp
   • Microsoft.SystemCenter.OperationsManager.AM.DR.2007.mp
   • Microsoft.SystemCenter.Visualization.ServiceLevelComponents.mpb

For information about how to import a management pack from a disk, see How to Import an Operations Manager Management Pack on the Microsoft TechNet website.

Note Management packs are included in the Server component updates in the following location:

%SystemDrive%\Program Files\System Center 2012 R2\Operations Manager\Server\Management Packs for Update Rollups

To install the updated monitoring packs and agents for UNIX and Linux operating systems, follow these steps:

1. Apply Update Rollup 13 to your System Center 2012 R2 Operations Manager environment.
2. Download the updated management packs for System Center 2012 R2 from the following Microsoft website:
    
   System Center Management Pack for UNIX and Linux Operating Systems
3. Install the management pack update package to extract the management pack files.
4. Import the updated management pack for each version of Linux or UNIX that you are monitoring in your environment.
5. Upgrade each agent to the latest version by using either the Update-SCXAgent Windows PowerShell cmdlet or the UNIX/Linux Agent Upgrade Wizard in the Administration pane of the Operations Console.

To uninstall an update, run the following command:

Note The PatchCodeGuid placeholder represents one of the following GUIDs.

Additionally, the RTMProductCodeGuid placeholder represents one of the following GUIDs.