IT14782: EXTERNAL ESQL VARIABLE DECLARED AT SCHEMA LEVEL NOT RESOLVED AT RUNTIME

APAR status

• Closed as program error.

Error description

• After applying Fix Pack 4 for IBM Integration Bus V10, ESQL
  variables declared as EXTERNAL (User Defined Properties [UDP])
  at the ESQL SCHEMA level may not be resolved correctly at
  runtime.
  
  For example, assume an external namespace variable is declared
  at the schema level:
  
  DECLARE ns EXTERNAL NAMESPACE 'http://www.ibm.com/mynamespace1';
  
  When the 'ns' variable is resolved in an ESQL statement such as
  
  IF InputRoot.XMLNSC.ns:message.data1 IS NOT NULL THEN...
  ELSE... END IF;
  
  the following BIP2328E exception may be seen:
  
  BIP2328E: A value of SQL datatype 'NULL' encountered when
  datatype 'CHARACTER' expected.
  

Local fix

• Either:
  * Remove the EXTERNAL option from the declaration
  * Move the declaration to the module level
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  All users of WebSphere Message Broker V8.0 and IBM Integration
  Bus v9.0 and V10.0 using ESQL UDP variables.
  
  
  Platforms affected:
  z/OS, MultiPlatform
  
  ****************************************************************
  PROBLEM DESCRIPTION:
  ESQL variables declared as EXTERNAL (User Defined Properties, or
  UDPs) at the ESQL SCHEMA level, that are used to denote a
  namespace, may not be resolved correctly at runtime. The
  following BIP2328E exception may be seen:
  
  BIP2328E: A value of SQL datatype 'NULL' encountered when
  datatype 'CHARACTER' expected.
  
  The values for the schema external variables (UDPs) are
  maintained in lists indexed by schema. The wrong index value is
  being used during a look up.
  
  
  There are a number of resource name changes between WebSphere
  Message Broker and IBM Integration Bus Version 9.0.  For details
  visit
  http://pic.dhe.ibm.com/infocenter/wmbhelp/v9r0m0/topic/com.ibm.e
  tools.mft.doc/bb23814_.htm
  

Problem conclusion

• The product now resolves the external variables (UDPs) using the
  correct schema index.
  
  ---------------------------------------------------------------
  The fix is targeted for delivery in the following PTFs:
  
  Version    Maintenance Level
  v8.0       8.0.0.7
  v9.0       9.0.0.6
  v10.0      10.0.0.5
  
  The latest available maintenance can be obtained from:
  http://www-01.ibm.com/support/docview.wss?rs=849&uid=swg27006041
  
  If the maintenance level is not yet available,information on
  its planned availability can be found on:
  http://www-1.ibm.com/support/docview.wss?rs=849&uid=swg27006308
  ---------------------------------------------------------------
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  INTEGRATION BUS

• Fixed component ID

  5724J0540

Applicable component levels

• RA00 PSY

     UP