JR56743: AN IBM PROCESS PORTAL INBOX QUERY FAILS ON AN ORACLE DATABASE AND YOU SEE THE ORA-01795 ERROR CODE

8.5.6.2-WS-BPM-IFJR56743
bpm.8570.cf2016.12.delta.repository
Downloading IBM Business Process Manager V8.5.7 Cumulative Fix 2016.12

APAR status

• Closed as program error.

Error description

• When the IBM Process Portal inbox of an user has more than 1000
  tasks and an Oracle database is used, the query might fail and
  you might see the following error message:
  
  "ORA-01795: maximum number of expressions in a list is 1000"
  
  This is a limitation for an IN clause on an Oracle database.
  

Local fix

Problem summary

• Oracle has a limitation of 1000 expressions in an IN clause of a
  query. Sometimes the Process Portal client generates queries
  with more than 1000 expressions. You experience this problem
  when you specify a value larger than 1000 for the
  max-in-clause-length configuration setting and, as a result, the
  Process Portal client might try to create an inbox query that
  has more than 1000 tasks.
  

Problem conclusion

• A fix is available in IBM BPM V8.5.6 cumulative fix 2 (CF02)
  on request from BPM level 3 support that handles the Oracle
  limitation when multiple queries with more than 1000 tasks are
  in IN clauses.
  
  -
  
  A fix will be included in IBM BPM V8.5.7 cumulative fix (CF)
  2016.12.
  
  To determine whether the cumulative fix is available and
  download it if it is, complete the following steps on Fix
  Central:
  
  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 Text, enter "cumulative fix?, and click Continue.
  
  PRODUCTS AFFECTED
  IBM Business Process Manager (BPM) Advanced
  IBM BPM Standard
  IBM BPM Express
  

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

• R856 PSY

     UP

• R857 PSY

     UP