JR47299: NO RESULT ON ORACLE WHEN EXECUTING SAVED SEARCH WITH QUERY FILTER ON PT_PTID.

Download Version 8.0.1 Fix Pack 2 for the IBM Business Process Manager products
Version 8.5.0 Fix Pack 1 for the IBM Business Process Manager products
Version 8.5 Refresh Pack 5 for the IBM Business Process Manager products

APAR status

• Closed as program error.

Error description

• When executing the saved search IBM.DEFAULTALLTASKSLIST_75 on
  IBM Business Process Manager configured with a Oracle DB and
  specifying a filter on property PT_PTID no result will be
  returned.
  

Local fix

• n/a
  

Problem summary

• Problem Description:
  
  When executing the saved search IBM.DEFAULTALLTASKSLIST_75 on
  IBM Business Process Manager
  configured with a Oracle DB and specifying a filter on property
  PT_PTID no result will be
  returned.
  
  Problem Summary:
  
  When generating the SQL for the saved search that is executed on
  the Oracle database,
  the genertaed SQL is not correct. The generated SQL contains a
  UPPER for column bpd_id,
  which is not correct and cause the incorrect result.
  

Problem conclusion

• Problem Conclusion:
  
  With this interim fix the SQL generation will be changed, so
  that the incorrect usage of
  UPPER in the SQL query will be fixed.
  
  FIX AVAILABILITY:
  
  iFix for 8.0.1.0 is available on Fix Central, search for APAR
  JR47299 at http://www.ibm.com/support/fixcentral/
  
  iFix for 8.0.1.1 is available on Fix Central, search for APAR
  JR47265 at http://www.ibm.com/support/fixcentral/
  
  Fix is also targetted for inclusion in next fixpack for BPM
  V8.0.1.2
  
  Fix is also targetted for inclusion in next fixpack for BPM
  V8.5.0.1
  
  Fix is also targetted for inclusion in next fixpack for BPM
  V7.5.1.2
  
  When obtaining any of the above fixes, be sure to download the
  accompanying readme, for itself and any prerequisite fixes, and
  review them thorougly
  

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

• R801 PSY

     UP