Summary
The user is encountering a SQLException indicating that a view in MySQL references invalid objects or lacks necessary permissions during the connection setup to PostgreSQL.
Question
Hi,
I am having a successful source and destination setup and where i am facing the below error while connection creation.
source : - MYSQL
destination : - postgreSQL
Error: Internal message: java.sql.SQLException: View ‘Database_name.emp_vw’ references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Failure type: system_error
This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.