All Forums Tools
malli 10 posts Joined 08/12
08 May 2014
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 14.10.00.04
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
 

feinholz 1234 posts Joined 05/08
08 May 2014

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

You must sign in to leave a comment.