08-14-2015 05:12 AM
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?
08-14-2015 05:23 AM
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.
08-14-2015 06:44 AM
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.
08-14-2015 06:47 AM
And how do you update them?
08-14-2015 07:09 AM
Well, if you do
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?
08-14-2015 07:17 AM
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.
08-14-2015 07:24 AM
And which process runs under number 20022?