DSXchange

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!

Welcome aboard.

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

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!

Try changing the Lookup Failed rule to something else.

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

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

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

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