SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

PROC METALIB ERROR WHILE TRYING TO UPDATE MYSQL METADATA FOR TABLES

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 6
Accepted Solution

PROC METALIB ERROR WHILE TRYING TO UPDATE MYSQL METADATA FOR TABLES

[ Edited ]

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


Accepted Solutions
Solution
‎02-29-2016 06:36 AM
Occasional Contributor
Posts: 6

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

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

View solution in original post


All Replies
Trusted Advisor
Posts: 1,141

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

Hi,

 

probably it is an stupid question:

 

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

Occasional Contributor
Posts: 6

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

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.

Trusted Advisor
Posts: 1,141

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

And can you register new tables?

Occasional Contributor
Posts: 6

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

Yes.

Solution
‎02-29-2016 06:36 AM
Occasional Contributor
Posts: 6

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

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

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 5 replies
  • 543 views
  • 0 likes
  • 2 in conversation