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 number
IT31928
Reported component name
INTEGRATION BUS
Reported component ID
5724J0540
Reported release
A00
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-02-20
Closed date
2020-05-18
Last modified date
2020-05-18
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
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSNQK6","label":"IBM Integration Bus"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
19 May 2020