TPT script loading issue

Tools & Utilities
Enthusiast

Re: TPT script loading issue

Hi Feinholz,

Can you plz visit the below link, where in i have posted few of my queries. i was not sure of where to post the same.

http://forums.teradata.com/forum/tools/teradata-pt-12-0-error-output-schema-does-not-match#comment-1...

Thanks in advance,

Regards,

Sam

Enthusiast

Re: TPT script loading issue

Hi Feinholz,

Please provide your valuable inputs.....

I am getting the below error, when trying to load to a TD empty table: -

LOAD_OPERATOR: preparing target table

LOAD_OPERATOR: entering Acquisition Phase

LOAD_OPERATOR: entering Application Phase

LOAD_OPERATOR: Statistics for Target Table:  'abc.load_table_name'

LOAD_OPERATOR: Total Rows Sent To RDBMS:      1

LOAD_OPERATOR: Total Rows Applied:            0

LOAD_OPERATOR: Total Possible Duplicate Rows: 1

LOAD_OPERATOR: disconnecting sessions

FILE_READER: TPT19221 Total files processed: 1.

LOAD_OPERATOR: Total processor time used = '5.01691 Second(s)'

LOAD_OPERATOR: Start : Mon Mar 26 12:15:16 2012

LOAD_OPERATOR: End   : Mon Mar 26 12:35:10 2012

Job step load_data_from_file completed successfully

Job c1513506 completed successfully

The Error tables are getting deleted automatically as the job is getting successfully executed.

So Can you please, specify any link or doc wherein i can get the entire set of common errors & their solutions.

Regards,

Sam

Teradata Employee

Re: TPT script loading issue

I do not see an error message from that output.

You will probably have to look at the entire log (with the tlogview utility) to see more about why the row may have been rejected.

-- SteveF

Re: TPT script loading issue

I am using export and update operator in a TPT script.Primary Index alone is defined in my target table(Not-UPI).I don't get any error while executing the TPT script.But while loading the target table,the exported rows are not getting inserted.

I want to insert all the exported rows,even if they are duplicates.

PFB the output of the TPT script.

Teradata Parallel Transporter Update Operator Version 13.10.00.04

UPDATE_OPERATOR: private log specified: Loadoper_privatelog

Teradata Parallel Transporter Export Operator Version 13.10.00.05

EXPORT_OPERATOR: private log specified: exportoper_privatelog

EXPORT_OPERATOR: connecting sessions

UPDATE_OPERATOR: connecting sessions

UPDATE_OPERATOR: preparing target table(s)

UPDATE_OPERATOR: entering DML Phase

UPDATE_OPERATOR: entering Acquisition Phase

EXPORT_OPERATOR: sending SELECT request

EXPORT_OPERATOR: entering End Export Phase

EXPORT_OPERATOR: Total Rows Exported:  4

UPDATE_OPERATOR: entering Application Phase

UPDATE_OPERATOR: Statistics for Target Table:  'student_2'

UPDATE_OPERATOR: Rows Inserted: 0

UPDATE_OPERATOR: Rows Updated:  0

UPDATE_OPERATOR: Rows Deleted:  0

UPDATE_OPERATOR: entering Cleanup Phase

UPDATE_OPERATOR: disconnecting sessions

EXPORT_OPERATOR: disconnecting sessions

EXPORT_OPERATOR: Total processor time used = '0.36 Second(s)'

Kindly help in resolving this issue.

Regards,

Barathe G.

Teradata Employee

Re: TPT script loading issue

Is your target table a SET table, or a MULTISET table? It must be a MULTISET Table in order to load duplicates.

You will need to look at the rest of the log to see where the rows are. They might be in one of the error tables.

-- SteveF
Enthusiast

Re: TPT script loading issue

Hi Fieholz,

I am having multiset target table with only primary index defined. Still duplicate records are not getting loaded when i use the following script. I would be be grateful to you, if you can throw some light on this.

USING CHARACTER SET UTF8
DEFINE JOB MOVE_DATA_WITHOUT_LANDING_TO_DISK
DESCRIPTION 'MOVE DATA WITHOUT LANDING THE DATA TO DISK'
(
DEFINE SCHEMA SCHEMA_NAME
   (
   COLUMN1 INTEGER,
COLUMN2 VARCHAR(384),
COLUMN3 VARCHAR(1500),
COLUMN4 VARCHAR(240),
COLUMN5 VARCHAR(240)

    );
   /*** Export Operator Definition ***/
 
   DEFINE OPERATOR EXPORT_OPERATOR
    DESCRIPTION 'TERADATA PARALLEL TRANSPORTER EXPORT OPERATOR'
    TYPE EXPORT
    SCHEMA PLT_IWH_BASE
    ATTRIBUTES
    (
      VARCHAR PrivateLogName = 'exportoper_privatelog',
       INTEGER MaxSessions    =  8,
       INTEGER MinSessions,
       VARCHAR TdpId          = 'XXXX',
       VARCHAR UserName       = 'XXXX',
       VARCHAR UserPassword   = 'XXXX',
       VARCHAR SelectStmt     = 'SELECT COLUMN1,
COLUMN2,
COLUMN3,
COLUMN4
 from SRC_DB_NAME.TABLE_NAME;'
    );
    /*** Load Operator Definition ***/

    DEFINE OPERATOR LOAD_OPERATOR   
    DESCRIPTION 'TERADATA PARALLEL TRANSPORTER LOAD OPERATOR'
    TYPE LOAD
    SCHEMA SCHEMA_NAME
    ATTRIBUTES
    (  VARCHAR PrivateLogName = 'loadoper_privatelog',
       INTEGER MaxSessions    = 16,
       INTEGER MinSessions,
       VARCHAR TargetTable    = 'TGT_DB_NAME.TABLE_NAME',
       VARCHAR TdpId          = 'XXXXX',
       VARCHAR UserName       = 'XXX',
       VARCHAR UserPassword   = 'XXX',
       VARCHAR ErrorTable1    = 'ERRTABLE1',
       VARCHAR ErrorTable2    = 'ERRTABLE2',
        VARCHAR LogTable      = 'LOGTABLE'
           );
 
   /*** Apply Statement ***/
   APPLY
    ('INSERT INTO TGT_DB_NAME.TABLE_NAME
(
:COLUMN1,
:COLUMN2,
:COLUMN3,
:COLUMN4
);')
    TO OPERATOR (LOAD_OPERATOR [1])
 
   SELECT * FROM OPERATOR (EXPORT_OPERATOR [2]);
 
);
Supporter

Re: TPT script loading issue

Fastload (or TPT load operator) doesn't load duplicated rows, no matter if table is SET or MULTISET  (NoPI tables are an exception to this).

If you need to load duplicates you must use multiload (or TPT update operator)

Cheers.

Carlos.

Highlighted
Enthusiast

Re: TPT script loading issue

Many Thanks CarlosAL.

Using UPDATE operetaor, the duplicates got loaded.

I am loading a set of tables and only few tables contain duplicate data. Trying to analyze the performance difference b/w LOAD and UPDATE operator.