TPT Crashed

Tools
Enthusiast

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)

3 REPLIES
Teradata Employee

Re: TPT Crashed

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

Re: TPT Crashed

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

Teradata Employee

Re: TPT Crashed

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