Table name xxxx_xxxx_xxxxx_xxxx_xxx_xxx is greater than 27 characters

[AaronMacPhail]

Hello Everyone,

I am working on a flow that writes to a backup table in Tdata and I receive the following error from my output tool. 

Info: Output Data (7): ODBC Driver version: 03.80

Error: Output Data (7): Table Name xxxx_xxxx_xxxxx_xxxx_xxx_xxx is greater than 27 characters; Log and Error Tables won't be able to be created.

I was able to create the table just fine and I can write to it in SQL assistant.

Any insight is appreciated!

Thank You

[jrgo · Accepted solution]

@AaronMacPhail,

Looking at Alteryx's help doc for Teradata, it seems to be a limitation to the Bulk Loader's API service.

https://help.alteryx.com/11.7/index.htm#TeradataBCP.htm

As it mentions, if your table name is longer than 27chars then you'll need to specify an alternate name for your log/error tables which looks like can be specified in the output tools option as shown below.

Hope this helps!

Jimmy