IBM Support

JR57068: PROCESS INSTANCES OR TASKS ARE NOT RETRIEVED WHEN YOU SEARCH BY USING MICROSOFT SQL SERVER AS THE 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 when you search by
    using Microsoft SQL Server as the IBM Business Process Manager
    (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 IBM Process Portal, the time values include
    fractions of a second, you use Microsoft SQL Server 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 Microsoft SQL Server, IBM BPM stores searchable variables of
    type "time" in columns of type DATETIME. During insertion, the
    value is rounded to increments of .000, .003, or .007 seconds.
    If the search value has fractions of a second that do not
    exactly match the rounded value, the comparison fails. As a
    result, corresponding process instances or tasks cannot be
    retrieved.
    

Problem conclusion

  • A fix will be available in IBM BPM V8.5.7 cumulative fix 2016.12
    that casts the search value to DATETIME before the comparison
    is done.
    
    To determine whether the cumulative fix is available, complete
    the following steps on Fix Central
    (http://www.ibm.com/support/fixcentral):
    
    1. On the Select product tab, select WebSphere as the product
    group, IBM Business Process Manager with your edition from the
    WebSphere options, All as the installed version, and All as the
    platform, and then click Continue.
    2. In the Text field, enter "cumulative fix", and click
    Continue.
    
    If cumulative fix 2016.12 is available, download and install it.
    When you download fix packages, ensure that you also download
    the readme file for each fix. Review each readme file for
    additional installation instructions and information about the
    fix.
    
    
    PRODUCTS AFFECTED
    IBM BPM Advanced
    IBM BPM Standard
    IBM BPM Express
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR57068

  • 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-11-28

  • Closed date

    2016-12-09

  • Last modified date

    2016-12-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 December 2016