topic Re: Pre-assigned library issue in Metadata to register tables in Administration and Deployment

Pre-assigned library issue in Metadata to register tables

sathya66 — Tue, 01 Jun 2021 12:57:29 GMT

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.

Re: Pre-assigned library issue in Metadata to register tables

Kurt_Bremser — Tue, 01 Jun 2021 13:10:59 GMT

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.

Re: Pre-assigned library issue in Metadata to register tables

sathya66 — Wed, 02 Jun 2021 11:02:31 GMT

thanks,
I have admin rights on Metadata (unrestricted user)

Re: Pre-assigned library issue in Metadata to register tables

gwootton — Wed, 02 Jun 2021 12:46:28 GMT

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.

Re: Pre-assigned library issue in Metadata to register tables

sathya66 — Wed, 02 Jun 2021 13:21:36 GMT

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:

screenshot 2:

screenshot 3:

Re: Pre-assigned library issue in Metadata to register tables

gwootton — Wed, 02 Jun 2021 13:35:14 GMT

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?

Re: Pre-assigned library issue in Metadata to register tables

sathya66 — Wed, 02 Jun 2021 14:17:02 GMT

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

Re: Pre-assigned library issue in Metadata to register tables

gwootton — Wed, 02 Jun 2021 14:22:36 GMT

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?

Re: Pre-assigned library issue in Metadata to register tables

sathya66 — Wed, 02 Jun 2021 14:27:13 GMT

Yes, I am loggging into SAS Management Console with the same user I am using to log in to Enterprise Guide.

Re: Pre-assigned library issue in Metadata to register tables

gwootton — Wed, 02 Jun 2021 14:29:36 GMT

Are these other credentials stored under your user directly? Does it pre-assign successfully if you use a user that is not unrestricted?

Re: Pre-assigned library issue in Metadata to register tables

sathya66 — Wed, 02 Jun 2021 14:34:11 GMT

Yes, defaultAuth and Teradata Auth in my account. Same issue for every user.

Re: Pre-assigned library issue in Metadata to register tables

gwootton — Wed, 02 Jun 2021 14:39:48 GMT

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?

Re: Pre-assigned library issue in Metadata to register tables

PaulHomes — Wed, 02 Jun 2021 22:00:14 GMT

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).

Re: Pre-assigned library issue in Metadata to register tables

Kurt_Bremser — Thu, 03 Jun 2021 05:02:09 GMT

@sathya66 wrote:
thanks,
I have admin rights on Metadata (unrestricted user)

Unrestricted users are used for administration, they are NOT used for work.

Re: Pre-assigned library issue in Metadata to register tables

sathya66 — Tue, 08 Jun 2021 12:15:01 GMT

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;

Re: Pre-assigned library issue in Metadata to register tables

sathya66 — Tue, 08 Jun 2021 14:15:29 GMT

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.

Re: Pre-assigned library issue in Metadata to register tables

sathya66 — Mon, 21 Jun 2021 12:00:28 GMT

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.