Issue

The following error appears while connecting to a Teradata database:

F_JD22A1: DBMS error \[' ' ('0A'X) is not a valid Teradata SQL token\]. DBMS error number \[-3704\]. SQL State \[42000\]. DBMS version \[15.10.0301 15.10.03.01\]

Environment

Local Data Processing

Answer

This error is caused by a problem in the Teradata ODBC driver version 15.10. See: http://community.teradata.com/t5/Database/Teradata-Error-3704-0A-X-is-not-a-valid-Teradata-SQL-token/td-p/49648

The solution/workaround is to downgrade the ODBC driver to 15.00.