SCOM 2019 UR3 - Dashboards views not refreshing or just timing out

Question

question

anthonypstrother-8017 asked Feb 17, '22 anthonypstrother-8017 commented Feb 17, '22

SCOM 2019 UR3 - Dashboards views not refreshing or just timing out

Morning, I made a series of dashboards, each in different folders for customers, along with different views. The views work consistently. The dashboards either do not refresh when selected or just sit there with the little circle spinning forever then just time out. I used the SQL Server Dashboards Template/Data Center Dashboard which is really good, as I can add groups and customize things. I have been using this for quite a while with no issues. Then one morning things just seem to not work. I have not made any updates or changes in some time.
Would appreciate some pointers, advise, tips to fix this.
Thank you,
Tony

msc-operations-manager

· 1

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

anthonypstrother-8017 · Feb 17 at 08:47 PM

It was event id 26319:
An exception was thrown while processing GetDataWarehouseStoredProcedureResult for session ID uuid:18db7ef2-9267-43f8-89a8-e856b487f096;id=12179.
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 ---

0 ·

question