|Error: Dashboard_engine database connection error
UMP was also throwing a popup error in the browser
"The backend server has issued an error requiring the client window to close"
data_engine version 7.92
Database version: Microsoft SQL Server 2008 (RTM) Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
data_engine schema version: 4.87(0)
It appears that the dashboard_engine loses its connection to the database nightly during maintenance.
The nas shows errors before the dashboard_engine issue occurs and it appears that the root casue has to do with maintnenace running at night.
1. [Microsoft OLE DB Provider for SQL Server] [DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation.
2. Dashboard_engine database connection error.
3. Failed to insert QoS data into the database, check that the database is running.
4. [Microsoft OLE DB Provider for SQL Server] [DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation.
We noted that in the data_engine, raw data is being saved for 1 year (365 days)
The dashboard_engine log also shows the following:
Mar 09 02:17:05:591 ERROR [MultiInstanceManager, DashboardDesigner:2453] SqlException in getUpdateActions : com.microsoft.sqlserver.jdbc.SQLServerException: Read timed out
com.microsoft.sqlserver.jdbc.SQLServerException: com.microsoft.sqlserver.jdbc.SQLServerException: Read timed out
Mar 14 18:40:17:138  de: [Admin] ADO_Database::ExecuteSP com error for - 1 errors
Mar 14 18:40:17:138  de: (1) ADO_Database::ExecuteSP com error for [Microsoft OLE DB Provider for SQL Server] Failed executing: alter index RN_QOS_DATA_0004_Idx0 on RN_QOS_DATA_0004 rebuild partition=302 with (online=on, DATA_COMPRESSION = ROW) : 'online' is not a recognized ALTER INDEX REBUILD PARTITION option.
First do a complete review/check all of your data_engine settings here:
Then, as per the data_engine Help documentation, review the section titled:
"Index Maintenance Properties "
Important! It is not possible to rebuild the index for single partitions prior to SQLServer 2014. You can only reorganize individual partitions. Performing automatic indexing for large tables from the data_engine is discouraged, as indexing may not complete in a reasonable amount of time.
So make sure that in the data_engine GUI, "Automatically reindex tables" is unchecked.
If it is checked, uncheck it and restart the data_engine.