IBM Support

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

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

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

Temporary fix

Comments

APAR Information

  • APAR number

    IT33608

  • Reported component name

    APP CONNECT ENT

  • Reported component ID

    5724J0550

  • Reported release

    B00

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-07-20

  • Closed date

    2020-08-25

  • Last modified date

    2020-08-25

  • 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

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSDR5J","label":"IBM App Connect Enterprise"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B00","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
26 August 2020