System Center Operations Manager 2007 R2 Cumulative Update 3

Cumulative Update 3 for Microsoft System Center Operations Manager (SCOM) 2007 R2 is now available. This update also includes Cumulative Update 3 for Cross-Platform Components (KB2222955). If using PRO Integration, please see known issues below.

Cumulative Update 3 for Microsoft System Center Operations Manager (SCOM) 2007 R2 includes all preceding cumulative updates for System Center Operations Manager 2007 R2. Additionally, Cumulative Update 3 resolves the following issues:

• Feature addition: Azure Application Monitoring
• Feature addition: Parameter Extraction in Web Application Synthetic Transactions
• Some ACS reports do not work as expected in Windows Server 2008
• SCOM 2007 SP1 Reports do not run after a shared Data Warehouse is upgraded to SCOM 2007 R2
• The SDK Services stops working due to an unhandled exception, and the operations console becomes unresponsive
• Multi-selection in the alert view is not maintained during a view refresh
• The operations console stops working when creating an override on the cluster resource group monitor
• When Agentless Exception Monitoring (AEM) is set up to use SharePoint, reports from Watson are blocked
• The Operations Manger Console stops working when a high number of instances of State Views or Alert Views are left open for extended durations
• Upgrading MPs that include new properties may not recreate views correctly
• The total transaction response performance counter in URL monitoring is not accurate
• MPs with empty knowledge elements cannot be imported in Operations Manager 2007 R2
• Monitoringhost.exe does not work reliably on Windows 2003 SP2 X64 Domain Controllers
• Alerts using the “Specific Time Period” criteria are not included during automatic alert view refresh
• ACS forwarders with 15 character names in workgroups are unable to communicate with the ACS collector
• Language packs authored for a previous version of an MP cannot be imported once an updated MP is released
• Language Pack import fails if the MP contains strings which are not contained in the English Management Pack
• Generic performance reports consume a large amount of temporary database space and can fail for Windows Server 2003 Computer Groups
• When using a remote console the notification wizard does not work in certain situations
• The SDK service may stop working due to an arithmetic overflow error in very rare circumstances
• The notification scheduler does not compensate correctly for different time zones

To download Cumulative Update 3 for System Center Operations Manager 2007 R2, visit the following Microsoft Web site:

The following released Operations Manager 2007 R2 hotfix is not included in this update because it includes SQL Server Transact-SQL scripts, SQL Stored Procedure updates, or cross-platform agent updates. Refer to the individual KB article for information about how to obtain a hotfix for this issues. For up-to-date information, refer to the following article:

List of known issues for this update

• Restart of non-Operations Manager services: In certain cases, non-Operations Manager services may be restarted when the Operations Manager agent is updated. This issue only affects computers that are running Windows Server 2008 or Windows Server 2008 R2. We recommend that you update agents at a time when a service restart or a server restart is acceptable. Or, only update agents that are experiencing one or more of the agent-related issues that are mentioned in the list of resolved issues. This issue will be addressed in an upcoming cumulative update.
• When you apply the Audit Collection Services update, you may have to restart the computer if a file is being used. Additionally, the following error is returned:
  
  Error 2803: Dialog View did not find a record for dialog
  
  To resolve this issue, restart the computer that has Audit Collection Services installed after you apply the update.
• Agents do not go into the pending folder after Cumulative Update 3 for System Center Operations Manager 2007 R2 is applied on User Account Control (UAC)-enabled Windows servers, Root Management Server servers, or gateway servers. To resolve this issue, disable UAC on the server, and then reapply Cumulative Update 3 for System Center Operations Manager 2007 R2.
• The HealthServiceRuntime.dll file is not updated on Windows 2000-based agent computers. This means that the resolution for the following issue is not applied:
  The monitoring host process does not start the workflows immediately when tasks are received.
  This fix will not be supported on Windows 2000 based computers, and will not be addressed in upcoming CUs.
