Hello, I am using SAS DI 4.9. If I register a table from mysql library everything is OK. But if i try to udate the metadata for already registered table i have an error. Any solution? 8 The SAS System 10:13 Monday, February 29, 2016 68 69 proc metalib; 70 omr (libid='B50000S0' repid='A54TRPEC'); 71 update_rule = (noadd); 72 report(type = summary); 73 dbauth(dbuser='sas_system' dbpassword=XXXXXXXXXX); 74 select (A54TRPEC.BJ001071); 75 run; ERROR: Prepare error: Table 'eol.OFFICES' doesn't exist SQL statement: SHOW index FROM `OFFICES`. NOTE: A total of 1 tables were analyzed for library "A.01. EOL". NOTE: Metadata for 0 tables was updated. NOTE: Metadata for 0 tables matched the data sources. NOTE: 0 tables listed in the SELECT or EXCLUDE statement were not found in either the metadata or the data source. NOTE: 1 other tables were not processed due to error or UPDATE_RULE. NOTE: The SAS System stopped processing this step because of errors. NOTE: The PROCEDURE METALIB printed page 6. NOTE: PROCEDURE METALIB used (Total process time): real time 0.15 seconds cpu time 0.06 seconds
... View more