topic lock is not available in SAS Programming

lock is not available

GokulShivananda — Wed, 20 Jun 2018 10:24:04 GMT

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

Re: lock is not available

Kurt_Bremser — Wed, 20 Jun 2018 13:41:39 GMT

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.

Re: lock is not available

GokulShivananda — Thu, 21 Jun 2018 09:57:14 GMT

Thank you,

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

Please Find the attachment.

Any pointers.. ?

Regards,

Gokul Shivananda

Re: lock is not available

Kurt_Bremser — Thu, 21 Jun 2018 10:07:10 GMT

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.