topic Re: SAS Metadata DB Library tables not appearing in Administration and Deployment

SAS Metadata DB Library tables not appearing

shoin — Fri, 19 Apr 2024 16:32:27 GMT

Hello all, 1 machine SAS 9.4 M8 install, one specific issue seen

Issue: SAS Meta ODBC data libraries established, (Oracle & DB2, lets called them db2 & ora data libraries, all using their own AuthDomain and CLI and odbc.ini are set). The issue is in EG is the library db2 or ora is expanded no tables appear. However, the relevant LIBNAME when run successfully execute and tables appear.

Checks done:

Checked for user's privilege and permissions OS, DB grants, and Metadata permission) all valid and at minimum have RM and read
Checked effective permissions in Metadata > Authorization > Advanced > Explore Authorization for the user = look good as expected.
Data server assignments of connection server and data library all look okay.

Anyone has any idea what else I could look at?

TIA

Re: SAS Metadata DB Library tables not appearing

carl_sommer — Fri, 19 Apr 2024 17:53:42 GMT

By "relevant libname statement", do you mean the libname you can view from SAS Management Console when you right-click on the library and select Display LIBNAME statement...? Or do you mean something using the META libname engine?

The latter is what you really need to try. Let's assume the name of the registered library is MYLIB. What do you get when you submit LIBNAME test META LIBRARY="MYLIB" libdebug ;

Carl Sommer - SAS Technical Support

Re: SAS Metadata DB Library tables not appearing

shoin — Fri, 19 Apr 2024 19:23:24 GMT

Ty for the suggestion Carl.

I meant using 'meta' libname or even a ODBC based libname they execute fine (using their own auth-domain).

I have not generated the libname string from SMC (I will)

I will do the test and update. TY very much for your time!

Re: SAS Metadata DB Library tables not appearing

Sajid01 — Sat, 20 Apr 2024 23:20:15 GMT

Hello @shoin

Thanks for the question.Two questions.
Have you preassigned the libraries?
Did anybody pointed to the library with mouse pointer and right clicked to assign the library? Did this work?

Re: SAS Metadata DB Library tables not appearing

SASKiwi — Sun, 21 Apr 2024 20:06:23 GMT

To get tables to appear in the EG servers panel for metadata-defined external database libraries you need to do either of these two things:

Register the tables in SAS metadata
Add the AssignMode option = 2 to the library's extended attributes

Settling the AssgnMode is by far the easier option:

Note, only table names that don't exceed 32 characters will show.

Re: SAS Metadata DB Library tables not appearing

shoin — Mon, 22 Apr 2024 18:24:30 GMT

TY, AssignMode did it 🙂

Re: SAS Metadata DB Library tables not appearing

SASKiwi — Mon, 22 Apr 2024 20:08:28 GMT

@shoin - Glad to hear it worked. In my experience, this is not a very well known option and it took me some considerable time to find many years ago.

Re: SAS Metadata DB Library tables not appearing

shoin — Tue, 23 Apr 2024 19:06:09 GMT

I am with you, I discovered it recently too on another project, but totally did not consider, wasn't there a metaautoinit type option (my memory fails me) and did not place it this new way, TY for the memory jog & for your time 🙂