Hi We are getting the below error. We have checked we are using the SCOM R2 with the latest data warehouse MP. Last time we had the issue with the eventid:31552 and that is due to the managedentity table size is huge and that is fixed working with Microsoft PSS support. currently the all the table size is not more than 3 GB. Event Type: Error Event Source: Health Service Modules Event Category: Data Warehouse Event ID: 31553 Date: 6/24/2011 Time: 5:32:57 AM User: N/A Computer: IND-AP142 Description: Data was written to the Data Warehouse staging area but processing failed on one of the subsequent operations. Exception 'SqlException': Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. One or more workflows were affected by this. Workflow name: Microsoft.SystemCenter.DataWarehouse.CollectPerformanceData Instance name: IND-AP142.ind.com Instance ID: {024F88C7-F71B-9221-D650-8D988DB4901B} Management group: MG_IND For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. Help us to resolve this issue. Regards Donald D'souza

Hi Donald Dsouza, Have a look here: http://thoughtsonopsmgr.blogspot.com/2011/04/eventid-31552-in-opsmgr-event-log-of.html Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

Hi, Regaring the Event 31552, please try the method in the following post: Getting 31552 ->Exception 'SqlException': Timeout expired very frequently in SCOM server http://blogs.technet.com/b/sudheesn/archive/2009/07/28/getting-31552-exception-sqlexception-timeout-expired-very-frequently-in-scom-server.aspx Hope this helps. Thanks. Nicholas Li - MSFT Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

Hi Nicholas We are having issue with Event id:31553 on the RMS server and not with 31552. Regards Donald D'souza

Hi, Take a look at this link may help you to resolve your problem: http://social.technet.microsoft.com/Forums/en-US/operationsmanagergeneral/thread/6bf66bb1-1a0e-4a67-98e6-bb0d04408e10/ Oussama Oueslati | System Engineer | vNext Consulting

Hi We have opened the case with PSS support for this issue. The PSS support has given the same solution posted in the http://social.technet.microsoft.com/Forums/en-US/operationsmanagergeneral/thread/6bf66bb1-1a0e-4a67-98e6-bb0d04408e10/. Regards Donald D'souza