topic Re: File locked by another user in SAS Programming

File locked by another user

jhh197 — Mon, 25 Nov 2019 18:38:12 GMT

Hi All,
I get below error when I try update dataset in spde server

Error : The file is locked by another user
Error : Requested lock is not available for data set
Libname stest spde ‘path’;
Libname mlib ‘path’;
proc append base = stest.cards (asyncindex= yes partsize=100) data= mlib.cards force;
run;

Can anyone please help .

Re: File locked by another user

SuryaKiran — Mon, 25 Nov 2019 19:00:13 GMT

Hello,

Did you check if any other members are accessing the dataset (Other users might be writing to it) or Did any other user opened in window and doing nothing. Make sure they close the dataset before you can make updates.

Re: File locked by another user

r_behata — Mon, 25 Nov 2019 19:17:34 GMT

This SAS Note May be of Interest for the SPDE datasets locking issue.

http://support.sas.com/kb/18/467.html

Re: File locked by another user

SASKiwi — Mon, 25 Nov 2019 19:23:13 GMT

If this is a constant problem (the lock error always occurs) then follow @SuryaKiran 's instructions.

If this is an intermittent problem, then use of the FILELOCKWAIT option might help: https://documentation.sas.com/?docsetId=hostwin&docsetTarget=n0fh4oaq31gvqkn1hlh75lvv9396.htm&docsetVersion=9.4&locale=en

Re: File locked by another user

jhh197 — Mon, 25 Nov 2019 19:35:07 GMT

how do I check if any user opening the dataset ?

Re: File locked by another user

jhh197 — Mon, 25 Nov 2019 19:37:12 GMT

Not Sure how much is the wait time . Is there any other option

Re: File locked by another user

SASKiwi — Mon, 25 Nov 2019 20:23:34 GMT

Option to do what? First you need to understand what / who is locking the dataset in the first place and for how long. Then you can implement a solution that might use FILELOCKWAIT or some other technique to reduce the possibility of locking. There is no SAS option that will fix a lock that has already happened in another process.

Re: File locked by another user

r_behata — Mon, 25 Nov 2019 22:30:01 GMT

There is a Macro available that waits till the lock is available until a configurable duration. Once the dataset is released by the other process it puts a lock so that no other process can access while it is being used by your process and releases the lock after execution. But the only drawback is that this wont work of the same dataset is opened by an person( and not process) from a client tool like EG.

http://support.sas.com/kb/51/275.html