Resolution:
Description:
============
Question regarding whether the opaque exception table can work without the exception table being enabled in the subscription service.

Environment:
===========
All supported platforms
All Supported Databases
ADB Adapter Version v5.x and v6.x

Resolution:
=========
The subscription service 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 adapter logs the message to the opaque exception table. In the second layer, if any DML command fails at any level, the adapter rolls back this transaction and starts another transaction, inserting it into exception tables. If the insert into the exception table transaction fails, the adapter then logs the message to the opaque exception table. If there is no exception table set, the exception from both layers can log to the opaque exception table.