Cumulative Update 7 for System Center Operations Manager 2007 R2

Issues that are fixed in Cumulative Update 7

Cumulative Update 7 for System Center Operations Manager 2007 R2 fixes the following issues:

• Console performs poorly when User Roles are used to scope object access.
• Availability data is not shown for the current day when daily aggregation is used.
• Behavior is inconsistent between some views on web console and console.
• Log files do not roll over when the Unicode log file is monitored.
• Several security issues are fixed.

Cumulative Update 7 for System Center Operations Manager 2007 R2 fixes the following cross-platform issues:

• Logical disk performance statistics are not collected for some volume types on Solaris computers.
• Some Network Adapters on HP-UX computers may not be discovered.
• Network adapter performance statistics are not collected for HP-UX network adapters.
• The Solaris 8 and 9 agent may not restart after an ungraceful shutdown. 

How to obtain and install Cumulative Update 7 for System Center Operations Manager 2007 R2

Download information

Cumulative Update 7 for System Center Operations Manager 2007 R2 is available for download from the Microsoft Download Center.

Installation information

Recommended installation order

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

1. Root management server (RMS)
2. Operations Manager database. Manually update the Operations Manager database by running the included stored procedure file that is discussed in the following sections:
   • Manual operations that must be performed after you update the root management server and the data warehouse
   • Manual operations that must be performed after you update the ACS collector
3. Management packs that are discussed in the Import the management packs section. Manually import these management packs.
4. Secondary management servers
5. Gateway servers
6. Agent update. Deploy the update to agents that used a discovery-based installation.
7. Operations console role computers
   
   Note When you update this role, select the Run Server Update option from the Software Update dialog box.
   
   
8. Web Console server role computers
9. Manually installed agents. Apply the agent update.
10. Audit Collection Services (ACS) role computers

Note After you apply the cumulative update to ACS computers, follow these steps:

1. Net stop adtserver.
2. Run DbUpgV6toV7.sql.
3. Net start adtserver.

For instructions on how to run DbUpgV6toV7.sql, see the "Manual operations that must be performed after you update the ACS collector" section.

Installation notes

When you update a component by using the installer splash screen, you have to complete three update installers. When you update a component such as RMS, each installer starts and requires you to click Finish when the update is complete. Then, the next installer starts automatically.

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 an available network share:
   SystemCenterOperationsManager2007-R2CU7-KB2783850-X86-X64-IA64-ENU.MSI
2. Run this file locally on each applicable computer. For example, run this file on the root management server (RMS).
3. In the System Center Operations Manager 2007 Software Update window, select the update option for the role that will be updated.

Recommended steps for applying this cumulative update to a clustered root management server

For more information about the recommended instructions for applying this cumulative update to a clustered root management server, go to the following Microsoft website:

Manual operations that must be performed after you update the root management server and the data warehouse

Run the SQL scripts

This update contains fixes that must be manually applied. These fixes are applied by running the c:\program files (x86)\System Center 2007 R2 hotfix utility\KB2783850 \SQLUpdate\CU_DataWarehouse.sql file against the Operations Manager data warehouse (OperationsManagerDW) and by running the c:\program files (x86)\System Center 2007 R2 hotfix utility\KB2783850\SQLUpdate\CU_Database.sql file against the Operations Manager database (OperationsManager). To do this, follow these steps:

