JR57068: PROCESS INSTANCES OR TASKS ARE NOT RETRIEVED WHEN YOU SEARCH BY USING MICROSOFT SQL SERVER AS THE IBM BPM DATABASE

bpm.8570.cf2016.12.delta.repository
Downloading IBM Business Process Manager V8.5.7 Cumulative Fix 2016.12

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 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