Operator terminated abnormally: received signal SIGSEGV

xicheng_my_love · Post by **xicheng_my_love** » Tue Apr 22, 2008 8:23 pm

Event#:198
Message:Operator terminated abnormally: received signal SIGSEGV
A very simple Job.Data is exported using a oracle stage and transformed by a transformer,then inserted into a table using a oracle stage.There are 8 million rows all together.The error above occured at the time when about 3 million rows are processed.

keshav0307 · Post by **keshav0307** » Tue Apr 22, 2008 8:31 pm

what is the load method??
Are there any other warnings??

xicheng_my_love · Post by **xicheng_my_love** » Tue Apr 22, 2008 9:42 pm

User-defined Upsert,in the update statement we use 'where 1<2' as the where conditon to make the Upsert insert only.

keshav0307 · Post by **keshav0307** » Tue Apr 22, 2008 10:29 pm

'where 1<2' will always be true. that means for every records it will execute the update.
post your update query

xicheng_my_love · Post by **xicheng_my_love** » Wed Apr 23, 2008 12:06 am

sorry for the misunderstanding.I typed wrong words.It is 'where 1>2' in the update statement to exclude the update.

keshav0307 · Post by **keshav0307** » Wed Apr 23, 2008 1:20 am

you are not giving enough input to comment on.
can you post the job log the query used etc.

xicheng_my_love · Post by **xicheng_my_love** » Wed Apr 23, 2008 1:33 am

no other infomation can be provided.

keshav0307 · Post by **keshav0307** » Wed Apr 23, 2008 1:42 am

then probably no solution can be provided

ray.wurlod · Post by **ray.wurlod** » Wed Apr 23, 2008 2:00 am

Please provide the full detail of event #198. This will include mention of the stage/operator that generated the message.

You could be looking for the problem in the wrong place.