Direct links to fixes
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 number
JR56743
Reported component name
BPM STANDARD
Reported component ID
5725C9500
Reported release
856
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-09-29
Closed date
2016-11-23
Last modified date
2016-11-23
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
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTDH","label":"IBM Business Process Manager Standard"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"856","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
14 October 2021