Update Wizard throws deadlock errors Reason code "68"
The application was upgraded to Pega 7.1.7 on WebSphere with DB2 UDB back end database. Running the update wizard tool resulted in deadlock errors.
com.ibm.db2.jcc.am.SqlTransactionRollbackException: The current transaction has been rolled back because of a deadlock or timeout. Reason code "68".. SQLCODE=-911, SQLSTATE=40001, DRIVER=3.64.133
Steps to Reproduce
- Attempt to run the post update wizard from the UI in DB2 or Websphere system.
- Navigate to Designer Studio > System > Upgrade > Update Existing Applications.
An error or omission in product documentation:
The connection property webSphereDefaultIsolationLevel must be set in the datasource, which is missing from the Pega 7.1.7 DB2 WebSphere Installation Guide.
Perform the following local-change:
Set the connection property webSphereDefaultIsolationLevel=2
0% found this useful