02-29-2016 03:47 AM - edited 02-29-2016 03:48 AM
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.
8 The SAS System 10:13 Monday, February 29, 2016
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);
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
02-29-2016 06:17 AM
I think so, cause I am able to register it , but i am not able to update it. In fact I cannot update any of my tables.
Need further help from the community? Please ask a new question.