IBM Support

JR56283: EMPTY SEARCH RESULT WHEN STORING TIME VALUE INCLUDING FRACTIONS OF A SECOND IN PROCESS VARIABLE WITH ORACLE AS IBM BPM DATABASE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Process instances or tasks are not retrieved while you search by
    using Oracle as IBM BPM database and a JavaScript object of
    type TWSearch that specifies the date value or date values as a
    search parameter, even though the value or values match existing
    process instances or tasks.
    

Local fix

Problem summary

  • If you store time values in process variables that are marked as
    Visible in Process Portal, the time values include fractions of
    a second, you use Oracle as the IBM BPM database, and you run a
    search specifying an exact match filter with a time value that
    includes fractions of a second, an empty result might be
    returned.
    
    On Oracle, IBM BPM stores searchable variables of type "time" in
    columns of type DATE. During insertion, fractions of a second
    are truncated. If you compare the stored date value to a time
    with fractions of a second, the date value is cast to a
    timestamp value before the comparison is complete. If the input
    value has fractions of a second, the comparison fails because of
    the truncation. As a result, corresponding process instances or
    tasks cannot be retrieved.
    
    PRODUCTS AFFECTED
    IBM Business Process Manager (BPM) Advanced
    IBM BPM Standard
    IBM BPM Express
    

Problem conclusion

  • A fix is included in IBM BPM V8.5.7 cumulative fix 2016.09 that
    resolves the problem by truncating the milliseconds from the
    search parameter values of type "date" so that the comparison
    succeeds.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR56283

  • Reported component name

    BPM STANDARD

  • Reported component ID

    5725C9500

  • Reported release

    857

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-07-11

  • Closed date

    2016-09-09

  • Last modified date

    2016-09-09

  • 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

  • R857 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":"857","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
09 September 2016