How to configure and design the DB poller service with the View as a parent database object?
book
Article ID: KB0076227
calendar_today
Updated On:
Products
Versions
TIBCO ActiveMatrix BusinessWorks Plug-in for Database
8.3.x
Description
While designing the publication/ADB Poller service by selecting view as parent DB object then try to save the service but it will not save and throws the error as "ORA-25001: cannot create this trigger type on this type of view"
This is indicating that ADB will not able to select view as parent DB object. For this reason, ADB plugin does not provide the functionality of view as parent DB object.
Environment
========================================
Product: TIBCO ActiveMatrix BusinessWorks Plug-in for Database
Version: 8.3.x
OS: All
========================================
Resolution
To configure and design the ADB poller service with the View as a parent database object follow the workaround steps:
1)Create the tables such as parent P1 and child C1 then configure the ADB poller activity so that publishing table and triggers will get generated. 2)After creating triggers and publishing tables, rename the tables with different names such as parent P2 and child C2. 3)Then recompile the triggers so that the correct table name will get incorporated. 4)Then create the view with the same name like tables that created previously which is parent P1 and child C1 with a select query on parent P2 and child C2 tables. After inserting the data in P2 and C2, poller is working fine with views.