** Database-LockFailure-LockLost With Obj-Delete-By-Handle method
Getting ** Database-LockFailure-LockLost during commit operation which is happening after perform delete operation using Open-Delete-By-Handle method .
Steps:-
1) Collecting pzInskeys of the work history instances and iterate through them to delete each instance using obj-delete-by-handle.
2) Checked the Lock & Release on Commit for delete operation.
3) After deleting all objects then apply commit method ,but commit is successful for first 30 instances of system_lock after that system is using select query for a record which deleted just before to it and then it's started failing as Database-locklost.
***Edited by Moderator Marissa to update SR Details***
Accepted Solution
Pegasystems Inc.
US
Upon reviewing the associated Support Request, the resolution was as follows:
Perform the following local-change: Disable the ‘Allow locking’ option for the History class group and re save the Class Definition and Data-Admin-DB-Table definition to avoid the issue.
Swedbank AB
SE
Hello Brahmesh,
Can you attach the tracer file here for our review?
Does the commit always is successful for 30 instances or this number variates?
Thank you,
Pawan
Updated: 18 Jun 2019 4:26 EDT
Skandiabanken
SE
Attached the tracer results .
yes..the number variates ..no specific pattern for this.
Skandiabanken
SE
As per my observation,During lock acquisition on instances,the lockhandle in lock table is varies from actual pzInsKey of instance.Hence,The Lock table is ended up with same lock handles for multiple instances.
The value of pxLockHandle is HISTORY-MyOrg-App-WORK MyOrg-App-WORK L-13353!20190302T095757.603 GMT
PzInsKey of the history :HISTORY-MyOrg-App-WORK MyOrg-App-WORK L-13353!20190302T095757.602 GMT
Accepted Solution
Pegasystems Inc.
US
Upon reviewing the associated Support Request, the resolution was as follows:
Perform the following local-change: Disable the ‘Allow locking’ option for the History class group and re save the Class Definition and Data-Admin-DB-Table definition to avoid the issue.