Desktop productivity for business analysts and programmers

The library could not be assigned by SAS Server

Reply
Occasional Contributor
Posts: 15

The library could not be assigned by SAS Server

Hello,

 

need immediate solution

 

i have some sas tables & code in particular sas library but im getting this error.

 

 

Thank You.

Attachment
Super Contributor
Posts: 406

Re: The library could not be assigned by SAS Server

[ Edited ]

Hi Vishu,

 

Did you click the "Show details" button? Often this gives good insight as to what the underlyhing issue is. Please share that info with us.

 

Regards, Jan.

Esteemed Advisor
Posts: 5,198

Re: The library could not be assigned by SAS Server

What about checking "Show details"?

What kind of library is it?

It's not pre-assigned?

Does this happen for every user?

Authorization?

Search the metadata server & object spawner log for any more clues.

Data never sleeps
Occasional Contributor
Posts: 15

Re: The library could not be assigned by SAS Server

yes i checked with show details checkbox.

 

it shows

[Error] Error trying to establish connection: Unable to Initialize: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

 

--------------------------- Technical Information Follows ------------------------------

SAS.EG.SDS.SDSException: <?xml version="1.0" ?><Exceptions><Exception><SASMessage severity="Error">Error trying to establish connection: Unable to Initialize: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.</SASMessage></Exception></Exceptions>
   at SAS.EG.SDS.Model.Library.Assign()
   at SAS.EG.SDS.Model.Library.PopulateDatasets(Collection& collection)
   at SAS.EG.SDS.Model.Broker.PopulateCollection(Collection collection)
   at SAS.EG.SDS.Model.Collection.DoPopulate()
   at SAS.EG.SDS.Model.Collection.Populate()
   at SAS.EG.SDS.Views.View.DoPopulate(DisplayOperation& op)

------------------------------ End of Technical Information -----

 

 

This issue is occuring for every user as Linush said..

 

 

thnx Linush & Jklaverstijn

Super Contributor
Posts: 406

Re: The library could not be assigned by SAS Server

Well there you have it. For some reason (many possibilities) you cannot get to the data in SQL Server as specified in the metadata. You will probably need to work with your trusted DBA to figure this one out. One hint I can give you:

 

Run this code from within EG. Insert the actual name of the library between the quotes:

libname test metalib library="<your library metadata name>"  libdebug;

 

This will give you the current info used to assign the library from metadata.

 

Hope this helps,

- Jan

Occasional Contributor
Posts: 15

Re: The library could not be assigned by SAS Server

 GETTING THIS ERROR

 

ERROR: The METALIB engine cannot be found.

ERROR: Error in the LIBNAME statement.

 

 

 

Thank U

Esteemed Advisor
Posts: 5,198

Re: The library could not be assigned by SAS Server

Oh, it should read:

libname test meta library="<your library metadata name>"  libdebug;
Data never sleeps
Super Contributor
Posts: 406

Re: The library could not be assigned by SAS Server

Ah yes. Typo while reading off another screen. That was severely untested code. Sorry for that.

Occasional Contributor
Posts: 15

Re: The library could not be assigned by SAS Server

there any solution last one is not working ....thank u

Respected Advisor
Posts: 3,063

Re: The library could not be assigned by SAS Server

[ Edited ]

Try assigning a test LIBNAME without involving metadata. Does it work? If it does then your problem is with the metadata version. If it doesn't work then you need to get this right first before considering your metadata definition.

 

libname test "<your data library path>" ;

 

Super Contributor
Posts: 406

Re: The library could not be assigned by SAS Server

[ Edited ]

Hi Vishnu,

We cannot provide a solution based on what we know. And it requires knowledge of your local installation. The best approach imho is still to run

libname test meta library="<your library metadata name>" libdebug;



Print out the log and take that to your local (database) support people.

Good luck,
- Jan.

 

Esteemed Advisor
Posts: 5,198

Re: The library could not be assigned by SAS Server

It was just a test.
Have this ever worked? If so, what has changed?
As @jklaverstijn said, the SAS Admin and SQL Server DBA should work close together to solve this.
If there's anything wrong in the meta data, it's hard for us to trouble shoot. So if you can't find what's wrong, maybe it's simpler to register the schema and library from scratch based on the guides available in the documentation and published papers.
Data never sleeps
Ask a Question
Discussion stats
  • 11 replies
  • 931 views
  • 4 likes
  • 4 in conversation