Parallel job getting aborted

ketanshah123 · Post by **ketanshah123** » Sun Dec 20, 2009 11:24 pm

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.

hamzaqk · Post by **hamzaqk** » Mon Dec 21, 2009 12:21 am

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...

srinivas.g · Post by **srinivas.g** » Mon Dec 21, 2009 7:50 am

it is related to memory allocation problem.

Please check null handling properly used in transformer stage?

sjfearnside · Post by **sjfearnside** » Mon Dec 21, 2009 9:05 am

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.

DSguru2B · Post by **DSguru2B** » Mon Dec 21, 2009 9:51 am

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?

ETLJOB · Post by **ETLJOB** » Thu Dec 31, 2009 4:50 am

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.

chulett · Post by **chulett** » Thu Dec 31, 2009 7:28 am

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.