Error 'Critical error encountered: Exception has been thrown by the target of an invocation.'

Versions / Builds Affected

GFI EventsManager 2013 SR1 (build 20130606)

Status

Open

Problem Summary

When collecting SQL events, the error 'Critical error encountered: Exception has been thrown by the target of an invocation.' shows in the Operational History under Status -> Job Activity

TT / JIRAID

536

How to Identify

The sqlcollector_*.csv will show the following errors: 2015-09-14, 10:30:20, 922, 0, cd8, f64, error, SQLCollector.dll, ReadSQLEvents, Unexpected error reading info Exception has been thrown by the target of an invocation., internal Failed to retrieve column value.. Process private memory level: 123011072, virtual memory level: 476585984 2015-09-14, 10:30:20, 922, 0, cd8, f64, error, SQLCollector.dll, ReadSQLEvents, Stack trace is: at GFILog.LogError(String message, Object[] args) at SQLCollector.SQLEngine.ReadSQLEvents() at SQLCollector.SQLEngine.StartSQLScan() at System.Threading.ThreadHelper.ThreadStart_Context(Object state) at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart()

Workaround / Fix Details

Apply the following patch: ftp://ftp.gfisoftware.com/temp/PSG/ESM/Patches/20130606/2015-04-16-sql-collector-patch.zip

Required Actions

1. Apply the patch as per default procedure 2. Attach article to case if issue is solved with patch 3. Contact PSG for further instructions should the issue persist