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

Article translations Article translations
Close Close
Article ID: 2012828 - View products that this article applies to.
Expand all | Collapse all

Symptoms

MOM 2005 Reports with an end date of 01/01/2010 or later result in incorrect date values on the X-axis.

Cause

This is due to the SC_DateDimension_table in the SystemCenterReporting DB not containing dates past 01/01/2010.

Resolution

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
GO

DECLARE @MaxDate DATETIME
DECLARE @NewStartDate DATETIME

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'
GO

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:

http://support.microsoft.com/contactus/?ws=support (http://support.microsoft.com/contactus/?ws=support)

 

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.

Properties

Article ID: 2012828 - Last Review: February 15, 2010 - Revision: 4.0
APPLIES TO
  • Microsoft Operations Manager (MOM) 2005 Service Pack 1
  • Microsoft Operations Manager (MOM) 2005 Workgroup Edition
Keywords: 
KB2012828

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com