Direct links to fixes
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"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"857","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
16 October 2021