Versions / Builds Affected
GFI EventsManager 2013 SR1Status
ResolvedProblem Summary
The SQL event collection fails with the error 'The file specified could not be found'TT / JIRAID
562How 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.msiRequired Actions
- Apply fix
- Attach article
- Contact L3 support if issue persists