Hi everyone,
We are experiencing some issues in SAS 9.4 M7. We've recently migrated from Microsoft server 2012 R2 to 2019 and this is when the issues started.
We have a SAS scheduled batch job which every now and then will raise the following error:
ERROR: User does not have appropriate authorization level for library WORK.
As mentioned, this only happens every now and then (e.g., job runs successfully 10 times and then fails on run 11). There is no apparent pattern in terms of when it'll fail. It fails both when running in batch and when it is run manually.
We've tried to exclude the work library catalogue from Microsoft Defender. We've also checked that the user has appropriate credentials to access the folder. This did not resolve the issue.
I would check that the method SAS is using to name the directory it creates for the WORK directory is insured of generating a unique name.
Sounds to me like there is conflict of two or more jobs trying to use the same directory for their WORK location. So the first one makes it with permissions for user X and when the second job tries to use for user Y the access is denied.
Do you have multiple SAS hosts that are sharing the same work directory?
Or multiple instances of SAS.
Or multiple SAS application servers?
Where in the batch job does that happen? Is it at invocation or later? If later is it always the same statement or step causing the error? Can you post the SAS log for that step, including errors and notes?
Hi,
we are seeing same errors with authorization level to Work occasionally. Also sas m7 on Microsoft Server 2019.
Did something resolve this issue?
@viswmmo - The original poster never responded to our questions. If you want help with your issue then you would need to answer those questions.
@AnushaS4 wrote:
Hi. Was this issue ever resolved
Since neither of the people asking about this provided any details we have no idea. If you are having a similar behavior start your own thread and provide the information requested of the other posters.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.