1. Log on to the computer that hosts the Operations Manager 2007 database by using a user account that has database system administrator (SA) rights to the instance of the Operations Manager 2007 database. To perform the database update remotely, log on to a computer that hosts SQL Server Management Studio by using a user account that has the appropriate SA rights to the Operations Manager 2007 database.
2. Run SQL Server Management Studio.
3. In the Connect to Server dialog box, connect to the instance of SQL Server that hosts the Operations Manager database. The default database name is OperationsManager.
4. On the toolbar, click New Query.
5. From the SQL Editor toolbar, use the Available databases option to select the Operations Manager database.
6. On the File menu, click Open, browse to C:\program files (x86)\System Center 2007 R2 hotfix utility\KB2783850\SQLUpdate, select the CU_Database.sql file that was extracted by the Windows installer (.msi file), and then click Open.
7. When the file is loaded, click Execute in the SQL Editor toolbar.
8. View the Messages pane to check whether the Transact-SQL commands ran successfully.
9. Exit SQL Server Management Studio.
10. For the Operations Manager data warehouse, repeat steps 1 through 8. However, connect to the instance of SQL Server that hosts the Operations Manager data warehouse, and then run the \SQLUpdate\CU_DataWarehouse.sql file.

Manual operations that must be performed after you update the ACS collector

Run the SQL scripts

This update contains fixes that must be manually applied. These fixes are applied by running the %SystemDrive%\Windows\System32\Security\AdtServer\DbUpgV6toV7.sql file against the ACS database (OperationsManagerAC2). To do this, follow these steps:

1. Log on to the computer that hosts the ACS database by using a user account that has database system administrator (SA) rights to the instance of the ACS database. To perform the database update remotely, log on to a computer that hosts SQL Server Management Studio by using a user account that has the appropriate SA rights to the ACS database.
2. Run SQL Server Management Studio.
3. In the Connect to Server dialog box, connect to the instance of SQL Server that hosts the ACS database. The default database name is OperationsManagerAC2.
4. On the toolbar, click New Query.
5. From the SQL Editor toolbar, use the Available databases option to select the ACS database.
6. On the File menu, click Open, select the %SystemDrive%\Windows\System32\Security\AdtServer\DbUpgV6toV7.sql file that was installed by the Windows installer (.msi file), and then click Open.
7. When the file is loaded, click Execute in the SQL Editor toolbar.
8. View the Messages pane to check whether the Transact-SQL commands ran successfully.
9. Exit SQL Server Management Studio.

Import the management packs

The management packs that are supplied in the ManagementPacks folder must be manually imported by using the Import Management Packs Wizard in the Operations console.

The following 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

Update the Web.Config file on the Web Console server role computers

To make sure that all cookies that are created by the Web Console cannot be accessed by the client cscript, add the following configuration to the Web.Config file on the Web Console server:However, if the Web Console is configured to run under SSL, add the following configuration to the Web.Config file instead to make sure that all cookies are encrypted:Note Only one of these lines has to be added to the Web.Config file. To add one of these lines, scroll down in the Web.Config file until you see the <system.web> tag, and then add the appropriate new line immediately after the line that contains <system.web>.

Updated support tools that are included in this cumulative update

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

Advanced installation instructions at a command prompt

The installer (hotfix utility) that is downloaded from this site unpacks the bootstrapping application and necessary MSP files to install Cumulative Update 7 for System Center Operations Manager 2007 R2. It is better to run the hotfix utility on each computer and to deploy Cumulative Update 7 for System Center Operations Manager 2007 R2 by using the GUI interface that is invoked after you run the hotfix utility. However, you can avoid multiple installations of the hotfix utility by copying the unpacked directory and files to the appropriate computers. These files are unpacked to the following location by the hotfix utility:If you decide to install Cumulative Update 7 for System Center Operations Manager 2007 R2 at a command prompt, use the following command:Note The /Silent flag is not necessary if you want to install Cumulative Update 7 for System Center Operations Manager 2007 R2 by using the GUI interface. Replace the <LOC> parameter with the appropriate language code for the update that you have downloaded. Replace the <#> parameter with the Microsoft Knowledge Base article number for this cumulative update.

For example, run the following command for the English version of Cumulative Update 7 for System Center Operations Manager 2007 R2:

Advanced installation instruction to manually update agents

With Cumulative Update 7 for System Center Operations Manager 2007 R2, you can manually update agents without copying the full contents of the package. To deploy updates to an agent, follow these steps:

