Skip navigation
Log in to create and rate content, and to follow, bookmark, and share content with other members.

Log Collection: Troubleshoot ODBC Collection

Document created by RSA Information Design and Development Employee on Sep 11, 2017Last modified by RSA Information Design and Development Employee on Jan 21, 2021
Version 18Show Document
  • View in full screen mode

You can troubleshoot problems and monitor ODBC collection by reviewing the ODBC collector log informational, warning, and error messages to during execution of collection.

Each ODBC log messages includes the:

  • Timestamp
  • Category: debug, info, warning, or failure
  • collection method = OdbcCollection
  • ODBC event source type (GOTS-name) = Generic ODBC Type Specification name that you configured for the event source.
  • collection function completed or attempted (for example, [processing])
  • ODBC event source name (DSN-name) = Data Source Name that you configured for the event source.
  • description (for example, how many events  the Log Collector collected)
  • tracking ID  = the Log Collector position in the target database table.

The following example illustrates the message you would receive upon successful collection of an ODBC event:

2014-July-25 17:21:25 info (OdbcCollection) : [event-source] [processing] [event-source] Published 100 ODBC events: last tracking id: 2014-July-25 13:22:00.280

The following example illustrates a message you may receive upon unsuccessful collection of an ODBC event:

Log Message

timestamp failure (OdbcCollection: [event-source] [processing][event-source-type] Failed during doWork: Unable to prepare statement: state: S0002; error-code:208; description: [RSA] [ODBC-driver][event-source-type]Invalid object name 'object-name'.

Possible Cause

ODBC collection failed while accessing the ODBC Driver or the target database.


Validate the DSN value pairs for the events source.

Previous Topic:Create Custom Typespec
You are here
Table of Contents > Collection Protocols > ODBC > Troubleshoot ODBC Collection