Can subscription service handle exceptions by using opaque exception table without exception table in TIBCO ActiveMatrix® Adapter for Database?

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?