fastload says paused, and select * from file says "is being Loaded"

Tools & Utilities
Enthusiast

fastload says paused, and select * from file says "is being Loaded"

This my first time using FASTLOAD.  It hangs. I am clueless.

Thanks for any help. I really appreciate the help I get on this site.

-Jim

 

 

Untitled.png

 

 

 

 

Untitled.png 

 

 

Untitled.png

 

Untitled.pngUntitled.pngUntitled.png


Accepted Solutions
Teradata Employee

Re: fastload says paused, and select * from file says "is being Loaded"

You used the term "hang". I do not see the job as hanging.

The job terminated with an error.

The job is in a paused state because if the error is corrected, the job can be resubmitted and it will resume.

With the FastLoad protocol, when a job is paused, the target table is locked.

The table remains locked until the job completes.

 

Now, as to why the job terminated with an error, please look at the data file and see if there are any extra characters at the end of each record. The last field is defined as VARCHAR(2), and it "looks" as if the data is correct, but if there are extraneous blanks (space characters) that we cannot see, it might lead to the error you are getting.

 

-- SteveF
1 ACCEPTED SOLUTION
2 REPLIES
Teradata Employee

Re: fastload says paused, and select * from file says "is being Loaded"

You used the term "hang". I do not see the job as hanging.

The job terminated with an error.

The job is in a paused state because if the error is corrected, the job can be resubmitted and it will resume.

With the FastLoad protocol, when a job is paused, the target table is locked.

The table remains locked until the job completes.

 

Now, as to why the job terminated with an error, please look at the data file and see if there are any extra characters at the end of each record. The last field is defined as VARCHAR(2), and it "looks" as if the data is correct, but if there are extraneous blanks (space characters) that we cannot see, it might lead to the error you are getting.

 

-- SteveF
Highlighted
Enthusiast

Re: fastload says paused, and select * from file says "is being Loaded"

yep, had spaces at end of line..  Thanks Mr Feinholz....