Performance data collection process unable to store data in the Data Warehouse in a timely manner

Are you getting this error from your Data Warehouse?

I immediately started getting these alerts after I upgraded my Data Warehouse Library Management Pack to version 6.0.5000.26 from this knowledge base article http://www.microsoft.com/downloads/details.aspx?FamilyID=09f74984-7e9d-42ef-8b38-ad770b084363&DisplayLang=en. I believe the issues exists in SP1 RC1 as well.

The problem is caused by a few hardware MPs, primarily HP and Dell that populate the Data Warehouse with “last discovered on” date as a property, basically, making an object different every time they happen to run the discovery and not only when object really changed.

This has been fixed in SP1 (RTM not in RC0) with some scripts that I am posting. Theses scripts came from Microsoft and were installed by a number of other customers with no issues, however I cannot claim that they are fully tested. They will not prevent upgrade to SP1.

The scripts create indexes in the Data Warehouse. I verified them with one our DBA’s and he said they were safe to run. As soon as I ran the scripts the alerts stopped immediately

http://www.scom2k7.com/downloads/Datawarehouse.zip

12 Responses to Performance data collection process unable to store data in the Data Warehouse in a timely manner

  1. Luis January 31, 2008 at 3:52 pm #

    Hi Timothy,

    Just after a run the SP1, the errors disappeared so I didnt test the download you mentioned.

    But if the error shows up again I know where to look for good info !

    Tks

    Luis Albero

  2. Victor February 11, 2008 at 5:54 pm #

    I am running Ops Manager SP1 RC1 and the Data Warehouse mgt pack installed is versin 6.0.6246.0 I am confused as to latest version I should be runing since 6.0.5000.28 is counter intuitive to the version scheme. Please let me know which I should be running to clear this up. Thanks.

  3. Victor February 11, 2008 at 5:57 pm #

    Hello,
    I am currently running SP1 RC1 and the MP version of the DW MP is 6.0.6246.0, I am confused as to which version is the latest, 6.0.5000.28 or the one I am running. Please help. Thanks.

  4. Timothy McFadden March 8, 2008 at 12:07 am #

    Victor run 6.0.6246.0. Or at this point run SP1 RTM

  5. Joshua June 5, 2008 at 2:37 pm #

    I had this error on my DW/Report Server in my SCOM 2007 SP1 environment. Just ran both scripts on my DW SQL Server and my errors went away! Thank you for posting this! I have been searching for a fix for months!

  6. Jim July 21, 2008 at 5:06 pm #

    Still have this error. OpsMgr SP1 RTM. MP version 6.0.6246.0
    Ran both scripts on SQL/Rptg srvr. Recalculate health, it resolves the alert, then produces new one seconds later.

  7. admin July 21, 2008 at 5:21 pm #

    I have see this on a servers with Database performance issues as well. Do you have other applications using this database server? Is you memory, cpu, or disk queues high?

  8. bobic October 10, 2008 at 8:26 am #

    Same problem as Jim posted…Recalculate health, it resolves the alert, then produces new one seconds later.

  9. IanZ February 18, 2009 at 10:57 am #

    Anybody have an update on this? I’m having this problem now. DW MP is already 6.0.6278

    These are the alerts in succession:
    – Performance data collection process unable to store data in the Data Warehouse in a timely manner
    – Entity Health State data collection process unable to store data in the Data Warehouse in a timely manner
    – The root management server (HealthService) is running but has reported limited functionality soon after 2/17/2009 12:56:40 PM. The specific reason code is 49 and description is ” The health manager has detected that entity state collection has stalled. “.

  10. Daniël February 24, 2009 at 11:07 am #

    Running this scripts seems to solved my problem.
    Also a possible cause for this alert:
    Does the clock on both Datawarehouse-server and the management server shows the same time. Be sure there’s not a gap in time between these servers!

  11. Gascoigne June 24, 2009 at 2:30 am #

    Hi lanZ, I have the same MP that you (6.0.6278.0), and I receive the same alerts. If I run this scripts, this problem will be solved?

  12. Manjun December 12, 2011 at 1:35 pm #

    I am running SCOM R2, and started getting the same alerts more and more from a month ago,
    Is anyone experiencing the same with SCOM R2? and what is your solution if you fixed?
    Thank you,

    Manjun

Leave a Reply