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.
Issue/Introduction
TIBCO Adapter for ActiveDatabase publishes incorrect messages under specific scenarios
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.
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
