I observe that a table from a library is locked by a process. I ensured all the batches or the sessions from the application are closed and just launched a batch, but unfortunately I see a particular table is getting locked without a reason!.
I have Stopped all the SAS services and started it many times. Didn't work!!
So I logged in Unix and killed the process ID which was locking my table and the batches were successful,
this solution was okay for 30 minutes but the issue appears !! I have SASShare in my environment.
How would I know what is this process and how to resolve this ?
Thank you
Error Msg:
MPRINT(_M_SET_BOP_RESERVES): modify CES0094.SIM_NET_PGN_RSK_LI_Q22018 (cntllev=rec) key=XPKSIM_NET_PGN_RSK_LI_Q22018 ;
ERROR: A lock is not available for CES0094.SIM_NET_PGN_RSK_LI_Q22018.DATA.
ERROR: Lock held by process 16973856.
Regards,
Gokul
A ps -fp 16973856 will show you details about the process responsible. "Climbing up" the process tree along PPID will help you determine where it came from.
Thank you,
Yes I did that but it is pointing to Object Spawner!!
Please Find the attachment.
Any pointers.. ?
Regards,
Gokul Shivananda
In SAS Management Console, look for a server definition for
A5L1RGTE.AU000005
It's most probably a workspace server, which means you'll get the user-id from the ps output, so you have an avenue for investigation.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.