Hi ,

I have imported the latest SQL MP V6.6.0.0 in our SCOM 2012 R2 environment .We also have UR5 applied. When clicking on SQL Summary dashbords, it is showing no data. When i checked management server logs, i found event id 26319 . I have refered to existing posts on id 26319 but found no solution. Same MP is working fine in our Test environment.

Event : 26319, Source : OpsMgr SDK Service

*********************************

An exception was thrown while processing GetDataWarehouseStoredProcedureResult for session ID uuid:5aec4ab0-8bed-4e55-a6cd-a339a6dc98d6;id=195.
 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.Microsoft_SQLServer_Visualization_Library_GetDataCenterDashboardData
 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.Microsoft_SQLServer_Visualization_Library_GetDataCenterDashboardData ---> 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)

*******************************************************************

• Edited by amit2005 Thursday, July 30, 2015 8:50 PM

I have the same issue running UR6. Verified that there is no firewall blocking communication.