If in any case user key field is not selected in TIBCO ActiveMatrix Adapter for Database throws an error " com.tibco.adapter.adb.database.DBSQLException: No columns specified for WHERE clause into exception table xx
Article ID: KB0081065
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks Plug-in for Database | 7.x |
Description
When the data is published through the process containing publish to adapter activity and subscribed using subscriber service and not selected user key field in the Subscriber service of TIBCO ActiveMatrix Adapter for Database throws below exception:
=====
com.tibco.adapter.adb.database.DBSQLException: No columns specified for WHERE clause
into exception table (exception table name)
=====
This issue happens only when opcode has been set to 2,3,4. This is because the TIBCO ActiveMatrix Adapter for Database will query the primary key while updating deleting and upserting the record.
Issue/Introduction
TIBCO ActiveMatrix Adapter for Database throws an error "com.tibco.adapter.adb.database.DBSQLException: No columns specified for WHERE clause into exception table "
Environment
========================================
Product: TIBCO ActiveMatrix Adapter for Database
Version: 7.0 and above
OS: All Supported Operating Systems
========================================
Resolution
To resolve this exception select the user key field in the Subscriber service.
Feedback
Yes
No
Powered by
