IBM Support

JR50299: ERROR DELETING LARGE APP FROM PROCESS CENTER: COLLECTION PASSED AS VALUE OF GROUP_ID IS TOO LARGE (257, LIMIT IS 100)

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • In the unversioned PODAO class, there is a limit of 100 entities
    for SQL ?in clauses?.  If a SQL query tries to add more than 100
    entries to an ?in clause?, the following TeamWorksException is
    encountered:
    
     com.lombardisoftware.core.TeamWorksException: Collection passed
    as value of group_id is too large (257, limit is 100)A setting
    is needed to configure the limit to allow a larger number of
    entries in the SQL 'in clause'.
    

Local fix

Problem summary

  • In some database systems, there is a limit for the number of
    entities that can be used in SQL ?in clauses?.  In this context,
    a limit of 100 entities was introduced in the code so that SQL
    statements with more than 100 entities in a SQL ?in clause?
    results in a TeamWorksException, indicating that the current
    number of entities is larger than this limit. For example, when
    there is large number of users and a large application, this
    limit can be reached, which prevents process applications from
    being deleted.
    

Problem conclusion

  • A fix is/will be available that allows you to configure the
    number of entities that can be used in SQL ?in clauses? by
    modifying the default limit (100) by changing an int value in
    the 100Custom.xml file:
    
        <server merge="mergeChildren">
            <max-in-clause-length>{int value}</max-in-clause-length>
        </server>
    
    For more information, see ?Changing IBM Process Server
    properties in 100Custom.xml?
    and ?The 99Local.xml and 100Custom.xml configuration files?
    
    in the IBM Business Process Manager Information Center.
    
    On Fix Central (http://www.ibm.com/support/fixcentral), search
    for JR50299:
    
    1. Select IBM Business Process Manager with your edition from
     the product selector, the installed version to the fix pack
     level, and your platform, and then click Continue.
    
    2. Select APAR or SPR, enter JR50299, and click Continue.
    
    When you download fix packages, ensure that you also download
    the readme file for each fix. Review each readme file for
    additional installation instructions and information about the
    fix.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR50299

  • Reported component name

    BPM STANDARD

  • Reported component ID

    5725C9500

  • Reported release

    751

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-05-20

  • Closed date

    2014-07-10

  • Last modified date

    2014-07-10

  • 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

    BPM STANDARD

  • Fixed component ID

    5725C9500

Applicable component levels

  • R751 PSY

       UP

  • R801 PSY

       UP

  • R850 PSY

       UP

  • R855 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTDH","label":"IBM Business Process Manager Standard"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.5.1","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
10 July 2014