All Forums Database
anjunair 13 posts Joined 04/12
07 Aug 2012
Missing record on loading table with Fastload

Hi,

I have a .txt file which is pipe separated and it has 543895 rows. Duplicate records are avoided by putting a serial number at the end of every row.

Its UTF-8 encoded. On running the fastload script, I had got the error ": EOF encountered before end of record" and on reading another post in this forum I added a new line at the end of my last record, after which the fastload script was running fine. But one of my records is not loaded into table, since it was found to be a duplicate record.

 

 Total Records Read              =  543895

     Total Error Table 1             =  0  ---- Table has been dropped

     Total Error Table 2             =  0  ---- Table has been dropped

     Total Inserts Applied           =  543894

     Total Duplicate Rows            =  1

 

But I fail to understand how a duplicate record can be found despite adding a unique serial number at the end of every row.

 

If any one of you could please help, I'd be much obliged.

 

Thanks,

anju

ulrich 816 posts Joined 09/09
07 Aug 2012

What you descriped is indicating that the serial number process has one dup value.

Can you share the file?

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

You must sign in to leave a comment.