Need help on TPT


Need help on TPT

Getting the below  error  whicle loading data from file to table by TPT for CLOB datatypes columns .

OPLO_enb_acs_collectors_stg: private log specified: load_log

Teradata Parallel Transporter OPPRO_enb_acs_collectors_stg: TPT19006 Version

OPPRO_enb_acs_collectors_stg Instance 1 directing private log report to 'file_log-1'.

OPPRO_enb_acs_collectors_stg: TPT19003 NotifyMethod: 'None (default)'

OPPRO_enb_acs_collectors_stg: TPT19008 DataConnector Producer operator Instances: 1

OPPRO_enb_acs_collectors_stg: TPT19003 ECI operator ID: 'OPPRO_enb_acs_collectors_stg-9807'

OPPRO_enb_acs_collectors_stg: TPT19222 Operator instance 1 processing file 'collect.dat'.

OPLO_enb_acs_collectors_stg: connecting sessions

OPLO_enb_acs_collectors_stg: preparing target table

OPLO_enb_acs_collectors_stg: entering Acquisition Phase

OPLO_enb_acs_collectors_stg: TPT10508: RDBMS error 5685: FastLoad is not supported on LOB columns.

OPLO_enb_acs_collectors_stg: disconnecting sessions

Teradata Employee

Re: Need help on TPT

As the message says, the operator you are using does not support the loading of LOBs.

Only the SQL Inserter supports the loading of LOBs.

(This is a database restriction, not a TPT restriction.)

-- SteveF