• The server patch may fail and roll back on Virtual Machines with less than 2GB of memory. This behavior is inconsistent, and is addressed by reapplying the patch.
• The final dialog box is titled "Error", and provides information as to where to identify errors that may have been encoutered during the install process. The correct title for this dialog box is "Information". We will address this in the next Cumulative Update.
• CU3 Rollback / SDK Start Failure: In some cases, Cumulative Update 3 (CU3) rolls back multiple times or the SDK Service does not restart after a rollback of CU3. This is caused by a service timing issue that affects a small percentage of computers. If you encounter this issue, follow the steps that are outlined in Microsoft Knowledge Base article KB992918, and then set the ServicesPipeTimeout to 120000. Restart the affected computer, and then reapply CU3. The CU3 installer may show an error or warning during the installation process. If this occurs, you have to click through the error or warning.
• Pushed agents do not show the correct patch level when looking at the "Patch List" view for agent machines. Two entries should exist for Cumulative Update 3 in this view. If two entries are not present, reboot the agent machine, and select "Repair" for the respective agent through the Operations Console.
• PRO Integration: PRO Tips do not function correctly after CU3 is installed. Event ID 26319 is thrown in the Operations Manager Event Log, and PRO Tips are not shown. If you are leveraging PRO Tips, we advise skipping CU3 and applying CU4 when it is released. Please contact your CSS representative if you have already applied CU3 and are experiencing this issue.
• Service Restart / Machine Reboot: In some cases after you apply CU3, Restart Manager may restart certain services. If you encounter this issue, a machine reboot, or manual restart of the Health Service may be required. This issue has been addressed in CU5.

Installation information

This update must be applied to the computers that host any of the following Microsoft Operations Manager servers or agents:

• Root Management Server
• Management Server
• Gateway Server
• Operations console
• Web Console server
• An agent that was manually installed
• Audit Collection Services server

Be aware that to apply this cumulative update, you must use an account that has the same privileges that were used during the installation of Operations Manager. The process of updating the Operation Manager Database should be run under an account that has Local Administrator rights and System Administrator (SA) credentials on the database. The process of updating the RMS should occur under an account with Administrator rights that is a member of the Operations Manager Administrators group.

Note Before you apply this update, we recommend that you back up the Operations database.

Recommended Installation order

We recommend that you install this cumulative update in your environment in the following order:

1. Root Management Server
2. Manual update of the Operations Manager database together with the included stored procedure file that is discussed later in this article
3. Manual import of the Management Packs that is discussed later in this article
4. Secondary Management Servers
5. Gateway Servers
6. Deploy the agent update to the agents that used a discovery-based installation
7. Operations console role computers
   
   Note Select the Run Server Update option from the Software Update dialog box.
8. Web Console server role computers
9. Audit Collection Services role computers
10. Apply the agent update to manually installed agents

Note: When updating a component from the installer splash screen, it is necessary to go through three patch installers. After selecting the component to update (ie: RMS) each installer will launch and will require clicking "Finish" upon completion. The next installer will start automatically. This is by design, as CU3 consists of three patches (SCOM 2007 R2 Patches, Localized Patches, and Cross-Platform Patches)

Installation steps

To extract the files that are contained in this update, follow these steps:

1. Copy the following file to either a local folder or to an available network-shared folder:
   SystemCenterOperationsManager2007-R2CU3-KB2251525-X86-X64-IA64-ENU.MSI
2. Run this file locally on each applicable computer that meets the conditions that were mentioned earlier.
   
   You can run this file by using either Windows Explorer or by using a command prompt.
   
   Note To run this file on a computer that is running Windows Server 2008, you must use an elevated command prompt. An elevated command prompt is a command prompt that was started by using the Run as Administrator option. If you do not run this Windows-based installer file under an elevated command prompt, the System Center Operations Manager 2007 Software Update splash screen does not allow the hotfix to be installed.
3. On the System Center Operations Manager 2007 Software Update window, select the update option that is appropriate for the role that will be updated.

Recommended steps for applying this cumulative update on a clustered Root Management Server

For more information, visit the following Microsoft website:

Manual operations that must be performed after you update the Root Management Server and Data Warehouse

Running the provided SQL Scripts

This update contains fixes that must be manually applied. The “\SQLUpdate\CU3_DataWarehouse.sql” and “\SQLUpdate \CU3_Database.sql” files will need to be run manually against the OM data warehouse (OperationsManagerDW) and the OM database (OperationsManager), respectively.


