Job running on Multiple node and lookup fails..

craviraj · Post by **craviraj** » Sat Aug 29, 2009 4:41 am

Hi,
When I run a job on multiple node (windows 8x DS) and I do a normal lookup. The job aborts stating that lookup failed for the key records, but I see the data in the table when checked manually.

The lookup reference is in entire mode and the same job worked fine with more number of records.

Input to the lookup is 'Auto'. Input comes from a sequential file and Director log shows that only 10% of the file is read before the job is aborted. However, the lookup should have been successful.

Please pass on any suggestions.

Thanks,
Raviraj

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Sat Aug 29, 2009 7:19 am

Check the matching key column datatype, length and value.

siauchun84 · Post by **siauchun84** » Tue Sep 01, 2009 12:48 am

Besides checking on the datatype, what is the total records estimated that you used in your lookup reference (I means the database).
Another thing to highlight is, have you trim you lookup column before the sequential data went into the lookup stage?

craviraj · Post by **craviraj** » Thu Nov 05, 2009 1:33 pm

Datatype, length, trim -everything was handled. Could not understand the issue.

Kryt0n · Post by **Kryt0n** » Thu Nov 05, 2009 1:50 pm

And what types and lengths are they?

Send the failing record to a peek stage, put markers on either side of the key to check the total length, do a hex dump of it.