topic Re: SAS EG error unable to load library items in Administration and Deployment

SAS EG error unable to load library items

woo — Thu, 21 Oct 2021 04:03:16 GMT

I have one oracle library defined in SMC as below,

Assign: SASApp + SASAppVA

Not-preassigned

Authorization:

oracle access grp: RM/WM/Read (with grayed out permission)

SASUSERS: RM/WM/Read/Write

Now, when we try to expand this library from EG, it says,

unable to load the library's items

The library could not be assigned by the SAS server

Server Response: invalid or missing "delimiter" or" defaultvalue" attributes value from property object with "usevalueonly" attributes set to FALSE. Metadata incorrect.

Re: SAS EG error unable to load library items

SASKiwi — Thu, 21 Oct 2021 04:17:13 GMT

Does this work OK in a LIBNAME statement connecting to the same Oracle server, database and schema? If it does then it is a metadata setup problem. If it doesn't then it is an Oracle settings or permissions problem.

Re: SAS EG error unable to load library items

woo — Thu, 21 Oct 2021 12:48:49 GMT

yes, we can connect with libname statement. What kind of metadata setup could be wrong?

Re: SAS EG error unable to load library items

gwootton — Thu, 21 Oct 2021 13:31:17 GMT

This error can occur if the credentials are incorrect. When you assign successfully with the LIBNAME statement are you using the AUTHDOMAIN option or manually specifying the credentials? In the library's properties Data Server tab, is "Default Login" set to "(none)"?

Re: SAS EG error unable to load library items

woo — Thu, 21 Oct 2021 13:49:13 GMT

Manually assigning credentials in the libname statement and "default login" set to none on "Data Server" tab.

Re: SAS EG error unable to load library items

gwootton — Thu, 21 Oct 2021 13:51:49 GMT

Does using the AUTHDOMAIN= fail when using a libname statement? This should use the credentials you have stored.

Re: SAS EG error unable to load library items

woo — Thu, 21 Oct 2021 13:51:50 GMT

also, on "authorization" tab we have oracle group assigned to that connection and on group definition, for "Accounts" tab, we have,

Authentication Domain=OraAuth

User id=xyz

password=xyz

Re: SAS EG error unable to load library items

woo — Thu, 21 Oct 2021 21:56:07 GMT

i tested and all libraries assigned fine using authdomain as well, not sure what is missing,

Re: SAS EG error unable to load library items

SASKiwi — Thu, 21 Oct 2021 22:31:05 GMT

@woo - From the look of the errors it looks like a metadata permissions problem. Does the metadata-defined library work for any users or none at all? If it works for some then what are the permission differences between users?

Re: SAS EG error unable to load library items

gwootton — Fri, 22 Oct 2021 13:04:24 GMT

If using libname with authdomain= works, issue is not with the stored credentials. You may need to recreate your database server and library in SAS Management Console to resolve the issue with it's definition. SAS Technical Support may be able to help narrow down what the issue with the library/server definition is triggering the error.

Re: SAS EG error unable to load library items

woo — Tue, 16 Nov 2021 20:10:49 GMT

Thanks everyone. So issue was, we were missing few details,

"server manager" -> highlight oracle server definition, on right hand pan, right click on "Connection: xyzoracle" and go to properties -> options tab --> update path + authentication type + Auth Domain. And then you should be good to go.