TPT - LOAD_OPERATOR - Issue

Tools
Enthusiast

TPT - LOAD_OPERATOR - Issue

Hi,

I'm using a TPT with LOAD_OPERATOR to load a flat file (Format='Text') into an empty table.  I'm receiving the following error:

LOAD_OPERATOR: connecting sessions

LOAD_OPERATOR: preparing target table

LOAD_OPERATOR: entering Acquisition Phase

LOAD_OPERATOR: TPT10508: RDBMS error 3944: Data length is invalid for the data type.

LOAD_OPERATOR: disconnecting sessions

Here is the script i tried:

DEFINE JOB FILE_UPDATE

DESCRIPTION 'Load TD tables from a file'

(

 DEFINE SCHEMA MySchema

 ( MySchema goes here...... );

DEFINE OPERATOR FILE_READER

TYPE DATACONNECTOR PRODUCER

SCHEMA MySchema

ATTRIBUTES

(

  VARCHAR PrivateLogName,

  VARCHAR DirectoryPath,

  VARCHAR FileName = @filename,

  VARCHAR Format = 'TEXT',

  VARCHAR OpenMode = 'READ',

  VARCHAR IndicatorMode = 'N'

 );

DEFINE OPERATOR LOAD_OPERATOR

TYPE LOAD

SCHEMA *

ATTRIBUTES

(

  VARCHAR PrivateLogName ,

  VARCHAR TdpId        = @td_id,

  VARCHAR UserName     = @td_username,

  VARCHAR UserPassword = @userpassword,

  VARCHAR LogTable     = @logtable,

  VARCHAR TargetTable  = @targetable,

  VARCHAR ErrorTable1  = @errortable_et,

  VARCHAR ErrorTable2  = @errortable_uv,

  INTEGER TenacityHours = 4,

  INTEGER TenacitySleep = 10,

  INTEGER MaxSessions   = 8,

  INTEGER MinSessions   = 1

);

APPLY (my INSERT statement)

TO OPERATOR (LOAD_OPERATOR[1])

SELECT * FROM OPERATOR (FILE_READER[1]);

);

It would be really helpful if someone could share your understanding and thereby help me solving this situation. 

Thanks,

Govi

Tags (3)
1 REPLY
Teradata Employee

Re: TPT - LOAD_OPERATOR - Issue

Please provide the schema and a sample of your input data.

-- SteveF