"XXX IS AN UNDEFINED NAME" happens while using TIBCO ActiveMatrix BusinessWorks Plug-in for Database

"XXX IS AN UNDEFINED NAME" happens while using TIBCO ActiveMatrix BusinessWorks Plug-in for Database

book

Article ID: KB0076366

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks Plug-in for Database 8.x

Description

"[tibcosoftwareinc][DB2 JDBC Driver][DB2]XXX IS AN UNDEFINED NAME" (XXX is the collection name) happens while using TIBCO ActiveMatrix BusinessWorks Plug-in for Database 8.x.
The issue usually happened while executing Generate Trigger option in DBPoller. 
This error means DB2 Server on AS/400 is missing the XXX collection or XXX collection is not granted to the connecting UserID or public.
 

 
 
 

Environment

Product: TIBCO ActiveMatrix BusinessWorks Plug-in for Database Version: 8.x OS: All Supported Operating Systems

Resolution

Please contact the DBA team to confirm the name of the collection and the privilege of the connecting user.
 
 
 

Issue/Introduction

"XXX IS AN UNDEFINED NAME" happens while using TIBCO ActiveMatrix BusinessWorks Plug-in for Database

Additional Information

Refer to below document from IBM:
https://www-01.ibm.com/support/docview.wss?uid=swg2169691