Architecting, installing and maintaining your SAS environment

SAS code errors in SAS EG but runs fine in SAS Scheduler

Reply
New Contributor
Posts: 2

SAS code errors in SAS EG but runs fine in SAS Scheduler

Hello,

 

We have a 3 tier environement for our SAS software and we publish our SAS application using a client installed on citrix.  When a user runs a job using SAS EG it fails with the error below, but if they run the job again it works. We even made a new excel file to prove no one was in it and still got the SAS error.  Now if the user schedules the job using the SAS scheduler it works fine. We installed 64 bit microsoft products on the server and verifed the drives are there.

 

 

ERROR: Connect: The Microsoft Access database engine cannot open or write to the file ''. It is already opened exclusively by
another user, or you need permission to view and write its data.
ERROR: Error in the LIBNAME statement.

 

Example of code:

 

PROC EXPORT DATA = COUNT.COUNT_SHEET_GM
546 OUTFILE= "\\NASstoragenamehere\Count Sheets\&filedate HD_COUNT_SHEET.xls"
547 DBMS=EXCEL REPLACE;
548 SHEET="HD_COUNT_SHEET_GM";
549 RUN;

 

Has anyone else had this issue?

Thanks for your time,

 

Trusted Advisor
Posts: 1,141

Re: SAS code errors in SAS EG but runs fine in SAS Scheduler

Hello @jyost76,

 

this can be 2 things. Or either your own user does not have the right permissions on the shared folder (from the server, just ask an admin to test the UNC path for you), or your server does not have registered properlly the SPNs> I would bet that is its more likely the first option.

New Contributor
Posts: 2

Re: SAS code errors in SAS EG but runs fine in SAS Scheduler

So we added the service accounts we used for SAS to the storage locations and it worked. We don't know why, we figured if it didn't have the right security it shouldn't work at all. The other thing why would we need to add service account ID's to the security of the data? 

 

1)Shouldn't the security you use in a SAS session be the ID you created in your SAS profile within SAS EG

2) Is there some process in the back ground when your in SAS that uses a service account?

3) The security on the folder used to store the data: if we added the user shouldn't that be enough?

 

Thanks for your time, I hope this information helps other.

 

Ask a Question
Discussion stats
  • 2 replies
  • 151 views
  • 2 likes
  • 2 in conversation