You are currently offline, waiting for your internet to reconnect

MOM 2005 Reports have incorrect date values on the X-axis

MOM 2005 Reports with an end date of 01/01/2010 or later result in incorrect date values on the X-axis.
This is due to the SC_DateDimension_table in the SystemCenterReporting DB not containing dates past 01/01/2010.

To ensure that future operational data is inserted correctly into the DB, run the following SQL on the SystemCenterReporting DB to extend the dates held in the SystemCenterReporting DB.

USE SystemCenterReporting


SELECT @MaxDate = MAX([Date]) FROM dbo.SC_DateDimension_View

SET @NewStartDate = DATEADD(day, 1, @MaxDate)

EXECUTE p_PopulateDateDimension @startDate = @NewStartDate, @endDate = '1/1/2020 12:00 AM'

While this will result in future operational data being correctly inserted and displayed, this will not correct the operational data that has been copied over since 01/01/2010 and before the SQL code shown above was run.

More Information

In order to correct the dates on the data that has already been affected by this problem, please open up a support case with Microsoft Customer Support Services (CSS), so that a Microsoft CSS representative can help you through the process of correcting this. 

For a complete list of Microsoft Customer Service and Support telephone numbers, visit the following Microsoft Web site: (


Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

Article ID: 2012828 - Last Review: 02/15/2010 20:16:00 - Revision: 4.0

  • Microsoft Operations Manager (MOM) 2005 Service Pack 1
  • Microsoft Operations Manager (MOM) 2005 Workgroup Edition
  • KB2012828