JagannathR8869 Member since 2016 43 posts
DXC Technology
Posted: 2 years ago
Last activity: 2 years 3 months ago

Requestor shown having system locks in All Locks page


I am finding in my production application where many users are logged in that few human requestors are showing up in All locks page in designer studio for a time period which exceeds the time till which their lock should be and should have been released but are not.

Have attached a screen shot for your help.

Could you let me know the following regarding this:

a) why the locks which are from pr_sys_locks table still showing as system locks even after their Lock expires time has exceeded ?

b) Does it mean then this human requestor still holds lock actually , if so are they holding locks on the database or just in their user session ?

c) Is there a way as a system admin that if i find that these locks are way old and have exceeded the lock expire time, for me to close these locks, either through designer studio or through updates on database tables ?

d) What is the setting in DSS that manages the lock expire time stamp particularly for a human requestor alone ?

Low-Code App Development System Administration
Moderation Team has archived post
Share this page LinkedIn