Hi All,
Hope you're Doing Well !!
In our environment SAS is installed on Windows 2012 R2. Now a days we are frequently experiencing the scheduled jobs failure due to the MEMBER lock is not available on the particular tables in our Production environment.
This time we got the below error.
ERROR: MEMBER lock is not available for STAGE.ERAS0001_R.DATA, lock held by SYSTEM(ADMUSER1) connection ID 66648736.
Anyone can please suggest us how to find out the user who locked the table and how to kill the sessions.
My user id account is holding the all admin privileges to do the above tasks.
Please help us out.