Having issues with Lookup Stage

mahmudul · Post by **mahmudul** » Fri May 27, 2011 9:45 am

Hi All,

I am having some issues with Lookup Stage. I have one dataset as source and another one as reference connected to lookup stage and then connected to a transformer stage to find the required records that will be loaded to Oracle table. While running I get the following error:

Lkp_Add_Updttm: Error occurred during initializeFromArgs().
Lkp_Add_Updttm: When processing argument -ifNotFoundWhen processing action: No value supplied
main_program: Creation of a step finished with status = FAILED.

Please let me know what could be done to fix this error. Thanks in advance!

ray.wurlod · Post by **ray.wurlod** » Fri May 27, 2011 3:06 pm

Welcome aboard.

Make sure the "Lookup Failed" rule is correctly set in the Lookup stage.

mahmudul · Post by **mahmudul** » Tue May 31, 2011 1:58 pm

My 'Lookup Failed' rule is setup as given below:
Condition Not Met --> Fail and Lookup Failur --> Fail
Can you please suggest how to fix this error that I get while running:

Lkp_Add_Updttm: Error occurred during initializeFromArgs().
Lkp_Add_Updttm: When processing argument -ifNotFoundWhen processing action: No value supplied
main_program: Creation of a step finished with status = FAILED.

Thank you in advance!

ray.wurlod · Post by **ray.wurlod** » Tue May 31, 2011 5:13 pm

Try changing the Lookup Failed rule to something else.

mahmudul · Post by **mahmudul** » Wed Jun 01, 2011 10:02 am

I changed the 'Lookup Failed' rule to 'Reject' and then connected to DataSet to catch the rejected row. It still aborts! Thanks in advance!!!

mahmudul · Post by **mahmudul** » Fri Jun 03, 2011 9:36 am

Do you know what could be done to fix this error?

ray.wurlod · Post by **ray.wurlod** » Fri Jun 03, 2011 3:59 pm

Not really. Try replacing the Lookup stage with a new Lookup stage (for test purposes).

mobashshar · Post by **mobashshar** » Fri Jun 03, 2011 7:37 pm

Try changing the lookup Condition Not Met = Continue and LookUp Failed = Continue