Archives of the TeradataForum

Message Posted: Thu, 27 Jun 2013 @ 20:14:35 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi team,

Not sure if anyone is face this issue in TPT, the job is getting hang in Acquisition phase form more than 10+ hours. This issue occurs when the tpt is trying to restart the connection (not sure the reason for disconnectiong sessions). When the job restarts it is getting hang in Acquisition phase. We use named pipe as input and ttu is running in AIX server.

     log -
     File_Reader: TPT19008 DataConnector Producer operator Instances: 1 Teradata Parallel Transporter Load Operator Version 13.10.00.04
     File_Loader: private log not specified
     File_Reader: TPT19003 ECI operator ID: File_Reader-58982638
     File_Loader: connecting sessions
     File_Reader: TPT19222 Operator instance 1 processing file '/wrk/prd/tmp/dw/icdw/temp_pipe'.
     File_Loader: disconnecting sessions
     File_Loader: Total processor time used = '0.218175 Second(s)'
     File_Loader: Start : Wed Jun 26 01:31:47 2013
     File_Loader: End   : Wed Jun 26 01:32:03 2013
     File_Reader: TPT19221 Total files processed: 0.
     Attempting to restart (1)
     Teradata Parallel Transporter DataConnector Version 13.10.00.08 File_Reader Instance 1 restarting.
     File_Reader: TPT19008 DataConnector Producer operator Instances: 1 Teradata Parallel Transporter Load Operator Version 13.10.00.04
     File_Loader: private log not specified
     File_Reader: TPT19003 ECI operator ID: File_Reader-34930706
     File_Loader: connecting sessions
     File_Loader: preparing target table
     File_Loader: entering Acquisition Phase
     ----------------------

But when we kill the job and rerun the job the job is running fine..

Can someone please provide some inputs on this. ?

Thanks,

Vijay Mani

	<Prev	Next>		<<First	<Prev	Next>	Last>>