Update library metadata tool error

[skarnew]

Hi,

i've a table who's metadata registred in a library but don't have corresponding physcial table existing.

My library is pre-assigned by metadata engine.

When i try to use Update library metadata tool, option report content of library as registred in the metadata repository, I got this error, why?

NOTE: Libref C_PA was successfully assigned as follows:
Engine: META
Physical Name: d:\dwh\PA\CDS\Data

ERROR: File C_PA.PERIOD_BASE.DATA does not exist.
ERROR: The metadata for the table/view C_PA.PERIOD_BASE does not exist.

Documentation says "

Option NameDescription

Report on the contents of the library, as registered in the metadata repository

generates a report of the library's contents based on the table definitions in the metadata repository

Thanks

[Sajid01]

Hello @skarnew 
Your library is referencing a physical location d:\dwh\PA\CDS\Data and there are no tables existing.
From the error message it appears that you are trying to perform some operation on the non-existent table /dataset PERIOD_BASE. The error message is apparently correct.
What exactly are you trying to do?

[SASKiwi]

You can't update a table's registered metadata definition if the underlying table does not exist. Either delete the table's metadata definition or recreate the underlying physical table so that the update metadata process can work successfully. 

[skarnew]

Hi,

many thanks, so the documentation is not accurate.

So when a create a duplicate another table and renamed it as PERIOD_BASE it said 

ERROR: Variable ABSENCE_ID is not on file C_PA.PERIOD_BASE.

So i don't understand what is the purpose of the option 

apparently SAS look  on physical table rather than the metada repository

Why this action is named like this then? It's confusing...

[SASKiwi]

Personally I've never found any great benefit to registering SAS tables in metadata so we simply don't do it.

Maybe the second option in your screenshot is more useful  - to report differences between the metadata definitions and the physical tables.

[skarnew]

Hi Kiwi,

many thanks for your answer. I´m working with data integration studio so working with metadata is mandatory.

Yes your proposition to use the second option in the menu what my first attempt but as I get error I switch to thé first option.

Finally the problem was comming from metadata table with the same name, same physical name but one colum has different lenght. No other choice to take à look to the tables one by one.