ReSearch This KB – Data Warehouse failed to deploy reports for a management pack to SQL Reporting Services Server

Alert: Data Warehouse failed to deploy reports for a management pack to SQL Reporting Services Server

Management Pack Name: Data Warehouse Internal Library

Management Pack Version: 7.0.9538.0

Rule or Monitor: Monitor

Rule or Monitor Name: Data Warehouse Report Deployment Recovery State

Rule or Monitor Notes: This is a built-in function of Operations Manager which reports errors deploying reports. The alert description field contains information on what reports are failing to deploy to identify where issues need to be resolved.

Issue: In this environment we deployed the SCC Health Check reports external-link-aqua05-Shapes4FREE but we had not performed the step to create the data source documented in the instructions. Additionally, only two reports within the SCC Health Check Reports folder were appearing {Alerts – Alerts Closed by UserID (DW) and Misc – Management Packs (OM)}.

Resolution: Removed the SCC Health Check Reports and waited for the two existing reports to be removed (I ended up removing the folder in SQL Reporting Services just to be certain it was gone).  Next create the OperationalDataBaseMain data source and validate it’s functionality (per the SCC Health Check reports documentation). Finally re-add the SCC Health Check Reports and validated that all reports were now appearing and the alert had been closed.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.