topic Re: PROC METALIB ERROR WHILE TRYING TO UPDATE MYSQL METADATA FOR TABLES in SAS Data Management

PROC METALIB ERROR WHILE TRYING TO UPDATE MYSQL METADATA FOR TABLES

svenikol — Mon, 29 Feb 2016 08:48:30 GMT

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

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

Re: PROC METALIB ERROR WHILE TRYING TO UPDATE MYSQL METADATA FOR TABLES

JuanS_OCS — Mon, 29 Feb 2016 11:03:02 GMT

Hi,

probably it is an stupid question:

does this table (and his index) exist, still, in the MySQL databse/schema?

Re: PROC METALIB ERROR WHILE TRYING TO UPDATE MYSQL METADATA FOR TABLES

svenikol — Mon, 29 Feb 2016 11:17:02 GMT

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.

Re: PROC METALIB ERROR WHILE TRYING TO UPDATE MYSQL METADATA FOR TABLES

JuanS_OCS — Mon, 29 Feb 2016 11:23:50 GMT

And can you register new tables?

Re: PROC METALIB ERROR WHILE TRYING TO UPDATE MYSQL METADATA FOR TABLES

svenikol — Mon, 29 Feb 2016 11:29:29 GMT

Yes.

Re: PROC METALIB ERROR WHILE TRYING TO UPDATE MYSQL METADATA FOR TABLES

svenikol — Mon, 29 Feb 2016 11:35:11 GMT

I've found the problem. The physical table name was not with capital letters. Thank you for the answer anyway.