Important If this is the first time you are running a Cumulative Update, you will also need to apply ”\SQLUpdate \DiscoveryEntitySProcs.sql” on the Operations Manager database first. It is not necessary to apply DiscoveryEntitySProcs.sql otherwise.


To perform these steps please use an account with Local Administrator rights and System Administrator (SA) credentials on the database instances. You will also need to manually import all MPs that are provided in the ManagementPacks folder to complete the install.

1. Log on to the computer that hosts the Operations Manager 2007 database as a user who has database System Administrator (“SA” rights) to the Operations Manager 2007 database instance. To perform the database update remotely, log on to a computer that hosts SQL Server Management Studio as a user who has appropriate "SA" rights to the Operations Manager 2007 database. Run SQL Server Management Studio.
2. In the Connect to Server dialog box, connect to the SQL Server that hosts the Operations Manager database. The default database name is OperationsManager.
3. Click New Query on the toolbar.
4. From the SQL Editor toolbar, use the Available databases option to select the Operations Manager database.
5. On the File menu, click Open, and then browse for the path where the msi installer placed the appropriate files. Select “\SQLUpdate \CU3_Database.sql”, and then click Open.
6. When the file is loaded, click Execute in the SQL Editor toolbar.
7. View the Messages pane to check whether the Transact-SQL commands ran successfully.
8. Exit SQL Server Management Studio.
9. Repeat Steps 1 through 8, connecting to the Operations Manager data warehouse, and by running “CU3_DataWarehouse.sql.”

Importing the provided Management Packs

The management packs supplied in the ManagementPacks folder must be imported manually by using the Import Management Packs Wizard by using the Operations Manager console. The Windows Installer packages that are released for each localized version of Operations Manager contain the appropriate localized version of the management pack. For example, the following file contains the localized version of the management pack for the Japanese localized version of Operations Manager:The updated management packs are located in the ManagementPacks folder of the package installation.

• Microsoft.SystemCenter.DatawareHouse.Report.Library.mp
• Microsoft.SystemCenter.WebApplication.Library.mp
• Microsoft.SystemCenter.WSManagement.Library.mp

Updated Support Tools that are included in the cumulative update

The following updated file that is located in the SupportTools folder supports the upgrade from SQL Reporting Services 2005 to SQL Reporting Services 2008:Note Use the appropriate platform version of this file instead of the file that is supplied in the SupportTools folder of the Operations Manager 2008 R2 distribution media.

Advanced Installation Instructions - CU3 Command Prompt Installation

The installer (Hotfix Utility) downloaded from this site unpacks the bootstrapper and necessary MSPs to update System Center Operations Manager 2007 R2 to Cumulative Update 3. It is preferable to run the Hotfix Utility on each computer and deploy Cumulative Update 3 via the GUI interface invoked once this is complete. However, it is also possible to bypass multiple installations of the hotfix utility, and deploy Cumulative Update 3 directly by copying the unpacked directory and files (.\System Center 2007 R2 Hotfix Utility\KB 2251525\) to the appropriate computers directly.

If you choose to install Cumulative Update 3 directly via the command prompt, the following command should be used:

Note The /Silent flag is not necessary if you wish to install Cumulative Update 3 by using the GUI interface. The <LOC> parameter should be replaced with the appropriate language code based on which patch you have downloaded. The <#> parameter should be replaced by the KB number for this Cumulative Update. For example, should you have downloaded the English version of Cumulative Update 3 “<LOC>” would be replaced by “ENU”, <#> by 2251525:

Advanced Installation Instruction - Updating manually installed agents

CU3 manually installed agents can be updated without using the full contents of this package. To deploy updates to an agent using the minimal number of required files:

• Install the hotfix utility using the process detailed above.
• Copy all components except ACS, Gateway, ManagementPacks, SCX-Gateway, SQLUpdate, Support Tools and Update Folders, as well as the msp files in the root folder (KB2251525) of the installer
• Push the new folder to all agent machines
• Run the following command

Note: "ENU" in the above command will need to be replaced by the language code of the CU3 package you have downloaded.