Solved

JDBC_34 - Query failed to execute

  • 8 October 2021
  • 1 reply
  • 32 views

Userlevel 1
  • StreamSets Employee
  • 0 replies

Troubleshooting and Resolution for JDBC_34 - Query failed to execute

icon

Best answer by Dash 11 October 2021, 22:38

View original

This topic has been closed for comments

1 reply

Userlevel 5
Badge +2

This error can occur when there is:

  • An issue with the structure of the query eg. WHERE clause or ORDER BY clause is required but is missing
  • Database object permissions are not correct

Verify that the query is correctly structured, and verify the permissions on the database objects that are being accessed.  Also, JDBC Query Consumer has an option to disable the validation query.  This will prevent validation, but may lead to other errors later in the Origin’s processing.