Hi everyone,
I am experiencing problems with an ODBC event source in the Log Collector.
The event collection was fine until this morning when I saw that the ODBC Event Source was looping back and forth between two different timestamps (the following is the result of tail /var/log/messages | grep XXX):
Jan 19 09:50:20 hostname NwLogCollector[16097]: [OdbcCollection] [info] [oracle_fga.XXX] [processing] [XXX] [processing] Published 101 ODBC events: last tracking id: 2021-01-19 05:26:50
Jan 19 09:53:21 hostname NwLogCollector[16097]: [OdbcCollection] [info] [oracle_fga.XXX] [idle] Creating work unit for ODBC Collection
Jan 19 09:53:22 hostname NwLogCollector[16097]: [OdbcCollection] [info] [oracle_fga.XXX] [processing] [XXX] [processing] Published 101 ODBC events: last tracking id: 2021-01-19 05:26:07
Jan 19 09:56:24 hostname NwLogCollector[16097]: [OdbcCollection] [info] [oracle_fga.XXX] [idle] Creating work unit for ODBC Collection
Jan 19 09:58:07 hostname NwLogCollector[16097]: [OdbcCollection] [info] [oracle_fga.XXX] [processing] [XXX] [processing] Published 33 ODBC events: last tracking id: 2021-01-19 05:26:50
Jan 19 09:59:25 hostname NwLogCollector[16097]: [OdbcCollection] [info] [oracle_fga.XXX] [idle] Creating work unit for ODBC Collection
Jan 19 10:01:12 hostname NwLogCollector[16097]: [OdbcCollection] [info] [oracle_fga.XXX] [processing] [XXX] [processing] Published 0 ODBC events: last tracking id: 2021-01-19 05:26:50
Jan 19 10:02:27 hostname NwLogCollector[16097]: [OdbcCollection] [info] [oracle_fga.XXX] [idle] Creating work unit for ODBC Collection
Jan 19 10:02:28 hostname NwLogCollector[16097]: [OdbcCollection] [info] [oracle_fga.XXX] [processing] [XXX] [processing] Published 101 ODBC events: last tracking id: 2021-01-19 05:26:50
Jan 19 10:05:29 hostname NwLogCollector[16097]: [OdbcCollection] [info] [oracle_fga.XXX] [idle] Creating work unit for ODBC Collection
Jan 19 10:05:30 hostname NwLogCollector[16097]: [OdbcCollection] [info] [oracle_fga.XXX] [processing] [XXX] [processing] Published 101 ODBC events: last tracking id: 2021-01-19 05:26:07
Has anyone ever had to deal with something like this and can point me in the right direction to solve the issue?
Thank you