1. Install the hotfix utility by using the instructions in the "Advanced installation instructions at a command prompt" section. By default, the files that you must have to update the agent are at the following location:
   C:\Program Files (x86)\System Center 2007 R2 Hotfix Utility\KB2783850
2. Copy the appropriate .msp files to a folder of your choice (for example, C:\temp\CU7_Agent) on each computer on which you want to manually update the agent.
3. Run the following two commands at a command prompt from the folder that contains the update files. This folder is C:\temp\CU7_Agent if you follow the suggestion here. For example (x64 architecture and English language):
   msiexec.exe /p "C:\temp\CU7_Agent\KB2783850-x64-Agent.msp" REBOOT="ReallySuppress"
   
   msiexec.exe /p "C:\temp\CU7_Agent\KB2783850-x64-ENU-Agent.msp" REBOOT="ReallySuppress"

Install the Linux and UNIX management packs, and then update the Linux and UNIX agents

Cumulative Update 7 for System Center Operations Manager 2007 R2 contains new agents and management packs for all supported Linux and UNIX operating systems. To fully install Cumulative Update 7, you should follow these steps to make sure that your monitoring of Linux and UNIX computers is up to date:

1. Download and then install the updated management packs from the following Microsoft website:
   System Center Operations Manager 2007 R2 Cross Platform Monitoring Management Packs
2. Import the updated management pack for each version of Linux or UNIX that you are monitoring in your environment.
3. Use the Operations Manager 2007 R2 Discovery Wizard to rediscover the Linux and UNIX computers that you monitor. After you rediscover the computers, the agents on those computers upgrade automatically.

This update installs updated UNIX and Linux agents, and this update removes older UNIX and Linux agents in the following folder:The updated agents have file names that use the following format and a version number of 318:Notes

• The placeholder server type represents the name of the UNIX or Linux server product.
• The placeholder server version represents the version number of the server type.
• The placeholder architecture represents the processor architecture of the destination computer.
• The placeholder package type represents the kind of installation file.

For example, the following is the file name format for the agent for SUSE Linux Enterprise Server 10 (x86):The agents that are included with Systems Center Operations Manager 2007 R2 Cross Platform Cumulative Update 5 have a version number of 277. All agent files for this version number are removed during the installation of this update.

The agents that are included with Systems Center Operations Manager 2007 R2 Cross Platform Cumulative Update 2 (hotfix 979490) have a version number of 258. All agent files for this version number are removed during the installation of this update.

The agents that are included with System Center Operations Manager 2007 R2 Cross Platform Agent Update (hotfix 973583) have a version number of 252. All agent files for this version number are removed during the installation of this update.

The agents that are included with the original release of System Center Operations Manager 2007 R2 have a version number of 248. These files are not removed during installation. However, these files are replaced with 1 kilobyte (KB) files. You have the option of removing these 1 KB files. These files are as follows:

• scx-1.0.4-248.aix.5.ppc.lpp.gz
• scx-1.0.4-248.aix.6.ppc.lpp.gz
• scx-1.0.4-248.hpux.11iv2.ia64.depot.Z
• scx-1.0.4-248.hpux.11iv2.parisc.depot.Z
• scx-1.0.4-248.hpux.11iv3.ia64.depot.Z
• scx-1.0.4-248.hpux.11iv3.parisc.depot.Z
• scx-1.0.4-248.rhel.4.x64.rpm
• scx-1.0.4-248.rhel.4.x86.rpm
• scx-1.0.4-248.rhel.5.x64.rpm
• scx-1.0.4-248.rhel.5.x86.rpm
• scx-1.0.4-248.sles.10.x64.rpm
• scx-1.0.4-248.sles.10.x86.rpm
• scx-1.0.4-248.sles.9.x86.rpm
• scx-1.0.4-248.solaris.10.sparc.pkg.Z
• scx-1.0.4-248.solaris.10.x86.pkg.Z
• scx-1.0.4-248.solaris.8.sparc.pkg.Z
• scx-1.0.4-248.solaris.9.sparc.pkg.Z