Receive log message 'com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table '<schema>.missing' doesn't exist'

Good day KNIME users/experts.

I created a workflow that transfers table to table data (source to target) from Mysql to Postgres.
Tablenames are listed in a text file and read via CSV reader. I used the column0 as a variable to be passed during loop and be accessed by DB Table Selector node and passed thru DB Reader. The process went well but it keeps logging the ff. message :

WARN DB Table Selector 0:5 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table ‘schema.missing’ doesn’t exist.

Is there a way to fix this issue or is it a bug log?

Looking forward to your response.

Attached is the workflow screenshot for your assessment and review.

Thank you

Hello csarsonas,
this is only a warning that occurs when the DB Table Selector node tries to check if the selected table exists in the DB during configure but the flow variable values aren’t set and thus missing. You can disable the metadata fetching and thus the checking during configure by deselecting the “Retrieve in configure” option in the Advanced tab of the MySQL Connector node.
Bye
Tobias

3 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.