Products | Versions |
---|---|
TIBCO ActiveMatrix BusinessWorks Plug-in for Database | - |
Not Applicable | - |
Resolution:
Description:
==========
TIBCO ActiveMatrix® Adapter for Database error "Column ADB_SOURCE not found".
Environment:
===========
Windows/Linux/AIX/Solaris/HP platform
All Databases
ADB Adapter 5.X, 6.X
Symptoms:
========
When starting up TIBCO ActiveMatrix® Adapter for Database throws the following error in the log but had no problem publishing messages:
Error [Database] AEADB-100004
DBError:
Database driver code:
Database server code:
Database driver message: Column ADB_SOURCE not found
Info [Database] AEADB-100013
Attribute ADB_SOURCE (class <pub_table_name> ): No column data; ignoring
Cause:
=====
This could be due to ADB_SOURCE existing in the publishing table's schema but not in the database table.
Another possible cause might be after the ADB_SOURCE column was added to the source table, the customer reselected the source table in publisher or recreated the publisher.
Resolution:
=========
ADB_SOURCE is used in "loop detection" when a publisher's source table and a subscriber's destination table are the same. It will only be used to copy desired records from a source table to a publishing table. The solution is to remove the attribute from the publisher's aeschema.