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

For more information, see Data handling in Data Merger Activity in 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.