TPT scripts

Tools & Utilities

TPT scripts

Currently I have TPT scripts which transfers data from schema1 (Teradata  box1) to schema2 (Teradata box2). There is a plan to move the contents of Teradata Box2 to Oracle.

Will the TPT scripts written can be reused to tranfer data to Oracle. If so does it require any major changes to be done to make it work for Oracle. If not what is the alternate way?

Thanks,

4 REPLIES
Teradata Employee

Re: TPT scripts

TPT only loads Teradata.

-- SteveF

Re: TPT scripts

Hi feinholz ... i have a trouble with TPT 14.10... yesterday i was upgrade the TTU's 13.10 to 14.10 in a linux server.. and when the users rus the comand tbuild they have the next error... :

Teradata Parallel Transporter Version 14.10.00.00

Teradata Parallel Transporter SQL DDL Operator Version 14.10.00.00

DDL_OPERATOR: private log specified: log_ins_LNDCRM_HOGCUP_M

DDL_OPERATOR: connecting sessions

DDL_OPERATOR: The RDBMS retryable error code list was not found

DDL_OPERATOR: The job will use its internal retryable error codes

DDL_OPERATOR: sending SQL requests

DDL_OPERATOR: TPT10508: RDBMS error 3807: Object 'TD_STGEDW.LNDCRM_HOGCUP_M_LOG' does not exist.

DDL_OPERATOR: TPT18046: Warning: error is ignored as requested in ErrorList

DDL_OPERATOR: TPT10508: RDBMS error 3807: Object 'TD_STGEDW.LNDCRM_HOGCUP_M_ERR1' does not exist.

DDL_OPERATOR: TPT18046: Warning: error is ignored as requested in ErrorList

DDL_OPERATOR: TPT10508: RDBMS error 3807: Object 'TD_STGEDW.LNDCRM_HOGCUP_M_ERR2' does not exist.

DDL_OPERATOR: TPT18046: Warning: error is ignored as requested in ErrorList

DDL_OPERATOR: disconnecting sessions

DDL_OPERATOR: Total processor time used = '0.04 Second(s)'

DDL_OPERATOR: Start : Mon Sep 15 13:32:37 2014

DDL_OPERATOR: End : Mon Sep 15 13:32:37 2014

Job step Setup_Tables completed successfully

Teradata Parallel Transporter Load Operator Version 14.10.00.00

LOAD_OPERATOR: private log not specified

Teradata Parallel Transporter FILE_READER: TPT19006 Version 14.10.00.00

FILE_READER: TPT19003 NotifyMethod: 'None (default)'

FILE_READER: TPT19008 DataConnector Producer operator Instances: 1

FILE_READER: TPT19003 ECI operator ID: FILE_READER-6458

FILE_READER: TPT19232 Multi-instance read feature requested via attribute 'MultipleReaders'. Disallowed because file count is > 1 or (#) instances is equal to 1

LOAD_OPERATOR: connecting sessions

LOAD_OPERATOR: The RDBMS retryable error code list was not found

LOAD_OPERATOR: The job will use its internal retryable error codes

LOAD_OPERATOR: preparing target table

LOAD_OPERATOR: entering Acquisition Phase

LOAD_OPERATOR: disconnecting sessions

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

LOAD_OPERATOR: Start : Mon Sep 15 13:32:38 2014

LOAD_OPERATOR: End : Mon Sep 15 13:32:40 2014

Job step Load_Table terminated (status 12)

Job 6543 terminated (status 12)

Job start: Mon Sep 15 13:32:35 2014

Job end: Mon Sep 15 13:32:40 2014

[root@mxchkaloatlap01 scripts]# ls

Can you help me please to know what happend!!

Teradata Employee

Re: TPT scripts

First, was you intent to use the MultipleReaders feature?

If so, then please upgrade to the latest patch for 14.10.

If not, then please do not set that attribute.

-- SteveF
Teradata Employee

Re: TPT scripts

Update: please upgrade to the latest patch. I believe it is 14.10.00.06.

-- SteveF