Data Warehouse Timestamp issue
Home  » Forums  » Data Warehouse Timestamp issue

Data Warehouse Timestamp issue
Posted: Mon, Feb 01, 2010 12:47 AM :: Rank: 0
Author
Points: 1510
Level: System Center Specialist

Guys

One of our sys admins accidentally set the time on one of the domain controllers to a date in March 2010.

This time was picked up by the members servers of the domain and they recoded data warehouse information with this timestamp.

The time was then corrected and now the RMS is logging 5500 Errors -

Frequent state change requests caused the incoming state change request to be dropped due to it being older than the currently recorded state change for this monitor. This could also be due to an invalid configuration for this monitor............"

> Request generated time: 2010-02-01T16:43:01.0136208+11:00

Is there any way to correct this issue, or is it just a waiting game until the March 2010 date elapses?

Thanks in advance

> Requested state: Success

> Recorded time: 2010-03-18T12:37:42.0088000+11:00

> Recorded state Success

Reply  
Report Abuse
Re: Data Warehouse Timestamp issue
Posted: Mon, Feb 01, 2010 7:24 AM :: Rank: 0
Author
Points: 12304
Level: System Center Expert
Jamie,

as a rule of thumb, MS doesn't support any tampering in the DB. I'm not sure what options you have but I guess you should open a case @ MS.



cheers,

Stefan
Reply  
Report Abuse
Re: Data Warehouse Timestamp issue
Posted: Mon, Feb 01, 2010 5:19 PM :: Rank: 0
Author
Points: 1510
Level: System Center Specialist
Thanks Stefan



I had a quick look and it would be quite an erroneous task to go through and "clean up" the data.



Looks like it might just be a waiting game.



Cheers

Reply  
Report Abuse
RE: Data Warehouse Timestamp issue
Posted: Mon, Feb 01, 2010 5:48 PM :: Rank: 0
Author
Points: 20575
Level: System Center Expert

This happened to me with a small number of machines in our DMZ and we were told to wait it out. Sure wish there was a way to trim data for just one server out of the OpsMgr data warehouse. 

Reply  
Report Abuse
Re: Data Warehouse Timestamp issue
Posted: Tue, Feb 02, 2010 4:07 AM :: Rank: 0
Author
Points: 12304
Level: System Center Expert
Just an FYI: we had several requests lately to groom out data for single machines or specific rules. We forwarded those requests to the product team and they are looking into it right now. The quick answer was that there's no supported way at this time but we still have hope that they will come up with something. If they do, I'll let you know.



cheers,

Stefan
Reply  
Report Abuse

Home  » Forums  » Data Warehouse Timestamp issue
Tag Cloud
Quick Links
Top Contributors
Pete Zerger
Points: 28919
Level: System Center Expert
Simon Skinner
Points: 23973
Level: System Center Expert
Tommy Gunn
Points: 20575
Level: System Center Expert
Stefan Koell
Points: 12304
Level: System Center Expert
MadHatter
Points: 11676
Level: System Center Expert