DATA Step, Macro, Functions and more

lock is not available

Reply
Occasional Contributor
Posts: 15

lock is not available

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

Super User
Posts: 10,209

Re: lock is not available

Posted in reply to GokulShivananda

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Occasional Contributor
Posts: 15

Re: lock is not available

Posted in reply to KurtBremser

Thank you,

Yes I did that but it is pointing to Object Spawner!!

Please Find the attachment.

 

Any pointers.. ?

 

Regards,

Gokul Shivananda

Super User
Posts: 10,209

Re: lock is not available

Posted in reply to GokulShivananda

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. 

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Ask a Question
Discussion stats
  • 3 replies
  • 52 views
  • 0 likes
  • 2 in conversation