BookmarkSubscribeRSS Feed
vishu
Fluorite | Level 6

Hello,

 

need immediate solution

 

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

 

 

Thank You.


Capture.JPG
11 REPLIES 11
jklaverstijn
Rhodochrosite | Level 12

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.

LinusH
Tourmaline | Level 20

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
vishu
Fluorite | Level 6

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

jklaverstijn
Rhodochrosite | Level 12

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

vishu
Fluorite | Level 6

 GETTING THIS ERROR

 

ERROR: The METALIB engine cannot be found.

ERROR: Error in the LIBNAME statement.

 

 

 

Thank U

LinusH
Tourmaline | Level 20

Oh, it should read:

libname test meta library="<your library metadata name>"  libdebug;
Data never sleeps
jklaverstijn
Rhodochrosite | Level 12

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

vishu
Fluorite | Level 6

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

SASKiwi
PROC Star

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>" ;

 

jklaverstijn
Rhodochrosite | Level 12

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.

 

LinusH
Tourmaline | Level 20
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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

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

View all other training opportunities.

Discussion stats
  • 11 replies
  • 4909 views
  • 4 likes
  • 4 in conversation