NextSurrogateKey() in a stage variable

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
I_Server_Whale
Premium Member
Premium Member
Posts: 1255
Joined: Wed Feb 02, 2005 11:54 am
Location: United States of America

NextSurrogateKey() in a stage variable

Post by I_Server_Whale »

Hi all,

I'm trying to assign the NextSurrogateKey() function to a stage variable. The job compiles fine but aborts with SIGSEGV error message.

Has anyone encountered this before in IS 8.0.1? Or in 7.5.2?

The exact error message is as below:

Code: Select all

X2,0: Operator terminated abnormally: received signal SIGSEGV
Where X2 is the transformer.

As always, appreciate your inputs.

Regards,
Whale.
Anything that won't sell, I don't want to invent. Its sale is proof of utility, and utility is success.
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
AmeyJoshi14
Participant
Posts: 334
Joined: Fri Dec 01, 2006 5:17 am
Location: Texas

Post by AmeyJoshi14 »

oops sorry :cry:
I got confused ..... :oops:
Last edited by AmeyJoshi14 on Wed Jan 09, 2008 3:59 am, edited 2 times in total.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Whale got a SIGSEGV, not a SIGBUS signal.
:roll:
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
rleishman
Premium Member
Premium Member
Posts: 252
Joined: Mon Sep 19, 2005 10:28 pm
Location: Melbourne, Australia
Contact:

Post by rleishman »

I believe you can only set NextSurrogateKey() to output link columns - kind of limits it's usefulness.
Ross Leishman
I_Server_Whale
Premium Member
Premium Member
Posts: 1255
Joined: Wed Feb 02, 2005 11:54 am
Location: United States of America

Post by I_Server_Whale »

rleishman wrote:I believe you can only set NextSurrogateKey() to output link columns - kind of limits it's usefulness.
That is awful. :( I would think it is a bug rather than it being a limit. :)

Whale.
Anything that won't sell, I don't want to invent. Its sale is proof of utility, and utility is success.
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
I_Server_Whale
Premium Member
Premium Member
Posts: 1255
Joined: Wed Feb 02, 2005 11:54 am
Location: United States of America

Post by I_Server_Whale »

Got a patch from IBM to call it in a stage variable. And now it works!!!
Anything that won't sell, I don't want to invent. Its sale is proof of utility, and utility is success.
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
I_Server_Whale
Premium Member
Premium Member
Posts: 1255
Joined: Wed Feb 02, 2005 11:54 am
Location: United States of America

Post by I_Server_Whale »

case no for the patch: 128834.
Anything that won't sell, I don't want to invent. Its sale is proof of utility, and utility is success.
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
Post Reply