Failed a KeyLookup for Record

[just4geeks]

I have a simple job that uses a lookup stage to lookup a column from Database A into a similar column in Database B and extract the values in the relevant columns from Database B into a flat file. The lookup column has the same definition Integer( 8 ) in both the databases.

I get the following errors when I run the job.

Lookup_2,0: Failed a keylookup for record.
Lookup_2,0: The runLocally() of the operator failed.

And then the job fails.
Step execution finished with status = FAILED.

Does anyone have any idea? Thanks for your time.

[bcarlson]

You can tell the lookup what to do when a match is not found for a record - fail, continue, reject. Check out the documentation or online help for lookup for how to set this.

Brad.

[karrisuresh]

Hi

In the look-up u have to mention
what if the condition fails
and look-up fails
by default it fails the job which in ur case aborting the job
please have a check in that area

thanks
Suresh

I have a simple job that uses a lookup stage to lookup a column from Database A into a similar column in Database B and extract the values in the relevant columns from Database B into a flat file. The lookup column has the same definition Integer( 8 ) in both the databases.

I get the following errors when I run the job.

Lookup_2,0: Failed a keylookup for record.
Lookup_2,0: The runLocally() of the operator failed.

And then the job fails.
Step execution finished with status = FAILED.

Does anyone have any idea? Thanks for your time.

[karrisuresh]

Hi

In the look-up u have to mention
what if the condition fails
and look-up fails
by default it fails the job which in ur case aborting the job
please have a check in that area

thanks
Suresh

I have a simple job that uses a lookup stage to lookup a column from Database A into a similar column in Database B and extract the values in the relevant columns from Database B into a flat file. The lookup column has the same definition Integer( 8 ) in both the databases.

I get the following errors when I run the job.

Lookup_2,0: Failed a keylookup for record.
Lookup_2,0: The runLocally() of the operator failed.

And then the job fails.
Step execution finished with status = FAILED.

Does anyone have any idea? Thanks for your time.

[ray.wurlod]

Etiquette Note
When a thread is marked as Resolved convention requires that a post is made indicating how it was resolved.

I suspect in this case that the default Lookup Failed rule (Fail) was changed to Continue, Drop or Output. But I don't know for sure.

[just4geeks]

I changed the default response to failed look-up from failure to continue. And the job worked successfully.

Thanks Suresh and Brad for your responses.