Load Limit of 50K Rows in v15.10

Teradata Studio
Enthusiast

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

12 REPLIES
Senior Apprentice

Re: Load Limit of 50K Rows in v15.10

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

Enthusiast

Re: Load Limit of 50K Rows in v15.10

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.

Senior Apprentice

Re: Load Limit of 50K Rows in v15.10

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

Enthusiast

Re: Load Limit of 50K Rows in v15.10

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

Enthusiast

Re: Load Limit of 50K Rows in v15.10

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.

Enthusiast

Re: Load Limit of 50K Rows in v15.10

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.

Teradata Employee

Re: Load Limit of 50K Rows in v15.10

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

Enthusiast

Re: Load Limit of 50K Rows in v15.10

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

Senior Apprentice

Re: Load Limit of 50K Rows in v15.10

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