The audit collection service (ACS) fails when the ACS is configured for a grooming retention policy that is greater than 256 days in System Center Operations Manager 2007 Service Pack 1

When an audit collection service (ACS) is configured for a grooming retention policy that is greater than 256 days in Microsoft System Center Operations Manager 2007 Service Pack 1, the ACS service cannot insert events into the ACS database.

In addition, event messages that resemble the following messages are logged in the System Center Operations Manager 2007 event log.

Event message 1Event message 2

This problem occurs because an SQL database has a built-in limitation of 256 tables. When ACS builds a view, ACS creates a select statement that contains data from all the partition tables. When the number of partition tables exceeds 256, this problem occurs.

Update Information

To resolve this problem, obtain the latest version of Microsoft System Center Operations Manager 2007. For more information, refer to this Microsoft Web site: http://www.microsoft.com/systemcenter/operationsmanager/en/us/how-to-buy.aspx (http://www.microsoft.com/systemcenter/operationsmanager/en/us/how-to-buy.aspx)

Hotfix information

A supported hotfix is available from Microsoft. However, this hotfix is intended to correct only the problem that is described in this article. Apply this hotfix only to systems that are experiencing this specific problem. This hotfix might receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next software update that contains this hotfix.

If the hotfix is available for download, there is a "Hotfix download available" section at the top of this Knowledge Base article. If this section does not appear, contact Microsoft Customer Service and Support to obtain the hotfix.

Note If additional issues occur or if any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific hotfix. For a complete list of Microsoft Customer Service and Support telephone numbers or to create a separate service request, visit the following Microsoft Web site: Note The "Hotfix download available" form displays the languages for which the hotfix is available. If you do not see your language, it is because a hotfix is not available for that language.

Prerequisites

You must have System Center Operations Manager 2007 Service Pack 1 installed to apply this hotfix. This hotfix must be applied to each computer that meets the following criteria:

• The computer hosts a Microsoft Operations Manager Audit Collector

Restart requirement

You do not have to restart the computer after you apply this hotfix.

Hotfix replacement information

You do not have to restart the computer after you apply this hotfix.

File information

The English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.

System Center Operations Manager 2007 Service Pack 1, x86-based versions

System Center Operations Manager 2007 Service Pack 1, x64-based versions

To apply this hotfix, you must run the two following procedures:

1. You must extract the hotfix files by running the .MSI file in which the hotfixes are packaged on the ACS Collector.
2. You must install the hotfix files into the ACS Collector.

Procedure 1: Extract the hotfix files

1. Copy the following file to either a local folder or to an available network shared folder:
   SystemCenterOperationsManager2007-SP1-KB954948-X86-X64-ENU.MSI
2. Run the file that you copied in step 1. Note the installation path that is requested during installation. The installation path is typically the following path:
   Program Files\System Center Hotfix Utility

You can run the file that is mentioned in step 1 from either Windows Explorer or at a command prompt.

Procedure 2: Install the hotfix files on the ACS Collector

1. On the ACS Collector, open the Services MMC snap-in, locate Operations Manager Audit Collection Service, and then stop the service.
2. Use Windows Explorer to locate the hotfix installation folder that you noted in Procedure 1.
3. Open the following sub-folder:
   Q954948
   Within the Q954948 folder are two sub-folders for each platform (x86 or x64) for which the hotfix is available. Open the platform folder for the ACS update that is appropriate for your situation. This folder contains an update file. For example, for an x86-based update, the update file is named "Q954948-x86.msp."
4. In Windows Explorer, double-click the update file. This starts the Welcome to the System Center Operations Manager Audit Collection Server Setup Wizard.
5. Click Next to apply the updated files, and then click Finish to complete the wizard.
6. To confirm the successful application of the hotfix, change to the %systemroot%\System32\Security\AdtServer folder, and then check the file properties for the following files:
   • AdtSrvDll.dll: The file version should be 6.0.6278.34.
   • DbCreatePartition.dll: The last modified date should be July 22, 2008.
   • DbDeletePartition.dll: The last modified date should be July 22, 2008.
7. In the Services MMC, restart Operations Manager Audit Collection Service.

To work around the issue, reduce the ACS groom retention to less than 256 days.

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.This problem was first corrected in Microsoft System Center Operations Manager 2007 R2.

For a list of issues that are fixed in Microsoft System Center Operations Manager 2007 R2, refer to the following article in the Microsoft Knowledge base:

For more information, click the following article number to view the article in the Microsoft Knowledge Base: