Desktop productivity for business analysts and programmers

"An unexpected error has occurred" after double-clicking on a library

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 6
Accepted Solution

"An unexpected error has occurred" after double-clicking on a library

[ Edited ]

Hi all,

 

I am very, very new to SAS and having some trouble using a library I create. For background on my particular situation, I'm using Enterprise Guide 7.15 HF3 on a Windows VM, and after I create a new library in Management Console, I can see it in Enterprise Guide but the icon is white and not yellow which I have read means it isn't active. After I double-click on the library, I get a message saying "An unexpected error has occurred: The library could not be assigned by the SAS Server" and I also read something about "User does not have appropriate authorization level for library TestLIB" in the error details. 

I've discussed this with my SAS Admin at my workplace but he is just as new as I am and doesn't know what to do or what permission to enable and for obvious reasons, they don't want to enable all permissions for me.

 

Any suggestions would be greatly appreciated. Thanks in advance.


Accepted Solutions
Solution
a week ago
SAS Employee
Posts: 11

Re: "An unexpected error has occurred" after double-clicking on a library

Posted in reply to JenniferLB08

Can you open a program editor in Enterprise Guide (File - new - program) and manually submit a LIBNAME statement to the same location you created in SMC (instead of clicking on the library)?

 

After submitting the LIBNAME statement to the same location on the SAS server, are you able to expand the library and open tables? If you encounter the same authorization error, it indicates that the userid being used in Enterprise Guide doesn't have permission to access the underlying folder in referenced in the LIBNAME statement. Can you verify with the systems administrator that this userid has full read/write access to the folder on the operating system level?

 

If you use IWA (Integrated Windows Authorization) to log into Enterprise Guide, then this SAS note may help: http://support.sas.com/kb/41/477.html
Even though this document references SAS 9.2, this should still apply for a SAS 9.4 environment.

If you need more assistance, then please consider sending email stating the issue to support@sas.com, which will open a ticket with SAS Technical Support. A consultant will be glad to assist you.

View solution in original post


All Replies
Solution
a week ago
SAS Employee
Posts: 11

Re: "An unexpected error has occurred" after double-clicking on a library

Posted in reply to JenniferLB08

Can you open a program editor in Enterprise Guide (File - new - program) and manually submit a LIBNAME statement to the same location you created in SMC (instead of clicking on the library)?

 

After submitting the LIBNAME statement to the same location on the SAS server, are you able to expand the library and open tables? If you encounter the same authorization error, it indicates that the userid being used in Enterprise Guide doesn't have permission to access the underlying folder in referenced in the LIBNAME statement. Can you verify with the systems administrator that this userid has full read/write access to the folder on the operating system level?

 

If you use IWA (Integrated Windows Authorization) to log into Enterprise Guide, then this SAS note may help: http://support.sas.com/kb/41/477.html
Even though this document references SAS 9.2, this should still apply for a SAS 9.4 environment.

If you need more assistance, then please consider sending email stating the issue to support@sas.com, which will open a ticket with SAS Technical Support. A consultant will be glad to assist you.

Occasional Contributor
Posts: 6

Re: "An unexpected error has occurred" after double-clicking on a library

Thank you for the quick reply and your help. I think the issue was the user ID in EG. I found a video that helped me change the credentials I was using and I can now see the libraries in EG. 

In case anyone needs it, the video I used is titled 'Work with a Connection Profile" and is linked here.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 118 views
  • 0 likes
  • 2 in conversation