05-10-2018 10:53 AM
I’m trying to use the tasks > data > download feature of Enterprise Guide to download a table. However the physical name of the library the table points to is not the same thing as the library name (the table use to be in another library) , so when I cannot locate the table to export it. When I tried changing the physical name to match I can see the table however Enterprise Gide throws the error
ERROR: File EAARL.PUBLIC.DATA does not exist.
ERROR: The metadata for the table/view EAARL.PUBLIC does not exist.
05-11-2018 07:09 PM
Do you register your SAS tables in SAS metadata, because that is what your error is suggesting. If you rename a table without deleting the metadata definition for the old table and then create a new one that is the sort of error you would likely get. I avoid metadata registration of tables to prevent running into these type of issues.
You can check if you have these tables registered in SAS Management Console.
05-14-2018 09:10 AM
Yes, the table is registered in Metadata. I believe I need to register it in Metadata in order to work with the table in Data Integration Studio.
05-14-2018 05:29 PM
OK, then when you rename a physical table you need to delete the original metadata registration and re-create it with the new name.