Regarding Range Lookup

[madsongtel]

Hi,

I am facing runtime error while using range lookup as "Lookup_56,1: Operator terminated abnormally: received signal SIGSEGV [processmgr/rtpexecutil.C:199]".
My requirement is as below:
--> Main link has 4 columns(EMP_ID, EMP_NAME, START_DATE,END_DATE)
12, ABC, 2010-12-11, 2010-12-23
--> Reference lilnk has 3 columns(EMP_ID, EMP_DATE, PERIOD)
12, 2010-12-20, 6
here i am doing lookup on M.EMP_ID=R.EMP_ID and R.EMP_DATE between M.START_DATE and M.END_DATE..
doing range lookup on reference link and normal lookup on EMP_ID.

My output should be
EMP_ID, EMP_NAME, PERIOD
12, ABC, 6

when i run the job it is giving "Lookup_56,1: Operator terminated abnormally: received signal SIGSEGV [processmgr/rtpexecutil.C:199]" and in job designer it is showing as green(Successfull). No records are getting to output.

I have seen many posts and tried according to that, but no use...
Please help me out. Thanks in advance.

[soumya5891]

Better use a join stage and then filter out with the date range condition.I think it will work fine