Problem
GFI EventsManager appears to lock up when running a database maintenance job.
Environment
- EventsManager 2011
- EventsManager 2010
- EventsManager 8
- All Supported Environments
Root Cause
In this case, SQL was terminating the connection before GFI EventsManager was able to complete the maintenance job. The jobs could be clearly seen being exported when reviewing the dbimportexport debug log file:
2011-06-17, 11:12:10, 491, 9, e84, c20, info, DbImportExport.dll, fetch_get, Fetching 1000 records from events 2011-06-17, 11:12:10, 694, 9, e84, c20, info, DbImportExport.dll, RunCopyToFolderJob, Preparing to update range for table: EVENTS 2011-06-17, 11:12:10, 694, 9, e84, c20, info, DbImportExport.dll, RunCopyToFolderJob, Table is evt, updating. 2011-06-17, 11:12:10, 834, 9, e84, c20, info, DbImportExport.dll, CalculatePercent, Progress is: 5
The following was logged to the odbcmodule debug log file:
2011-06-17, 11:12:55, 052, 0, 38c, d74, error, odbcmodule\connstringmgr.cpp, ConnStringMgr::DisconnectWorkingConn, Unexpected exception: Object reference not set to an instance of an object.
The logs mention the connection was dropped (DisconnectWorkingConn) which points to a remote connection timeout as the culprit.
Resolution
- Increase or remove the remote connection timeout from within the SQL Server Management Studio.
- Go to SQL Server Management Studio > Properties of the instance > Connections > Remote query timeout (in seconds,
0=no timeout).