TIBCO Adapter for ActiveDatabase publishes incorrect messages under specific scenarios
Article ID: KB0093208
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks Plug-in for Database | - |
| Not Applicable | - |
Description
Description:
TIBCO Adapter for ActiveDatabase publishes incorrect messages under following scenario: Publish by reference and set the source table as a referenced object. There is no "where condition" in an SQL statement, which causes the TIBCO Adapter for ActiveDatabase publisher to fetch the first record in a referenced object.
Resolution
Resolution 1):
TIBCO Adapter for ActiveDatabase documentation (at Chapter 13th) - expand the AESchemas in the Project panel and check the Key Field checkbox in the Configuration tab.
Resolution 2):
a). Remove 'Referred Object' and keep this field blank.
b). Change to a new publishing table name for 'Publishing Table'.
c). After applying these changes, save the project and run the adapter again.
Issue/Introduction
TIBCO Adapter for ActiveDatabase publishes incorrect messages under specific scenarios
Additional Information
TIBCO Adapter for ActiveDatabase documentation.
You must explicitly designate a key column or substitute key column for the reference object because a reference object has no external designation of the key column.
Designating the Key Column -
To designate a column of the reference object as the key, follow these steps:
1). In the Project panel, expand AESchemas > ae > ADB > adapter_instance > classes > ref_object > key_column.
2). In the Configuration tab, check the Key Field checkbox, then click the Apply button.
Feedback
Yes
No
Powered by
