IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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 number

    JR47299

  • Reported component name

    BPM STANDARD

  • Reported component ID

    5725C9500

  • Reported release

    801

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-07-23

  • Closed date

    2013-08-29

  • Last modified date

    2013-08-29

  • 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

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTDH","label":"IBM Business Process Manager Standard"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0.1","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
29 August 2013