Error The file specified could not be found when enabling SQL event collection

Versions / Builds Affected

GFI EventsManager 2013 SR1

Status

Resolved

Problem Summary

The SQL event collection fails with the error 'The file specified could not be found'

TT / JIRAID

562

How to Identify

1) The sqlcollector.log shows the following: [...] 2015-11-13, 15:08:54, 030, 9, 1f7c, 1d98, info, SQLCollector.dll, FillExistingDatabases, Found db Market_Live_20150527, id 33 2015-11-13, 15:08:54, 030, 9, 1f7c, 1d98, info, SQLCollector.dll, FillExistingDatabases, Found db Statistik2014, id 34 2015-11-13, 15:08:54, 030, 9, 1f7c, 1d98, info, SQLCollector.dll, FillExistingDatabases, Remote info retrieved 2015-11-13, 15:08:54, 030, 9, 1f7c, 1d98, info, SQLCollector.dll, GetSettingsFromCRMI, Inherited settings 2, process all events: true 2015-11-13, 15:08:54, 030, 3, 1f7c, 1d98, warning, SQLCollector.dll, GetSettingsFromCRMI, Read crmi settings failed! 2015-11-13, 15:08:54, 030, 9, 1f7c, 1d98, info, SQLCollector.dll, GetSettingsFromCRMI, Security settings check. Old False, New False 2015-11-13, 15:08:54, 030, 9, 1f7c, 1d98, info, SQLCollector.dll, StartSQLScan, Settings read from CRMI for server OVB-SQL-DEV-01 2015-11-13, 15:08:54, 030, 9, 1f7c, 1d98, info, SQLCollector.dll, StartSQLScan, Initialize Trace Server 2015-11-13, 15:08:54, 030, 9, 1f7c, 1d98, info, SQLCollector.dll, .ctor, Loading assembly Microsoft.SqlServer.ConnectionInfo 2015-11-13, 15:08:54, 030, 0, 1f7c, 1d98, error, SQLCollector.dll, LoadAssembly, Did not find assembly file for Microsoft.SqlServer.ConnectionInfo 2015-11-13, 15:08:54, 030, 0, 1f7c, 1d98, error, SQLCollector.dll, LoadAssembly, Stack trace is: bei GFILog.LogError(String message, Object[] args) bei SQLCollector.BaseReflection.LoadAssembly(String name) bei SQLCollector.BaseReflection..ctor(String name, String typeName) bei SQLCollector.SqlConnectionInfo..ctor() bei SQLCollector.SQLEngine.InitTracer() bei SQLCollector.SQLEngine.StartSQLScan() bei System.Threading.ThreadHelper.ThreadStart_Context(Object state) bei System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) bei System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) bei System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) bei System.Threading.ThreadHelper.ThreadStart() 2015-11-13, 15:08:54, 030, 9, 1f7c, 1d98, info, SQLCollector.dll, InitTracer, Process private memory level: 246353920, virtual memory level: 768741376 2015-11-13, 15:08:54, 030, 0, 1f7c, 1d98, error, SQLCollector.dll, InitTracer, Unexpected error init scanning on SQL Server OVB-SQL-DEV-01, err Die angegebene Datei konnte nicht gefunden werden., internal 2015-11-13, 15:08:54, 030, 0, 1f7c, 1d98, error, SQLCollector.dll, InitTracer, Stack trace is: bei GFILog.LogError(String message, Object[] args) bei SQLCollector.SQLEngine.InitTracer() bei SQLCollector.SQLEngine.StartSQLScan() bei System.Threading.ThreadHelper.ThreadStart_Context(Object state) bei System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) bei System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) bei System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) bei System.Threading.ThreadHelper.ThreadStart() 2015-11-13, 15:08:54, 030, 9, 1f7c, 1d98, info, SQLCollector.dll, SendToMonitor, notification message Die angegebene Datei konnte nicht gefunden werden. - Die angegebene Datei konnte nicht gefunden werden. 2015-11-13, 15:08:54, 030, 9, 1f7c, 1d98, info, SQLCollector.dll, StartSQLScan, Trace Server failed to initialize! Trying to re-connect! 2015-11-13, 15:08:54, 030, 9, 1f7c, 1d98, info, SQLCollector.dll, GetSettingsFromCRMI, Reading CRMI configuration for sql server OVB-SQL-DEV-01... 2) The SQL Native Client version 9.0 and the SQL Management Object version 9.0 are not installed on the ESM server (check in Programs and Features)

Workaround / Fix Details

Install missing SQL components in Version 9.0 as per operating system architecture: http://ftp.gfisoftware.com/temp/PSG/ESM/Software/SQL_V9.0_Native_Client_and_Management_Objects/SQLServer2005_XMO_x64.msi http://ftp.gfisoftware.com/temp/PSG/ESM/Software/SQL_V9.0_Native_Client_and_Management_Objects/SQLServer2005_XMO.msi http://ftp.gfisoftware.com/temp/PSG/ESM/Software/SQL_V9.0_Native_Client_and_Management_Objects/sqlncli_x64.msi http://ftp.gfisoftware.com/temp/PSG/ESM/Software/SQL_V9.0_Native_Client_and_Management_Objects/sqlncli.msi

Required Actions

- Apply fix - Attach article - Contact L3 support if issue persists