topic Re: Update library metadata tool error in SAS Enterprise Guide

Update library metadata tool error

skarnew — Fri, 01 Mar 2024 09:02:37 GMT

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

Re: Update library metadata tool error

Sajid01 — Fri, 01 Mar 2024 15:11:38 GMT

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?

Re: Update library metadata tool error

SASKiwi — Tue, 05 Mar 2024 00:41:02 GMT

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.

Re: Update library metadata tool error

skarnew — Wed, 06 Mar 2024 09:07:12 GMT

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...

Re: Update library metadata tool error

SASKiwi — Fri, 08 Mar 2024 03:44:06 GMT

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.

Re: Update library metadata tool error

skarnew — Tue, 19 Mar 2024 10:18:15 GMT

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.