topic Re: SAS/Share Server problem in Administration and Deployment

SAS/Share Server problem

Micheal_S — Fri, 14 Aug 2015 09:12:22 GMT

Hello

My application is having multiple job flows scheduled in Platform Process Manager, these flows executes the jobs in parallel and multiple jobs updates single sas dataset at the same time, so for this purpose we have SAS/Share Server installed but somehow even after I am getting LOCK error on the jobs and they are failing. Can anyone please help me in understanding that what should I check to make this work?

Thanks

Mike

Re: SAS/Share Server problem

Kurt_Bremser — Fri, 14 Aug 2015 09:23:21 GMT

If you replace a dataset completely, it is not available for other accesses at all. SAS/SHARE allows multiple update or append operations, but you can't access a dataset while it is being (re)created.

Re: SAS/Share Server problem

Micheal_S — Fri, 14 Aug 2015 10:44:16 GMT

Thanks for your response Kurt, My process is not creating any new datasets, all of them are existing ones and they are just getting updated with each run.

Re: SAS/Share Server problem

Kurt_Bremser — Fri, 14 Aug 2015 10:47:09 GMT

And how do you update them?

Re: SAS/Share Server problem

Micheal_S — Fri, 14 Aug 2015 10:56:33 GMT

Already existing base sas programs are using PROC SQL and Data steps to do Load append.

Re: SAS/Share Server problem

Kurt_Bremser — Fri, 14 Aug 2015 11:09:27 GMT

Well, if you do

data test;

set test;

......

run;

This always means that the dataset is completely rewritten, something that causes it to be inaccessible to other processes even when done via SAS/SHARE. Only certain update types can be handled concurrently by the SAS/SHARE server.

And do the jobs all access the libraries with the REMOTE engine and the SERVER= option?

Re: SAS/Share Server problem

Micheal_S — Fri, 14 Aug 2015 11:17:53 GMT

Okay let me tell you little history, all these programs are running from past few years in older version of SAS (9.2) and now they all are migrated to SAS 9.4, and there is no change in codes. Individually each and every program is tested and they are perfectly fine but when we execute in parallel it throws error like

ERROR: A lock is not available for REMOLIB.DETAIL.DATA.

ERROR: Lock held by process 20022.

Yes all the jobs access libraries from Remote engine and SAS/SHARE server option.

Thanks

Re: SAS/Share Server problem

Kurt_Bremser — Fri, 14 Aug 2015 11:24:14 GMT

And which process runs under number 20022?