DSTAGE-TERA-0113`:`Row rejected.

sagar deshmukh · Post by **sagar deshmukh** » Tue Apr 05, 2011 1:36 am

Hi,

I have simple job,

Seq stage --> Trasformer --> Teradata.

I am reading just one record from Seq file, I have manually edited the record, everything is perfect about the record..

Record :-

"C",74236526445,"HORIZON",64.00,"EA","OZ","64 OZ",789788,"210",763000161,"123456",10.2,8.5,12.8,27.00,0.642, 16,5,700600,6,789788," ","N",90,"0",0,"HORIZON","Y","S",0,0600

While loading this record in Teradata table it is getting rejected with below warning :

Untitled1..Transformer_4: The source parcel length does not match data that was defined.

I am not doing any trasformation here...hence it is surprising for me why this issue is happening.

Could you please please help me with your valuable guidance regarding this issue?

Thanks
Sagar

chulett · Post by **chulett** » Tue Apr 05, 2011 6:52 am

A Google search for your message "The source parcel length does not match data that was defined" returned about 5M hits, so there should be some help for you out there. Your record may be perfect but it doesn't match your metadata, it would seem.

pandeesh · Post by **pandeesh** » Tue Apr 12, 2011 5:46 am

Sagar,

If you post your metadata, that should be easier to help out.

Post by **rschirm** » Wed Jun 01, 2011 7:47 pm

No reply

ray.wurlod · Post by **ray.wurlod** » Wed Jun 01, 2011 8:58 pm

Perhaps it's urgent.