Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 10 Jun 2013 @ 17:19:33 GMT


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


Subj:   FastLoad : Line rejected due to "Field too large"
 
From:   Aitsakel Rochdi

Hi guys,

I use Fasload tool with inmod option to load multiple files in a table. In the genereted log file,it traced that I have errors of type "Field too large in vartex data record" . But I didn't find these errors in error tables :

     **** 11:42:01 Number of recs/msg: 26
     **** 11:42:01 Starting to send to RDBMS with record 1 [ADM_ACC_inmod] - INFO - Mon Jun 10
     11:42:01 2013 - T[00000001] - Creation des queues et des threads [ADM_ACC_inmod] - INFO -
     Mon Jun 10 11:42:01 2013 - T[00000001] - Creation de la Listreader thread [ADM_ACC_inmod]
     - INFO - Mon Jun 10 11:42:01 2013 - T[00000001] - Creation de la datareader thread 0
     [ADM_ACC_inmod] - INFO - Mon Jun 10 11:42:01 2013 - T[00000001] - Creation de la
     datareader thread 1 [ADM_ACC_inmod] - INFO - Mon Jun 10 11:42:01 2013 - T[00000001] -
     Creation de la datareader thread 2 [ADM_ACC_inmod] - INFO - Mon Jun 10 11:42:02 2013 -
     T[00000001] - Creation de la datareader thread 3
     **** 11:42:02 Field too large in vartext data record: 1, field:
     FRARC_COLUMN_NAME_8
     **** 11:42:02 Field too large in vartext data record: 2, field:
     FRARC_COLUMN_NAME_9
     [ADM_ACC_inmod] - INFO - Mon Jun 10 11:42:02 2013 - T[00000001] - Fin de flux
     **** 11:42:02 Sending row 100
     **** 11:42:02 Finished sending rows to the RDBMS

     ------------------------------------------------------ ------------- - - - End Loading
     Phase - - - ------------------------------------------------------ -------------

     0010 END LOADING;

     **** 11:42:02 END LOADING COMPLETE

     Total Records Read = 100
     Total Error Table 1 = 0 ---- Table has been dropped Total Error Table 2 = 0 ---- Table
     has been dropped Total Inserts Applied = 98 Total Duplicate Rows = 0 Total Rejected Rows
     = 2

     Start: Mon Jun 10 11:42:02 2013
     End : Mon Jun 10 11:42:02 2013

     0011 LOGOFF

Thanks for your help



     
  <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