TIBCO Adapter for ActiveDatabase Alerter configuration does not work.

TIBCO Adapter for ActiveDatabase Alerter configuration does not work.

book

Article ID: KB0093253

calendar_today

Updated On:

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

Description

Description:
If the publisher is configured to use "Alerted" as a type of update trigger, no notifications are received from the adapter on insert or update of rows in the table on which we listen for updates. Updates are received if we have the exact same setup with the use of the timer polling method.

Expected behavior: Get notifications of table row inserts or updates.

The Database used is SQL Server 2008 R2. 

Issue/Introduction

TIBCO Adapter for ActiveDatabase Alerter configuration does not work.

Resolution

After the adapter is running and has inserted or updated rows in the table, it needs to execute the command 'execute commit_and_notify' in the side of DB. Note that the documentation mentions to run the command "execute commit_and_notify_table '<table_name>'". However, 'execute commit_and_notify' can work instead of the command "execute commit_and_notify_table '<table_name>'".

Additional Information

Copy some related content in the documentation for review.
===================================
After inserting a message, execute the commit_and_notify_table stored procedure with the publishing table monitored by the adapter. For example, if the adapter is monitoring the PUB_ORDER table:

isql -Udemo -Pdemo
SQL> insert into ORDER_TABLE values(111,'Oak Table',499.95);
SQL> execute commit_and_notify_table ’PUB_ORDER’;

The procedure puts a message to the service broker queue, which is picked up by the adapter. The publisher adapter then reads its publishing table and sends a message containing the changed data on its configured subject.

This example shows how to tell the adapter instance to poll a single table, PUB_ORDER, for changes. Use the commit_and_notify stored procedure to poll all publishing tables for changes.
====================================

Powered by Wolken Software