Direct link to fix
APAR status
Closed as program error.
Error description
A specific SQL select statement, generated by the IBM Business Process Manager (BPM) Query Table Builder and based on user requirements, causes a locking conflict with IBM BPM's cleanup-unused-shared-workitems process when it runs on a Microsoft SQLServer database.
Local fix
Problem summary
The generated SQL statement contains some sub-queries, which are not marked read uncommitted. This causes additional, unintended row locks for the specified database tables. PRODUCT AFFECTED IBM Business Process Manager (BPM) Advanced
Problem conclusion
A fix is available for IBM BPM V8.5.7.0 that generates the SQL statement so that all sub-queries are marked WITH (READUNCOMMITTED).
Temporary fix
Comments
APAR Information
APAR number
JR59808
Reported component name
BPM ADVANCED
Reported component ID
5725C9400
Reported release
857
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-07-25
Closed date
2018-11-21
Last modified date
2018-11-21
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 ADVANCED
Fixed component ID
5725C9400
Applicable component levels
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTN5","label":"IBM Business Process Manager Advanced"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"857","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
21 November 2018