Exception Table

If a database restriction is applied or a failure occurs, an exception table can be configured to receive a message.

In addition to destination table columns, the following columns are added to the exception table:

Column Name Type Description
ADB_OPCODE INTEGER Operation code used by the plug-in:
  • 1 indicates INSERT
  • 2 indicates UPDATE
  • 3 indicates DELETE
  • 4 indicates UPDATE if row exists, otherwise, INSERT

If an incoming job does not have an operation code, an INSERT operation occurs. For more information about the upsert operation, see Upsert Operation on Parent-Child Tables.

ADB_TRACKING_ID VARCHAR2(40) Tracking ID of the job.

This column is the primary key. Each exception table that is mapped to a child table is connected to the parent exception table by this column.

ADB_JOIN_ID VARCHAR2(46) Joined column used to link a parent record to its child record.

ADB_JOIN_ID is generated from ADB_TRACKING_ID and concatenated with the record number in the group.

The exception table of a child table is connected to the exception table of a parent table by the ADB_JOIN_ID column.

ADB_ERROR_TEXT VARCHAR(4000) Text of the error from the database server or other source that caused the error.
ADB_ERROR_TIME TIMESTAMP Timestamp of the inserted record.

For Oracle databases, the timestamp includes the time zone information.