Dashboard_engine database connection error.

Document ID : KB000033918
Last Modified Date : 14/02/2018
Show Technical Document Details
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"

Environment:
NMS/UMP 7.1
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)

Symptoms:
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

data_engine errors:
Mar 14 18:40:17:138 [12176] de: [Admin] ADO_Database::ExecuteSP com error for - 1 errors
Mar 14 18:40:17:138 [12176] 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.


Solution:

First do a complete review/check all of your data_engine settings here:
http://docs.nimsoft.com/prodhelp/en_US/Probes/Catalog/data_engine/7.9/index.htm?toc.htm?1913310.html?zoom_highlight=data_engine+7.9

Then, as per the data_engine Help documentation, review the section titled:

"
Index Maintenance Properties "
http://docs.nimsoft.com/prodhelp/en_US/Probes/Catalog/data_engine/8.0/data_engine-8.0.pdf#search=%22data_engine%22

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.


?