Direct link to fix
APAR status
Closed as program error.
Error description
When you migrate instances by using the migrateWithContextTo Javascript API or migrateWithPolicyTo Javascript API, lock timeouts occur, such as in the following example: CWLLG2229E: PreparedStatementCallback; SQL [SELECT BPD_INSTANCE_ID FROM LSW_BPD_INSTANCE WITH (ROWLOCK,UPDLOCK) WHERE BPD_INSTANCE_ID = ?]; Lock request time out period exceeded.; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Lock request time out period exceeded. PRODUCTS AFFECTED IBM Business Automation Workflow
Local fix
Do not run Javascript instance migration commands from within the instance being migrated. Instead, use an admin service or other process to run the Javascript.
Problem summary
This issue occurs only when the Javascript runs from within the instance being migrated.
Problem conclusion
A fix is available or will be available that prevents lock timeouts by detecting if the Javascript is running from within the instance being migrated.
Temporary fix
Comments
APAR Information
APAR number
JR63273
Reported component name
BUS AUTO WORKFL
Reported component ID
5737H4100
Reported release
K00
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-02-02
Closed date
2021-02-23
Last modified date
2021-02-23
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
BUS AUTO WORKFL
Fixed component ID
5737H4100
Applicable component levels
[{"Line of Business":{"code":"LOB45","label":"Automation"},"Business Unit":{"code":"BU029","label":"Software"},"Product":{"code":"SS8JB4","label":"IBM Business Automation Workflow"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"20.0.0.1"}]
Document Information
Modified date:
21 June 2021