Architecting, installing and maintaining your SAS environment

SAS EG library issue

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 12
Accepted Solution

SAS EG library issue

Hi friends. we are on 9.4 M_3. we recently migrated from M_2. we asked our users to test the functionality of EG. for one of our users the following error message appeared:

 

"Multiple libraries detected in metadata that use same libref for server sasapp. This is not supported configuration and may be casue problems."

 

Please advise!!!!


Accepted Solutions
Solution
‎11-18-2016 01:51 PM
Super User
Posts: 6,971

Re: SAS EG library issue

In SAS Management Console, use the Data Library Manager and scan through all defined libraries to find the multiple librefs.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers

View solution in original post


All Replies
Occasional Contributor
Posts: 12

SAS EG library issue

Hi friends. we are on 9.4 M_3. we recently migrated from M_2. we asked our users to test the functionality of EG. for one of our users the following error message appeared:

 

"Multiple libraries detected in metadata that use same libref for server sasapp. This is not supported configuration and may be casue problems."

 

Please advise!!!!

Solution
‎11-18-2016 01:51 PM
Super User
Posts: 6,971

Re: SAS EG library issue

In SAS Management Console, use the Data Library Manager and scan through all defined libraries to find the multiple librefs.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Super User
Posts: 6,971

Re: SAS EG library issue

PS if that is the problem of one user, he probably has defined a library for himself that uses the same libref that a "global" library for all users has.

That is the reason why I disabled the use of the SAS Enterprise Guide Explorer and the function "Update Library Metadata" for J. Random User here. Grew tired of having to delete surplus library definitions.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Occasional Contributor
Posts: 12

Re: SAS EG library issue

Hi Kurt. Thank you for the solution. How to disable the use of the SAS Enterprise Guide Explorer and the function "Update Library Metadata". Are there any backdrops doing this? Please advise
Super User
Posts: 6,971

Re: SAS EG library issue


littley wrote:
Hi Kurt. Thank you for the solution. How to disable the use of the SAS Enterprise Guide Explorer and the function "Update Library Metadata". Are there any backdrops doing this? Please advise

You do this in SAS Management Console, User Manager.

Your "average" users should have one of the "Enterprise Guide" roles assigned to their group (or individually).

In this role, de-select the functions "Enterprise Guide (version) - Tools and Help - Update Library Metadata" and "Enterprise Guide (version) - Tools and Help - Access SAS Enterprise Guide Explorer".

Or copy the role to a new one, give it an appropriate name, do the changes there and assign that role instead of the default one.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Super User
Posts: 3,115

Re: SAS EG library issue

In SAS Management Console, check all data libraries by viewing their properties to confirm where the duplicate LIBREF is defined.

Occasional Contributor
Posts: 12

Re: SAS EG library issue

Hi. Your solution worked for me. Thanks a lot

☑ This topic is solved.

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

Discussion stats
  • 7 replies
  • 597 views
  • 3 likes
  • 3 in conversation