tibco activematrix businessworks plug-in for database user ......postgresql, amazon rds for mysql,...
TRANSCRIPT
TIBCO ActiveMatrix BusinessWorks™ Plug-infor DatabaseUser's GuideSoftware Release 8.2September 2018
Two-Second Advantage®
Important Information
SOME TIBCO SOFTWARE EMBEDS OR BUNDLES OTHER TIBCO SOFTWARE. USE OF SUCHEMBEDDED OR BUNDLED TIBCO SOFTWARE IS SOLELY TO ENABLE THE FUNCTIONALITY (ORPROVIDE LIMITED ADD-ON FUNCTIONALITY) OF THE LICENSED TIBCO SOFTWARE. THEEMBEDDED OR BUNDLED SOFTWARE IS NOT LICENSED TO BE USED OR ACCESSED BY ANYOTHER TIBCO SOFTWARE OR FOR ANY OTHER PURPOSE.
USE OF TIBCO SOFTWARE AND THIS DOCUMENT IS SUBJECT TO THE TERMS ANDCONDITIONS OF A LICENSE AGREEMENT FOUND IN EITHER A SEPARATELY EXECUTEDSOFTWARE LICENSE AGREEMENT, OR, IF THERE IS NO SUCH SEPARATE AGREEMENT, THECLICKWRAP END USER LICENSE AGREEMENT WHICH IS DISPLAYED DURING DOWNLOADOR INSTALLATION OF THE SOFTWARE (AND WHICH IS DUPLICATED IN THE LICENSE FILE)OR IF THERE IS NO SUCH SOFTWARE LICENSE AGREEMENT OR CLICKWRAP END USERLICENSE AGREEMENT, THE LICENSE(S) LOCATED IN THE “LICENSE” FILE(S) OF THESOFTWARE. USE OF THIS DOCUMENT IS SUBJECT TO THOSE TERMS AND CONDITIONS, ANDYOUR USE HEREOF SHALL CONSTITUTE ACCEPTANCE OF AND AN AGREEMENT TO BEBOUND BY THE SAME.
ANY SOFTWARE ITEM IDENTIFIED AS THIRD PARTY LIBRARY IS AVAILABLE UNDERSEPARATE SOFTWARE LICENSE TERMS AND IS NOT PART OF A TIBCO PRODUCT. AS SUCH,THESE SOFTWARE ITEMS ARE NOT COVERED BY THE TERMS OF YOUR AGREEMENT WITHTIBCO, INCLUDING ANY TERMS CONCERNING SUPPORT, MAINTENANCE, WARRANTIES,AND INDEMNITIES. DOWNLOAD AND USE THESE ITEMS IS SOLELY AT YOUR OWNDISCRETION AND SUBJECT TO THE LICENSE TERMS APPLICABLE TO THEM. BY PROCEEDINGTO DOWNLOAD, INSTALL OR USE ANY OF THESE ITEMS, YOU ACKNOWLEDGE THEFOREGOING DISTINCTIONS BETWEEN THESE ITEMS AND TIBCO PRODUCTS.
This document contains confidential information that is subject to U.S. and international copyright lawsand treaties. No part of this document may be reproduced in any form without the writtenauthorization of TIBCO Software Inc.
TIBCO, Two-Second Advantage, TIBCO ActiveMatrix BusinessWorks, TIBCO Business Studio, TIBCOActiveMatrix BusinessWorks Plug-in for Database are either registered trademarks or trademarks ofTIBCO Software Inc. in the United States and/or other countries.
Enterprise Java Beans (EJB), Java Platform Enterprise Edition (Java EE), Java 2 Platform EnterpriseEdition (J2EE), and all Java-based trademarks and logos are trademarks or registered trademarks ofOracle Corporation in the U.S. and other countries.
All other product and company names and marks mentioned in this document are the property of theirrespective owners and are mentioned for identification purposes only.
THIS SOFTWARE MAY BE AVAILABLE ON MULTIPLE OPERATING SYSTEMS. HOWEVER, NOTALL OPERATING SYSTEM PLATFORMS FOR A SPECIFIC SOFTWARE VERSION ARE RELEASEDAT THE SAME TIME. SEE THE README FILE FOR THE AVAILABILITY OF THIS SOFTWAREVERSION ON A SPECIFIC OPERATING SYSTEM PLATFORM.
THIS DOCUMENT IS PROVIDED “AS IS” WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSOR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OFMERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, OR NON-INFRINGEMENT.
THIS DOCUMENT COULD INCLUDE TECHNICAL INACCURACIES OR TYPOGRAPHICALERRORS. CHANGES ARE PERIODICALLY ADDED TO THE INFORMATION HEREIN; THESECHANGES WILL BE INCORPORATED IN NEW EDITIONS OF THIS DOCUMENT. TIBCOSOFTWARE INC. MAY MAKE IMPROVEMENTS AND/OR CHANGES IN THE PRODUCT(S)AND/OR THE PROGRAM(S) DESCRIBED IN THIS DOCUMENT AT ANY TIME.
THE CONTENTS OF THIS DOCUMENT MAY BE MODIFIED AND/OR QUALIFIED, DIRECTLY ORINDIRECTLY, BY OTHER DOCUMENTATION WHICH ACCOMPANIES THIS SOFTWARE,INCLUDING BUT NOT LIMITED TO ANY RELEASE NOTES AND "READ ME" FILES.
2
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Copyright © 1999-2018 TIBCO Software Inc. All Rights Reserved.
3
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Contents
Figures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6
TIBCO Documentation and Support Services . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .7
Product Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8
Comparison between Adapter and Plug-In . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10
Getting Started . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16
Creating a Project . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16
Creating a JDBC Connection Shared Resource . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17
Creating an ADB Configuration Shared Resource . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18
Configuring a Process . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20
Testing a Process . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21
Debugging and Running a Process . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21
Deploying Applications . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21
Generating an EAR File . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22
ADB Configuration Shared Resource . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23
User Interface Elements of the ADB Configuration Shared Resource . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23
Creating a Schema Using the ADB Configuration Shared Resource . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34
Adding a Shared Resource . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .34
Adding a Parent Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .35
Adding a Child Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 36
Setting Up a Relation Between Parent and Child Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .37
Refresh the Schema . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 39
Specifying the Columns of an Order By Clause for a Child Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 39
Table Reference . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40
Publishing Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40
Child Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .41
Exception Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .41
Using an Exception Table as a Source Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 42
Child Exception Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 42
Opaque Exception Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 43
ADB Palette . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .44
Data Event Poller Activity . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 44
Data Merger Activity . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 48
Data Requester Activity . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .53
Advanced Topics . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .62
Output Mapping . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 62
Mapping Adapter Datatype to Plug-in XSD Type . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 62
4
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Mapping Sybase Datatype to XSD Type . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 63
Mapping Microsoft SQL Server Datatype to XSD Type . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 63
Mapping Oracle Datatype to XSD Type . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 64
Mapping DB2 Datatype to XSD Type . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 65
Mapping MySQL Datatype to XSD Type . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 66
Mapping PostgreSQL Datatype to XSD Type . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .67
Fault Tolerance . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 68
Load Balancing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .68
Enabling Load Balancing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .69
Disabling Load Balancing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 69
Unlocking the MUTEX Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 69
Viewing Client Information Details . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .70
Refactoring a Project . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 70
Error Handling by Data Merger Activity . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .71
Normal Error Handling . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 71
Bulk Insert Error Handling and Applicable Restrictions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 72
How Records are Handled by the Bulk Insert Error Handling Feature . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .72
Upsert Operation on Parent-Child Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .73
Entity Naming Conventions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 73
Configuring Sybase Database by Using Custom JDBC Driver . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 74
Managing Logs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 78
Setting Up Log Levels . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 78
Exporting Logs to a File . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 79
Error Codes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 81
5
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Figures
ADB Configuration shared resource: Connection Page . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19
ADB Configuration shared resource: Schemas Page . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19
ADB Configuration shared resource: Connection Page . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23
ADB Configuration shared resource: Schemas Page . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25
Data Event Poller: Advanced Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45
Data Event Poller Activity: Fault Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 48
Data Merger Activity: Advanced Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 50
Data Merger Activity: Output Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .52
Data Merger Activity: Fault Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .53
Data Requester Activity: General Tab: Request Reply Mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 53
Data Requester Activity: General Tab: RPC Mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 54
Data Requester Activity: Advanced Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .55
Data Requester Activity: Input Tab with RPC Mode (Operation: SQL_EXECUTE) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 56
Data Requester Activity: Input Tab with RPC mode (Operation SQL_BATCHEXECUTE) . . . . . . . . . . . . . . . . . . . . . . . . . . .56
Data Requester Activity: Input Tab with Request Reply Mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 57
Data Requester Activity: Output Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 58
Data Requester Activity: Output Tab with Request Reply Mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 59
Data Requester Activity: Output Tab with RPC Mode (Operation: SQL_EXECUTE) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 60
Data Requester Activity: Output Tab with RPC Mode (Operation: SQL_BATCHEXECUTE) . . . . . . . . . . . . . . . . . . . . . . . . 60
Data Requester Activity: Fault Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 61
Setting Custom Driver . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 74
Driver Details and User Credentials . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .75
Test Connection Pop-up . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .75
Plug-in Details . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 76
Errors . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 76
JDBC Connection . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 77
6
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
TIBCO Documentation and Support Services
How to Access TIBCO Documentation
Documentation for TIBCO products is available on the TIBCO Product Documentation website, mainlyin HTML and PDF formats.
The TIBCO Product Documentation website is updated frequently and is more current than any otherdocumentation included with the product. To access the latest documentation, visit https://docs.tibco.com.
Documentation for TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database is available on the TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database Product Documentation page.
Product-Specific Documentation
The following documents for this product can be found on the TIBCO Documentation site:
● TIBCO ActiveMatrix BusinessWorks Plug-in for Database User's Guide
● TIBCO ActiveMatrix BusinessWorks Plug-in for Database Installation
● TIBCO ActiveMatrix BusinessWorks Plug-in for Database Examples
● TIBCO ActiveMatrix BusinessWorks Plug-in for Database Release Notes
The following documents provide additional information and can be found on the TIBCO ProductDocumentation website:
● TIBCO ActiveMatrix BusinessWorks documentation
● TIBCO Enterprise Administrator documentation
How to Contact TIBCO Support
You can contact TIBCO Support in the following ways:
● For an overview of TIBCO Support, visit http://www.tibco.com/services/support.
● For accessing the Support Knowledge Base and getting personalized content about products you areinterested in, visit the TIBCO Support portal at https://support.tibco.com.
● For creating a Support case, you must have a valid maintenance or support contract with TIBCO.You also need a user name and password to log in to https://support.tibco.com. If you do not have auser name, you can request one by clicking Register on the website.
How to Join TIBCO Community
TIBCO Community is the official channel for TIBCO customers, partners, and employee subject matterexperts to share and access their collective experience. TIBCO Community offers access to Q&A forums,product wikis, and best practices. It also offers access to extensions, adapters, solution accelerators, andtools that extend and enable customers to gain full value from TIBCO products. In addition, users cansubmit and vote on feature requests from within the TIBCO Ideas Portal. For a free registration, go to https://community.tibco.com.
7
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Product Overview
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database is an add-on product for TIBCOActiveMatrix BusinessWorks™. The plug-in supports capturing of change data (insert, update, or deletedata) from and merging change data request into a relational database. It also supports submitting oneor more SQL statements, stored procedures, and getting a reply. The plug-in supports JDBC-compliantdatabases such as Oracle, Microsoft SQL Server, MySQL, IBM DB2 for z/OS, iSeries (AS400), and UDB,PostgreSQL, Amazon RDS for MySQL, Oracle, SQL Server, Microsoft Azure SQL Server, and Sybase.
You can perform the following main tasks by using the Data Event Poller activity:
● Define the schema of a parent table, parent-child table, and a reference table.
● Select the storage mode, that is, specify how the publishing table stores the event information.
— Publish by value: All the published column information is stored in the stage table.
— Publish by reference: Only the key values of the changed event are stored in the stage table, anddata of other columns is retrieved through the table's join operation.
● Publish data of child table. (Publish Child Data option)
● Order the data of the child table in ascending or descending order. (Child Table Order By option)
● Specify the maximum number of database records to be published per event to start a TIBCOActiveMatrix BusinessWorks™ job. (Record per event option)
● Specify a Polling Interval and the maximum number of records to be retrieved for each pollingwhen a polling batch is used. ("Polling Interval" and Polling Batch Size options)
● Improve the performance in a high-load scenario by using load balancing. Load balancingdistributes the workload across application nodes.
● Insert, delete, and update records in the parent and child tables.
● Republish records with status as failed or scheduled (Failed (F) Records and Scheduled (S) Recordsoptions)
● Specify schema mapping options for design time and runtime (Design Time and Runtime options)
You can perform the following main tasks by using the Data Merger activity:
● Define the schema of a parent table and a parent-child table.
● Specify exception table and opaque exception table.
● Specify child exception table mappings.
● Specify the precommit stored procedure. (Stored Procedure option)
● Specify the date-time patterns. (Date, Time, and Timestamp options)
● Specify the Bulk insert size and batch commit size for handling bulk insertion of data. (“Bulk InsertSize” and “Batch Commit Size” options)
● Handling of Bulk Insert Error. (Handle Bulk Insert Error option)
● Handle Upsert Operation. (Upsert option)
● Handle Empty String and set to default. (Set Empty String to Default (Oracle) option)
● Specify schema mapping options for design time and runtime (Design Time and Runtime options)
You can perform the following main tasks by using the Data Requester activity:
● Submit and run one or more SQL statements and stored procedures.
● Process the requests and return the result as a reply.
8
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
These features can be implemented using:
● ADB Configuration Shared Resource - The ADB Configuration shared resource uses JDBCConnection shared resource to connect to a database, and create XML schema definition (XSD)schema for plug-in operation. The ADB Configuration shared resource is used by the plug-inactivities.
● Data Event Poller - You can use this activity to poll the change in stage table at a specified interval.
● Data Merger - You can use this activity to perform insert, delete, update, and upsert operations onthe relevant tables in the associated database. The data is then available to other applications thathave access to the database.
● Data Requester - You can use this activity to submit and run one or more SQL statements andstored procedures. The result is returned as a reply.
9
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Comparison between Adapter and Plug-In
This topic is useful for users, who have previously used the TIBCO ActiveMatrix® Adapter forDatabase, to help understand differences in the plug-in where supported features have overlap withadapter.
FeatureTIBCO ActiveMatrix® Adapterfor Database
TIBCO ActiveMatrixBusinessWorksTM Plug-in forDatabase
Services Provided Publication service,Subscription service and RPCservice, as well as AlerterService
The plug-in is a replacement ofthe ADB Adapter and AEPalette available in TIBCOActiveMatrix BusinessWorks™.
Data Event Poller activity isequivalent to the adapter'sPublication service with anAdapter Subscriber activity.
Data Merger activity isequivalent to the adapter'sSubscription service with aTIBCO BusinessWorks™Adapter Publication activity.
The Data Requester activity isequivalent to the adapter'sRequest-Reply service. Itallows an application to submitone or more SQL statementsand procedures to beprocessed.
Transport Type JMS and Rendezvous The plug-in is native to TIBCOActiveMatrix BusinessWorks™and does not requiremessaging.
Message Format The ADB Adapter is developedusing Adapter SDK librariesand outputs the message usingAE Schema.
The plug-in is native to TIBCOActiveMatrix BusinessWorks™and outputs the message asXML based on a XSD.
Support for Load Balancing Configurable Supported by default but canbe configured by the user.
TRA Properties TRA properties are maintainedin TIBCO Administrator
TRA properties are notapplicable in plug-in.
UseBetweenClause Default is false Default is true
Referencing an external schema Yes Yes
Storage Mode Publish by value/reference Publish by value/reference
10
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
FeatureTIBCO ActiveMatrix® Adapterfor Database
TIBCO ActiveMatrixBusinessWorksTM Plug-in forDatabase
Stage Table Yes Yes
Triggers Generation Direct apply/SQL statementgenerated
or
save generated SQL into file
Direct apply/SQL statementgenerated
or
save generated SQL into file
DB reconnection attempts DB JDBC connection recovery/reconnect attempts
Reconnection is tried at everypolling interval or by everyactivity invocation.
Polling Batch size Supported Supported
Group messaging Supported Renamed as "record per event"
MS SQL WindowsAuthentication
Yes Yes
Auto Re-Publish(Oracle_failed_rePublish)
Yes Yes
Look back Yes No
Publishing by Reference Object Yes Yes
Polling performanceenhancement hint
Yes No
Database vendors● IBM DB2
● Microsoft SQL Server
● MySQL
● Oracle Database
● PostgreSQL
● Sybase
● Teradata
● IBM DB2
● Microsoft SQL server
● MySQL
● Oracle Database
● PostgreSQL
● Sybase
Database Driver support● Native Database Drivers
supported
● DataDirect Driverssupported
● Native Database drivers arerequired for Amazon RDSfor MySQL and MicrosoftAzure SQL Server.
● DataDirect Driverssupported.
Set Database client information Yes Yes
11
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
FeatureTIBCO ActiveMatrix® Adapterfor Database
TIBCO ActiveMatrixBusinessWorksTM Plug-in forDatabase
Publish Batch confirm size/timeout
Yes No
Database Connection JDBC-based adapter connection JDBC connection
Database Configuration Adapter Configuration ADB Configuration Sharedresource
Refresh the existing schema Refind Schema option The Refind Schema option isrenamed as Refresh Schema.
Multithreading (multipleprocessing stream)
Message session based Multithreading is providedthrough TIBCO ActiveMatrixBusinessWorks™ engine jobthread, each job thread has aData Merger activity instance.
Separate sessions Message session based Not applicable
UseSerial (Messages processedin order)
Yes Yes with a single TIBCOActiveMatrix BusinessWorks™engine and TIBCOActiveMatrix BusinessWorks™process thread count = 1
Use Exception table (Errorinserted in the exception table)
Yes This is optional for the plugin,as you might choose to correctthe data and reprocess it. Thestatus of the output alwaysshows the status of each recordif it is not a one way process.
Use Child Exception table(Error related to child tabledata inserted in the childexception table)
Yes Yes
User Opaque Exception table(when no exception table orinsertion in the exception tablefails)
Yes Yes
Subscriber Precommit StoredProcedure call
The subscriber can beconfigured to call a storedprocedure after a databaseinsert, update, or deleteoperation and before atransaction commit.
Yes
12
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
FeatureTIBCO ActiveMatrix® Adapterfor Database
TIBCO ActiveMatrixBusinessWorksTM Plug-in forDatabase
Batch processing The adapter providesprocessing of subscriptionrequests in batches at twooperation levels:
● Insert of the incomingmessages
● Commit of the insert,update, and deleteoperations
To use this feature, you have toconfigure the following fields:
● Bulk Insert Size
● Batch Commit Size
● Batch CommitTimeout(milliseconds)
The plugin supports batchprocessing if number of datarows in the activity input ismore than 1, but does notsupport this globally, that is, noaccumulation of the messagesprocessed by different TIBCOActiveMatrix BusinessWorks™process jobs or TIBCOActiveMatrix BusinessWorks™process nodes are packed asbatches.
For each process, one databaseoperation each, as a singlerecord or batch operation, canbe configured.
Bulk Insert Error Handlingfeature:
Batch commit (size, timeout)(The number of messages to beput in a batch before invoking acommit operation. The defaultvalue is 0.)
Error Handling by subscriptionservice
When Subscription Serviceinserts data into a database andan error occurs, the subscriberendpoint rolls back all previousoperations on the database tothe original status. SubscriptionService handles error data intwo ways: normal errorhandling and bulk insert errorhandling.
The Batch Commit Size field isdisplayed only when the UseSeparate Session check box isselected on the Configurationtab.
If you use the defaultvalue in the BatchCommit Size field,the adapter takes 1 asthe value of the batchcommit size whenrunning SubscriptionService.
No explicit setting is required.Plugin commits all thesuccessful operations, and un-successful processed recordsare sent to be handled by theexception logic. For example,operation results returned asresult of the activities and/orinsertion in the exceptiontables.
For more information aboutBulk insert error handling, see Bulk Insert Error Handling
One way upsert operationrequest
Yes No, as there is no messagingmiddleware involved.
13
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
FeatureTIBCO ActiveMatrix® Adapterfor Database
TIBCO ActiveMatrixBusinessWorksTM Plug-in forDatabase
JMS Durable Subscriber Name The JMS Subscriber Name cantake the deployment timeglobal variable value.
Not applicable.
Runtime Schema In the case where the schemaname of the table objects isdifferent in the developmentand the productionenvironments.
Yes
Bulk Insert Size Design-time setting Is part of the palette'sconfiguration and relatedTIBCO ActiveMatrixBusinessWorks™ process.
Request Reply A request can contain one ormore SQL statements, storedprocedures, functions, orpackages to be executed as atransaction. The text of the SQLstatement follows theconventions for JDBC SQLsyntax. All SQL statementssupported by the DBMS areallowed and placeholders,represented by a question mark(?), are permitted in the SQLstatement. The SQL statementsconform to the JDBC rules. Forperformance reasons, it is goodpractice to use a SQLstatement. The ‘?’ conventionmust only be used to bindbinary data or call storedprocedures.
A response from the adapter toa client application has a resultcode and one or more resultsets. Each result set containsnested self-describingmessages. Each of thesemessages encodes a result rowthat returned after executing aquery. A response can alsoreturn an error code and errordescription if the request is notsuccessful.
Yes
14
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
FeatureTIBCO ActiveMatrix® Adapterfor Database
TIBCO ActiveMatrixBusinessWorksTM Plug-in forDatabase
Remote Procedure Call (RPC) The adapter can be configuredto act as a remote procedurecall (RPC) server on behalf of aclient.
Yes
RPC Standard Operation(SQL_EXECUTE)
SQL_EXECUTE takes a singleSQL statement and processes it.
Yes
RPC Standard Operation(SQL_BATCHEXECUTE)
SQL_BATCHEXECUTE takes asequence of SQL statementsand processes them.
Yes
RPC one way messaging Yes No
Maximum rows Specifies the maximum numberof rows to be fetched at theservice level. This can be usedto limit the memory usage ofthe adapter. The unfetchedrows are ignored by theadapter.
Yes
Statement Cache The number of cachestatements for a generic RPCrequest/reply service.
The number of statementscached by the adapter isexecuted directly for repeatedrequests. If the cache is full, theadapter removes the oldestmessage from the cache andadds the new statement.
The default value is 1.
The size of the cache dependson the number of statementsprovided as input.
15
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Getting Started
A typical workflow for using the plug-in to achieve different goals includes creating a process, testing itin the debugger, and deploying the application.
TIBCO ActiveMatrix BusinessWorks™ uses the Eclipse GUI provided by TIBCO Business Studio™ todefine business processes and generate Enterprise Archives (EAR files). The EAR file is deployed andrun in the TIBCO ActiveMatrix BusinessWorks™ runtime, and also is managed by using TIBCO®
Enterprise Administrator (TEA).
The typical workflow for using the plug-in is:
1. Creating a Project
2. Creating a JDBC Connection Shared Resource
3. Creating an ADB Configuration Shared Resource
4. Configuring a Process
5. Testing a Process
6. Debugging and Running a Process
7. Deploying Applications
Creating a ProjectThe first task of using a plug-in is creating a project. You can add resources and processes after creatinga project. An Eclipse project is an application module configured for TIBCO ActiveMatrixBusinessWorks. An application module is a resource unit that is named, versioned, and packaged as apart of the application.
Procedure
1. Start TIBCO Business Studio by using one of the following ways:
● Microsoft Windows: click Start > All Programs > TIBCO > TIBCO_HOME > TIBCO BusinessStudio version number > Studio for Designers.
● Linux: run the TIBCO Business Studio executable file located in the TIBCO_HOME/studio/version_number/eclipse directory
2. From the menu, click File > New > BusinessWorks Resources to open the BusinessWorks Resourcewizard.
3. In the "Select a wizard" dialog box, click BusinessWorks Application Module and click Next toopen the New BusinessWorks Application Module wizard.
There are several ways to open the New BusinessWorks Application Module dialog boxand create a new project in TIBCO Business Studio. See the TIBCO ActiveMatrixBusinessWorks documentation for more information.
4. In the Project dialog box, configure the project you want to create:a) Type a name for the project that you are creating in the Project name field.b) By default, the created project is located in the workspace currently in use. Keep the Use default
location.c) Keep the Create empty process and Create Application check boxes selected to automatically
create an empty process and an application when creating a project.d) Click Finish to create the project.
16
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Result
The project with the specified settings is displayed in the Project Explorer view.
Creating a JDBC Connection Shared ResourceTo connect to the database, you must use the JDBC Connection shared resource.
1. Expand the created project in the Project Explorer view.
2. Right-click the Resources folder and select New > JDBC Connection.
3. Enter a name in the Resource Name field and click Finish.
4. Configure the JDBC Connection shared resource as described in the following sections.
General
The General section has the following fields.
Field Description
Name The name to be displayed as the label for the shared resource
Description A short description of the shared resource
JDBC Connection
This section has the following fields.
Field
LiteralValue/ModuleProperty? Description
Connection Type None Specifies the kind of JDBC connection you want to create.
17
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Field
LiteralValue/ModuleProperty? Description
MaximumConnections
Yes The maximum number of database connections to allocate.The default maximum is 10. The minimum value that can bespecified is 1.
Login Credentials Yes The user name used to connect to the database.
The password used to connect to the database.
JDBC Driver
This section has the following fields.
Field
LiteralValue/ModuleProperty? Description
Database Driver Yes The name of the JDBC driver. If you select a supported driverfrom a list of supported drivers, the Database URL field ispopulated with a template for the URL of the driver.
For example:tibcosoftwareinc.jdbc.sqlserver.SQLServerDriver
Database URL Yes The URL to use to connect to the database. A template of theURL is supplied for the selected JDBC driver. You mustsupply the portions of the URL that are in angle brackets (<>).
For example: jdbc:tibcosoftwareinc:sqlserver://<host>:<port>;DatabaseName=<dbname>
Login Timeout Yes The length of time (in seconds) to wait for a successfuldatabase connection.
Only JDBC drivers that support connection timeouts can usethis field. If the JDBC driver does not support connectiontimeouts, the value of this field is ignored. Most JDBC driverssupport connection timeouts.
Test Connection
Click the Test Connection button to test whether the specified configuration fields result in a validconnection to a database.
Creating an ADB Configuration Shared Resource
Prerequisites
Configure a JDBC Connection shared resource as described in Creating a JDBC Connection SharedResource.
18
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Procedure
1. Expand the created project in the Project Explorer view.
2. Right-click the Resources folder and select New > ADB Configuration.
3. Type a name in the Resource Name field in the ADB Configuration Editor dialog box. Click Finish.The ADB Configuration shared resource is created. The shared resource consists of two pages:Connection and Schemas.
ADB Configuration shared resource: Connection Page
ADB Configuration shared resource: Schemas Page
4. Configure the ADB Configuration shared resource in the displayed editor, as described in UserInterface Elements of the ADB Configuration Shared Resource.
19
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Configuring a ProcessAfter creating a project, an empty process is created. You must configure the process by addingactivities to the empty process to complete a task.
Prerequisites
Ensure that you have created an empty process when creating a project. See Creating a Project for moreinformation.
Procedure
1. In the Project Explorer view, click the created project and open the empty process from theProcesses folder.
2. Select an activity from the Palette view and drop it in the Process editor.For example, select and drop the DataEventPoller activity from the ADB palette. You can add otheractivities similarly.
3. Click an activity in the Process editor and drag the icon to create a transition between theadded activities.
4. Click to create links between two activities and configure the condition types.
5. Configure the DataEventPoller activity as described in Data Event Poller Activity.
6. Configure the DataMerger activity as described in Data Merger Activity.
7. Configure the DataRequester activity as described in Data Requester Activity.
An ADB Configuration shared resource is required when configuring the activities. Formore information about how to create the shared resource, see Creating an ADBConfiguration Shared Resource
8. Click File > Save to save the project.
20
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Testing a ProcessAfter configuring, you might debug or test a process.
Prerequisites
Ensure that you have configured a process, as described in Configuring a Process.
Procedure
1. Open the process you have configured in TIBCO Business Studio.
2. On the toolbar, click Debug > Debug Configurations.3. Click BusinessWorks Application > BWApplication in the left panel.
By default, all the applications in the current workspace are selected in the Applications tab. Ensurethat only the application you want to debug is selected in the Applications tab in the right panel.
4. Click the Advanced tab and click Browse to locate the logback file.By default, the log file resides in the TIBCO_HOME/bw/<version>/config/design/logbackdirectory and error logs are captured. See Managing Logs for more details.
5. Click Debug to test the process in the selected application.TIBCO Business Studio changes to the Debug perspective. The debug information is displayed inthe Console view.
6. In the Debug tab, expand the debugged process and click an activity.
7. In the upper-right panel, click Job Data view, and then click the Output tab to check the activityoutput.
Debugging and Running a ProcessDebug the application you have configured to ensure that the application configuration is correct.
Procedure
1. Open the process that you have configured in TIBCO Business Studio.
2. On the toolbar, click Run > Debug Configurations.3. Click BusinessWorks Application > BWApplication in the left panel.
4. Ensure only the application you want to debug and run is selected in the Applications tab in theright panel.
5. Click the Advanced tab and click Browse to locate the logback file.By default, the log file resides in the TIBCO_HOME/bw/<version>/config/design/logbackdirectory and error logs are captured. See Managing Logs for more details.
6. Click Debug.TIBCO Business Studio changes to the Debug perspective. Logs are displayed in the Console view.
Deploying ApplicationsAfter testing a process, you can deploy the application that contains the configured process into aruntime environment, and then use the bwadmin utility to manage the deployed application.
Prerequisites
Before deploying an application, generate an application archive, which is an enterprise archive (EAR)file created in TIBCO Business Studio. For more information, also see:
21
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
● Creating a Project.
● Generating an EAR File.
Deploying an application involves:
1. Uploading an EAR file.
2. Deploying an application.
3. Configuring an application.
4. Starting an application.
See TIBCO ActiveMatrix BusinessWorks Administration for more details about how to deploy anapplication.
Generating an EAR FileApplication archives are enterprise archive (EAR) files that are created in TIBCO Business Studio. AnEAR file is required when deploying an application.
Prerequisites
An application project has already been created, as described in Creating a Project.
There are many ways to generate an EAR file, the following is one such method. For more informationon this, see TIBCO ActiveMatrix BusinessWorks Administration for more information.
Procedure
1. Go to the File Explorer view and click the Open Directory to Browse icon.
2. Select the folder where you want to generate the EAR file and click OK.The new folder is displayed in the File Explorer view.
3. Drag the application from the Project Explorer view to the new folder in the File Explorer view.
The EAR file is generated with the name <name>.<application>_<version>.ear.
22
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
ADB Configuration Shared Resource
You should use the ADB Configuration shared resource to establish a connection from the ActiveMatrixBusinessWorks Plug-in to the database.
The ADB Configuration shared resource utilizes the JDBC connection shared resource to retrieve thedatabase table schema information.
The following topics are covered in this section:
● User Interface Elements of the ADB Configuration Shared Resource
● Creating Schema Using the ADB Configuration Shared Resource
● Table Reference
User Interface Elements of the ADB Configuration Shared ResourceThe user interface elements in the ADB Configuration shared resource are described below.
The shared resource consists of two pages: Connection and Schemas.
Connection Page
ADB Configuration shared resource: Connection Page
The ADB Configuration shared resource utilizes the JDBC connection shared resource to retrieve thedatabase table schema information. The JDBC connection shared resource is configured on theConnection page.
The Connection page consists of two sections: General and Configuration.
Shared Resource > Connection Page > General Fields
FieldModuleProperty? Description
Package No The name of the package where the shared resource is added.
Name No The name to be displayed as the label for the shared resource in theprocess.
23
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
FieldModuleProperty? Description
Description No A short description for the shared resource.
Shared Resource > Connection Page > Configuration Fields
FieldModuleProperty? Description
JDBCConnection
No Define the JDBC connection by selecting the JDBC shared resource.Oracle and Microsoft SQL Server are the supported vendors. OnlyTIBCO embedded DataDirect JDBC driver is supported by the plug-in.
DefaultSchema
Yes Specify the default schema name.
If no default schema name is specified, it uses the JDBCconnection user name.
Set ClientInfo(Oracle)
Yes When the value of this property is set to on, the plugin callsSET_CLIENT_INFO to set the database session client information.
The default value is on.
DB2 Type No Select the type of DB2 from the drop down: UDB , AS400, or OS390.
The default value is OS390.
ValidateSchema
No Click this button to validate the JDBC connection and the schemasconfigured under the shared resource. For the schema, the tables,columns, and column types are validated. If a referred table isprovided, the existence of the table is also validated. An errormessage is displayed if the validation fails.
After all the issues are resolved, after clicking Validate Schema, youreceive a "Validation of Schema is successful" message.
24
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Schemas Page
ADB Configuration shared resource: Schemas Page
The type of service and the associated tables to generate XSD schema and database triggers are definedon the Schemas page.The Schemas section on the left lists the schema type. You can add or remove schemas. You can addDBPoller, DBMerger and DBRequester schema types when a new DBPoller or DBMerger orDBRequester schema is added, a corresponding section is created on the right that consists of thefollowing tabs:
● Configuration
● Schema
● Options
● Child Table Order By (only for DBPoller activity)
● Child Table Exception Mappings (only for DBMerger activity)
● DB2 (only when the DB2 connection is used)
The Configuration tab contains the following fields:
25
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Shared Resource > Schemas Page > Configuration Tab
FieldModuleProperty? Description
Name No You can update the schema name.
See Entity Naming Conventions.
Description No A short description for the schema.
The Schema tab contains the following UI options:
Shared Resource > Schemas Page > Schema Tab
Icon/Option Description
Add a parent table from the connected Database (through JDBC connection).
Add a child table to a parent table.
Refresh the existing schema or change the columns used.
Allow KeyColumns Only
If this check box is selected, the Join To relation between the parent and childtable is applied only on the columns having a User Key. If the check box is notselected, the Join To relation can be applied on any fields.
Tables andColumns
Displays the selected table and its columns.
26
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Icon/Option Description
Join To Set a relation between the parent table and child table.
For setting a relation between the parent table and child table, you must eitherclear the Allow Key Columns Only or at least one column must be enabled asUser Key from the parent.
User Key Select the check box beside the column name to specify that the column mustcontain a unique sets of values. If the user key is defined in a child table and theparent table has a primary key, it has no impact on the generated triggers andthe user key is used for mapping the parent-child relationship.
If the parent table does not have a primary key (rare cases), no update or deletetriggers are generated. To use a user key as the implicit primary key in thetrigger, you must modify and apply the trigger manually.
Update Trigger Fires a trigger when an UPDATE statement changes a value in a column.
Only the following databases are supported in the Update Trigger option:
● Oracle
● SQL Server
● DB2 UDB/AS400/OS390
Update trigger is applicable only for a parent table.
XSD Type Displays the XSD type of the column. This is a read-only column.
DB Type Displays the data type of the database column. This is a read-only column.
The Options tab contains the following fields for the Data Event Poller activity:
27
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Shared Resource > Schemas Page > Options Tab for Data Event Poller activity
FieldModuleProperty? Description
Storage Mode No Select how the stage table keeps the event information. You caneither Publish by Value or Publish by Reference. If you selectPublish by Reference as the storage mode when you select thereference object, you can see all the column details such as Column,XSD Type, and DB Type.
● Publish by Value: The storage table keeps all the publishedcolumn information in the stage table.
● Publish by Reference: Only the key value(s) of the changed eventare kept in the storage table, and data of other columns isretrieved through the table's join operation.
If you specify a table or view as a referred object, thereferred object must contain columns with the samenames and data types as the primary key columns inthe source table.
The primary key values in the source table must be thesame as the primary key values in the referred object.
PublishingTable
No Displays the stage table name. This name can be modified.
You can use only alphanumeric characters and anunderscore in the table name. No other special charactersare allowed in the table name.
See Publishing Table for more information on the columns in thepublishing table.
ReferredObject
No You can add a reference object from the same schema or a differentschema. This option is enabled only when the Storage Mode isPublish by Reference.
You can also download a table or a view as a referred object.
If this field is empty, the plug-in reads data from the source table.
If you specify a table or view as a referred object, thereferred object must contain columns with the samenames and data types as the primary key columns in thesource table. The primary key values in the source tablemust be the same as the primary key values or the subsetof primary key values in the referred object.
For more information about how to add a reference object, see Creating a Schema Using the ADB Configuration Shared Resource.
Publish ChildData
No Select the check box if you want to publish the parent table and thechild table data.
The default is true.
28
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
FieldModuleProperty? Description
ReferredObject
No Displays the name of the table that is selected as the referred object.
Select No Click this button to select a table as a referred object.
Refresh No When the schema is altered, you can click this button to refresh theschema displayed in the Referred Object Table.
No Click this button to clear the selected referred object.
Referred Object Table
Columns No Displays the columns in the referred object.
XSD Type No Displays the XSD type of the column.
DB Type No Displays the data type of the database column.
The Options tab contains the following fields for the Data Merger activity:
29
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Shared Resource > Schemas Page > Options Tab for Data Merger activity
FieldModuleProperty? Description
ExceptionTable Name
No Name of the exception table to which data is written if the plugincannot write the data to the data merger destination table. This tableholds messages that caused an exception. If the table does not exist,data merger creates one by itself. For more information aboutexception table, see Exception Table.
The exception table cannot contain any user-created columns wherethe column name starts with ADB_. These characters are reservedfor use by the plugin.
For the parent-child relationship, this is the parentexception table. If you do not set the parent exceptiontable, the child exception table is invalid.
OpaqueExceptionTable Name
No Specifies the name for the opaque exception table. For moreinformation about opaque exception table, see Opaque ExceptionTable.
You can use the Child Table Order By tab to specify the columns of an Order By clause used for eachchild table query. The plug-in returns the child table result set in a particular sequence.
The Child Table Order By tab contains the following fields:
Shared Resource > Schemas Page > Child Table Order By Tab
Icon/Option Description
Child TableName
When a child table is added to a parent table, the child table is automaticallyadded to the Child Table Order By tab. The name of table is displayed here.
30
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Icon/Option Description
Select Columns The Order By Clause column cannot be edited; you can add the fields of thetable by selecting them using the Select Columns button. The wizard thatopens, contains a list of all the fields of the child table. You can select thecolumns based on which you want to order the table.
● Check to Use DESC - Identifies the columns based on which you want toorder the table. The default order is the ascending order. To order in thedescending order, you can select the check box beside the column in theCheck to Use DESC panel.
● - Moves the selected column to the Check to Use DESC list.
● - Moves the selected column from the Check to Use DESC list to theleft.
● - Moves the selected column to one level above in the Check to UseDESC list.
● - Moves the selected column to one level below in the Check to UseDESC list.
You can use the Child Exception Table Mappings tab to create child exception table.
The Child Exception Table Mappings tab contains the following fields:
Shared Resource > Schemas Page > Child Exception Table Mappings Tab
Icon/Option Description
DBMerger ChildTable Name
Displays the list of child table names.
Child ExceptionTable Name
Displays the list of child exception table names corresponding to each childtable in the DBMerger Child Table Name column.
The DB2 tab contains the following fields for the Data Even Poller activity:
31
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Shared Resource > Schemas Page > DB2 Tab for Data Event Poller activity
Icon/Option Description
OS390 Options
Database Name Name of the database that you want to put your publishing table in.
Table SpaceName
Name of the table space where the publishing table is located.
Storage Group Optional.
The designator of the storage group that holds the publishing table indexes.
Buffer Pool Optional.
Name of the buffer pool to be used for indexes.
Index Suffix A suffix of your choice, up to 13 characters, that the plug-in appends to each ofthe indexes (IDX_1 and IDX_2).
Trigger Suffix A suffix of your choice, up to 5 characters, that the plug-in appends to each ofthe triggers (T1, T2, and T3).
AS400 Options
Trigger Option The new data from the source table is copied to the publishing table by settingthe trigger options. Currently, the SQL option is available.
SQL: The SQL trigger can be insert, update, or a delete trigger. When copyingfrom the source table to the publishing table, the prompt is not returned untilall data is written.
The DB2 tab contains the following fields for the Data Merger activity:
32
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Shared Resource > Schemas Page > DB2 Tab for Data Merger activity
Icon/Option Description
OS390 Options
Database Name Name of the database that you want to put your publishing table in.
Table Space Name Name of the table space where the publishing table is located.
LOB Table SpaceName
The name of the Large Objects (LOB) table space name where auxiliary tableof the opaque exception table is located.
The Configuration tab contains the following fields for the Data Requester activity:
33
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Shared Resource > Schemas Page > Configuration Tab for Data Requester activity
Field Description
Name Name of the database that you want to put your table in.
Description Description of the table.
Mode The mode of operation - Request-Reply or Remote Procedure Call.
Creating a Schema Using the ADB Configuration Shared ResourceYou can use the ADB Configuration Shared Resource to create a schema to use in the processes youcreate using the activities provided by this plug-in.
Adding a Shared ResourcePerform the following steps to add a shared resource for the DataEventPoller activity, DataMergeractivity, and the DataRequester activity.
Procedure
1. Expand the created project in the Project Explorer view.
2. Right-click the Resources folder and select New > ADB Configuration. Specify the Resource Folder,Package, and Resource Name. Click Finish.
3. On the Connection page, select the JDBC connection in the JDBC Connection field.
4. On the Schemas page, select DBPoller, DBMerger, or DBRequester as required, and then clickAdd. As soon as a new DBPoller, DBMerger, or DBRequester schema is added, a correspondingsection is created on the right.
34
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
The schema for DataRequester activity has the following modes:● Request Reply mode takes a sequence of statements as a request and replies back to
activity as output.
● Remote Procedure Call (RPC) mode can be used to configure the plug-in to act asremote procedure call server on behalf of a client.
Adding a Parent Table
If you perform a delete operation on a Parent table, the DataEventPoller activity does not publish anychild data.
To add a parent table from the connected Database (through JDBC connection) for the DataEventPolleractivity and the DataMerger activity:
Procedure
1. Click the icon. The Select Table wizard is displayed.2. Enter a pattern name to search the table.
You can also use the % character to search for table names.3. To fetch data from the default schema, click Fetch beside the Default Schema field. To fetch data
from any other schema, click Fetch beside the Other Schema.
● For a parent table, only tables are fetched.
● In the same ADB Configuration shared resource, after a table is downloaded, it is notdisplayed in the list when you do the next fetch.
All the tables available in the specified schemas are displayed.
35
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
4. Click Finish.The table is displayed in the Schema tab on the right.
Adding a Child TableTo add a child table from the connected Database (through JDBC connection) for the DataEventPolleractivity and the DataMerger activity:
Procedure
1. Select the parent table and click .
A wizard similar to the one for adding a parent table is displayed.
2. Fetch the table and click Finish.
● For a child table, both tables and views are fetched.
● In the same ADB Configuration shared resource, once a table or view is downloaded, itis not displayed in the list when you do the next fetch.
The child table is added under the parent table and displayed in the Schema tab on the right.
36
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Setting Up a Relation Between Parent and Child TablesYou can set up a relation between the parent and child table using Join To for the DataEventPolleractivity and the DataMerger activity. For applying a Join To relation between a parent and child table,you need to set at least one field as the User Key in the child table or uncheck the Allow Key Columnscheck box.
Procedure
1. If you want to apply the Join To relation only on fields having a user key, select the Allow KeyColumns Only checkbox. If you clear the Allow Key Columns Only check box, the Join To relationis applied on any fields from the parent table.
2. Select the Update Trigger check box to ensure that the selected column is updated by the databaseapplication.
You can edit the information for Join To, User Key, and Update Trigger columns of the child tablein a dialog box by double clicking the table name.
37
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
38
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Refresh the Schema
Refresh the existing schema or change the columns used by using the icon.
Specifying the Columns of an Order By Clause for a Child TableWhen a child table is added to a parent table, it is displayed on the Child Table Order By tab. You canspecify the columns of an Order By clause used for each child table query. The plug-in returns the childtable result set in a particular sequence. To specify the columns of an Order By clause for a child tablefor the DataEventPoller activity and the DataMerger activity:
Procedure
1. Click Select Columns on the Child Table Order By tab.The Select Child Table Order By Columns wizard appears.
2. Select the fields depending on the order you want and move them to the right panel using .
Similarly, you can use to move them back to the left panel. You can also reorder the sequenceusing the Up and the Down buttons.
3. If you want to get the values of a field in a descending order, select the check box beside theappropriate field in the right panel, that is, the Check to Use DESC panel. The default order is theascending order.
4. Click Finish.
39
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Table ReferenceWhen TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database publishes data to or retrieves datafrom a source or target schema, the plug-in has to deal with several tables.
The tables are listed below:
● Publishing Table
● Child Table
● Exception Table
● Child Exception Table
● Opaque Exception Table
Publishing TablePublishing tables mirror tables that you have identified for monitoring. They contain additionalcolumns, primarily a sequence number and delivery status, which are required by the plug-in to detectnew rows. You can create a publishing table for each table you want to activate in TIBCO BusinessStudio.
In addition to a copy of the source table columns, the publishing table has the following additionalcolumns.
Column Name Type Description
ADB_SEQUENCE INTEGER Stores the monotonically increasingsequence number that represents newrows in the publishing table. If a columnwith this name exists, the number isgenerated automatically.
By default, the schema type is string. Theplug-in treats this number as a string. Thisnumber can be larger than an integer if thedatabase supports it.
ADB_TIMESTAMP DATE Time of row insertion in publishing tablethat is used to calculate expiration of rows.The timestamp is generated automatically.
ADB_OPCODE INTEGER Operation code used by the plug-in:
● 1 indicates INSERT
● 2 indicates UPDATE
● 3 indicates DELETE
For more information about the upsertoperation, see Upsert Operation on Parent-Child Tables.
ADB_REF_OBJECT VARCHAR2(64) When publishing by reference object isused, contains the name of the referenceobject that provides source data.
40
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Column Name Type Description
ADB_L_DELIVERY_STATUS
ADB_L_DELIVERY (for DB2)
CHAR Delivery status of Records:
● N indicates that a new Record hasarrived, but has not yet been published.
● S indicates that one node has got thisrecord, and is not taken again whenpolling other records.
● C indicates complete.
● F indicates failed.
Also see Child Table.
Child TableTo support incremental parent-child operations, each child row has an opcode, that is, an extraADB_OPCODE field that is added to the child schema. The plug-in determines if the operation is anincremental parent-child operation by checking the first level child opcode. If the first level childopcode is not set, the plug-in treats it as a complete operation. For the subsequent child level, if thechild opcode is not set, it inherits the parent opcode.
When working with a parent-child table, the value of ADB_OPCODE in the parent table and the childtable must be the same. Or set the value of ADB_OPCODE only in the parent table and leave the childtable empty.
Also see Publishing Table.
Exception TableIf a database restriction is applied or a failure occurs, an exception table can be configured to receive amessage.
In addition to destination table columns, the following columns are added to the exception table:
Column Name Type Description
ADB_OPCODE INTEGER Operation code used by the plug-in:
● 1 indicates INSERT
● 2 indicates UPDATE
● 3 indicates DELETE
● 4 indicates UPDATE if row exists,otherwise, INSERT
If an incoming job does not have anoperation code, an INSERT operationoccurs. For more information about theupsert operation, see Upsert Operation onParent-Child Tables.
41
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Column Name Type Description
ADB_TRACKING_ID VARCHAR2(40) Tracking ID of the job.
This column is the primary key. Eachexception table that is mapped to a childtable is connected to the parent exceptiontable by this column.
ADB_JOIN_ID VARCHAR2(46) Joined column used to link a parent recordto its child record.
ADB_JOIN_ID is generated fromADB_TRACKING_ID and concatenatedwith the record number in the group.
The exception table of a child table isconnected to the exception table of a parenttable by the ADB_JOIN_ID column.
ADB_ERROR_TEXT VARCHAR(4000) Text of the error from the database serveror other source that caused the error.
ADB_ERROR_TIME TIMESTAMP Timestamp of the inserted record.
For Oracle databases, the timestampincludes the time zone information.
Using an Exception Table as a Source Table
If you want to publish data from an exception table and use that exception table as the source table, donot use the ADB_ERROR_TEXT or ADB_OPCODE column names. Instead, follow these guidelines:
● Create a database view that mirrors the exception table, rename the ADB_ERROR_TEXT andADB_OPCODE columns so that they do not begin with "ADB_."
● After renaming the columns, use Publish By Reference Object and choose your view as the referenceobject.
Child Exception TableA child exception table contains both child table columns and additional columns.
The additional columns are listed in the following table:
Column Name Type Description
ADB_TRACKING_ID VARCHAR2(40) Tracking ID of the message.
ADB_JOIN_ID VARCHAR2(46) Joined column used to link a parent recordto its child record.
ADB_JOIN_ID is generated fromADB_TRACKING_ID and concatenatedwith the record number in the group.
ADB_ERROR_TEXT VARCHAR(4000) Text of the error from the database serveror other source that caused the error.
42
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Opaque Exception TableThe Data Merger activity uses two logical layers when processing a message. The first layer decodesdata from the message, and the second layer provides the database transaction. If an exception occursin the first layer, the plugin logs the message in the opaque exception table. In the second layer, if anyDML command fails at any level, the plugin rolls back this transaction and starts another transaction,inserting the error messages in exception tables. If inserting error messages in the exception table fails,the plugin logs the message in the opaque exception table.
The opaque exception table records the entire message in a column with the error message. The opaqueexception table has the following columns:
Column Name Type Description
ADB_TRACKING_ID VARCHAR2(40) Tracking ID of the message.
ADB_SUBTAB VARCHAR2(1000) Destination table name.
ADB_ERROR_TEXT VARCHAR(4000) Text of the error from the database server,plugin SDK, or other source that causedthe error.
ADB_ERROR_TIME TIMESTAMP Timestamp of the inserted record.
For Oracle records, the timestamp includesthe time zone information.
ADB_MSG BLOB Raw bytes of the message.
The default column size is 1 M.
43
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
ADB Palette
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database achieves its functionality with the help ofData Event Poller activity, Data Merger activity, and Data Requester activity.
The Data Event Poller Activity, Data Merger Activity and the Data Requester Activity use the ADBConfiguration shared resource created earlier.
● In Data Event Poller activity, the user key is used to define a relationship between the parent andchild tables.
● In the Data Merger activity, the user key is used in the "where" clause of a query during an updateoperation or a delete operation.
● Projects from earlier versions of the TIBCO ActiveMatrix BusinessWorks™ Plug-in for Databaseneed to be refactored. For more information about refactoring, see Refactoring a Project.
Data Event Poller ActivityThe Data Event Poller activity polls the change in a stage table in a specified time interval. Theconfiguration allows you to generate the required trigger SQL script file to create stage table andtriggers.
General
The General tab contains the following fields:
Field
Literal Value/ProcessProperty/ModuleProperty? Description
Name No The name to be displayed as the label for the activity in theprocess.
See Entity Naming Conventions.
ConfigurationResource
Yes Shared configuration resource containing information aboutthe ADB Configuration connection.
44
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Field
Literal Value/ProcessProperty/ModuleProperty? Description
Schema No The DBPoller schema which is configured with the schematable is based on the XSD generated by the DBPoller schema.
● Apply Trigger: Applies the trigger script to the database.
● Generate Trigger: Saves the trigger script to a specific fileand can be applied to the database later. You areprompted to select the directory where the trigger filesare to be created. Two files are generated at the specifiedlocation:
— A SQL file containing the script for triggering to thedatabase
— A cleanup SQL file which contains a script to cleanup created publishing table, triggers, sequences, andso on.
The filenames are created based on the name of theschema.
You cannot apply or generate the trigger if you areoffline; you must be connected to the database tofetch table metadata.
Description
Provide a short description for the activity.
Advanced
This tab has the following fields:
Data Event Poller: Advanced Tab
45
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Field
Literal Value/ProcessProperty/ModuleProperty? Description
Sequence Key No This field can contain an XPath expression that specifieswhich processes should run in order. Process instanceswith sequencing keys that evaluate to the same value areexecuted sequentially in the order the process instancewas created.
Custom Job ID No This field can contain an XPath expression that specifiesa custom ID for the process instance.
Operation Options
Record Per Event Yes Specifies the maximum number of database records tobe retrieved per event to start a TIBCO ActiveMatrixBusinessWorks™ job. The default value is 1.
PollingInterval(ms)
Yes Specifies the amount of time in seconds for polling. Thedefault value is 5000.
Batch Size(MaxRows)
Yes Maximum number of records to be retrieved for eachpolling, when polling batch is used. The default value is10.
ReadCommit(DB2)
Yes Enables the plug-in publisher to perform a commitoperation after selecting a query for DB2.
This check box is enabled only when you use DB2database vendors, including DB2 OS390, DB2 AS400,and DB2 UDB.
Load Balancing Options
Enable LoadBalancing
Yes Load balancing distributes the workload across TIBCOActiveMatrix BusinessWorks™ Application nodes toimprove the performance in a high-load scenario.TIBCO ActiveMatrix BusinessWorks™ Applicationnodes with the same mutex name specified are in thesame load balance group.
Load balancing is enabled by default.
If you enable Load balancing, the order ofdata processing is not sequential.
Mutex Name Yes Name of the Mutex table. This name can be changed.
The default name is the first 20 characters of thepublishing table name suffixed with "_MUTEX".
Republish Data Options
46
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Field
Literal Value/ProcessProperty/ModuleProperty? Description
Failed(F) Records Yes If this check box is selected, records that have a failedstatus are republished when the application is started.
Scheduled(S)Records
Yes If this check box is selected, records that have ascheduled status are republished when the applicationis started.
Schema Mapping Options
Design Time Yes Specifies the design-time database object's schema. Itcan be a list of comma-separated schemas.
Runtime Yes Specifies the runtime table object's schema. It can be acomma-separated list of schemas.
Output
This tab displays the output schema.
For more information about how different data types are mapped to the XSD type, see OutputMapping.
47
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Fault
Data Event Poller Activity: Fault Tab
The Fault tab lists the following exceptions, which are thrown by this activity:
Error Schema Element Data Type Description
ADBSQLException String It has a msg and msgCode field for the exception.
ADBValidationExeption String It has a msg and msgCode field for the exception.
msg String The error message returned by the plug-in.
msgCode String The error code returned by the plug-in.
Data Merger ActivityThe Data Merger activity performs the insert, update, and delete operations on the parent-child table.The configuration allows you to generate the required exception table SQL script file to create exceptiontables in the database. If an exception occurs while performing a database operation, the record isinserted in the created exception or opaque table.
When you migrate a project created in an earlier version to 8.1.0 version, you must have to refactor it tobe able to see the schema for Data Merger activity. To refactor your project, in TIBCO Business Studio,in the Project Explorer pane, right click the project name, select Refactor > Repair BusinessWorksProjects.
General
The General tab contains the following fields:
48
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Field
Literal Value/ProcessProperty/ModuleProperty? Description
Name No The name to be displayed as the label for the activity in theprocess.
See Entity Naming Conventions.
ConfigurationResource
Yes Shared configuration resource containing information aboutthe ADB Configuration connection.
Schema No The DBMerger schema which is configured with the schematable is based on the XSD generated by the DBMergerschema.
● Create Exception Table: Applies the exception table scriptto the database.
● Script Exception Table: Saves the exception table script toa specific file and can be applied to the database later. Youare prompted to select the directory where the triggerfiles are to be created. Two files are generated at thespecified location:
— An SQL file containing the script for triggering to thedatabase
— A cleanup SQL file which contains a script to cleanupthe exception tables that are created.
The filenames are created based on the name of theschema.
You cannot apply or generate the exception tablesif you are offline; you must be connected to thedatabase to fetch the table metadata.
Description
Provide a short description for the activity.
49
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Advanced
Data Merger Activity: Advanced Tab
This tab has the following fields:
Field
Literal Value/ProcessProperty/ModuleProperty? Description
Operation Options
Timeout(sec) Yes Activity timeout in seconds.
Default value is 180 seconds.
Upsert Yes Updates a row in the destination table if the row exists. Ifno such row exists, it performs an insert. For moreinformation about the upsert operation behavior, see Upsert Operations on Parent-Child Tables.
Set Empty String toDefault(Oracle)
Yes Either on or off. The default setting is off. It works only ifthe following three criteria are met:
● Oracle database is used
● Insert operation is being performed
● JDBC Property CatalogOptions property is set to 1
When you set a default value to a field in creating table, ifthe property value is set to on, the empty strings arechanged to the default value.
Pre Commit Options
50
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Field
Literal Value/ProcessProperty/ModuleProperty? Description
Stored Procedure Yes The value entered here represents the name of a storedprocedure the merger calls after the database insert,update, or delete operation and before the commit.
Date And Time Pattern Options
Date Yes Enter the date in the yyyy-MM-dd format.
Time Yes Enter the time in the HH:mm:ss format.
Timestamp Yes Enter the timestamp in the yyyy-MM-dd HH:mm:ss.Sformat, where S is milliseconds.
Batch And Bulk Insert Options
Bulk Insert Size Yes All incoming messages to be inserted are stored until thissize is reached. Then, a bulk insert operation is performedon the destination table.
The default value is 1.
Batch Commit Size Yes This property specifies the number of records to bebatched before invoking a commit operation.
The default value is 1. You can set this property if youwant to enable batch commit.
Handle Bulk InsertError
Yes This property indicates whether the bulk insert errorhandling feature in the Data Merger activity is enabled ornot.
Its default value is off.
Schema Mapping Options
Design Time Yes Specifies the design time database object schema. It can bea list of comma-separated schemas.
Runtime Yes Specifies the runtime database object schema. It can be alist of comma-separated schemas.
Input
This tab displays the input schema. You must map the input for the parent-child tables.
51
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Output
This tab displays the output schema. If the table does not have a primary key, all columns of the tableare displayed. However, if the table has a primary key, then only the primary key column is displayed.The ADB_STATUS field displays the status of whether a record is processed or not. This field can havetwo values - Success and Fail.
The ADB_ERROR_TEXT field displays the details of the error. This error might be caused when anyrecord fails due to an SQL exception and the ADB_STATUS field has value Fail.
Data Merger Activity: Output Tab
For more information about how different data types are mapped to the XSD type, refer to OutputMapping.
Fault
A fault is generated in the following scenarios:
● When the XSD validation fails or the JDBC connection fails, the ADBValidationException occurs.
● The ADBSQLException occurs and any one of the following scenarios is true:
— The database connection is lost.
— The exception and opaque table names are not specified.
— The exception and opaque tables are not created in the database.
52
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
— The "insert into exception table" fails and the opaque table is not specified or not created.
Data Merger Activity: Fault Tab
The Fault tab lists exceptions that are thrown by this activity.
Error Schema Element Data Type Description
ADBSQLException String It has a msg and msgCode field for the exception.
ADBValidationExeption String It has a msg and msgCode field for the exception.
msg String The error message returned by the plug-in.
msgCode String The error code returned by the plug-in.
Data Requester ActivityThe Data Requester activity allows an application to submit one or more SQL statements andprocedures to be processed. The plug-in processes the request and returns the results as a reply.
General
The General tab contains the following fields:
Data Requester Activity: General Tab: Request Reply Mode
53
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Data Requester Activity: General Tab: RPC Mode
Field
Literal Value/ProcessProperty/ModuleProperty? Description
Name No The name to be displayed as the label for the activity in theprocess.
See Entity Naming Conventions.
ConfigurationResource
Yes Shared configuration resource containing information aboutthe ADB Configuration connection.
Schema No The DBRequester schema which is configured with RequestReply mode or Remote Procedure Call (RPC) mode.
The Request Reply mode takes a sequence of statements as arequest and sends the reply back to the reply subject.
The RPC mode is used to configure the plug-in to act as aremote procedure call server on behalf of a client.
Operation No Type of RPC operation.
SQL_EXECUTE - a single SQL statement is processed.
SQL_BATCHEXECUTE - a sequence of SQL statements isprocessed.
Description
Provide a short description for the activity.
Advanced
This tab has the following fields:
54
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Data Requester Activity: Advanced Tab
Field
Literal Value/ProcessProperty/ModuleProperty? Description
Operation Options
Maximum Rows Yes Specifies the maximum number of rows to be fetched.This can be used to limit the memory usage of the plug-in. The unfetched rows are ignored by the plug-in.
At run time, the plug-in fetches the number of rowsaccording to the value set in the operation level insteadof the service level.
Statement Cache Yes The number of cache statements for a generic RPCrequest/reply service.
The size of the cache depends on the number ofstatements provided as input.
Date And Time Pattern Options
Date Yes Enter the date in the yyyy-MM-dd format.
Time Yes Enter the time in the HH:mm:ss format.
Timestamp Yes Enter the timestamp in the yyyy-MM-dd HH:mm:ss.Sformat, where S is milliseconds.
Input
This tab displays the input schema.
55
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Data Requester Activity: Input Tab with RPC Mode (Operation: SQL_EXECUTE)
To execute multiple SQL statements, you must provide the input as multiple item elements forstatements with their individual SQL string as can be seen in the following image:
Data Requester Activity: Input Tab with RPC mode (Operation SQL_BATCHEXECUTE)
56
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Data Requester Activity: Input Tab with Request Reply Mode
Input Schema Description
Field Description
MAXROWS The maximum number of rows to retrieve.
SQL_STRING The SQL string used to specify the SQL statement to be executed.
CLOSURE Closure argument. The reply returns this closure argument untouched.
POSITION Specify the index of the input parameter to bind the input data.
NAME Specify the column name from the DB table if binding either of the followingdata types: DATE, TIME, TIMESTAMP.
PARAMTYPE Specify if the parameter is the INPUT parameter or OUTPUT. Use IN/OUT.
DATA Specify the input data to bind to the input parameter in the SQL String.
Output
This tab displays the output schema.
57
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Data Requester Activity: Output Tab
58
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Data Requester Activity: Output Tab with Request Reply Mode
59
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Data Requester Activity: Output Tab with RPC Mode (Operation: SQL_EXECUTE)
Data Requester Activity: Output Tab with RPC Mode (Operation: SQL_BATCHEXECUTE)
For more information about how different data types are mapped to the XSD type, see OutputMapping.
60
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Field Description
STATUS SUCCESS if the stored procedure or SQL statement is executed successfully.
FAILURE if an error occurs. Error details are stored in the ERROR_DESCfield.
SQL The SQL string used to specify the SQL statement to be executed.
ERROR_DESC In case if the status is FAILURE, error description is stored here.
CLOSURE Closure argument obtained from the request.
OUTBINDS The output parameters of the stored procedure.
RESULTSETS The result set(s) returned by the stored procedure or SQL statement.
Fault
Data Requester Activity: Fault Tab
The Fault tab lists exceptions that are thrown by this activity:
Error Schema Element Data Type Description
ADBSQLException String It has a msg and msgCode field for the exception.
ADBValidationExeption String It has a msg and msgCode field for the exception.
msg String The error message returned by the plug-in.
msgCode String The error code returned by the plug-in.
61
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Advanced Topics
When you use TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database, you can use advancedconfiguration and deployment.
The following topics are covered in this section:
● Output Mapping
● Fault Tolerance
● Load Balancing
● Unlocking the MUTEX Table
● Viewing Client Information Details
● Refactoring a Project
● Error Handling by Data Merger Activity
● Upsert Operation on Parent-Child Tables
● Entity Naming Conventions
● Configuring Sybase Database by Using Custom JDBC driver
Output MappingThis section describes how different data types are mapped to the XSD type.
Mapping Adapter Datatype to Plug-in XSD Type
Adapter AE Datatype Plug-in XSD Type
i1 byte
i2 short
i4 int
i8 long
ui1 unsignedByte
ui2 unsignedShort
ui4 unsignedInt
ui8 unsignedLong
r4 float
r8 double
binary base64Binary
string string
62
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Adapter AE Datatype Plug-in XSD Type
adbDateTime string
Mapping Sybase Datatype to XSD Type
Database Type XSD Type
binary base64Binary
bit int
char string
datetime string
decimal double
float double
int double
money double
numeric double
real double
smalldatetime string
smallint int
smallmoney double
tinyint int
varbinary base64Binary
varchar string
Mapping Microsoft SQL Server Datatype to XSD Type
Database Type XSD Type
nchar(n) string
datetime string
binary(n) base64Binary
decimal(p,s) double
63
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Database Type XSD Type
float double
money double
real double
smalldatetime string
smallint int
smallmoney double
tinyint int
uniqueidentifier string
varbinary(n) base64Binary
bit int
bigint long
datetimeoffset string
date string
varchar(max) string
char(n) string
int int
numeric double
nvarchar string
timestamp base64Binary
Mapping Oracle Datatype to XSD Type
Database Type XSD TypeCases for Numeric andNumber
BLOB base64Binary
CLOB string
CHAR string
DATE string
64
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Database Type XSD TypeCases for Numeric andNumber
FLOAT string
LONG string
LONG RAW base64Binary
NCHAR string
NCLOB string
NUMBER double If size is not specified, thedefault is 22.
NUMBER(n) int If size less than 10
NUMBER(p,s) double If size is 10 or more than 10
NVARCHAR2 string
RAW base64Binary
TIMESTAMP string
VARCHAR2 string
NUMBER(n) int If size less than 10
NUMERIC double If size is not specified, thedefault is 22.
NUMERIC(p,s) double
NUMERIC double If size is 10 or more than 10
Mapping DB2 Datatype to XSD Type
Database Type XSD Type
integer double
char string
bigint long
date string
decimal int
decimal(n,s) double
65
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Database Type XSD Type
double double
time string
timestamp string
numeric int
real double
smallint int
float double
blob base64binary
clob string
graphic string
long vargraphic string
long varchar string
varchar string
binary base64binary
Mapping MySQL Datatype to XSD Type
Database Type XSD Type
bigint long
bigint unsigned double
binary base64binary
bit base64binary
blob base64binary
char string
date string
datetime string
decimal double
66
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Database Type XSD Type
double double
float double
integer double
longblob base64binary
longtext string
mediumblob base64binary
mediumint int
mediumint unsigned int
mediumtext string
smallint int
smallint unsigned int
text string
time string
timestamp string
tinyblob base64binary
tinyint int
tinyint unsigned int
tinytext string
varbinary base64binary
varchar string
year string
Mapping PostgreSQL Datatype to XSD Type
Database Type XSD Type
bigint long
bytea base64binary
67
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Database Type XSD Type
character string
char string
date string
double precision double
numeric double
real double
time without time zone string
timestamp without time zone string
text string
bit int
bit(n) where n=1 int
bit(n) where n>1 int/base64binary
integer double
smallint int
Fault ToleranceFault Tolerance allows multiple application nodes to substitute for each other. When the primaryapplication node terminates unexpectedly, the role held by the primary application node can be takenover by an application node in the standby state. In the process of replacement, the standby applicationnode is promoted to the primary application node.
To apply Fault Tolerance, you can select one of the following methods:
● In the process designer, right-click and select Show Properties View. Navigate to the Advanced tab.Select Activation as Single AppNode.
● Setup TIBCO ActiveMatrix BusinessWorks™ Administrator in a Fault Tolerance group.For more information on fault tolerance in TIBCO Activematrix BusinessWorks™, refer to the TIBCOActiveMatrix BusinessWorks™ Administration guide.
Load BalancingThe plug-in provides Load Balancing to distribute the workload across application nodes. This resultsin an improvement of performance in a high-load scenario.
Application nodes with the same mutex name specified are in the same load balancing group.
By default, load balancing is ON.
The default name of the mutex table is the first 20 characters of the publishing table name suffixed with"_MUTEX". You can change the name of the mutex table name and the corresponding mutex table iscreated in the database.
68
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
For more information on load balancing and fault tolerance in BusinessWorks, refer to the TIBCOActiveMatrix BusinessWorks™ Administration guide.
Enabling Load BalancingBy default, load balancing is on.
To apply Load Balancing, you can select one of the following methods:
● In the process designer, right-click and select Show Properties View. Navigate to the Advanced tab.Select Activation as Multiple AppNode.
● Setup ActiveMatrix BusinessWorks Administrator in a Group mode.
Disabling Load Balancing
Procedure
1. Click the DataEventPoller activity in the Process Designer.
2. Navigate to the Properties tab > Advanced section.
3. Clear the Enable Load Balancing check box.Load balancing is disabled.
Unlocking the MUTEX TableA Mutex table could result in lock and unlock situations.
When you publish data, the data is set in the table and the status is also set to N. When an applicationnode is running, the mutex table fetches data with status as N and acquires a lock. When the statuschanges from N to S, the mutex table releases the lock from the table. If you try to forcefully shutdownthe application node, the mutex table gets locked and the configurations associated with Mutex table donot work. To release a lock on a MUTEX table, manual intervention is required.
Only DBA users can execute the scripts to unlock the MUTEX table.
Oracle
To fetch the ID and serial number of the locked session, execute the following query:select s.sid, s.serial#, p.spid From v$session s, v$process pwhere s.paddr = p.addr AND s.sid in (select SESSION_ID fromv$locked_object);
69
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
To kill the session that has acquired the lock, execute the following query:alter system kill session '<id>, <serial number>';
Microsoft SQL Server
To fetch the ID and serial number of the locked session, execute the following query:SELECT OBJECT_NAME(P.object_id) ASTableName,Resource_type,request_session_idFROM sys.dm_tran_locks LJOIN sys.partitions PON L.resource_associated_entity_id=p.hobt_idWHERE OBJECT_NAME(P.object_id)='P1Chronolog_IncidentActivityUpdates'
To kill the session that has acquired the lock, execute the following query:Kill session_ID
Viewing Client Information DetailsClient information is displayed in the format ADB_<appnode>_<appspace>_<domain>. Theclient_info parameter is limited to 64 bytes. Longer values are truncated.
Administrators can check client information details. To view client information in the database, youmust run the following query:
SELECT sid, username, client_info FROM v$session WHERE username='<username>';
Refactoring a ProjectProjects from earlier versions have to be refactored to enable the features provided in the new versionsof the plug-in.
Procedure
1. In the Project Explorer pane of TIBCO Business Studio, right-click the project name and selectRefactor > Repair BusinessWorks Projects.
70
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
2. In the Select the BusinessWorks Projects window, ensure that the Refresh Project Cache and doProject Clean and Add DBMerger in ADB Configuration Shared Resource check boxes areselected.
3. Click OK.
Error Handling by Data Merger ActivityWhen the Data Merger activity inserts data in a database and an error occurs, the activity rolls back allprevious operations on the database to the original status. The Data Merger activity handles data in twoways: normal error handling and bulk insert error handling.
The following topics are covered in this section:
● Normal Error Handling
● Bulk Insert Error Handling
● How Records are Handled by the Bulk Insert Error Handling Feature
Normal Error Handling
Principles for normal error handling are as follows:
71
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
● If you do not set a bulk insert size, the Data Merger activity inserts error data into either theexception table or opaque exception table.
● If you set both a bulk insert size and a batch commit size, the Data Merger activity inserts data in thefollowing ways:
— If all the data in a bulk is processed successfully, the Data Merger activity inserts all the data inthe bulk in the destination table.
— If all the data in a bulk is not processed successfully, the Data Merger activity inserts all thedata, including the error data, in the bulk in either the exception table or opaque exceptiontable.
Bulk Insert Error Handling and Applicable RestrictionsYou can insert records in a bulk in the destination table. The bulk insert error handling feature is usedto improve data accuracy and processing efficiency. It also prevents failure during bulk insertoperation.
The bulk insert error handling feature restrictions are as follows:
● This feature applies to the Data Merger activity only.
● It can be implemented only when the java.sql.BatchUpdateException error occurs.
● It supports the Oracle and MSSQL databases only.
● It cannot be used with schemas having a parent-child relationship.
For example, a job attempts to perform a bulk insert of 500 rows to the destination table. If the first 300rows are inserted successfully but the last 200 rows are not, the job inserts the successful 300 rows to thedestination table and the unsuccessful 200 rows to the exception table.
If the bulk insert error handling feature is not enabled and an error occurs, the job inserts all rows (bothcorrect and incorrect) in the exception table when the Data Merger activity performs the bulk insertoperation.
How Records are Handled by the Bulk Insert Error Handling Feature
The following example explains the workflow of bulk insert error handling.
Consider that the plug-in attempts to execute a bulk insert operation that contains the followingrecords. M1, M3, and M4 are correct records. M2 and M5 are incorrect records.
When the Handle Bulk Insert Error check box on the Advanced tab of the Data Merger activity isselected, the following process shows how bulk insert error handling is performed:
1. When the bulk commit size limit is reached, the plug-in starts to commit this bulk insert into thedatabase.
2. When an error occurs while inserting the incorrect record (M2), bulk insert error handling insertsthis record in the exception table.
3. Then the plug-in handles the remaining records, and when an error occurs while inserting theincorrect record (M5), bulk insert error handling inserts this record in the exception table.
4. After the bulk insert operation is complete, you can see all correct records (M1, M3, and M5) are inthe destination table and the incorrect records (M2 and M5) are in the exception table.
If a plug-in instance contains multiple Data Merger activities, each activity handles exception logicbased on its configuration. Therefore, the exception logic of each Data Merger activity might bedifferent.
72
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Upsert Operation on Parent-Child TablesWhen an upsert operation is performed on parent-child tables by using the Data Merger activity, theupsert operation behaves differently in different scenarios.
Consider that the Data Merger schema has parent-child tables and the upsert operation is performed onthese tables. The following table summarizes the different scenarios and the results:
Upsert Operation Behavior
Parent Table Child Tables Result
Scenario 1
ADB_OPCODE=2 for a record
Record exists
ADB_OPCODE isblank for allrecords
Records do notexist
The record in parent table is updated correctly; the sameoperation (update) is performed on child records.
Non-existing records in child tables are not inserted in thechild tables.
Scenario 2
ADB_OPCODE=2 for a record
Record does notexist
ADB_OPCODE isblank for allrecords
Records exist
The parent record is inserted in the parent table correctly;the same operation (insert) is performed on child records.
“Duplicate records error" occurs when you try to insertexisting records in the child tables.
Scenario 3
ADB_OPCODE=2 for a record
Record exists
ADB_OPCODE=1for all records
Records do notexist
The record in parent table is updated correctly andrecords are inserted in the child tables correctly.
Scenario 4
ADB_OPCODE=2 for a record
Record does notexist
ADB_OPCODE=2for all records
Records exist
The record is inserted in the parent table correctly and thechild records are updated in child tables correctly.
When working with parent-child tables, the value of ADB_OPCODE in the parent table and the childtable must be the same. Or you must set the value of ADB_OPCODE only in the parent table and leavethe child table empty.
Entity Naming ConventionsMost of the ActiveMatrix BusinessWorks named entities are modeled as NCNames (or as a subset of anNCName). These include activity names and schema names.
NCName stands for XML non-colonized name. For the W3C definition for NCName, see https://www.w3.org/TR/xmlschema-2/#NCName. NCNames conform to the following restrictions:
● Include any or all of the following valid characters: A-Z, a-z, numbers 0-9, hyphen (-), underscore(_).
73
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
● Do not include the following characters: at (@), colon (:), dollar ($), percent (%), ampersand (&),slash (/), plus (+), comma (,), semicolon (;) , parentheses (()), and white space characters.
● Do not begin with a number, dot (.), or hyphen (-). However, these characters can appear in anNCName.
Configuring Sybase Database by Using Custom JDBC DriverYou can configure Sybase Database by using the custom JDBC driver.
Procedure
1. In TIBCO Business Studio™, go to Windows and click Preferences.
2. Select the option Allow use of custom driver under BusinessWorks > Palettes > JDBC, click Apply,and then click OK.
Setting Custom Driver
3. Create a new JDBC connection resource and select custom.jdbc.driver from the Database Driver list.Enter the Driver details and user credentials in the project that you have created.
74
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Driver Details and User Credentials
4. Click Test Connection. A pop-up window is displayed.
Test Connection Pop-up
5. Click OK. A new Plug-in Project with a prepopulated project name is displayed. Click Next.
75
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Plug-in Details
6. Click Finish. A custom project is created in the workspace named ascom.tibco.custom.driver.project.name with compilation errors.
Errors
7. Go to JDBC connection resource and click Test Connection again. A connection is establishedsuccessfully.
76
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
JDBC Connection
After the connection is established successfully, delete the custom plug-in project"com.tibco.custom.driver.project.name" from the workspace that was created earlier and run theactivity. The activity runs successfully.
If the custom project is not present in the workspace and if you click again on the TestConnection button in the JDBC Connection shared resource, then every time the customproject is created in the workspace as mentioned in the steps in this section. You have todelete the same custom project before running the activity.
77
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Managing Logs
Logs are used to trace and troubleshoot the plug-in exceptions.
When an error occurs, you can check the logs to trace and troubleshoot the plug-in exception. Bydefault, error logs are displayed in the Console view when you run a process in the debug mode. Youcan change the log level of the plug-in to trace different messages and export logs to a file. Different loglevels correspond to different messages, as described in Log Levels
A logback.xml file is located in the TIBCO_HOME\bw\<version>\config\design\logback directory.Update this file to set up a log file and export logs to a file.
Log Levels
Different log levels include different information. The plug-in supports the following log levels:
LogLevel Description
Debug Indicates a developer-defined tracing message.
Info Indicates normal plug-in operations. No action is required. A tracing message tagged withInfo indicates that a significant processing step is reached, and logged for tracking orauditing purposes. Only Info messages preceding a tracking identifier are considered assignificant steps.
Error Indicates that an unrecoverable error occurred. Depending on the severity of the error, theplug-in might continue with the next operation or might stop.
Warn Indicates that an abnormal condition occurred. Processing continues, but special attentionfrom an administrator is recommended.
Trace Includes all information regarding the running process.
Setting Up Log LevelsYou can configure different log levels for the plug-in and plug-in activities to trace different messages.By default, the plug-in uses the log level configured for TIBCO ActiveMatrix BusinessWorks. Thedefault log level of TIBCO ActiveMatrix BusinessWorks is Error.
If neither the plug-in log nor the BusinessWorks log is configured in the logback.xml file, the errorlogs of the plug-in are displayed in the Console view by default. If the plug-in log is not configured, butthe BusinessWorks log is configured in the logback.xml file, the configuration for the BusinessWorkslog is implemented by the plug-in.
Procedure
1. Navigate to the TIBCO_HOME\bw\<version>\config\design\logback directory and open thelogback.xml file.
2. Add the following node in the Console Appender area to specify the log level for the plug-in:<logger name="com.tibco.bw.palette.adbplugin.runtime"> <level value="DEBUG"/></logger>
The level tag defines the log level and the value of the level element can be Trace, Info, Error orDebug.
78
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
When the level is set to Debug, the input and output for the plug-in activities are alsodisplayed in the Console view.
3. Optional: Add the following node in Console Appender area to specify the log level for an activity:<logger name="com.tibco.bw.palette.adbplugin.runtime.ActivityNameActivity"> <level value="DEBUG"/></logger>
See the following examples:
● To set the log level of the Data Event Poller activity to Debug, you must add the following node:<logger name="com.tibco.bw.palette.adbplugin.runtime.datapoller.ADBEventSource"> <level value="DEBUG"/></logger>
● To set the log level of the Data Merger activity to Debug, you must add the following node:<loggername="com.tibco.bw.palette.adbplugin.runtime.datamerger.DataMergerActivity"> <level value="DEBUG"/></logger>
● To set the log level of the Data Requester activity to the Debug options, you must add thefollowing node:<logger name="com.tibco.bw.palette.adbplugin.runtime.datarequester.DataRequesterActivity"> <level value="DEBUG"/></logger>
● To set the log level of the ADB Configuration shared resource to Debug, you must add thefollowing node:<logger name="com.tibco.bw.sharedresource.adbplugin.runtime"> <level value="DEBUG"/></logger>
For the activities that do not configure with specific log levels, they still inherit log levelconfigured for the plug-in or BusinessWorks.
4. Save the file.
Exporting Logs to a FileModify the logback.xml file to export plug-in logs to a file.
Procedure
1. Navigate to the TIBCO_HOME\bw\<version>\config\design\logback directory and open thelogback.xml file.
When deploying an application in TIBCO Enterprise Administrator, you must navigate tothe TIBCO_HOME\bw\domains\defaultdomain\appnodes\defaultappspace\defaultappnode directory to find the logback.xml file.
2. Add the following node to specify the file location:<appender name="FILE" class="ch.qos.logback.core.FileAppender"> <file>c:/bw6-adbplugin.log</file> <encoder> <pattern>%d{HH:mm:ss.SSS} [%thread] %-5level %logger{36}-%msg%n</pattern> </encoder></appender>
The file tag defines the location to which the log is exported and the value is the absolute path ofthe file that is detailed to the file name.
79
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
3. Add the following node to the root node at the bottom of the logback.xml file to enable exportingthe logs to a file:<root level="DEBUG"> <appender-ref ref="STDOUT" /> <appender-ref ref="FILE" /></root>
4. Save the file.
80
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Error Codes
The following table lists error codes, detailed explanation of each error, and ways to resolve errors(wherever applicable).
Error Code and ErrorMessage Role Category Description Resolution
TIBCO-BW-PALETTE-ADBPLUGIN-100001.
The number of
records per event is
{0}.
Trace BW-Plugin Number of recordsper event is 0.
This is a tracemessage andresolution is notapplicable
TIBCO-BW-PALETTE-ADBPLUGIN-100002.
DataEventPoller
schema {0} bind
fault status updater.
Trace BW-Plugin Set parameter valuesfor updatingADB_L_DELIVERY_STATUS in publishingtable from S to F.
This is a tracemessage andresolution is notapplicable
TIBCO-BW-PALETTE-ADBPLUGIN-100003.
DataEventPoller
Schema {0} execute
fault status updater
{1}.
Trace BW-Plugin Execute update ofADB_L_DELIVERY_STATUS in publishingtable from S to F.
This is a tracemessage andresolution is notapplicable
TIBCO-BW-PALETTE-ADBPLUGIN-100004.
DataEventPoller
Schema {0} No record
found.
Trace BW-Plugin Polling is in progressand no data is foundin parent or child tablefor publishing
This is a tracemessage andresolution is notapplicable
TIBCO-BW-PALETTE-ADBPLUGIN-100005.
DataEventPoller
Schema {0} execute
pub table updater
{1}.
Trace BW-Plugin SQL query used forupdating publishingtable.
This is a tracemessage andresolution is notapplicable
TIBCO-BW-PALETTE-ADBPLUGIN-100006.
DataEventPoller
Schema {0} batch
update {1}.
Trace BW-Plugin Number of recordsupdated during batchprocessing.
This is a tracemessage andresolution is notapplicable
81
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Error Code and ErrorMessage Role Category Description Resolution
TIBCO-BW-PALETTE-ADBPLUGIN-100007.
DataEventPoller
Schema {0} release
multi-threading
semaphore after
marking records.
Trace BW-Plugin Release the publishingtable semaphore toallow other threadspoll the publishingtable
This is a tracemessage andresolution is notapplicable
TIBCO-BW-PALETTE-ADBPLUGIN-100008.
DataEventPoller
Schema {0} release
table {1} lock in
load balance mode.
Trace BW-Plugin Release the table lockin load balance mode.
This is a tracemessage andresolution is notapplicable
TIBCO-BW-PALETTE-ADBPLUGIN-100009.
DataEventPoller
Schema {0} execute
publishing table
selector {1}.
Trace BW-Plugin Select columns frompublishing table withADB_L_DELIVERY_STATUS = 'N'
This is a tracemessage andresolution is notapplicable
TIBCO-BW-PALETTE-ADBPLUGIN-100010
DataEventPoller
Schema {0} builds
publishing table
selector.
Trace BW-Plugin Build select statementfor fetching data frompublishing table.
This is a tracemessage andresolution is notapplicable
TIBCO-BW-PALETTE-ADBPLUGIN-100011
DataEventPoller
Schema {0} binds
publishing table
selector, polling
batch size is {1}.
Trace BW-Plugin Set parameter valuesfor the select query onpublishing table.
This is a tracemessage andresolution is notapplicable
TIBCO-BW-PALETTE-ADBPLUGIN-100012.
DataEventPoller
Schema {0} execute
publishing table max
sequence selector
{1}.
Trace BW-Plugin SelectMAX(ADB_SEQUENCE) from table whereADB_L_DELIVERY ='N'
This is a tracemessage andresolution is notapplicable
82
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Error Code and ErrorMessage Role Category Description Resolution
TIBCO-BW-PALETTE-ADBPLUGIN-100013.
DataEventPoller
Schema {0} builds
publishing table max
sequence selector.
Trace BW-Plugin Build select statementfor fetching maximumADB_SEQUENCEvalue
This is a tracemessage andresolution is notapplicable
TIBCO-BW-PALETTE-ADBPLUGIN-100014.
DataEventPoller
Schema {0} execute
publishing table
mini sequence
selector {1}.
Trace BW-Plugin SELECTMIN(ADB_SEQUENCE) from table whereADB_L_DELIVERY ='N'
This is a tracemessage andresolution is notapplicable
TIBCO-BW-PALETTE-ADBPLUGIN-100015.
DataEventPoller
Schema {0} builds
publishing table
mini sequence
selector.
Trace BW-Plugin Build select statementfor fetching minimumADB_SEQUENCEvalue
This is a tracemessage andresolution is notapplicable
TIBCO-BW-PALETTE-ADBPLUGIN-100016.
DataEventPoller
Schema {0} selects
record data from
reference object
table {1}.
Trace BW-Plugin SQL query for selectfrom reference objector source table
This is a tracemessage andresolution is notapplicable
TIBCO-BW-PALETTE-ADBPLUGIN-100017.
DataEventPoller
Schema {0} builds
pub table updater.
Trace BW-Plugin Build update queryfor publishing table
This is a tracemessage andresolution is notapplicable
TIBCO-BW-PALETTE-ADBPLUGIN-100018.
DataEventPoller
Schema {0} binds pub
table updater.
Trace BW-Plugin Set parameter valuesfor the update queryon publishing table.
This is a tracemessage andresolution is notapplicable
TIBCO-BW-PALETTE-ADBPLUGIN-100019.
DataEventPoller
Schema {0} build 'S'
to 'N' updater.
Trace BW-Plugin Build update queryfor publishing table tochangeADB_L_DELIVERY_STATUS from S to N.
This is a tracemessage andresolution is notapplicable
83
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Error Code and ErrorMessage Role Category Description Resolution
TIBCO-BW-PALETTE-ADBPLUGIN-100020.
DataEventPoller
Schema {0} bind 'S'
to 'N' updater.
Trace BW-Plugin Set parameter valuesfor updatingADB_L_DELIVERY_STATUS in publishingtable from S to N.
This is a tracemessage andresolution is notapplicable
TIBCO-BW-PALETTE-ADBPLUGIN-100021.
DataEventPoller
Schema {0} execute
'S' to 'N' updater
{1}.
Trace BW-Plugin Execute update ofADB_L_DELIVERY_STATUS in publishingtable from S to N.
This is a tracemessage andresolution is notapplicable
TIBCO-BW-PALETTE-ADBPLUGIN-100022.
DataEventPoller
Schema {0} Child
table {1} has no
data to publish.
Trace BW-Plugin Publish Child Data isenabled and there isno data to fetch fromchild table.
This is a tracemessage andresolution is notapplicable
TIBCO-BW-PALETTE-ADBPLUGIN-100023.
The mutex table {0}
already exists.
Trace BW-Plugin The mutex tablealready exists in theDB.
This is a tracemessage andresolution is notapplicable
TIBCO-BW-PALETTE-ADBPLUGIN-100024.
DataEventPoller
Schema {0} bind
reference object
selector.
Trace BW-Plugin Set parameter valuesfor selecting data fromreferred table.
This is a tracemessage andresolution is notapplicable
TIBCO-BW-PALETTE-ADBPLUGIN-100025.
DataEventPoller
Schema {0} selects
record data from
reference object
table.
Trace BW-Plugin Execute select onreferred table.
This is a tracemessage andresolution is notapplicable
TIBCO-BW-PALETTE-ADBPLUGIN-100026.
DataEventPoller
Schema {0} builds
reference object
selector.
Trace BW-Plugin Build select query forreferred table.
This is a tracemessage andresolution is notapplicable
84
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Error Code and ErrorMessage Role Category Description Resolution
TIBCO-BW-PALETTE-ADBPLUGIN-100027.
DataEventPoller
Schema {0}
constructs the
instance based on
the source table.
Trace BW-Plugin If referred table is notmentioned, updatepublishing table basedon the source table.
This is a tracemessage andresolution is notapplicable
TIBCO-BW-PALETTE-ADBPLUGIN-100029.
DataEventPoller
Schema {0} Start to
fetch data from
child table.
Trace BW-Plugin Publish Child Data isenabled and threadstarts to fetch datafrom child table.
This is a tracemessage andresolution is notapplicable
TIBCO-BW-PALETTE-ADBPLUGIN-100030.
DataEventPoller
Schema {0} Finish
fetching data from
child table.
Trace BW-Plugin Publish Child Data isenabled and threadcompleted fetchingdata from child table.
This is a tracemessage andresolution is notapplicable
TIBCO-BW-PALETTE-ADBPLUGIN-100031.
DataEventPoller
Schema {0} Fetch
child data from {1}.
Trace BW-Plugin Fetching data fromchild table.
This is a tracemessage andresolution is notapplicable
TIBCO-BW-PALETTE-ADBPLUGIN-100032.
DataEventPoller
Schema {0} execute
child selector {1}.
Trace BW-Plugin Select columns forpublishing from childtable.
This is a tracemessage andresolution is notapplicable
TIBCO-BW-PALETTE-ADBPLUGIN-100033.
DataEventPoller
Schema {0} build
child selector.
Trace BW-Plugin Build select query forfetching data fromchild table.
This is a tracemessage andresolution is notapplicable
TIBCO-BW-PALETTE-ADBPLUGIN-100034.
DataEventPoller
Schema {0} bind
child selector.
Trace BW-Plugin Set parameter valuesfor select query tofetch child data.
This is a tracemessage andresolution is notapplicable
85
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Error Code and ErrorMessage Role Category Description Resolution
TIBCO-BW-PALETTE-ADBPLUGIN-100035.
DataEventPoller
Schema {0} build
fault status
updater.
Trace BW-Plugin Build update query toupdate status to F
This is a tracemessage andresolution is notapplicable
TIBCO-BW-PALETTE-ADBPLUGIN-100036.
DataEventPoller
Schema {0} builds
ADB_L_DELIVERY_STATU
S N->S marker.
Trace BW-Plugin Build update queryfor Load Balancingmarker
This is a tracemessage andresolution is notapplicable
TIBCO-BW-PALETTE-ADBPLUGIN-100037.
DataEventPoller
Schema {0} builds
publishing table
selector whose
ADB_L_DELIVERY_STATU
S is S.
Trace BW-Plugin Select query for loadbalancing
This is a tracemessage andresolution is notapplicable
TIBCO-BW-PALETTE-ADBPLUGIN-100038.
DataEventPoller
Schema {0} binds
ADB_L_DELIVERY_STATU
S N -> S marker …
Trace BW-Plugin Sets parameter valuesfor the load balancingquery
This is a tracemessage andresolution is notapplicable
TIBCO-BW-PALETTE-ADBPLUGIN-100039.
DataEventPoller
Schema {0} acquire
table {1} lock in
load balance mode.
Trace BW-Plugin DataEventPollerSchema acquiring lockon a table in the loadbalancing mode.
This is a tracemessage andresolution is notapplicable
TIBCO-BW-PALETTE-ADBPLUGIN-100040.
DataEventPoller
Schema {0} execute
ADB_L_DELIVERY_STATU
S N -> S marker ...
{1}
Trace BW-Plugin Executes the query inload balancing mode.
This is a tracemessage andresolution is notapplicable
86
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Error Code and ErrorMessage Role Category Description Resolution
TIBCO-BW-PALETTE-ADBPLUGIN-100041.
Creating the mutex
table {0}.
Trace BW-Plugin Creates table in DBlock initialization forload balancing mode.
This is a tracemessage andresolution is notapplicable
TIBCO-BW-PALETTE-ADBPLUGIN-100042.
DataEventPoller
Schema {0} selects
record data from
source table.
Trace BW-Plugin If referred table is notmentioned, selectsdata from the sourcetable.
This is a tracemessage andresolution is notapplicable
TIBCO-BW-PALETTE-ADBPLUGIN-100043.
Mutex table {0} is
already locked by
other node.
Trace BW-Plugin Table is already lockedby another node.
This is a tracemessage andresolution is notapplicable
TIBCO-BW-PALETTE-ADBPLUGIN-100044.
DataEventPoller
Schema {0} failed to
construct result
based on source
table because no
data fetched from
{1}.
Trace BW-Plugin Object constructionfailed when no datafound in source table.
This is a tracemessage andresolution is notapplicable
TIBCO-BW-PALETTE-ADBPLUGIN-200001.
Activity {0}
generated output:
\n{1}.
Debug BW-Plugin Shows output of datapoller activity in XMLformat.
This is a debugmessage andresolution is notapplicable
TIBCO-BW-PALETTE-ADBPLUGIN-300001.
DataEventPoller
Schema {0} starts
polling message.
Info BW-Plugin Thread starts pollingpublishing table tofetch any changes.
This is a infomessage andresolution is notapplicable
TIBCO-BW-PALETTE-ADBPLUGIN-300002.{0}
Info BW-Plugin Shown if there is lossof connection orreconnection issuccessful.
This is a infomessage andresolution is notapplicable
87
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Error Code and ErrorMessage Role Category Description Resolution
TIBCO-BW-PALETTE-ADBPLUGIN-400001.
DataEventPoller
Schema {0} has
different reference
object in Shared
Resource and
Publishing Table. To
resolve this issue,
either fix the
shared resource or
re-generate the
trigger.
Warn BW-Plugin Schema has differentreference object inShared Resource andPublishing Table.
To resolve thisissue, either fix theshared resource orre-generate thetrigger.
TIBCO-BW-PALETTE-ADBPLUGIN-400002.
DataEventPoller
Schema {0} failed to
construct result
based on reference
object because no
data fetched from
{1}.
Warn BW-Plugin Object constructionfailed when no datafound in referencedtable.
This is a tracemessage andresolution is notapplicable
TIBCO-BW-PALETTE-ADBPLUGIN-500001.
DataEventPoller
Schema {0} throw
exception {1} when
update entry status.
Error BW-Plugin Thrown if issue occursin updating 'N' to 'C'in publishing tableduring transaction.SQLException isthrown.
Check errors listedin the errormessage, and takean appropriateaction.
TIBCO-BW-PALETTE-ADBPLUGIN-500002.
DataEventPoller
Schema {0} throw
exception {1} when
execute publishing
table selector.
Error BW-Plugin Thrown whenexecuteQuery fails forpublishing table andSQLException isthrown.
Check errors listedin the errormessage, and takean appropriateaction.
TIBCO-BW-PALETTE-ADBPLUGIN-500003.
DataEventPoller
Schema {0} throw
exception {1} when
build publishing
table selector.
Error BW-Plugin Thrown whenprepareStatement failsfor publishing tableand SQLException isthrown.
Check errors listedin the errormessage, and takean appropriateaction.
88
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Error Code and ErrorMessage Role Category Description Resolution
TIBCO-BW-PALETTE-ADBPLUGIN-500004.
DataEventPoller
Schema {0} throw
exception {1} when
bind publishing
table selector.
Error BW-Plugin Thrown when settingparameter fails forpublishing table andSQLException isthrown.
Check errors listedin the errormessage, and takean appropriateaction.
TIBCO-BW-PALETTE-ADBPLUGIN-500005.
DataEventPoller
Schema {0} throw
exception {1} when
execute the max
sequence selector.
Error BW-Plugin Thrown whenexecuteQuery fails formax sequence selectorand SQLException isthrown.
Check errors listedin the errormessage, and takean appropriateaction.
TIBCO-BW-PALETTE-ADBPLUGIN-500006.
DataEventPoller
Schema {0} throw
exception {1} when
build publishing
table max sequence
selector.
Error BW-Plugin Thrown whenprepareStatement failsfor max sequenceselector andSQLException isthrown.
Check errors listedin the errormessage, and takean appropriateaction.
TIBCO-BW-PALETTE-ADBPLUGIN-500007.
DataEventPoller
Schema {0} throw
exception {1} when
execute the mini
sequence selector.
Error BW-Plugin Thrown if there is noDataEventPoller table.
Check errors listedin the errormessage, and takean appropriateaction.
TIBCO-BW-PALETTE-ADBPLUGIN-500008.
DataEventPoller
Schema {0} throw
exception {1} when
build publishing
table mini sequence
selector.
Error BW-Plugin Thrown whenprepareStatement failsfor min sequenceselector andSQLException isthrown.
Check errors listedin the errormessage, and takean appropriateaction.
89
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Error Code and ErrorMessage Role Category Description Resolution
TIBCO-BW-PALETTE-ADBPLUGIN-500009.
DataEventPoller
Schema {0} throw
exception {1} when
get dbTable whose
name is
publishingTableName.
Error BW-Plugin Thrown if there iserror fetching datafrom publishing table.
Check errors listedin the errormessage, and takean appropriateaction.
TIBCO-BW-PALETTE-ADBPLUGIN-500010.
DataEventPoller
Schema {0} throw
exception {1} when
build pub table
updater.
Error BW-Plugin Thrown whenprepareStatement failswhile updatingpublishing table andSQLException isthrown.
Check errors listedin the errormessage, and takean appropriateaction.
TIBCO-BW-PALETTE-ADBPLUGIN-500011.
DataEventPoller
Schema {0} throw
exception {1} when
bind pub table
updater.
Error BW-Plugin Thrown when settingparameter fails whileupdating publishingtable andSQLException isthrown.
Check errors listedin the errormessage, and takean appropriateaction.
TIBCO-BW-PALETTE-ADBPLUGIN-500012.
DataEventPoller
Schema {0} throw
exception {1} when
manipulate S to N
status updater.
Error BW-Plugin Thrown whenupdating status fromS to N fails.
Check errors listedin the errormessage, and takean appropriateaction.
TIBCO-BW-PALETTE-ADBPLUGIN-500013.{0}
Error BW-Plugin Throws when ADBvalidation fails.
Check errors listedin the errormessage, and takean appropriateaction.
90
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Error Code and ErrorMessage Role Category Description Resolution
TIBCO-BW-PALETTE-ADBPLUGIN-500014.
{0}
Error BW-Plugin Thrown when ADBsql Exception Faultoccurs. Scenario 1:Columns in sharedresource andpublishing table arenot same. Createshared resource withtable T columnscol1,col1. In dataevent poller activity,apply triggers. Thepublishing table P_Tis generated. Nowalter the original tableT and add columncol3. Refind schema inshared resource andfetch columnscol1,col1,col3. Nowrun the process. Inserta new record in tableT.
Check errors listedin the errormessage, and takean appropriateaction.
TIBCO-BW-PALETTE-ADBPLUGIN-500015.
DataEventPoller
Schema {0} throw
exception {1} when
construct minstance
based on publishing
table.
Error BW-Plugin Error fetching row ofpublishing table.SQLException isthrown.
Check errors listedin the errormessage, and takean appropriateaction.
TIBCO-BW-PALETTE-ADBPLUGIN-500016.
DataEventPoller
Schema {0} throw
exception {1} when
fetch child data.
Error BW-Plugin Error fetching rows ofchild table.SQLException isthrown.
Check errors listedin the errormessage, and takean appropriateaction.
TIBCO-BW-PALETTE-ADBPLUGIN-500017.
DataEventPoller
Schema {0} throw
exception {1} when
build child
selector.
Error BW-Plugin Thrown whenprepareStatement failsfor building childselector.SQLException isthrown.
Check errors listedin the errormessage, and takean appropriateaction.
91
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Error Code and ErrorMessage Role Category Description Resolution
TIBCO-BW-PALETTE-ADBPLUGIN-500018.
DataEventPoller
Schema {0} throw
exception {1} when
bind child selector.
Error BW-Plugin Thrown when settingparameter fails whilebuilding the childquery. SQL Exceptionis thrown.
Check errors listedin the errormessage, and takean appropriateaction.
TIBCO-BW-PALETTE-ADBPLUGIN-500019.
DataEventPoller
Schema {0} throw
exception {1} when
build pub load
balancing marker.
Error BW-Plugin Thrown whenprepareStatement failswhile building theload balance updatequery. SQL Exceptionis thrown.
Check errors listedin the errormessage, and takean appropriateaction.
TIBCO-BW-PALETTE-ADBPLUGIN-500020.
DataEventPoller
Schema {0} throw
exception {1} when
build pub load
balancing pub table
selector.
Error BW-Plugin Thrown whenfetching the rowsfrom publishing tablefor load balancingselector. SQLException is thrown.
Check errors listedin the errormessage, and takean appropriateaction.
TIBCO-BW-PALETTE-ADBPLUGIN-500021.
DataEventPoller
Schema {0} throw
exception {1} when
bind pub load
balancing marker.
Error BW-Plugin Thrown when settingparameters fail whilebuilding loadbalancing query. SQLException is thrown.
Check errors listedin the errormessage, and takean appropriateaction.
TIBCO-BW-PALETTE-ADBPLUGIN-500022.
DataEventPoller
Schema {0} throw
exception {1} when
execute pub load
balancing marker.
Error BW-Plugin Thrown when updatequery fails for loadbalancing. SQLException is thrown.
Check errors listedin the errormessage, and takean appropriateaction.
TIBCO-BW-PALETTE-ADBPLUGIN-500023.
DataEventPoller
Schema {0} throw
exception {1} when
initialize the
DBLockMechanism.
Error BW-Plugin Initializing the DBLock Mechanism.
Check errors listedin the errormessage, and takean appropriateaction.
92
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Error Code and ErrorMessage Role Category Description Resolution
TIBCO-BW-PALETTE-ADBPLUGIN-500032
IOException occurredwhile retrieving XMLOutput.
Error BW-Plugin Displays error ifIOException occurredwhile retrieving XMLOutput
Check errors listedin the errormessage, and takean appropriateaction.
TIBCO-BW-PALETTE-ADBPLUGIN-500033
{0}
Error BW-Plugin Displays error if erroroccurs while readinginput data
Check errors listedin the errormessage, and takean appropriateaction.
TIBCO-BW-PALETTE-ADBPLUGIN-500034
{0}
Error BW-Plugin Displays error if erroroccurs whilevalidating input data
Check errors listedin the errormessage, and takean appropriateaction.
TIBCO-BW-SR-ADBPLUGIN-100001.
Logs related ot
Starting,
stopping,updating
shared resource.
Trace BW-Plugin When user starts,stops, or updatesshared resource.
This is a tracemessage andresolution is notapplicable
TIBCO-BW-SR-ADBPLUGIN-300001.
Adding new
configuration for
Shared Resource with
name [{0}]
Info BW-Plugin Logs when usercreates new sharedresource
This is a infomessage andresolution is notapplicable
TIBCO-BW-SR-ADBPLUGIN-300002.
Deleting
Configuration for
Shared Resource with
name[{0}]
Info BW-Plugin When user deletesconfiguration forshared resource
This is a infomessage andresolution is notapplicable
TIBCO-BW-SR-ADBPLUGIN-500001.
Error creating
shared resource {0}.
Exception:{1}
Error BW-Plugin If any error whilecreating sharedresource.
Check errors listedin the errormessage, and takean appropriateaction.
ADB_DATA_MERGER_EVENTS_MSG-100049{0}
Trace BW-Plugin Displays the messageon activity events suchas initialization.
This is a tracemessage andresolution is notapplicable.
93
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Error Code and ErrorMessage Role Category Description Resolution
ADB_DATA_MERGER_PARENT_TBALE_INVALID_OPCODE_MSG-100050
Data Merger Schema
{0} the parent table
opcode {1} is
invalid,so discard
the message.
Trace BW-Plugin Discards the messagewhen the parent tableopcode is invalid.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_MERGER_OPCODE_BYPASS_MSG-100051.
Data Merger Schema
{0} bypass one
message.
Trace BW-Plugin If opcode is 10,bypasses the message.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_MERGER_MSGBODY_MSG-100052.
Data Merger Schema
{0} Message body:
{1}.
Trace BW-Plugin Displays the messagebody of Data Mergerschema.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_MERGER_CHILD_INCREMENTAL_OPERATION_MSG-100053.
Data Merger Schema
{0} will do
incremental
operation for child
records.
Trace BW-Plugin If opcode exists,handles the child dataincrementally.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_MERGER_BEGIN_TRANSACTION_MSG-100055.
Data Merger Schema
{0} start DB
transaction.
Trace BW-Plugin Displayed in logswhen databasetransaction starts.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_MERGER_COMMIT_TRANSACTION_MSG-100056.
Data Merger Schema
{0} commit DB
transaction.
Trace BW-Plugin Displayed in logswhen databasetransaction iscommitted.
This is a tracemessage andresolution is notapplicable.
94
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Error Code and ErrorMessage Role Category Description Resolution
ADB_DATA_MERGER_EXECUTE_STMT_FAILED_MSG-100057.
Data Merger Schema
{0} throw exception
{1} when execute
statement {2}.
Trace BW-Plugin Throws exceptionwhen executestatement fails.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_MERGER_CHILD_TABLE_INVALID_OPCODE_MSG-100058.
Data Merger Schema
{0} the child table
opcode {1} is
invalid,so discard
the child table
message.
Trace BW-Plugin Discards the messagewhen the child tableopcode is invalid.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_MERGER_SINGLE_TABLE_INVALID_OPCODE_MSG-100059.
Data Merger Schema
{0} the single table
opcode {1} is
invalid,so discard
the single message.
Trace BW-Plugin Discards the messagewhen single tableopcode is invalid.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_MERGER_STATEMENT_IS_NULL_WHEN_EXECUTE_MSG-100060.
Data Merger Schema
{0} can't execute
the statement
because of the
statement is null.
Trace BW-Plugin Displayed whentrying to execute anull statement.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_MERGER_AFFECT_DATABASE_ROWS_MSG-100061.
Data Merger Schema
{0} {1} row(s)
affected.
Trace BW-Plugin When database row isaffected due tosuccessful statementexecution.
This is a tracemessage andresolution is notapplicable.
95
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Error Code and ErrorMessage Role Category Description Resolution
ADB_DATA_MERGER_ROLLBACK_REASON-100062.
Data Merger Schema
{0} will rollback
since {1}.
Trace BW-Plugin Rolls back if you setnot to use anyexception table.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_MERGER_HANDLE_EXCEPTION_MSG-100063.
Data Merger Schema
{0} handle [{1}] :
{2}
Trace BW-Plugin Handles the exceptionmessage based on theerror status.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_MERGER_ROLLBACK_TRANSACTION_MSG-100064.
Data Merger Schema
{0} roll back DB
transaction.
Trace BW-Plugin Rolls back thedatabase transactionwhen the record fails.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_MERGER_INSERT_EXCEPTION_INTO_EXCEPTION_TABLE_MSG-100065.
Data Merger Schema
{0} insert the data
{1} into exception
table {2}.
Trace BW-Plugin When record fails anddata is inserted in theexception table.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_MERGER_OPAQUE_TABLE_NOT_FOUND_MSG-100066.
Data Merger Schema
{0} the opaque
exception table is
not found.
Trace BW-Plugin When trying to insertrecord in opaqueexception table andtable is not found.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_MERGER_INSERT_MSG_INTO_OPAQUE_TABLE_MSG-100067.
Data Merger Schema
{0} insert the data
{1} into opaque
exception table {2}.
Trace BW-Plugin When record fails toinsert in target tableand exception table,tries to insert record inopaque exceptiontable.
This is a tracemessage andresolution is notapplicable.
96
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Error Code and ErrorMessage Role Category Description Resolution
ADB_DATA_MERGER_DELETE_CASCADE_DELETE_CHILD_DATA_MSG-100068.
Data Merger Schema
{0} delete related
child records. {1}
Trace BW-Plugin If opcode is 3, deleteschild data records.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_MERGER_DELETE_CASCADE_FETCH_CHILD_DATA_MSG-100069.
Data Merger Schema
{0} query related
child records.{1}
Trace BW-Plugin If opcode is 4, fetcheschild data records.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_MERGER_CREATE_STMT_FAILED_MSG-100070.
Data Merger Schema
{0} throw exception
{1} when create
statement for Data
{2}.
Trace BW-Plugin When createstatement andinitialize parametersfail.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_MERGER_REUSE_DBSTMT_FAILED_MSG-100071.
Data Merger Schema
{0} the statement in
cache can't be
reused {1}.
Trace BW-Plugin If statement parameterlist is not equal tocolumn name, reusedatabase statementfails.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_MERGER_SET_STMT_TO_STORE_MSG-100072.
Data Merger Schema
{0} cache statement
{1} for table {2}.
Trace BW-Plugin When fails to setstatement in store.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_MERGER_ERROR_BIND_STATEMENT_IS_NULL_MSG-100073.
Data Merger Schema
{0} can't bind the
statement because of
the statement is
null.
Trace BW-Plugin Fails to bind statementwhen statement isnull.
This is a tracemessage andresolution is notapplicable.
97
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Error Code and ErrorMessage Role Category Description Resolution
ADB_DATA_MERGER_STMT_BIND_PARAM_FAILED_MSG-100074.
Data Merger Schema
{0} throw exception
{1} when bind
parameter to
statement {2}.
Trace BW-Plugin Fails when not able tobind parameters to thestatement.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_MERGER_PRE_COMMIT_SUCCESSFUL_MSG-100075.
Data Merger Schema
{0} call pre-commit
procedure
successfully.
Trace BW-Plugin Successfully calls pre-commit storedprocedure.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_MERGER_PRE_COMMIT_UNSUCCESSFUL_MSG-100076.
Data Merger Schema
{0} call pre-commit
procedure
unsuccessfully.
Trace BW-Plugin Not able to call pre-commit storedprocedure.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_MERGER_ERROR_PRECOMMIT_OUTPUT_PARAMTER_SPTEXT-100077.
Data Merger Schema
{0} the pre-commit
procedure output
parameter SP_TEXT is
{1}.
Trace BW-Plugin If pre-commitprocedure outputparameter SP_TEXT isnull or blank.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_MERGER_PRINT_PRE_COMMIT_PROCEDURE_RESULT-100078.
Data Merger Schema
{0} result of pre-
commit stored
procedure {1} is
\n{2}\n\t.
Trace BW-Plugin Prints result of pre-commit storedprocedure along withservice name and pre-commit storedprocedure name.
This is a tracemessage andresolution is notapplicable.
98
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Error Code and ErrorMessage Role Category Description Resolution
ADB_DATA_MERGER_START_HANDLE_NORMAL_EXCEPTION-100079.
Data Merger Schema
{0} start handle
normal exception.
Trace BW-Plugin Handles normalexception.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_MERGER_CREATE_STMT_FAILED-100080.
Data Merger Schema
{0} throw exception
\n\t\u0020{1}\n\t
\u0020 when create
statement for Data
\n\t\u0020{2}\n\t.
Trace BW-Plugin Fails to createstatement andinitialize parameters.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_MERGER_STMT_BIND_PARAM_FAILED-100081.
Data Merger Schema
{0} throw exception
\n{1}\n when bind
parameter to
statement \n\t
\u0020{2}\n\t.
Trace BW-Plugin Fails to bindparameters to thestatement.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_MERGER_RECEIVE_GROUPMSG-100082.
Data Merger Schema
{0} receive a group
message which
contain {1}
record(s). \n\t.
Trace BW-Plugin Receives groupmessage whichcontains n records.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_MERGER_START_TO_HANDLE_ONE_MSG_ITEM-100084.
Data Merger Schema
{0} start to handle
the {1} item for the
group message. \n\t
Trace BW-Plugin Starts to handle eachitem one at a time forgroup message.
This is a tracemessage andresolution is notapplicable.
99
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Error Code and ErrorMessage Role Category Description Resolution
ADB_DATA_MERGER_FLUSH_BULK_INSERT-100085.
Data Merger Schema
{0} flush Bulk-
Insert.\n\t.
Trace BW-Plugin Flushes bulk-Insert ifbulk insert statementis not null.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_MERGER_AFFECT_DATABASE_ROWS-100086.
Data Merger Schema
{0} {1} row(s)
affected.\n\t.
Trace BW-Plugin When database row isaffected due tosuccessful statementexecution.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_MERGER_EXECUTE_STATEMENT_SUCCESSFUL_COUNT-100087.
Data Merger Schema
{0} execute database
statement successful
count is {1}\n\t.
Trace BW-Plugin Displays count ofstatements executedsuccessfully on thedatabase.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_MERGER_NO_DATA_CHANGE_IN_DATABASE-100088.
Data Merger Schema
{0} no data change
in the database.\n
\t.
Trace BW-Plugin No change in databaseif count of statementsexecuted successfullyon the database is 0.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_MERGER_RECEIVE_SINGLEMSG-100089.
Data Merger Schema
{0} receive a single
message.\n\t.
Trace BW-Plugin Data Merger schemareceives a singlemessage.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_MERGER_HANDLE_EXCEPTION_ROLLBACK_DATA-100090.
Data Merger Schema
{0} prepare roll
back the exception
data \n\t.
Trace BW-Plugin Perform roll backoperation if there isany exception inprocessing the data.
This is a tracemessage andresolution is notapplicable.
100
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Error Code and ErrorMessage Role Category Description Resolution
ADB_DATA_MERGER_HANDLE_EXPTION_START-100091 DataMerger Schema {0}
cache data size {1},
start handle
exception\n {2} \n
\t.
Trace BW-Plugin Starts handling thesubcache exception.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_MERGER_HANDLE_EXPCEPTION_DATA_COUNT-100092.
Data Merger Schema
{0} exception cache
data size is {1},
executed successful
data size is {2} \n
\t.
Trace BW-Plugin Handles subcacheexception data count.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_MERGER_HANDLE_EXCEPTION_DATA_POSITION-100093.
Data Merger Schema
{0} handle exception
data {1} of {2} \n
\t.
Trace BW-Plugin Add all the messagesin the errorList to theexception table or theopaque exceptiontable.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_MERGER_HANDLE_NORMAL_EXCEPTION-100094.
Data Merger Schema
{0} finish handle
normal exception\n
\t.
Trace BW-Plugin Finishes handlingnormal exception.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_MERGER_BULKINSERT_CONFIRMING_MESSAGE_SUCCESS-100097.
Data Merger Schema
{0} Confirming {1}
message(s)
Successfully
Trace BW-Plugin Confirms count ofbatch commit datamessages successfully.
This is a tracemessage andresolution is notapplicable.
101
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Error Code and ErrorMessage Role Category Description Resolution
ADB_DATA_MERGER_PRINT_STMT_BOUNDS-100098.
Data Merger Schema
{0} statement
bounds:{1}
Trace BW-Plugin Displays messagewhen batch executionhappens in bulkinsert.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_MERGER_STATEMENT_IS_NULL_WHEN_EXECUTE-100099.
Data Merger Schema
{0} can't execute
the statement
because of the
statement is null
Trace BW-Plugin If the statement isnull, cannot executethe statement.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_MERGER_HANDLE_NEED_EXECUTE_DATA-100100.
Data Merger Schema
{0} handle {1} of
{2} need execute
data
Trace BW-Plugin Displays which data isbeing executed forbulk insert handling.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_MERGER_HANDLE_ERROR_DATA-100101.
Data Merger Schema
{0} handle {1} of
{2} error data.
Trace BW-Plugin Displays which data isbeing handled forbulk insert errorhandling.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_MERGER_NOT_CONFIRMING_MESSAGE-100102.
Data Merger Schema
{0} didn't confirm
error message "{1}",
since this error
message can't be
inserted into
exception/opaque
table.
Trace BW-Plugin When error messagecannot be insertedinto exception table oropaque exceptiontable.
This is a tracemessage andresolution is notapplicable.
102
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Error Code and ErrorMessage Role Category Description Resolution
ADB_DATA_MERGER_HANDLE_CONTINUE_DATA-100103.
Data Merger Schema
{0} handle {1} of
{2} continue
operation data.
Trace BW-Plugin Displays which data isbeing processedfurther for bulk inserterror handling.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_MERGER_FINISH_BULK_INSERT_ERROR_EXCEPTION-100104.
Data Merger Schema
{0} finish handle
bulk insert error
exception.
Trace BW-Plugin When finish handlingbulk insert errorexception.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_MERGER_HANDLE_CONTINUE_HANDLE_DATA-100105.
Data Merger Schema
{0} continue handle
bulk insert data.
Trace BW-Plugin Continue handle bulkinsert data whileprocessing bulk insertdata error handling.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_MERGER_HANDLE_BULK_INSERT_ERROR_EXCEPTION-100106.
Data Merger Schema
{0} start handle
bulk insert error
exception.
Trace BW-Plugin Starts handling bulkinsert errorexceptions.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_MERGER_HANDLE_EXCEPTION_EXECUTE_UPDATE_COUNT-100107.
Data Merger Schema
{0} execute update
count result {1}.
Trace BW-Plugin Displays logs whenupdate count result isexecuted.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_REQUESTER_EVENTS_MSG-100112
{0}.
Trace BW-Plugin Displays the messageon activity events suchas initialization.
This is a tracemessage andresolution is notapplicable.
103
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Error Code and ErrorMessage Role Category Description Resolution
ADB_DATA_REQUESTER_BEGIN_TRANSACTION-100113
\n\t\u0020DataRequester Schema {0}begin transaction.\n\t
Trace BW-Plugin Displays the messagewhen a transactionstarts.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_REQUESTER_BEGIN_TRANSACTION_FAILED-100114
\n\t\u0020 DataRequester Schema {0}throw exception \n{1}\nwhen begin transaction.\n\t
Trace BW-Plugin Displays the messagewhen the transactionfails to start.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_REQUESTER_COMMIT_TRANSACTION_FAILED-100115
\n\t\u0020 DataRequester Schema {0}throw exception \n{1}\nwhen committransaction.\n\t
Trace BW-Plugin Displays the messagewhen the committransaction fails.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_REQUESTER_COMMIT_TRANSACTION-100116
\n\t\u0020 DataRequester Schema {0}commit transaction.\n\t
Trace BW-Plugin Displays the messageafter a transaction iscommitted.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_REQUESTER_ROLL_BACK_TRANSACTION-100117
\n\t\u0020 DataRequester Schema {0}roll back transaction.\n\t
Trace BW-Plugin Displays the messageon rolling back atransaction.
This is a tracemessage andresolution is notapplicable.
104
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Error Code and ErrorMessage Role Category Description Resolution
ADB_DATA_REQUESTER_ROLL_BACK_TRANSACTION_FAILED-100118
\n\t\u0020 DataRequester Schema {0}throw exception \n\t\u0020{1}\n\t\u0020when roll backtransaction.\n\t
Trace BW-Plugin Displays the messagewhen rollbacktransaction fails.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_REQUESTER_CONFIRMING_MESSAGE_SUCCESS-100119
\n\t\u0020 DataRequester Schema {0}Confirming messageSuccess.\n\t
Trace BW-Plugin Displays the messageon successful messageconfirmation.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_REQUESTER_CREATE_STMT-100120
\n\t\u0020 DataRequester Schema {0}create statement.\n\t
Trace BW-Plugin Displays the messagewhen creating astatement.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_REQUESTER_STMT_CACHE_DISPLAY-100121
\n\t\u0020 DataRequester Schema {0}Statement Cached:\n\t\t{1}\n\t
Trace BW-Plugin Displays the cachedstatement.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_REQUESTER_CREATE_STMT_FAILED-100122
\n\t\u0020 DataRequester Schema {0}throw exception:\n\t\u0020\u0020\u0020-\u0020{1}\n\t\u0020when create DBStatement for Data:\n\t\u0020\u0020\u0020-\u0020{2}\n\t
Trace BW-Plugin Displays the messagewhen the createstatement fails.
This is a tracemessage andresolution is notapplicable.
105
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Error Code and ErrorMessage Role Category Description Resolution
ADB_DATA_REQUESTER_EXECUTE_STMT_FAILED-100123
\n\t\u0020 DataRequester Schema {0}throw exception \n\t\u0020{1}\t\u0020whenexecute DB Statement \n\t\u0020{2}\n\t
Trace BW-Plugin Displays the messagewhen a statementexecution fails.
This is a tracemessage andresolution is notapplicable.
ADB_EXCEPTION_DISPLAY_MESSAGE-200003.
Exception :{0}
Debug BW-Plugin Displays the exceptionmessage.
This is a debugmessage andresolution is notapplicable.
ADB_DATA_MERGER_VALIDATION_ERROR-500027.
{0}
Error BW-Plugin Validates the DataMerger with SharedResource and JDBCConnection
Check errors listedin the errormessage, and takean appropriateaction.
ADB_DATA_MERGER_INPUT_ERROR-500028.
{0}
Error BW-Plugin Displays error if erroroccurs while readinginput data.
Check errors listedin the errormessage, and takean appropriateaction.
ADB_DATA_MERGER_UNKNOWN_ERROR-500029.
Activity {0} failed
due to unknown error
in the process {1}.
Error BW-Plugin Fails due to unknownerror in the process.
Check errors listedin the errormessage, and takean appropriateaction.
ADB_DATA_MERGER_BEGIN_TRANSACTION_FAILED_MSG-500030.
Data Merger Schema
{0} throw exception
{1} when begin
transaction.
Error BW-Plugin Throws error whenfails to begintransaction.
Check errors listedin the errormessage, and takean appropriateaction.
106
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide
Error Code and ErrorMessage Role Category Description Resolution
ADB_DATA_MERGER_ROLLBACK_TRANSACTION_FAILED_MSG-500031.
Data Merger Schema
{0} throw exception
{1} when roll back
transaction.
Error BW-Plugin Throws error whenfails to roll back thetransaction.
Check errors listedin the errormessage, and takean appropriateaction.
EXCEPTION_OCCURED_RETRIEVE_RESULT-500032.
IOException occurred
while retrieving XML
Output.
Error BW-Plugin Throws error whenIOException occurswhile retrieving XMLoutput.
Check errors listedin the errormessage, and takean appropriateaction.
ADB_DATA_MERGER_PRINT_STMT_SQL-100108
Data Merger Schema
{0} statement SQL:
\n\t
\u0020\u0020\u0020-
\u0020{1}\n\t
Trace BW-Plugin Displays the SQLstatement.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_MERGER_CREATE_STMT - 100109
Data Merger Schema
{0} create
statement.\n\t
Trace BW-Plugin When the SQLstatement is created.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_MERGER_BIND_STMT - 100110
Data Merger Schema
{0} bind statement.
\n\t
Trace BW-Plugin When the SQLstatement is binding.
This is a tracemessage andresolution is notapplicable.
ADB_DATA_MERGER_EXECUTE_STMT -100111
Data Merger Schema
{0} execute
statement.\n\t
Trace BW-Plugin When the SQLstatement is executed.
This is a tracemessage andresolution is notapplicable.
107
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database User's Guide