All Forums Tools
gangadharan 6 posts Joined 08/11
15 Sep 2011
TPT Crashed

Hi,

 we have an automated TPT job which is running sucessfully for past 8 months but from last week we are getting some errors like disconnecting sessions. So please let me know below details.

 

1. Is it possible for TPT to corrupt? if yesm how i can fix this issue

2. below is the error, if any one you have encountered this issue, please let me know the solution

Attempting to restart (3)
Teradata Parallel Transporter Export Operator Version 13.00.00.07
W_0_o_TDDS_WKH_RTL_SMTH: private log not specified
Teradata Parallel Transporter Load Operator Version 13.00.00.08
W_1_o_TDDS_WKH_RTL_SMTH: private log not specified
W_0_o_TDDS_WKH_RTL_SMTH: connecting sessions
W_1_o_TDDS_WKH_RTL_SMTH: TPT10551: CLI '207' occurred while connecting to the RDBMS
W_1_o_TDDS_WKH_RTL_SMTH: TPT10507: CLI Error 207: MTDP: EM_NETCONN(207): Error in doing a network connect.
W_1_o_TDDS_WKH_RTL_SMTH: TPT10562: Fatal Error from DBCHQE in determining Logon Mechanism support
W_1_o_TDDS_WKH_RTL_SMTH: Total processor time used = '0.01 Second(s)'
W_1_o_TDDS_WKH_RTL_SMTH: Start : Tue Sep 13 06:13:30 2011
W_1_o_TDDS_WKH_RTL_SMTH: End   : Tue Sep 13 06:13:40 2011
W_0_o_TDDS_WKH_RTL_SMTH: disconnecting sessions
W_0_o_TDDS_WKH_RTL_SMTH: Total processor time used = '0.03 Second(s)'
W_0_o_TDDS_WKH_RTL_SMTH: Start : Tue Sep 13 06:13:30 2011
W_0_o_TDDS_WKH_RTL_SMTH: End   : Tue Sep 13 06:13:41 2011
Attempting to restart (4)

 

 

feinholz 1234 posts Joined 05/08
21 Sep 2011

That error indicates an inability for the TPT operator to connect to the given TdpId (Teradata database).

On the same machine from which you are running TPT, can you connect to the same database using BTEQ?

(This is not due to a corrupt TPT. The error message indicates a CLI error of 207. You can read more about the error in the error messages manual.)

--SteveF

12 Jun 2012

I have similar issue and my TPT job reads from a file.  After attempting to restart 3 times the TPT process just hung.  Is there a setting or timeout or something that we can set so that the TPT job will fail after 3 attempts?

 

Teradata Parallel Transporter Version 13.00.00.16
Job log: /pret04_etl/log/tbuild/logs/D_SHIP_INFO.9.chkpt-1128.out
Job id is D_SHIP_INFO.9.chkpt-1128, running on edwpret04
Teradata Parallel Transporter DataConnector Version 13.00.00.16
FILE_READER_OPERATOR DataConnector Producer operator Instances: 1
Teradata Parallel Transporter Load Operator Version 13.00.00.08
LOAD_OPERATOR: private log not specified
FILE_READER_OPERATOR Operator instance 1 processing file '/tmp/CONTR_DM.D_SHIP_INFO.dat'.
LOAD_OPERATOR: connecting sessions
FILE_READER_OPERATOR Total files processed: 0.
LOAD_OPERATOR: disconnecting sessions
LOAD_OPERATOR: Total processor time used = '0.192427 Second(s)'
LOAD_OPERATOR: Start : Mon Jun 11 15:14:37 2012
LOAD_OPERATOR: End   : Mon Jun 11 15:17:37 2012
Attempting to restart (1)
Teradata Parallel Transporter DataConnector Version 13.00.00.16
FILE_READER_OPERATOR Instance 1 restarting.
FILE_READER_OPERATOR DataConnector Producer operator Instances: 1
Teradata Parallel Transporter Load Operator Version 13.00.00.08
LOAD_OPERATOR: private log not specified
LOAD_OPERATOR: connecting sessions
LOAD_OPERATOR: disconnecting sessions
FILE_READER_OPERATOR Total files processed: 0.
LOAD_OPERATOR: Total processor time used = '0.228496 Second(s)'
LOAD_OPERATOR: Start : Mon Jun 11 15:17:39 2012
LOAD_OPERATOR: End   : Mon Jun 11 15:19:29 2012
Attempting to restart (2)
Teradata Parallel Transporter Load Operator Version 13.00.00.08
LOAD_OPERATOR: private log not specified
Teradata Parallel Transporter DataConnector Version 13.00.00.16
FILE_READER_OPERATOR Instance 1 restarting.
FILE_READER_OPERATOR DataConnector Producer operator Instances: 1
LOAD_OPERATOR: connecting sessions
FILE_READER_OPERATOR Total files processed: 0.
LOAD_OPERATOR: disconnecting sessions
LOAD_OPERATOR: Total processor time used = '0.238495 Second(s)'
LOAD_OPERATOR: Start : Mon Jun 11 15:19:33 2012
LOAD_OPERATOR: End   : Mon Jun 11 15:20:59 2012
Attempting to restart (3)
Teradata Parallel Transporter Load Operator Version 13.00.00.08
LOAD_OPERATOR: private log not specified
Teradata Parallel Transporter DataConnector Version 13.00.00.16
FILE_READER_OPERATOR Instance 1 restarting.
FILE_READER_OPERATOR DataConnector Producer operator Instances: 1
LOAD_OPERATOR: connecting sessions
LOAD_OPERATOR: preparing target table
LOAD_OPERATOR: entering Acquisition Phase
 

feinholz 1234 posts Joined 05/08
12 Jun 2012

Open an incident with the GSC. There is not enough information in the post to identify the exact problem.

The other thing you should do (first) is to upgrade to the latest and greatest patches of TPT and all of its components.

That should always be the first step, in case bugs have been fixed since the last time you installed TPT.

--SteveF

You must sign in to leave a comment.