Archives of the TeradataForum

Message Posted: Mon, 17 Jun 2013 @ 22:47:09 GMT

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

Hi ,

We use TPT update operator to load the table. (Teradata Parallel Transporter Update Operator Version 13.10.00.04) Sometimes the mload is hanging on the Acquisition Phase for several hours; We use mkfifo for reading the unix compressed file. I am not able get the exact issue here.

Can you someone help me in understanding the issue.

     Job id is Table1_20130615-26271, running on s41f200v01 Teradata Parallel Transporter
     DataConnector Version 13.10.00.08
     File_Reader: TPT19008 DataConnector Producer operator Instances: 1 Teradata Parallel
     Transporter Update Operator Version 13.10.00.04
     File_Loader: private log not specified
     File_Reader: TPT19003 ECI operator ID: File_Reader-41025602
     File_Loader: connecting sessions
     File_Reader: TPT19222 Operator instance 1 processing file '/wrk/prd/tmp/dw/icdw/Table1_pipe'.
     File_Loader: TPT10508: RDBMS error 2633: Too many load/unload tasks running: try again later
     File_Loader: Load/unload task limit exceeded, try connecting again later
     File_Loader: Tenacity enabled; retry logon every 6 minute(s) for 4 hour(s)
     File_Loader: disconnecting sessions
     File_Loader: Total processor time used = '0.452933 Second(s)'
     File_Loader: Start : Mon Jun 17 00:46:03 2013
     File_Loader: End?? : Mon Jun 17 01:10:10 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 Update Operator Version 13.10.00.04
     File_Loader: private log not specified
     File_Reader: TPT19003 ECI operator ID: File_Reader-41025604
     File_Loader: connecting sessions
     File_Loader: preparing target table(s)
     File_Loader: entering DML Phase
     File_Loader: entering Acquisition Phase

Thanks,

Vijay Mani

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