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

Download Version 8.0.1 Fix Pack 3 for the IBM Business Process Manager products
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

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