Share via

SCOM 2019,UR3- Microsoft SQL Server Visualization Library- Data Center Dasboards- Not Refreshing or displaying anything at all

anthony strother 586 Reputation points
2022-05-23T14:26:33.013+00:00

I have numerous dashboards made from the SQL Data Center Template(??). None of them are bringing back any data or info. They just sit and spin or the screen is empty.
Of course, the event in the log shows: 26319, always a PIA...

An exception was thrown while processing GetDataWarehouseStoredProcedureResult for session ID uuid:0753b6e4-f732-4155-a07e-ca81dc1efad5;id=1443.
Exception message: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Duplicate key was ignored.
Timed out stored procedure: sdk.Microsoft_SQLServer_Visualization_Library_GetDataCenterDashboardData
Full Exception: Microsoft.EnterpriseManagement.DataWarehouse.DataAccess.SqlTimeoutException: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Duplicate key was ignored.
Timed out stored procedure: sdk.Microsoft_SQLServer_Visualization_Library_GetDataCenterDashboardData ---> System.Data.SqlClient.SqlException: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Duplicate key was ignored. ---> System.ComponentModel.Win32Exception: The wait operation timed out
--- End of inner exception stack trace ---
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 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, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
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)

Any assistance is greatly appreciated!
Tony

System Center Operations Manager
System Center Operations Manager

A family of System Center products that provide infrastructure monitoring, help ensure the predictable performance and availability of vital applications, and offer comprehensive monitoring for datacenters and cloud, both private and public.


Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.