All Forums Database
realrx7 17 posts Joined 06/12
21 Jun 2012
CREATE TABLE Failed [3737] Name requires more than 30 bytes in LATIN internal form???

Here is what I have that is causing the error........

 

CREATE MULTISET TABLE DLAB_MARKETING.Click,

NO FALLBACK,

NO BEFORE JOURNAL,

NO AFTER JOURNAL,

CHECKSUM = DEFAULT,

DEFAULT MERGEBLOCKRATIO

(

AccountID INTEGER,

OYBAccountID INTEGER,

JobID INTEGER,

ListID INTEGER,

BatchID INTEGER,

SubscriberID INTEGER,

SubscriberKey VARCHAR(100),

EventDate DATE,

URL VARCHAR(900),

LinkName VARCHAR(1024),

LinkContent VARCHAR(1000),

TriggeredSendDefinitionObjectID VARCHAR(36),

TriggeredSendCustomerKey VARCHAR(36)

)

PRIMARY INDEX (AccountID);

Dixxie 47 posts Joined 12/10
21 Jun 2012

Hi realrx7, 

Te problem is with the column name TriggeredSendDefinitionObjectID , this has more than 30 characters.

3737 - Name is longer than 30 characters.

Regards.

realrx7 17 posts Joined 06/12
21 Jun 2012

Thanks!!

ersin.gulbahar 3 posts Joined 06/13
14 Jul 2013

Hi my table name is 26 characters and my column names are not more than 30 chars.
but I got this error :[Error 3737] [SQLState 42000] Name requires more than 30 bytes in LATIN

dnoeth 3267 posts Joined 11/04
14 Jul 2013

 

Your tablename is probably too long, when you check http://developer.teradata.com/doc/connectivity/jdbc/reference/current/jdbcug_chapter_2.html#BABIIEAG you'll find
JDBC FastLoad creates two temporary error tables with the following naming convention: ._ERR_1 and ._ERR_2
and
The name of the destination table in the Teradata Database that is to be used by JDBC FastLoad CSV must not exceed 24 characters because of the name of the two error tables created by JDBC FastLoad CSV
If this was a standard FastLoad i would simply add ERRORTABLES and use my own error table names, but this seems not to be available in JDBC FastLoad. So your only option is to create the table with a shorter name, FastLoad it and thensubmit a RENAME TABLE.
 
Dieter

 

Dieter

Sourabh_Rox 2 posts Joined 08/13
30 Aug 2013

My Largets column name is 29 char long. still i am facing the same error.
SELECT Failed 3737: Name requires more than 30 bytes in LATIN internal form.
thanks.

dnoeth 3267 posts Joined 11/04
30 Aug 2013

Based on the error message this seems to be a SELECT, could you show it (or at least the column names/aliases used)?
 
Dieter

Dieter

You must sign in to leave a comment.