Failure 2673 The source parcel length does not match data that was defined.

Database
Enthusiast

Failure 2673 The source parcel length does not match data that was defined.

Hello,

I created a flat file and now need to load that data to teradata table. But while importing the script was facing "Failure 2673 The source parcel length does not match data that was defined error"

My data in the file :

rahul 100

richa 200

riya   300

myra 400

Import Script :

.logon 127.0.0.1/dbc,dbc

.SET REPEATSTOP ON

.import  vartext ' ' file=/root/richa/tdpgms/example.out

.quiet on

.repeat *

using in_nm (varchar(5)),filler (char(1))

      ,in_reslt  (varchar(11))

  insert into retail.testdt

 (name,reslt)

  values

 (:in_nm ,:in_reslt);

.exit;


Retail.testdt defined as :

create table retail.testdt

(Name varchar(10),

reslt integer)

primary index (name);

Can anyone please help me in finding the error in bteq Import script.

Thank you

Richa


4 REPLIES
Enthusiast

Re: Failure 2673 The source parcel length does not match data that was defined.

Hi

Try below and reply whether it has worked.

remove filler (char(1))

change reslt varchar(11) in table

Thanks

Santanu

Enthusiast

Re: Failure 2673 The source parcel length does not match data that was defined.

Hi,

Thank you.It worked :)

But can you please tell me the reason as why to change  change reslt varchar(11) in table. 

what difference does it made/ :( And as per my knowledge Teradata internally insert data as per datatype of columns.

Thanks,

Richa

Enthusiast

Re: Failure 2673 The source parcel length does not match data that was defined.

Good to hear that it has worked. You are right, the 2nd option is not required.

Just one curiosity , are you using TD 14 ?

Thanks

Santanu

Enthusiast

Re: Failure 2673 The source parcel length does not match data that was defined.

yes, I am using TD14. Does that makes the difference?