Lkp_1,0: Operator terminated abnormally: received signal SIG
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 57
- Joined: Wed Nov 15, 2006 10:25 am
- Location: Ottawa ON
Lkp_1,0: Operator terminated abnormally: received signal SIG
Hello,
a lookup works fine. But as soon as a condition (the range) is added to the lookup stage, got the error at run time:
Lkp_1,0: Operator terminated abnormally: received signal SIGBUS.
Condition:
Key Expression: Range (DSLink2.lower, ">=", DSLink2.upper, "<=", 0)
Key Type: a..z
Column Name: INITIAL_ENTRY_DATE (all I want to show here it's a DATE).
Any help is highly appreciated.
a lookup works fine. But as soon as a condition (the range) is added to the lookup stage, got the error at run time:
Lkp_1,0: Operator terminated abnormally: received signal SIGBUS.
Condition:
Key Expression: Range (DSLink2.lower, ">=", DSLink2.upper, "<=", 0)
Key Type: a..z
Column Name: INITIAL_ENTRY_DATE (all I want to show here it's a DATE).
Any help is highly appreciated.
TPQ
-
- Premium Member
- Posts: 57
- Joined: Wed Nov 15, 2006 10:25 am
- Location: Ottawa ON
Hmm
Don't know much how to help but here are my two cents...
The range function should be done this way (checking one code + 1 date against list of codes and values interval such as dates for instance)
1) On the code : Set "=" and join with the code
On the start/end values, set "a..z" and join you value to check on the main stream to both bounds and check the range box (the zone will become red meaning you must insert an expression).
2) In the range expression use the following
Either :
value_to_check >= start_value AND value to check < end_value
OR
value_to_check > start_value AND value to check <= end_value
This is VERY important as intrervals must not overlap, I already had issues before.
3) When combining a range lookup (start/end) and a regular lookup, you must set "Multiple values returning".
Don't know much how to help but here are my two cents...
The range function should be done this way (checking one code + 1 date against list of codes and values interval such as dates for instance)
1) On the code : Set "=" and join with the code
On the start/end values, set "a..z" and join you value to check on the main stream to both bounds and check the range box (the zone will become red meaning you must insert an expression).
2) In the range expression use the following
Either :
value_to_check >= start_value AND value to check < end_value
OR
value_to_check > start_value AND value to check <= end_value
This is VERY important as intrervals must not overlap, I already had issues before.
3) When combining a range lookup (start/end) and a regular lookup, you must set "Multiple values returning".
-
- Premium Member
- Posts: 57
- Joined: Wed Nov 15, 2006 10:25 am
- Location: Ottawa ON
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Can you compile/run jobs with Transformer stages?
Range lookups are rewritten as transform operators (that is, as Transformer stages) and therefore have the same compiler and linker requirements as Transformer stages.
Range lookups are rewritten as transform operators (that is, as Transformer stages) and therefore have the same compiler and linker requirements as Transformer stages.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 57
- Joined: Wed Nov 15, 2006 10:25 am
- Location: Ottawa ON
Hi Rayand others,ray.wurlod wrote:Can you compile/run jobs with Transformer stages?
Range lookups are rewritten as transform operators (that is, as Transformer stages) and therefore have the same compiler and linker requirements as Transformer stages.
Thank you for your help.
Sorry for the late reply. I was off for a few days and just came back.
Yes, I can compile and run a Transformer stage. In fact, the same lookup wothout the range (condition) works fine. But as soon as the range is included, the error appears at run time.
-
- Premium Member
- Posts: 57
- Joined: Wed Nov 15, 2006 10:25 am
- Location: Ottawa ON
chulett wrote:All the more reason to check for a patch, IMHO - which the Linux version (I'm finding) has more than its fair share of.
chulett,
Thank you. I couldn't find any patch relating to "parellel range lookup" for V8.1. What I found is for V8.0 at the following link.
http://publib.boulder.ibm.com/infocente ... 01fp2.html.
Maybe this is what you mentioned?
My version is 8.1.0.0. I just found there is a Version 8.1 Critical Patch, which I haven't installed yet. But this patch doesn't mention anything about range lookup or SIGBUS error.
I'm with Craig here... in particular, the vague bit...chulett wrote:I vaguely recall issues with the Range Lookup that may require a patch from your official support provider....
We had the same problem a few months ago... think the final response from support was that our version of the C++ compiler was unsupported but as we jumped ship on to a new server that worked fine, we never pursued further.