Products | Versions |
---|---|
TIBCO ActiveMatrix BusinessWorks Plug-in for Database | 8.x |
The below exception can be encountered while trying to run the Plug-in for Database which is using the existing database references(Publication Table, Triggers, etc) in ADBPoller activity configuration:
>>>>
ERROR [Job_Executor0] com.tibco.bw.palette.adbplugin.runtime.datapoller.ADBEventSource - TIBCO-BW-PALETTE-ADBPLUGIN-500015: DataEventPoller Schema AP_InvoiceInfo_PubService_01 throw exception Columns in shared resource and publishing table are not same. Please re-generate publishing table and triggers.-{ProcessStarterActivityName=Adapter-Subscriber
<<<<
This issue can come in a scenario where it is not possible to create fresh Publishing table and triggers but it is required to use the existing ones.
The Source table which has been configured with the database poller must have the same table structure consisting of same columns as compared to the existing Publishing table in the database. This can be ensured by unchecking the 'use' column checkbox while selecting the source table such that the table columns which are not required should not be there. The number of elements in the table after such selection should be strictly in accordance with the Database references like Publication table and triggers.