Page 1 of 1
Operator terminated abnormally: received signal SIGSEGV
Posted: Tue Apr 22, 2008 8:23 pm
by xicheng_my_love
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.
Posted: Tue Apr 22, 2008 8:31 pm
by keshav0307
what is the load method??
Are there any other warnings??
Posted: Tue Apr 22, 2008 9:42 pm
by xicheng_my_love
User-defined Upsert,in the update statement we use 'where 1<2' as the where conditon to make the Upsert insert only.
Posted: Tue Apr 22, 2008 10:29 pm
by keshav0307
'where 1<2' will always be true. that means for every records it will execute the update.
post your update query
Posted: Wed Apr 23, 2008 12:06 am
by xicheng_my_love
sorry for the misunderstanding.I typed wrong words.It is 'where 1>2' in the update statement to exclude the update.
Posted: Wed Apr 23, 2008 1:20 am
by keshav0307
you are not giving enough input to comment on.
can you post the job log the query used etc.
Posted: Wed Apr 23, 2008 1:33 am
by xicheng_my_love
no other infomation can be provided.
Posted: Wed Apr 23, 2008 1:42 am
by keshav0307
then probably no solution can be provided
Posted: Wed Apr 23, 2008 2:00 am
by ray.wurlod
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.