JR51854: "RUN QUERY" REST API DOES NOT HANDLE DATE VALUES IN ISO-8601 FORMAT CORRECTLY

8.5.0.2-WS-BPM-IFJR51854
8.0.1.2-WS-BPM-IFJR51854
Version 8.5 Refresh Pack 6 for the IBM Business Process Manager products

APAR status

• Closed as program error.

Error description

• The Run Query REST API (/rest/bpm/wle/v1/search/query) does not
  parse a date value in ISO-8601 format correctly. Only the date
  portion of the specified value is interpreted; the time and time
  zone information is ignored. The time value used is 00:00:00 in
  the time zone of the server.
  
  ISO-8601 format is expected by all other REST APIs with a date
  value as input (f.e. process/task update due date).
  

Local fix

• Specify the date in local server time by using the format
  "yyyy-MM-dd HH:mm:ss.SSS".
  

Problem summary

• All date values are interpreted in server time zone in the
  format "yyyy-MM-dd HH:mm:ss.SSS". In addition, the following
  formats are accepted by using normalization (ignoring
  separators):
  
  "yyyy MM dd HH mm ss"
  "MM dd yyyy HH mm ss
  "yyyy MM dd HH mm"
  "MM dd yyyy HH mm"
  "yyyy MM dd"
  "MM dd yyyy"
  "MMM dd yyyy HH mm ss"
  "MMM dd yyyy HH mm"
  "MMM dd yyyy"
  To support code that has been adapted to the current behavior,
  the old parsing algorithm is still used if the date cannot be
  parsed as ISO-8601.
  

Problem conclusion

• A fix is/will be available for IBM BPM that allows you to
  specify date values for the Run Query REST API in ISO-8601
  format.
  
   On Fix Central (http://www.ibm.com/support/fixcentral), search
  for JR51854:
  
  1. Select IBM Business Process Manager with your edition from
    the product selector, the installed version to the fix pack
    level, and your platform, and then click Continue.
  
  2. Select APAR or SPR, enter JR51854, and click Continue.
  
  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.
  

Temporary fix

• Not applicable
  

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