We have been keep getting event id 31551 followed by 31554 since yesterday. We patched and rebooted our SQL Cluster as well as RMS and other management servers. How would I resolve this issue. Please help. Event Type: Error Event Source: Health Service Modules Event Category: Data Warehouse Event ID: 31551 Date: 7/18/2008 Time: 10:22:37 AM User: N/A Computer: RMS Description: Failed to store data in the Data Warehouse. The operation will be retried. 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.Synchronization.TypedManagedEntity Instance name: RMS.XYZ.COM Instance ID: {E8D68465-E771-F04E-2A13-72CB8D0B60B1} Management group: Production For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. Last modified by: System Alert: Data Warehouse configuration synchronization process failed to write data Source: RMS.XYZ.COM Path: RMS.XYZ.COM Last modified time: 7/18/2008 11:26:45 AM Alert description: Data Warehouse configuration synchronization process failed to write data to the Data Warehouse database. Failed to store data in the Data Warehouse. 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.Synchronization.Configuration Instance name: RMS.XYZ.COM Instance ID: {E8D68465-E771-F04E-2A13-72CB8D0B60B1} Management group: Production
Hi opsmgr, Please take a look at http://blogs.technet.com/alipka/archive/2006/07/05/440223.aspx -- Anders Bengtsson Microsoft MVP - Operations Manager Microsoft Certified Trainer (MCT) http://www.contoso.se > Failed to store data in the Data Warehouse. The operation will be > retried. Exception 'SqlException': Timeout expired >
Hi Anders, I have verified these account multiple times and they do exist. We get event id 31551 followed by 31554 in few minutes with the same workflow name. I am just curious to find out exactly what is causing all these. Thanks. "Anders Bengtsson [MVP]" wrote: > Hi opsmgr, > > Please take a look at http://blogs.technet.com/alipka/archive/2006/07/05/440223.aspx > > -- > Anders Bengtsson > Microsoft MVP - Operations Manager > Microsoft Certified Trainer (MCT) > http://www.contoso.se > > > Failed to store data in the Data Warehouse. The operation will be > > retried. Exception 'SqlException': Timeout expired > > > > >
