IT33608: ESQL LIST CONSTRUCTOR WITH EXPRESSION ARGUMENTS CAN CAUSE BIP2111 IMPLEMENTATION ERROR AT ACE 11.0.0.7 AND ABOVE

APAR status

• Closed as program error.

Error description

• A deploy of an ESQL file containing a LIST constructor with
  expression arguments that require resolution at runtime, such
  as EXTERNAL methods and built in functions, will fail with a
  BIP2111 implementation error at ACE 11.0.0.7 and above. For
  example the following file will fail to deploy at ACE
  11.0.0.7:
  
  CREATE COMPUTE MODULE Flow_Compute
  CREATE FUNCTION
  Main() RETURNS BOOLEAN
  BEGIN
  DECLARE myList ROW;
  SET
  myList.Index[] = LIST{SUBSTRING('aaaa' FROM 1 FOR 2)};
  RETURN
  TRUE;
  END;
  END MODULE;
  
  Deploying this module will fail with
  the following error:
  
  BIP9318E: Request to 'PreSetupValidate'
  resource 'EsqlDeployFail', 'EsqlDeployFail' of type
  'Application' failed.
  BIP2111E: IBM App Connect Enterprise
  internal error: diagnostic information
  'SqlExpressionNode::setChildNode(int): implementation
  error'.
  BIP9333W: Application 'EsqlDeployFail' has been changed
  but contains errors which has prevented some resources from
  starting.
  BIP1096E: The source
  'EsqlDeployFailproject.generated.bar' has been deployed but
  there were one or more failures which may mean the deployed
  resources will be unable to execute.
  

Local fix

• Use local variables to define the arguments to the list
  constructor, eg:
  
  CREATE COMPUTE MODULE Flow_Compute
  CREATE
  FUNCTION Main() RETURNS BOOLEAN
  BEGIN
  DECLARE myList
  ROW;
  DECLARE mySubstring CHARACTER SUBSTRING('aaaa' FROM 1 FOR
  2);
  SET myList.Index[] = LIST{mySubstring};
  RETURN
  TRUE;
  END;
  END MODULE;
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  All users of IBM App Connect Enterprise 11.0.0.7 and above who
  use LIST constructor expressions in ESQL modules.
  
  
  Platforms affected:
  MultiPlatform
  
  ****************************************************************
  PROBLEM DESCRIPTION:
  A deploy of an ESQL file containing a LIST constructor with
  expression arguments that require resolution at runtime, such as
  EXTERNAL methods and built in functions, will fail with a
  BIP2111 implementation error at ACE 11.0.0.7 and above. For
  example the following file will fail to deploy at ACE 11.0.0.7:
  
  CREATE COMPUTE MODULE Flow_Compute
      CREATE FUNCTION Main() RETURNS BOOLEAN
      BEGIN
          DECLARE myList ROW;
          SET myList.Index[] = LIST{SUBSTRING('aaaa' FROM 1 FOR
  2)};
          RETURN TRUE;
      END;
  END MODULE;
  
  Deploying this module will fail with
  the following error:
  
  BIP9318E: Request to 'PreSetupValidate' resource
  'EsqlDeployFail', 'EsqlDeployFail' of type 'Application' failed.
  BIP2111E: IBM App Connect Enterprise internal error: diagnostic
  information 'SqlExpressionNode::setChildNode(int):
  implementation error'.
  BIP9333W: Application 'EsqlDeployFail' has been changed but
  contains errors which has prevented some resources from
  starting.
  BIP1096E: The source 'EsqlDeployFailproject.generated.bar' has
  been deployed but there were one or more failures which may mean
  the deployed resources will be unable to execute.
  

Problem conclusion

• The product now correctly processes LIST constructor
  expressions.
  
  ---------------------------------------------------------------
  The fix is targeted for delivery in the following PTFs:
  
  Version    Maintenance Level
  v11.0      11.0.0.10
  
  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

  APP CONNECT ENT

• Fixed component ID

  5724J0550

Applicable component levels