BookmarkSubscribeRSS Feed
larsc
Obsidian | Level 7

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.

6 REPLIES 6
Tom
Super User Tom
Super User

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?

 

 

SASKiwi
Opal | Level 21

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?

viswmmo
Fluorite | Level 6

Hi,

we are seeing same errors with authorization level to Work occasionally. Also sas m7 on Microsoft Server 2019.

Did something resolve this issue? 

 

 

 

 

SASKiwi
Opal | Level 21

@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
Fluorite | Level 6
Hi. Was this issue ever resolved
ballardw
Super User

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

SAS INNOVATE 2024

Innovate_SAS_Blue.png

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. 

Register now!

How to Concatenate Values

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.

Get the $99 certification deal.jpg

 

 

Back in the Classroom!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 6 replies
  • 1592 views
  • 1 like
  • 6 in conversation