Products | Versions |
---|---|
TIBCO ActiveMatrix BusinessWorks | - |
Not Applicable | - |
Resolution:
Description:
============
I am able to select a value for the Catalog/Package field. But at run time the following error is reported:
BW-JDBC-100014 Job-1000 Error in [Process Definition.process/JDBC Call Procedure]
"JDBC error reported: (SQLState = HY000) - java.sql.SQLException: [tibcosoftwareinc][DB2 JDBC Driver][DB2]The Specified library "<schema>.<Catalog/package>.<procedure>" could not be loaded."
caused by: java.sql.SQLException: [tibcosoftwareinc][DB2 JDBC Driver][DB2]The Specified library "<schema>.<Catalog/package>.<procedure>" could not be loaded.
Environment
===========
All platforms
All BW versions
[SME-Comments] My recommendation for the Scope for the KB Article : Customer
Resolution:
==========
A DB2 stored procedure is qualified by <schema name>.<procedure name>. That is, the fully qualified procedure name does not have a catalog or package name. To resolve the error, you need to set the Catalog/Package field to blank.