This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 17%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
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
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 ---