BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
sathya66
Barite | Level 11

All,
I am getting below error with the pre-assigned library to register tables in SMC. If I remove pre-assigned library tick box in SMC then it is working fine not sure what is the issue.
it is a JDBC library
ERROR is showing it is not assigned but actually it is pre-assigned
libname rh_test list;
ERROR: Libref RH_TEST is not assigned.

1 ACCEPTED SOLUTION

Accepted Solutions
sathya66
Barite | Level 11
All,

Solved this by adding double quotes in theJDBC server connection information (ie:double quotes in the URL,Drivercalss and in Classpath).

Thanks for your help.

View solution in original post

16 REPLIES 16
Kurt_Bremser
Super User

You need to have the necessary permissions on the library object in metadata, otherwise the pre-assign can't be done when the workspace server starts with your userid.

sathya66
Barite | Level 11
thanks,
I have admin rights on Metadata (unrestricted user)
gwootton
SAS Super FREQ
It sounds like the library is failing to assign on startup. I usually troubleshoot this by turning off preassignment and attempting to assign the library in Enterprise Guide by right-clicking and choosing "Assign" to see what error is returned.
--
Greg Wootton | Principal Systems Technical Support Engineer
sathya66
Barite | Level 11

I am getting below error see screenshot below(screenshot3 without pre-assigned libraray).

I have admin rights , When I  selected pre-assigned ,I don't see the library in EG(screenshot 1) but if I remove pre-asign library tick box then I can see it from EG(screenshot 2)

 

screenshot 1:

 

sathya66_2-1622639970507.png

screenshot 2:

sathya66_1-1622639849651.png

screenshot 3:

sathya66_0-1622639662179.png

 

gwootton
SAS Super FREQ
It is not visible in EG when preassigned because the preassignment is failing. If you right-click on the library in SMC when logged in as this user and select "Display LIBNAME statement", copy the statement and run it in EG, does it return a more detailed error?
--
Greg Wootton | Principal Systems Technical Support Engineer
sathya66
Barite | Level 11

I tested this approach  and It works fine if I use display libname and copy that code into EG.(as it uses different credentials )

 

Back ground for this

 

This is a group JDBC library(so we have one user and password) so I created an authentication domain to use this library and created a group ( in the accounts tab is  using authentication domain user )

and also setup JDBC server and setup JDBC connection.

I have added my user into this group, 

 

Am I missing something

 

 

gwootton
SAS Super FREQ
I would expect the "Display LIBNAME" function to return the same group credentials unless you also have something stored for the auth domain under your user ID. Are you logging into SAS Management Console with the same user you are using to log in to Enterprise Guide?
--
Greg Wootton | Principal Systems Technical Support Engineer
sathya66
Barite | Level 11
Yes, I am loggging into SAS Management Console with the same user I am using to log in to Enterprise Guide.
gwootton
SAS Super FREQ
Are these other credentials stored under your user directly? Does it pre-assign successfully if you use a user that is not unrestricted?
--
Greg Wootton | Principal Systems Technical Support Engineer
sathya66
Barite | Level 11
Yes, defaultAuth and Teradata Auth in my account. Same issue for every user.
gwootton
SAS Super FREQ
Are either of those the functional credentials being returned by the display libname function? It sounds like the problem is with the stored credentials / authentication domain configuration, but I'm not clear on why the credentials in the display libname function would be functional or different than those being used by SAS when it tries to assign during preassignment. Where are those credentials being returned by display libname that are functional stored?
--
Greg Wootton | Principal Systems Technical Support Engineer
PaulHomes
Rhodochrosite | Level 12

Also, double check you are not logging into SAS EG as an unrestricted user as unrestricted users cannot fetch valid stored login passwords from metadata (they always get 8 asterisks).

sathya66
Barite | Level 11

If I try to register a table it is working with unassigned library ( by unticking the assign library) that means it is extracting the correct credentials from the AUTH domain.but not working in SAS EG (ie right click on the library and then assign)

tried with normal user and it is not working for him either.

I am just thinking, it is not using jdbc engine name( SASIOJDB or JDBC) in the libaname statement see below

libname rh_test list;

 

should be like below ?

 

libname  SASIOJDB rh_test list;

sathya66
Barite | Level 11

and If I try to assign metadata library ,I am getting below error

 

libname rh_test meta library=rh_test;


ERROR 22-7: Invalid option name OPT.
ERROR 22-7: Invalid option name :.
ERROR: Libref RH_TEST is not assigned.
ERROR: Error in the LIBNAME statement.

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 16 replies
  • 2804 views
  • 5 likes
  • 4 in conversation