Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Fri, 16 Nov 2012 @ 19:41:38 GMT


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


Subj:   Re: TPUMP running very very slow
 
From:   Bakthavachalam, Roopalini

Hi Forum,

Thanks for the responses. The Informatica consultant made the job work and the table is getting loaded at 500 records per second. However , when I try to run it from the Teradata server , I get the error - " Attempted to access out of range input data in felid....". I used the same script that Informatica generated to load the file. How is Informatica loading it fine and I run into the error when running from Teradata?

     **** 11:54:38 UTY6608 Import 1 begins.
     **** 11:54:38 UTY4203 Attempted to access out of range input data in field
          'COMMISSION_CODE', file

     'C:\Test\Test\Four_Seasons\Reservation_Daily_Element_Name_test.csv',record
          number '3'.

     ------------------------------------------------------------------------
     -
     -      Logoff/Disconnect
     -
     ------------------------------------------------------------------------
     **** 11:54:38 UTY6215 The restart log table has NOT been dropped.
     **** 11:54:38 UTY6212 A successful disconnect was made from the RDBMS.
     **** 11:54:38 UTY2410 Total processor time used = '0.187201 Seconds'
          .       Start : 11:54:33 - FRI NOV 16, 2012
          .       End   : 11:54:38 - FRI NOV 16, 2012
          .       Highest return code encountered = '12'.

Thanks

Roopalini



     
  <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: 28 Jun 2020