All Forums Tools
ursgovi 8 posts Joined 04/12
10 Aug 2012
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

feinholz 1234 posts Joined 05/08
15 Aug 2012

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

 

--SteveF

You must sign in to leave a comment.