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
I've found the problem. The physical table name was not with capital letters. Thank you for the answer anyway.
Hi,
probably it is an stupid question:
does this table (and his index) exist, still, in the MySQL databse/schema?
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.
And can you register new tables?
Yes.
I've found the problem. The physical table name was not with capital letters. Thank you for the answer anyway.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.