Database Libraries not Visible in SAS EG after upgrade

[sewa_bal_gmail_com]

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.

[sewa_bal_gmail_com]

Can anyone please update on this?

[Tom]

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.

[sewa_bal_gmail_com]

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.

[LeonidBatkhan]

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.