IT31928: ESQL FILES ARE NOT PROCESSED IN A CONSISTENT ORDER DURING DEPLOYMENT.

APAR status

• Closed as program error.

Error description

• ESQL Files are not processed in a consistent order during
  deployment. If ESQL Files deployed contain order sensitive
  dependencies then this may result in a deployment error on some
  systems but work correctly on other systems.
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  All users of IBM Integration Bus version 10 or App Connect
  Enterprise version 11 using ESQL.
  
  
  Platforms affected:
  MultiPlatform
  
  ****************************************************************
  PROBLEM DESCRIPTION:
  <span style="background-color:rgb(255, 255, 255)">ESQL Files are
  not processed in a consistent order during </span><span
  style="background-color:rgb(255, 255, 255)">deployment. If ESQL
  Files deployed contain order sensitive </span><span
  style="background-color:rgb(255, 255, 255)">dependencies then
  this may result in a deployment error on some </span><span
  style="background-color:rgb(255, 255, 255)">systems but work
  correctly on other systems.  </span>
  
  It is not recommended to construct ESQL in such a way that the
  order of processing is critical. For example do not initialise
  schema level or shared variables on one ESQL file based on the
  value of a schema level variable or shared variable in another
  ESQL file.
  

Problem conclusion

• ESQL files are now processed in a consistent order during
  deployment. This order is based on the natural sort order of the
  paths to the deployed ESQL files on disk.
  
  ---------------------------------------------------------------
  The fix is targeted for delivery in the following PTFs:
  
  Version    Maintenance Level
  v10.0      10.0.0.21
  v11.0      11.0.0.9
  
  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