Troubleshooting > Troubleshooting DataConnect > Execution of SQL statement failed
Was this helpful?
Execution of SQL statement failed
 
Error Code
4
Error Message
Exec SQL failed: SQL Statement <SELECT_Statement>. Check log for more details.
Description
This execution error may be displayed when executing SQL select statements like SELECT "column1", "column2" FROM "user"."table_name". This error is usually displayed for connectors like Actian X, Actian Ingress, and Actian Vector.
Cause/Solution
Cause: You are not the owner of the table that you are trying to select. For example, if you have selected a table created by user01 (user01.tbl) and the credentials you have entered are of user02 (a different user), then on running the map, you will receive this error.
Solution: Provide correct credentials and make sure that you have the access to the table that you have selected.
Related Information
Last modified date: 10/22/2024