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?
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.