In-Database Error - The object name is too long in NFD/NFC when connected to Teradata
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi
I had the same error. Try avoiding shortforms for select (sel) ,delete (del) ,etc.
It worked for me .
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you. Removing spaces worked
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Finally something worked for me. Thanks!

- « Previous
-
- 1
- 2
- Next »