Data Warehouse Timestamp issue
Home  » Data Warehouse Timestamp issue

Data Warehouse Timestamp issue
Posted: Mon, Feb 01, 2010 12:47 AM :: Rank: 1
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

   Report Abuse
Re: Data Warehouse Timestamp issue
Posted: Mon, Feb 01, 2010 7:24 AM :: Rank: 0
Author
Points: 28999
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
   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

   Report Abuse
RE: Data Warehouse Timestamp issue
Posted: Mon, Feb 01, 2010 5:48 PM :: Rank: 0
Author
Points: 42712
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. 

   Report Abuse
Re: Data Warehouse Timestamp issue
Posted: Tue, Feb 02, 2010 4:07 AM :: Rank: 0
Author
Points: 28999
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
   Report Abuse
Re: Data Warehouse Timestamp issue
Posted: Mon, Aug 23, 2010 12:09 PM :: Rank: 21
Author
Points: 30
Level: System Center Enthusiast
Any update on the above ?



Regards.
   Report Abuse
Re: Data Warehouse Timestamp issue
Posted: Mon, Aug 23, 2010 6:11 PM :: Rank: 14
Author
Points: 42712
Level: System Center Expert
Still no supported way to remove data from the warehouse manually. You just have to wait it out.
   Report Abuse

Home  » Data Warehouse Timestamp issue
Top Contributors
Featured Members
Pete Zerger
Points: 65442
Level: System Center Expert
Tommy Gunn
Points: 42712
Level: System Center Expert
Simon Skinner
Points: 40744
Level: System Center Expert
Stefan Koell
Points: 28999
Level: System Center Expert
Andreas Zuckerhut
Points: 27434
Level: System Center Expert