Do not work the Teradata FASTLOAD wizard of teradata studio express.

Tools

Do not work the Teradata FASTLOAD wizard of teradata studio express.

Hi at all.

Can somebody help me, I have the folllwing problem.

I'm trying to use the Fastload utility with teradata studio express SQL Assistant but I have this Error:

Error inserting data. Check the teradata SQL History for Details.

Caused by: Teradata Load Error: Batch is empty

Moreover in the "Teradata SQL History" label of the teradata studio express in the section note the following message is reported:

Starting Teradata Load...

Teradata Load Error Occurred: Error Code =  0

SQL State = null

Message = Teradata Load Error: Batch is empty.

1009 Rows Processed

0 Rows Loaded

Teradata Load Failed

Row number 2 had an error.

Cause = Unexpected number of parameters

Row number 3 had an error.

Cause = Unexpected number of parameters

Row number 4 had an error.

Cause = Unexpected number of parameters

Row number 5 had an error.

Cause = Unexpected number of parameters

Row number 6 had an error.

Cause = Unexpected number of parameters

Row number 7 had an error.

Cause = Unexpected number of parameters

.....

.....

.....

......

up to row 1009.

 Note: in teradata studio express when we make right click on the mouse we can choose  the following two options for loading data;

  1. LOAD
  2. TERADATA LOAD

I wanto to preface that i do not know the difference between 1. and 2. but the error above reported is related to point 2., that is, when I use TERADATA LOAD option.

2 REPLIES

Re: Do not work the Teradata FASTLOAD wizard of teradata studio express.

In the TERADATA LOAD option I specify and insert all options that wizard requires as the source data file, File Type (.txt, .csv, etc.),  Column Delimiter(comma, tab, pipe, etc) and Character String delimiter.

So, I do not understand what is the batch file wich it requires me in the error message.  I'm new with Teradata Data base.

Regards.

Re: Do not work the Teradata FASTLOAD wizard of teradata studio express.

Good morning at all

I resolved the problem. I've got to going see in the source data file and the fields of it do not match with table fields.