All Forums Teradata Studio
04 Jun 2015
Load Limit of 50K Rows in v15.10

I just upgraded to v15.10 of Studio Express 64-bit.  During a load operation, where I right-clicked on a table in the DSE and used Load, the log indicates:

Load Task

Loading data...

Starting Load...

Load Successful.

367075 Rows Processed

367075 Rows Loaded

 

But when I check it only has 50,000 rows.  I've looked for some setting in Preferences that enforces a limit, but couldn't find anything.  How can I fix this?

 

Thanks

Mike
dnoeth 4628 posts Joined 11/04
04 Jun 2015

How did you check it, SELECT COUNT(*) FROM tab?

Dieter

04 Jun 2015

Yes, and I also use RazorSQL for queries and checked it there, too.  I also used the right-click in the DSE.  In RazorSQL I loaded all available rows just to be sure, and there's only 50K.

Mike

dnoeth 4628 posts Joined 11/04
04 Jun 2015

Is the target table a SET table and FastLoad removed duplicate rows silently?

Dieter

04 Jun 2015

At first, I defined the table as multiset, assigned a primary index and tried loading.  When I had these issues, I even let Smart Load scan the input text file and build the table.  It still got stuck at 50K rows.  There really shouldn't be duplicates.
Mike

Mike

04 Jun 2015

I can always cut up input files into 50K chunks and load each one individually, but that's not much fun.  If there isn't some hidden setting, I'll try uninstalling and re-installing.

Mike

04 Jun 2015

I uninstalled and re-installed 15.10.00.01.201504291406, then deleted rows from the table and tried loading it.  Again, I get stuck at 50,000 rows, even though the log says all 367K rows were loaded.  I'm using TTU 14.10.  JDBC options for Studio Express are CHARSET=UTF8 and TMODE=ANSI.
If there's no solution to this I'll have to downgrade to the previous version.

Mike

fgrimmer 553 posts Joined 04/09
04 Jun 2015

Mike, We have fixed this problem and should have a patch release out very soon.

04 Jun 2015

OK, thanks, Francine.  I'm still downgrading until there's a fix.  I use Studio Express Fastload almost every day, usually for large files.

Mike

dnoeth 4628 posts Joined 11/04
04 Jun 2015

I just tried it and it's the same bug in Studio 15.10.00.201504221135 on my Mac :-)

Dieter

04 Jun 2015

I was successful loading the table with 15.00.02.201411070423.  Weird.

Mike

04 Jun 2015

In Windows 7.

Mike

vchen 1 post Joined 07/14
23 Jun 2015

Is there any update on when this patch is going out? Or are there links to previous Terdata versions that don't have this bug?
Thanks.

You must sign in to leave a comment.