Direct links to fixes
APAR status
Closed as program error.
Error description
DBUpgrade will hang when alter table LSW_BPD_INSTANCE_DATA on DB2 in some cases
Local fix
No local fix
Problem summary
**************************************************************** * USERS AFFECTED: IBM BPM Advanced * * IBM BPM Standard * * IBM BPM Express * **************************************************************** * PROBLEM DESCRIPTION: Running the DBUpgrade command might * * hang at either of the following SQL * * statements when you migrate IBM * * Business Process Manager (BPM) to IBM * * BPM Version 8.5.5.0 on the IBM DB2 * * database. * * ALTER TABLE LSW_BPD_INSTANCE_DATA * * ACTIVATE NOT LOGGED INITIALLY * * or * * ALTER TABLE * * LSW_TASK_EXECUTION_CONTEXT ACTIVATE * * NOT LOGGED INITIALLY * * This issue occurs because the * * previous upgrade step on these two * * tables encountered an unreleased lock. * **************************************************************** * RECOMMENDATION: * **************************************************************** The issue happens only when the user uses DB2 and there is no update needed for data in the IBM Process Server database including process instances or tasks data
Problem conclusion
A fix is available for IBM BPM V8.5.5.0 that prevents the system from hanging by committing the SQL transaction explicitly On Fix Central (http://www.ibm.com/support/fixcentral), search for JR51656: 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 JR51656, and click Continue. When you download fix packages, also download the readme file for each fix. Review each readme file for additional installation instructions and information about the fix.
Temporary fix
Comments
APAR Information
APAR number
JR51656
Reported component name
BPM ADVANCED
Reported component ID
5725C9400
Reported release
855
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2014-10-31
Closed date
2014-12-11
Last modified date
2014-12-11
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
R800 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTN5","label":"IBM Business Process Manager Advanced"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"855","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
16 October 2021