TIBCO ActiveMatrix® Adapter for Databaseerror "Column ADB_SOURCE not found".

TIBCO ActiveMatrix® Adapter for Databaseerror "Column ADB_SOURCE not found".

book

Article ID: KB0089649

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks Plug-in for Database -
Not Applicable -

Description

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 &ltpub_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.

Issue/Introduction

TIBCO ActiveMatrix® Adapter for Databaseerror "Column ADB_SOURCE not found".