Exception 'SqlTimeoutException': Timeout expired (Network Steve Forum)

Exception 'SqlTimeoutException': Timeout expired

hi all I got a lot of warning on my management servers

Failed to store data in the Data Warehouse.

Exception 'SqlTimeoutException': Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Timed out stored procedure: DataSetDataRouteGet

One or more workflows were affected by this.

Workflow name: Microsoft.SystemCenter.DataWarehouse.StandardDataSetMaintenance

Instance name: Microsoft.Exchange.2010.Reports.Dataset.Availability

Instance ID: {C9F7B4E7-5724-87B7-5EA1-A83FC8F66F93}

Management group: Efix_Management_Group

I delete the relevant Mp Microsoft.Exchange.2010.Reports.Dataset.Availability

bust I still get the error

any suggest ?

August 27th, 2015 7:04am

Have you checked these -

http://www.systemcentercentral.com/fix-failed-to-store-data-in-the-data-warehouse-due-to-a-exception-sqlexception-timeout-expired/

https://support.microsoft.com/en-us/kb/3029227

http://blogs.technet.com/b/kevinholman/archive/2010/08/30/the-31552-event-or-why-is-my-data-warehouse-server-consuming-so-much-cpu.aspx

Hope this helps.

August 27th, 2015 10:59am

This topic is archived. No further replies will be accepted.