Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!

Error, "The object name is too long in NFD/NFC" when connecting to Teradata

Alteryx
Alteryx
Created

Environment Details


When connecting to Teradata with the Input Data tool in Designer, the following error occurs:

Error SQLPrepare: [Teradata][ODBC Teradata Driver][Teradata Database] The object name is too long in NFD/NFC.

 

  • Alteryx Designer
    • All Versions
  • Teradata
    • All Version
  • Teradata ODBC
    • All Versions

 



Cause


There are SQL comments above the SELECT statement within the Connect In-DB or Input Data tool query box.

OR

There are other Data Manipulation Language (DML) statements other than the SELECT statement in the main SQL query field. (i.e. UPDATE, CREATE, etc.)



Resolution


Remove all comments from the SQL query or ensure there are no extra spaces before the SELECT statement.

Specifically for the Input Data tool, if needing to put other DML statements such as an UPDATE statement, utilize the the Pre or Post SQL Statement fields in the properties section.

 

idea Skyscrapers

For more details on Teradata Bulk connections with Teradata, please see the Alteryx Help documentation.