BookmarkSubscribeRSS Feed
ruturaj72
Fluorite | Level 6

Hi ,

Hearty Greetings.

 

unable to update metadata of one oracle table , registered in the library.

It does not throw an error, it just shows a note : 1 Table not found in either metadata or source mentioned in select/exclude statement.

 

NB :

1. Table is present at the Oracle DB.

2. I am able to register the table with the very same credential I am using to update.

3. All of the accesses are permitted to the library,table, and metadata folder structure.

4. Methods used to update 

                                    A : SAS Management console

                                    B : Proc Metalib in EG

 

Requesting response/help/suggestion .

🙂

1 REPLY 1
JuanS_OCS
Amethyst | Level 16

Hello @ruturaj72,

 

I would investigate a bit further, about the metadata and db permissions of the user who actually registers the table, and the one who updates the table. Check the permissions on the data and metadata (including folders and library)

 

Perhaps also worth to check the options set for the library. Sometimes just an option makes a difference, such as the case sensitivity or the symbols. 

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 1036 views
  • 1 like
  • 2 in conversation