All Forums Tools
raju197402 2 posts Joined 08/14
14 Aug 2014
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,

feinholz 1234 posts Joined 05/08
20 Aug 2014

TPT only loads Teradata.
 

--SteveF

SANTOYO09 2 posts Joined 07/14
17 Sep 2014

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!!

feinholz 1234 posts Joined 05/08
24 Sep 2014

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

feinholz 1234 posts Joined 05/08
24 Sep 2014

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

--SteveF

You must sign in to leave a comment.