Data Warehouse configuration synchronization process failed to read state
Hi I have a site where we get these messages every night. they are opened and closed within the same minute. Unfortunately they are priority 1 so go to pagers etc. Messages are in chronological order for recieved; Alert: Performance data collection process unable to store data in the Data Warehouse in a timely manner - 12:46 am Alert: Performance data collection process unable to store data in the Data Warehouse in a timely manner - closed - 12:50 am Alert: Root Management Server Unavailable. - closed 1:02 AM (message says this was opened at 12:57 - but we never see an new alert message). Alert: Data Warehouse managed object type synchronization process failed to read state - closed -1:03 am - again no new alert was recieved and opened at 1:01 am. and five more of much the same - all end by 1:05 am and all are closed. This happens every night. I dont care if this is down at this time so is there some way I can stop these alerts comming through? PS the server is NOT backed up so cant be a backup error - however this is a MS virtual server guest and the host may be being backed up at this time. Any help much appreciated!cheers
November 20th, 2008 10:27pm
Hi, What is the software you are using? And what is the version? Generally, this issue could be resolved by installing the latest version of Management Packs. For more information, please refer to the article below: Event data collection process unable to write data to the Data Warehousehttp://www.scom2k7.com/event-data-collection-process-unable-to-write-data-to-the-data-warehouse/ Hope it helps,
November 24th, 2008 11:46am
Hi thanks very much for the reply. I will try the fix today and report back next week (sorry only do scheduled maint on this site once a week...) Version is SCE 2007 V 6.0.1885.0. I recently had to reinstall - so I think I may have ofmissed the step to update the management packs. My guess is that you are bang on and the update will take care of it. As above will report back. Thanks for your help. Kelvin
November 27th, 2008 6:05pm
Hi Well I still have the issue.... Installed the management pack, ran the SQL scripts to add indexing... no joy Also I have tried to set overrides on the dataware house alerts but they just keep comming each night at the same time. This makes the product unusable as no one wants to review the messages that come in each night. Also tried to set the override to disable the rule - I have done this today so will see if this helps tonight. We dont really mind if they are correct alerts - seems ok to not monitor for a minute each night - but I need to be able to suppress these emails. please help ! thanks Kelvin
December 4th, 2008 11:21pm
Anybody have an update on this? Im having this problem now. SCOM SP1, DW MP is already 6.0.6278. Tried all the solution from scom2k7 site to no avail. 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. .SCOM is running smoothly for tha past 10 months until our DBA made some maintenance on the cluster SQL, and they took down the SQL Server for more than 8 hours. That was already 4 weeks ago, and I'm still getting this errors. Even after restarting the Health Service or rebooting the server, RMS will become red and critical, then will gray out after getting the 3 alerts above.Thanks.Ian Zarzuela
February 20th, 2009 9:58pm
Hiwell we logged a call with technical support an went through some hoops. In the end we replaced the solution with another one from another vendor - and have had no issues with the competing product on exactly the same server (MS said the server was not speced high enough - even though this was a VM on a host with plenty of resources spare and we were not seeing resource contention on the box).Sorry no real help - but just wanted to close the story from our end.
May 18th, 2009 4:19pm
We have the same issue here: Performance data collection process unable to store data in the Data Warehouse in a timely mannerPerformance data collection process unable to write data to the Data Warehouse Thoseoccur regularly and there is no knowledge information related to those alert :-(I wanted to open a call with MSFT but after seeing that you had no luck with them I wonder if I should ...
June 30th, 2009 9:59pm
We have the same issue here: Performance data collection process unable to store data in the Data Warehouse in a timely manner Performance data collection process unable to write data to the Data Warehouse Those occur regularly and there is no knowledge information related to those alert :-( I wanted to open a call with MSFT but after seeing that you had no luck with them I wonder if I should ... Same happened to me and manage to resolve by increasing the value of the following registry key. HKLM\SYSTEM\CurrentControlSet\services\HealthService\Parameters\Persistence Version Store Maximum Good luck.
May 6th, 2010 8:28am
What did you set it to? It's currently set to 780.
May 23rd, 2011 1:26pm