Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

In-Database Error - The object name is too long in NFD/NFC when connected to Teradata

FogoFortitude
7 - Meteor

I get the below error message in my workflow when doing any of the following: 

  • Using the Filter Tool to peform any column based filter eg apply IS NOT NULL on a column
  • Using the Data Stream Out Tool to the standard select tool
  • Using the InDB Browse Tool

 

Error: Data Stream Out (57): Error SQLPrepare: [Teradata][ODBC Teradata Driver][Teradata Database] The object name is too long in NFD/NFC.

14 REPLIES 14
cheangvi
7 - Meteor

I found the cause (as I missed one of the posts), I had a TAB character straight after the SELECT statement, seemed to have resolved the issue (yay).

I am using In-DB tools with Teradata.

 

m1patri
5 - Atom

Comments do not seem to create this error. I managed to get the error to generate by not having a [space] between my select statement and the next command. For example while using the syntax for select all: "Select*" - Error,  "Select *" - No error. The missing space appears to confuse Alteryx but not an SQL interface. In addition I placed comments before the select statement using various syntax methods, I also placed them throughout the SQL editor and the comments did not appear to change the Error message result at all.

lakshmysatheesh
5 - Atom

Hi 

 

I had the same error. Try avoiding shortforms for select (sel) ,delete (del) ,etc.

It worked for me .

 

Thanks 

grenjith7
5 - Atom

Thank you. Removing spaces worked

TJ
5 - Atom

Finally something worked for me. Thanks!

Labels