Hello,
need immediate solution
i have some sas tables & code in particular sas library but im getting this error.
Thank You.
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.
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.
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
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
GETTING THIS ERROR
ERROR: The METALIB engine cannot be found.
ERROR: Error in the LIBNAME statement.
Thank U
Oh, it should read:
libname test meta library="<your library metadata name>" libdebug;
Ah yes. Typo while reading off another screen. That was severely untested code. Sorry for that.
there any solution last one is not working ....thank u
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>" ;
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.