Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   MultiLoad Acquisition Phase Hangs
 
From:   Mani, Vijay

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016