IBM Support

JR51352: LIMIT OF 1000 USERS IN DYNAMIC GROUPS WITH ORACLE AS RUNTIME DATABASE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • With APAR JR50299 applied, you can change the default limit of
    100 dynamic team members, but because of an Oracle database
    limitation you are limited to 1000 members. For example, when
    you try to assign a task to a dynamic team that has more than
    1000 members, the Oracle IN clause limit is reached and the task
    assignment fails with the ORA-01795 message.
    .
      This is the error message that is logged
    CWLLG2229E: An exception occurred in an EJB call.  Error:
    Collection passed as value of UPPER(USER_NAME) is too large
    (1016, limit is 100)
    com.lombardisoftware.core.TeamWorksException: Collection passed
    as value of UPPER(USER_NAME) is too large (1016, limit is 100)
        at
    com.lombardisoftware.server.ejb.persistence.dao.UnversionedPODAO
    .appendWhereClause(UnversionedPODAO.java:365)
        at
    com.lombardisoftware.server.ejb.persistence.dao.UnversionedPODAO
    .findOrdered(UnversionedPODAO.java:220)
        at
    com.lombardisoftware.server.ejb.persistence.dao.UnversionedPODAO
    .findOrdered(UnversionedPODAO.java:202)
        at
    com.lombardisoftware.server.ejb.persistence.dao.UserDAO.findByFi
    lter(UserDAO.java:71)
    at
    com.lombardisoftware.server.core.UserCore.findByFilter(UserCore.
    java:322
    )
     at
    com.lombardisoftware.server.ejb.security.ParticipantGroupsCore.s
    ortParticipants(ParticipantGroupsCore.java:1335)
     at
    com.lombardisoftware.server.ejb.security.ParticipantGroupsCore.u
    pdateMembership(ParticipantGroupsCore.java:1301)
     at
    com.lombardisoftware.server.ejb.security.ParticipantGroupsCore.r
    esolveAddressForRetrievalService
    (ParticipantGroupsCore.java:569)
     at
    com.lombardisoftware.server.ejb.security.ParticipantGroupsCore.r
    esolveAddressInternal(ParticipantGroupsCore.java:473)
     at
    com.lombardisoftware.server.ejb.security.ParticipantGroupsCore.r
    esolveAddress(ParticipantGroupsCore.java:382)
    

Local fix

Problem summary

  • The problem occurs only for dynamic groups that have more than
    1000 users on an Oracle database because of a limitation in
    Oracle.
    

Problem conclusion

  • A fix is available for IBM BPM V8.5.0.1 that changes the
    generate SQL to allow more than 1000 users in a dynamic group.
    
    On Fix Central (http://www.ibm.com/support/fixcentral), search
    for JR51352:
    
    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 JR51352, 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

  • Not applicable
    

Comments

APAR Information

  • APAR number

    JR51352

  • Reported component name

    BPM ADVANCED

  • Reported component ID

    5725C9400

  • Reported release

    850

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2014-09-24

  • Closed date

    2014-10-21

  • Last modified date

    2015-08-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

    BPM STANDARD

  • Fixed component ID

    5725C9500

Applicable component levels

  • R850 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":"8.5","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
18 August 2015