locked
SLD 2.0 ‭(Hidden)‬ Dashboard Configuration Connections Error please help RRS feed

  • Question

  • I have installed SLD2.0 following the instructions with the package and also with the troubleshooting step found in previous posts on Technet.  Currently when i launch the dashboard and go in to edit mode i get the following error in the log.

     ---------------------------------
    6/16/2010 12:36:48 PM
    Message :Could not find stored procedure 'GetSLADetails'.
    Source :Void OnError(System.Data.SqlClient.SqlException, Boolean)
    Stack :   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
       at System.Data.SqlClient.SqlDataReader.get_MetaData()
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
       at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
       at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
       at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
       at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
       at Microsoft.EnterpriseManagement.ServiceLevelDashboard.DataProcessor.GetDataSetFromStoredProcedure(String commandString, List`1 sqlParameters)
    ---------------------------------
    ---------------------------------
    6/16/2010 12:36:48 PM
    Message :System.Data.SqlClient.SqlException: Could not find stored procedure 'GetSLADetails'.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
       at System.Data.SqlClient.SqlDataReader.get_MetaData()
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
       at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
       at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
       at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
       at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
       at Microsoft.EnterpriseManagement.ServiceLevelDashboard.DataProcessor.GetDataSetFromStoredProcedure(String commandString, List`1 sqlParameters)
    Source :System.Data.DataSet GetDataSetFromStoredProcedure(System.String, System.Collections.Generic.List`1[System.Data.SqlClient.SqlParameter])
    Stack :   at Microsoft.EnterpriseManagement.ServiceLevelDashboard.DataProcessor.GetDataSetFromStoredProcedure(String commandString, List`1 sqlParameters)
       at Microsoft.EnterpriseManagement.ServiceLevelDashboard.OpsManagerDataAccessor.GetServiceLevelList(String languageCode)
       at Microsoft.EnterpriseManagement.ServiceLevelDashboard.AdminFilter.DatabindGridView()
       at Microsoft.EnterpriseManagement.ServiceLevelDashboard.AdminFilter.CreateChildControls()

     

    Please help me figure this one out.

     

    Thanks

    Jason

    Wednesday, June 16, 2010 7:51 PM

Answers