Question

5
Replies
637
Views
Brahmesh@ Member since 2013 147 posts
Capgemini
Posted: June 16, 2019
Last activity: September 24, 2019
Closed
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
Moderation Team has archived post
Share this page LinkedIn