Hi,

Is any limitation (PerUser or Management Server Restriction) to create the Visualization Dashboard in SCOM 2012 R2 as I am getting errors since 2-3 days while creating the below. please suggest what can i resolve this issue.Dashboard...

Hi,

could you please post the message here, so that People can look into it? Ist a bit hard for me to read it from the screenshot. Thanks in advance.

Regards,

sure stylon, i am sharing the error as txt that i am getting while creating the dashboard and in Operation Manager Events.

Error while creating the dashboard..

Please provide the following information to the support engineer if you have to contact Microsoft Help and Support :

Microsoft.EnterpriseManagement.Presentation.DataAccess.DataProviderException: An error occurred executing the command: [Microsoft.EnterpriseManagement.ServiceLevel.DataProviders!ServiceLevelAgreementProvider/GetServiceLevels] in provider: [Microsoft.EnterpriseManagement.ServiceLevel.DataProviders.ServiceLevelAgreementProvider, Microsoft.EnterpriseManagement.ServiceLevel.DataProviders, Version=7.0.5000.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35].The client has been disconnected from the server. Please call ManagementGroup.Reconnect() to reestablish the connection. ---> Microsoft.EnterpriseManagement.Common.ServerDisconnectedException: The client has been disconnected from the server. Please call ManagementGroup.Reconnect() to reestablish the connection. ---> System.ServiceModel.CommunicationObjectFaultedException: The communication object, System.ServiceModel.Channels.ServiceChannel, cannot be used for communication because it is in the Faulted state.

Server stack trace:

   at System.ServiceModel.Channels.CommunicationObject.ThrowIfDisposedOrNotOpen()

   at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)

   at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)

   at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)

Exception rethrown at [0]:

   at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)

   at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)

   at Microsoft.EnterpriseManagement.Common.Internal.IDispatcherService.DispatchUnknownMessage(Message message)

   at Microsoft.EnterpriseManagement.Common.Internal.MonitoringDataWarehouseServiceProxy.GetDataWarehouseManagedEntity(Guid managedEntityId, String languageCode)

   --- End of inner exception stack trace ---

   at Microsoft.EnterpriseManagement.Monitoring.DataProviders.RetryCommandExecutionStrategy.Invoke(IDataProviderCommandMethodInvoker invoker)

   at Microsoft.EnterpriseManagement.Presentation.DataAccess.DataProviderCommandMethod.Invoke(CoreDataGateway gateWay, DataCommand command)

   --- End of inner exception stack trace ---

   at Microsoft.EnterpriseManagement.Presentation.DataAccess.DataProviderCommandMethod.Invoke(CoreDataGateway gateWay, DataCommand command)

   at Microsoft.EnterpriseManagement.Presentation.DataAccess.CoreDataGateway.ExecuteInternal[TResult](DataCommand command)

   at Microsoft.EnterpriseManagement.Presentation.DataAccess.CoreDataGateway.<ExecuteAsync>b__0[TResult](<>f__AnonymousType0`1 data)

Error in Operations Manager Events

Log Name:      Operations Manager

Source:        OpsMgr SDK Service

Date:          7/3/2015 3:10:30 PM

Event ID:      26319

Task Category: None

Level:         Error

Keywords:      Classic

User:          N/A

Computer:      AWISCOM.AIRWORKS.IN

Description:

An exception was thrown while processing GetDataWarehouseStoredProcedureResult for session ID uuid:03b827e1-7251-4a1a-9ecf-0660fa5b00b5;id=37.

 Exception message: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

Timed out stored procedure: sdk.ServiceLevelObjectiveDetailReportDataGet

 Full Exception: Microsoft.EnterpriseManagement.DataWarehouse.DataAccess.SqlTimeoutException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

Timed out stored procedure: sdk.ServiceLevelObjectiveDetailReportDataGet ---> System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception: The wait operation timed out

   --- End of inner exception stack trace ---

   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()

   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, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)

   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)

   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.ExecuteReader()

   at Microsoft.EnterpriseManagement.DataWarehouse.DataAccess.DataWarehouseSqlCommandExecutionEngine.ExecuteReader(SqlCommand command)

   --- End of inner exception stack trace ---

   at Microsoft.EnterpriseManagement.DataWarehouse.DataAccess.DataWarehouseSqlCommandExecutionEngine.ExecuteReader(SqlCommand command)

   at Microsoft.EnterpriseManagement.DataWarehouse.DataAccess.DwProcedureCommand.Execute()

   at Microsoft.EnterpriseManagement.DataWarehouse.DataAccess.DataWarehouseSingleCommand.ExecutionStep.Execute(DataWarehouseCommandExecutionContext context)

   at Microsoft.EnterpriseManagement.DataWarehouse.DataAccess.ConnectionOpenCloseExecutionStep.Execute(DataWarehouseCommandExecutionContext context)

   at Microsoft.EnterpriseManagement.DataWarehouse.DataAccess.ConnectionLifetimeManagementExecutionStep.Execute(DataWarehouseCommandExecutionContext context)

   at Microsoft.EnterpriseManagement.ServiceDataLayer.MonitoringDataWarehouseService.GetDataWarehouseStoredProcedureResult(String storedProcedureName, StoredProcedureParameterCollection param, IEnumerable`1 columnFilter, Int32 timeout)

