Question

5
Replies
527
Views
X
Brahmesh@ Member since 2013 140 posts
Capgemini
Posted: 1 year ago
Last activity: 9 months 2 weeks ago
Solved

** 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***

Data Integration Java and Activities System Administration Data Integration SR Created
Share this page LinkedIn