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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.