Tpump loader Error

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

Tpump loader Error

Rate Topic

Display Mode

Topic Options

Author

Message

UPENDRA.EX!LANT

Posted 9/23/2009 10:30:18 AM

Forum Member

Group: Forum Members
Last Login: 10/6/2009 11:47:18 AM
Posts: 27, Visits: 76

I got the following Error while executing a Tpump loader script.

**** 14:23:05 UTY3401 End of file was reached with an unbalanced number of quotes being found in the text.

Please suggest if anyone is familiar with this type of error

*

Post #16912

Arun Kumar K

Posted 10/27/2009 1:59:31 AM

Forum Guru

Group: Forum Members
Last Login: Yesterday @ 12:42:08 AM
Posts: 74, Visits: 32

Hi,
There may be 2 reasons why this may happen.
1. The last line of your input file is corrupted or has some special characters (printable or nonprintable) in it.
2. The last correct data line of your input file may have an unmatching number of quotes in it. It may happen due to UNICODE text if it is being supported in your loader job or simply because there is a fault with the data line you are trying to load.

Please check the exact data line being loaded, take it seperately to another data file and try loading it with a seperate job. You will be able to locate/isolate the exact data line causing the issue and rectify the issue and then continue your loading.

Strive to success.

Arun.

Post #17163

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 9:14pm