Data Warehouse failed to enumerate database components to be deployed
Right after I imported a couple of new MP to our OpsMgr environment, I started to get the below alert:
Alert: Data Warehouse failed to enumerate database components to be deployed
Source: XYZOPMP01.related.com
Path: XYZOPMP01.related.com
Last modified by: System
Last modified time: 8/12/2008 7:24:26 PM Alert description: Data Warehouse failed to enumerate database components to be deployed. Failed to enumerate Data Warehouse components for deployment. 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.Deployment.Component
Instance name: XYZOPMP01.related.com
Instance ID: {986ED2F5-5B26-0554-2092-0FF3851DFA86}
Management group: XYZ Enterprise Apps
We have OpsMgr SP1 and the latest Data Warehouse Library (6.0.6278.0). The fix from Vitaly Filimonov [MSFT] is to run sp_updatestats on OperationsManagerDW DB and it indeed solved our problem!