This is the latest in “Troubleshooting the Data Warehouse” series. The goal of this series is to not only help you troubleshoot specific issues you may be experiencing but also teach you more about the data warehouse. For a complete list of posts in the series, check out Troubleshooting the Data Warehouse: An overview.
One or more data warehouse jobs start failing after importing a custom management pack to Service Manager and synchronizing it to the Data Warehouse
The troubleshooting steps
To troubleshoot the above issue, please verify things in the following orders
1. Check the event log to ensure the root cause is the custom management pack
· In Data Warehouse Management Server, open Operations Manager event log.
· Find the event which is related to this job failure.
· Determine the failure is related to the custom management pack you just imported.
2. Remove the custom management pack and recover from the failure
If the failure is related to the custom management pack, you should remove it and let the rest of the data warehouse operate as usual. You can fix the MP and reimport it later.
· Uninstall the custom management pack via the Service Manager console
· Run MP Sync job
· Verify that this custom management pack is not in the Data Warehouse > Management Packs
· After MP Sync job is completed, resume the failed job either from UI or cmdlet
· You should be good to go
3. Fix and reimport the custom management pack
· First you must remove the custom management pack and recover from the failure (step 2 above)
· Fix the custom management pack
· Import the custom management pack with fix into Service Manager, run MP Sync job to sync it to Data Warehouse