Regarding the SIGSEGV Error ,while doing the UPSERT option

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
lydiapeter
Participant
Posts: 1
Joined: Fri Sep 07, 2007 4:57 am
Location: Kochi

Regarding the SIGSEGV Error ,while doing the UPSERT option

Post by lydiapeter »

I am newbie to DS, I am trying to load the data from one staging table to the warehouse table (One to one mapping) , i am using the PX transformer also in between these 2 oracle stages.

When i am loading the data into the datawarehouse using the option LOAD and truncate it was working fine.

But when i am trying the option with the UPSERT , Userdefined Insert and the Update option i am getting some errors like

InsStgAmt,1: Operator terminated abnormally: received signal SIGSEGV
InsStgAmt,0: Operator terminated abnormally: received signal SIGSEGV

In the userdefined Update SQL statement i am giving one false condition like Where 1=0 .
(The main thing for using this false condition was i dont want to update the table, only insertion without clearing i need ) here i can use the insert option but if there is any error occured while loading into the dwh i want to load into one Error table , in that Error table i am having one field like SQL_ERROR, if i am using the UPSERT option means i will get the SQLERROR data also and i can dirrectly map that data into my Error table. If i use the truncate and load option means i can't handle the error
Post Reply