Microsoft KB Archive/929655

= No data is groomed from the OnePoint database in MOM 2005 =

Article ID: 929655

Article Last Modified on 12/26/2006

-

APPLIES TO


 * Microsoft Operations Manager (MOM) 2005

-



SYMPTOMS
The MOMX Partitioning and Grooming job runs as expected on a computer that is running Microsoft Operations Manager (MOM) 2005. Additionally, the job does not generate any error messages or error results. However, no data is groomed from the OnePoint database. Therefore, the OnePoint database increases in size.



CAUSE
This problem may occur if the following conditions are true:
 * MOM 2005 Reporting was removed from the computer.
 * The row that contains the TimeDTSLastRan value was not removed from the ReportingSettings table of the OnePoint database.

Note The TimeDTSLastRan value specifies the date and the time of the last MOM Reporting Data Transformation Services (DTS) job.



RESOLUTION
To resolve this problem, remove the row that contains the TimeDTSLastRan value from the ReportingSettings table of the OnePoint database.

Important Remove this row only if MOM Reporting has been removed from the computer.



MORE INFORMATION
When you install MOM Reporting, the MOM 2005 Setup program adds a row that contains the TimeDTSLastRan value to the ReportingSettings table. If you remove MOM Reporting, the MOM 2005 Setup program deletes this row. If this row is blank in the OnePoint database, the MOMXGroomByDays stored procedure determines that MOM Reporting is not installed. Therefore, the MOMXGroomByDays stored procedure grooms the OnePoint database. If this row is present in the OnePoint database, the MOMXGroomByDays stored procedure compares the time that the DTS job last ran to the number of days to retain data setting. From this calculation, the MOMXGroomByDays stored procedure determines whether to groom the OnePoint database. However, because the DTS job no longer runs after you remove MOM Reporting, the TimeDTSLastRan value never changes. Therefore, the MOMXGroomByDays stored procedure does not groom the OnePoint database.

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

899158 How to troubleshoot DTS and database sizing issues in MOM 2005 Reporting

Keywords: kbtshoot kbprb KB929655

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.