Opsmgr Data Warehouse failed to enumerate database components to be deployed

less than 1 minute read

Today I ran into this issue:

image

 

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: scom.be Instance ID: {AC6FACD9-

 

Issue:This error appears immediately after a management pack is imported. The installaion of the reports in the MP is failing.

Resolution:Run exec sp_updatestats on the OperationsManagerDW db (the data warehouse).

 

When running the exec sp_updatestats doesn’t help follow these steps:

 

Download and extract the following hotfix:

 

http://support.microsoft.com/?kbid=954643

image

 

Run the SQL query Managementpackinstall.sp.sql

image

 

And directly after running the query I got the following event:

image

 

Everything is fine now and I have green management server:

 

image

 

Hope this help,

Alexandre Verkinderen

http://scug.be

Leave a comment