Page 1 of 1
Problem with the Transformer
Posted: Tue Dec 20, 2005 12:08 am
by BCAPP
I have developed a job which reads from two sequential files and performs a full outer join. The output of the join stage goes thru a Transformer where data is split into 3 output files based on certain criteria.
While running the job the job abends and gives the below error message
tfpAddrrec,0: Operator terminated abnormally: received signal SIGSEGV
(tfpAddrrec is the Transformer stage).
If I remove the transformer stage the job runs fine.
I tried changing the Transformer but to no avail.
Please let me know wht can be done in this regard.
Thanks,
Posted: Tue Dec 20, 2005 1:15 am
by ray.wurlod
Please post your "criteria" - the exact expressions, please. Also, if there are any output column derivation expressions in the Transformer can you also post these?
SIGSEGV is a segmentation violation. You might search the Forum for these terms. One common cause is using NULL in an expression that can not handle null values. Another is trying to stuff a string more than N characters long into a Char(N) data type.
In either case I would have expected to see a warning from a parallel job. Can you reset the job in Director, and post any text "from previous run..." ?
Posted: Tue Dec 20, 2005 7:17 am
by BCAPP
There are basically 3 output links from the Transformer based on the below constraint:
Output1:
(lnkRecsOut.leftRec_BRANCH_NUM <>"" and lnkRecsOut.rightRec_BRANCH_NUM<>"")
Output2:
lnkRecsOut.rightRec_BRANCH_NUM = ""
Output3:
lnkRecsOut.leftRec_BRANCH_NUM = ""
lnkRecsOut.leftRec_BRANCH_NUM is coming out of the left outer join and is defined as nullable
I have handled the Null condition for all the derivations in the Transformer.
I am still getting the below error message
tfpAddrrec,0: Operator terminated abnormally: received signal SIGSEGV
main_program: Unexpected exit status 1
main_program: Step execution finished with status = FAILED.
Thanks,
Bhavana
Posted: Tue Dec 20, 2005 12:28 pm
by ameyvaidya
BCAPP wrote:
I have handled the Null condition for all the derivations in the Transformer.
Hi Bhavana,
As far as I remember, the PX transformer is very Null-Intolerant.
Have you tried using NullToEmpty(lnkRecsOut.rightRec_BRANCH_NUM) in the constraints derivations?