Opsmgr Data Warehouse failed to enumerate database components to be deployed
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:
http://support.microsoft.com/?kbid=954643
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
http://scug.be