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 28 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!!

You must sign in to leave a comment.