LKP_STAGE issue

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
mekrreddy
Participant
Posts: 88
Joined: Wed Oct 08, 2008 11:12 am

LKP_STAGE issue

Post by mekrreddy »

Hello all,

i am using lookup stage in one of my jobs, i am getting this error

Lkp_stg: When processing argument -ifNotFoundWhen processing action: No value supplied,

but same job works fine in all other dev environments.

failed in production.. please give your thoughts..
Thank yo so much in advance!!
anand_dafaria
Premium Member
Premium Member
Posts: 36
Joined: Wed Dec 27, 2006 3:50 am
Location: Phoenix

Post by anand_dafaria »

Let us know what have you provided in the lookup failure option in the lookup stage.

It all depends on data, while data in production environments are relatively larger so you never know that is it because of data or code that the job is failing.


Anand.
VijayDS
Participant
Posts: 38
Joined: Thu Jun 18, 2009 3:50 am

Re: LKP_STAGE issue

Post by VijayDS »

Can you check the constraints and conditions specified in the lookup stage? I mean lookup failure condition and etc....
mekrreddy wrote:Hello all,

i am using lookup stage in one of my jobs, i am getting this error

Lkp_stg: When processing argument -ifNotFoundWhen processing action: No value supplied,

but same job works fine in all other dev environments.

failed in production.. please give your thoughts..
Thank yo so much in advance!!
Thanks
Vijay
mekrreddy
Participant
Posts: 88
Joined: Wed Oct 08, 2008 11:12 am

Post by mekrreddy »

yes, I changed it lookup failure --> reject, and works fine. failure was not handled earlier.
Post Reply