Can subscription service handle exceptions by using opaque exception table without exception table in TIBCO ActiveMatrix® Adapter for Database?
book
Article ID: KB0089197
calendar_today
Updated On:
Products
Versions
TIBCO ActiveMatrix BusinessWorks Plug-in for Database
-
Not Applicable
-
Description
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.
Issue/Introduction
Can subscription service handle exceptions by using opaque exception table without exception table in TIBCO ActiveMatrix® Adapter for Database?