 |
 |
Archives of the TeradataForum
Message Posted: Mon, 10 Jun 2013 @ 17:19:33 GMT
| 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
| |
