Active database adapter stops with an exception ""ADB_TRACKINGID": invalid identifier when update entry status."
Article ID: KB0079875
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks Plug-in for Database | 7.x |
Description
By starting the Active Database Adapter stopped by throwing the exception below:
=============
com.tibco.adapter.adb.database.DBSQLException: java.sql.SQLSyntaxErrorException:[tibcosoftwareinc][Oracle JDBC Driver][Oracle]ORA-000904:
"ADB_TRACKINGID":invalid identifier when update entry status
=============
When configure the publication service having publishing table field by setting the name in it and running the adapter.publishing table will be create automatically consist of ADB_TRACKINGID field in it. This error occurs due to missing ADB_TRACKINGID field in publishing table.
Issue/Introduction
Active database adapter stops with an exception ""ADB_TRACKINGID": invalid identifier when update entry status."
Environment
Product: TIBCO ActiveMatrix BusinessWorks Plug-in for Database
Version: 7.x and above
OS: All Supported Operating Systems
Resolution
To resolve this error follow any of the solutions below:
1). Alter the Publishing table by adding the column ADB_TRACKINGID.
2). If you want to avoid altering of the publication table:
- Open the project file and go to AESchemas --> ae --> ADB --> ActiveDatabaseAdapterConfiguration -> Classes -> P_table .
- Remove the field ADB_TRACKINGID.
- Start the adapter.
1). Alter the Publishing table by adding the column ADB_TRACKINGID.
2). If you want to avoid altering of the publication table:
- Open the project file and go to AESchemas --> ae --> ADB --> ActiveDatabaseAdapterConfiguration -> Classes -> P_table .
- Remove the field ADB_TRACKINGID.
- Start the adapter.
Feedback
Yes
No
Powered by
