Page 1 of 1
Parallel job getting aborted
Posted: Sun Dec 20, 2009 11:24 pm
by ketanshah123
HI
Parallel job getting aborted with error
Parallel job reports failure (code 139)
Contents of phantom output file =>
RT_SC8832/OshExecuter.sh[20]: 1978564 Segmentation fault
Job design is
oracle stage ----> transformer----->lookup------>transfprmer----->oracle stage
Any suggestion how can i resolve this ?
Thanx in advance.
Posted: Mon Dec 21, 2009 12:21 am
by hamzaqk
check if the NLS setting of the job is the same as the project or set it to project default. And if this does not work out so a search on the "segmentation fault" and it will come up results pertaining to the same problem...
Posted: Mon Dec 21, 2009 7:50 am
by srinivas.g
it is related to memory allocation problem.
Please check null handling properly used in transformer stage?
Posted: Mon Dec 21, 2009 9:05 am
by sjfearnside
I am using 8.0.1 and experienced this error message on 2 different occasions and it was related to a missing or invalid entry in my odbc.ini file.
Posted: Mon Dec 21, 2009 9:51 am
by DSguru2B
Why do you have two transformers ? can it be consolidated in one, can you split up the job to see where the issue is happening?
Posted: Thu Dec 31, 2009 4:50 am
by ETLJOB
I made a copy of my original job and did few modifications.
When I ran the job I got the following error message.
"Contents of phantom output file =>
RT_SC3666/OshExecuter.sh[20]: 2994302 Segmentation fault(coredump)"
"Parallel job reports failure (code 139)"
Finally, I could manage to get rid of this weird error by fixing my oracle query! So i guess there are more reasons for this code 139 failure and you can't guess some solutions unless you know what is there in the job.
Posted: Thu Dec 31, 2009 7:28 am
by chulett
ETLJOB wrote:So i guess there are more reasons for this failure and you can't guess some solutions unless you know what is there in the job.
I modified your quote slightly - a nice observation about trouble-shooting in general that some people don't seem to realize, and especially from where we sit on the other side of the glass. Sometimes you just gotta be there and have eyes on the target.
