Opaque Exception Table
The Data Merger activity uses two logical layers when processing a message. The first layer decodes data from the message, and the second layer provides the database transaction. If an exception occurs in the first layer, the plugin logs the message in the opaque exception table. In the second layer, if any DML command fails at any level, the plugin rolls back this transaction and starts another transaction, inserting the error messages in exception tables. If inserting error messages in the exception table fails, the plugin logs the message in the opaque exception table.
The opaque exception table records the entire message in a column with the error message. The opaque exception table has the following columns:
| Column Name | Type | Description |
|---|---|---|
| ADB_TRACKING_ID | VARCHAR2(40) | Tracking ID of the message. |
| ADB_SUBTAB | VARCHAR2(1000) | Destination table name. |
| ADB_ERROR_TEXT | VARCHAR(4000) | Text of the error from the database server, plugin SDK, or other source that caused the error. |
| ADB_ERROR_TIME | TIMESTAMP | Timestamp of the inserted record.
For Oracle records, the timestamp includes the time zone information. |
| ADB_MSG | BLOB | Raw bytes of the message.
The default column size is 1 M. |