topic Re: Database Libraries not Visible in SAS EG after upgrade in SAS Programming

Database Libraries not Visible in SAS EG after upgrade

sewa_bal_gmail_com — Wed, 08 Apr 2020 18:23:02 GMT

Dear All,

We are facing issues while migrating sas 9.3 to 9.4. We are able to connect to the oracle without any error. However unable to see the oracle libraries in SAS EG.

FYI... All other libraries I can see on SAS EG.

Re: Database Libraries not Visible in SAS EG after upgrade

sewa_bal_gmail_com — Thu, 09 Apr 2020 13:49:23 GMT

Can anyone please update on this?

Re: Database Libraries not Visible in SAS EG after upgrade

Tom — Thu, 09 Apr 2020 14:00:18 GMT

What is an Oracle library?

Do you mean that your previous installation you had defined some SAS librefs that were automatically created when Enterprise Guide started a new SAS session on your SAS application server?

If so then recreate that on your new setup.

Re: Database Libraries not Visible in SAS EG after upgrade

sewa_bal_gmail_com — Thu, 09 Apr 2020 14:06:39 GMT

We have defined the oracle library in sas metadata again and also registered the tables after new setup. I can see a list of tables under oracle lib in metadata.

SAS libname name assigned to oracle lib without any error and when I clicked on lib I can't see any tables listed in sasapp server.

Re: Database Libraries not Visible in SAS EG after upgrade

LeonidBatkhan — Thu, 09 Apr 2020 16:10:56 GMT

You need to make sure your Oracle library has ReadMetadata and Read permissions granted to SASUSERS - those SAS users who are registered in the Metadata.