Monday, October 3, 2011

Installing Service Level Dashboard

Had tried to install Service Level Dashboard and even though it was successful, the report does not seems to be appearing. Checked the logs, it says, “Message :System.Data.SqlClient.SqlException: Could not find stored procedure 'GetSLADetails'.” and tried re-installing for a few times but not successful.
The message above was all about “GetSLADetails” stored procedure was not found in the database. This stored procedure should be located in SCOM’s Data Warehouse database, which it did not happen to the be there Smile. Checking the net, seems that it might be due to the stored proc. was not successfully created during the installation of the SCOM Service Level Dashboard MP, manually re-run the SQL script to create this stored proc. should do the trick (at least it worked for me !!)
Please refer to the page here for the stored procedure.