Answered by:
Service Level Dashboard 2.0 - An Error has Occured

Question
-
I have installed both the MP in SCOM and the addin onto my Sharepoint Server, however everytime I browse the dashboard I get in the configuration window:
An Error has Occured. View the Logs for more Informattion.
I've checked the default log file location, its empty. I tried changing the web-config file to generate an error file but to no avail.
I have tried a re-install generating an install.log file, it came back with everything installing successfully.
I have checked my sql logs for the OperationsManager database, I cant see any connection refused messages.
I read that there is an issue where the MP has invalid characters which cause the SQL commands at install to fail, is there any truth in this?
http://social.technet.microsoft.com/Forums/en/operationsmanagermgmtpacks/thread/4b67aa58-8edf-4c67-94fa-8e085ee696c5
Can anyone please tell em whats going on? I'm banging my head against the wall continually trying to work this out.Friday, February 5, 2010 11:21 AM
Answers
-
In the webconfig file can you please change the following and access the site
1. Go to ..\inetput\wwwroot\wss\virtualdirectories\51918\web.config file
2. Change CallStack="False" to CallStack="True"
3. Change customErrors mode="On" to customErrors mode="Off"
After that run the dashboard and see what error you see
- Marked as answer by Åke PetterssonMicrosoft employee Friday, April 9, 2010 11:51 PM
Tuesday, February 9, 2010 11:26 PM
All replies
-
Update:
I have finally managed to extract data from the logfile:
05/02/2010 12:52:32
Message :System.Data.SqlClient.SqlException: Invalid object name 'vmanagementgroup'.
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()Friday, February 5, 2010 1:02 PM -
It is saying that there is a view or table that is missing (vmanagementgroup). Did you have the correct permissions (DBO) when you installed the tables in the database?
Microsoft CorporationFriday, February 5, 2010 4:26 PM -
In the webconfig file can you please change the following and access the site
1. Go to ..\inetput\wwwroot\wss\virtualdirectories\51918\web.config file
2. Change CallStack="False" to CallStack="True"
3. Change customErrors mode="On" to customErrors mode="Off"
After that run the dashboard and see what error you see
- Marked as answer by Åke PetterssonMicrosoft employee Friday, April 9, 2010 11:51 PM
Tuesday, February 9, 2010 11:26 PM