SAS EG error unable to load library items

[woo]

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.  

[SASKiwi]

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.

[woo]

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

[SASKiwi]

@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?

[gwootton]

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)"?

[woo]

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

[gwootton]

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

[woo]

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

[gwootton]

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.

[woo]

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

[woo · Accepted solution]

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.