OpsMgr Errors – Data Warehouse failed to enumerate

Just got this error:

Data Warehouse failed to enumerate database components to be deployed

Error text:

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: OPSMGR-SUPPORT.chemistry.ohio-state.edu
Instance ID: {289202F8-310D-7F10-4B38-4BD907301697}
Management group: Support Computers

Resolution:

  • Run exec sp_updatestats on the OperationsManagerDW database.
Reference:
Advertisements

One thought on “OpsMgr Errors – Data Warehouse failed to enumerate

  1. Pingback: Table of Contents | windowsmasher

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s