Event Xml:

<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">

  <System>

    <Provider Name="OpsMgr SDK Service" />

    <EventID Qualifiers="49152">26319</EventID>

    <Level>2</Level>

    <Task>0</Task>

    <Keywords>0x80000000000000</Keywords>

    <TimeCreated SystemTime="2015-07-03T09:40:30.000000000Z" />

    <EventRecordID>42037341</EventRecordID>

    <Channel>Operations Manager</Channel>

    <Computer>AWISCOM.AIRWORKS.IN</Computer>

    <Security />

  </System>

  <EventData>

    <Data>GetDataWarehouseStoredProcedureResult</Data>

    <Data>uuid:03b827e1-7251-4a1a-9ecf-0660fa5b00b5;id=37</Data>

    <Data>Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

Timed out stored procedure: sdk.ServiceLevelObjectiveDetailReportDataGet</Data>

    <Data>Microsoft.EnterpriseManagement.DataWarehouse.DataAccess.SqlTimeoutException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

Timed out stored procedure: sdk.ServiceLevelObjectiveDetailReportDataGet ---&gt; System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ---&gt; System.ComponentModel.Win32Exception: The wait operation timed out

   --- End of inner exception stack trace ---

   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean&amp; dataReady)

   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()

   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, Int32 timeout, Task&amp; task, Boolean asyncWrite, SqlDataReader ds)

   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task&amp; task, Boolean asyncWrite)

   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.ExecuteReader()

   at Microsoft.EnterpriseManagement.DataWarehouse.DataAccess.DataWarehouseSqlCommandExecutionEngine.ExecuteReader(SqlCommand command)

   --- End of inner exception stack trace ---

   at Microsoft.EnterpriseManagement.DataWarehouse.DataAccess.DataWarehouseSqlCommandExecutionEngine.ExecuteReader(SqlCommand command)

   at Microsoft.EnterpriseManagement.DataWarehouse.DataAccess.DwProcedureCommand.Execute()

   at Microsoft.EnterpriseManagement.DataWarehouse.DataAccess.DataWarehouseSingleCommand.ExecutionStep.Execute(DataWarehouseCommandExecutionContext context)

   at Microsoft.EnterpriseManagement.DataWarehouse.DataAccess.ConnectionOpenCloseExecutionStep.Execute(DataWarehouseCommandExecutionContext context)

   at Microsoft.EnterpriseManagement.DataWarehouse.DataAccess.ConnectionLifetimeManagementExecutionStep.Execute(DataWarehouseCommandExecutionContext context)

   at Microsoft.EnterpriseManagement.ServiceDataLayer.MonitoringDataWarehouseService.GetDataWarehouseStoredProcedureResult(String storedProcedureName, StoredProcedureParameterCollection param, IEnumerable`1 columnFilter, Int32 timeout)</Data>

  </EventData>

</Event>

Hi

Please do not post twice the same Problem. Check the answers here https://social.technet.microsoft.com/Forums/systemcenter/en-US/e649f277-1519-47cf-9452-efb4c8100dfa/event-id-26319-source-opsmgr-sdk-service-exception-message-timeout-expired?forum=operationsmanagerdeployment

Cheers,

Stefan