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

8.5.5.0-WS-BPM-IFJR51352
Version 8.5 Refresh Pack 6 for the IBM Business Process Manager products
Version 8.5.0 Fix Pack 2 for the IBM Business Process Manager products

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