Opsmgr Data Warehouse failed to enumerate database components to be deployed

less than 1 minute read

Today I ran into this issue:



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:





Run the SQL query Managementpackinstall.sp.sql



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



Everything is fine now and I have green management server:




Hope this help,

Alexandre Verkinderen


Leave a comment