Error on workflow ORA-00001 unique constraint violation

Avatar

Avatar

thibaultb473199

Avatar

thibaultb473199

thibaultb473199

26-11-2020

Hello everyone,

Recently, I had this error on one of my import workflow that runs daily and this one happens to fail on the Update Data activity. For an unknown reason, this is failing. Do you know why this happened and where to look to resolve that ?

This is the error I got : (is there an issue in the file I am importing ? I'm trying to understand the failure here)

 

11/22/2020 7:32:20 AM writer22 Oracle error: 'ORA-00001: violation de contrainte unique (NEO.THITRAVELTICKET2014_ID)'
11/22/2020 7:32:20 AM writer22 SQL statement 'INSERT INTO ThiTravelTicket2014(SVOC_ID,sFBC,sTARIF,tsTRANSACTION_DATE,sPNR,dAMOUNT,sORIGIN_STATION,sDESTINATION_STATION,sCOMFORT,TRAIN_NR,tsDeparture,sCIN,iTKL_FLG,sCHANNEL,iTICKET_SEQ,sYEAR,sTRANSACTION_TYPE,sDISTRIBUTOR,sCOUNTRY_CODE,sT
11/22/2020 7:32:20 AM writer22 CN,FLAG_IZY,tsDate_loaded,TICKET_ID,TICKET_TYPE,IS_TRAVELER,tsNEO_Creation_,tsNEO_Modification_,sSERVICE_CLASS,tmARRIVAL_TIME,tmTRAVEL_TIME,POS_UNICODE,POS_DISTRIBUTOR_ID) SELECT COALESCE( sFld136920973418, NULL),COALESCE( sFld13692104981, NULL),COALESCE
11/22/2020 7:32:20 AM writer22 ( sFld139635471515, NULL),COALESCE( tsFld13963447200, NULL),COALESCE( sFld13692104982, NULL),COALESCE( fFld139635472917, 0),COALESCE( sFld139635478118, NULL),COALESCE( sFld139635478119, NULL),COALESCE( sFld139635478220, NULL),COALESCE( sFld139635478221,
11/22/2020 7:32:20 AM writer22 NULL),COALESCE( tsFld139635478222, NULL),COALESCE( sFld139635494323, NULL),COALESCE( iFld139635494324, 0),COALESCE( sFld139635494325, NULL),COALESCE( biFld139635498726, 0),COALESCE( sFld139635498727, NULL),COALESCE( sFld139635498828, NULL),COALESCE( sFld
11/22/2020 7:32:20 AM writer22 139635498829, NULL),COALESCE( sFld139635500930, NULL),COALESCE( sFld13964386113, NULL),COALESCE( iFld1393623045, 0),COALESCE( tsFld3190685701, NULL),COALESCE( iFld2561277962, 0),COALESCE( sFld2567831564, NULL),COALESCE( iFld2566979595, 0),COALESCE( tsFld
11/22/2020 7:32:20 AM writer22 606797841, NULL),COALESCE( tsFld607846418, NULL),COALESCE( sFld906756359, NULL),COALESCE( tmFld2216099841, NULL),COALESCE( tmFld2217345026, NULL),COALESCE( sFld2136145929, NULL),COALESCE( sFld2137063434, NULL) FROM wkf674452117_9767_1 WHERE iRecProcStat

11/22/2020 7:32:20 AM writer22 e>:1 AND iRecProcState<=:2 AND COALESCE(sPKey_1,NULL) IS NULL AND COALESCE(sPKey_2,NULL) IS NULL AND COALESCE(sPKey_3,NULL) IS NULL' could not be executed. Param(0)=1259 Param(1)=1260
11/22/2020 7:32:20 AM writer22 e>:1 AND iRecProcState<=:2 AND COALESCE(sPKey_1,NULL) IS NULL AND COALESCE(sPKey_2,NULL) IS NULL AND COALESCE(sPKey_3,NULL) IS NULL' could not be executed. Param(0)=0 Param(1)=10000

 

Thank you in advance.

Kind regards.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

wodnicki

MVP

Avatar

wodnicki

MVP

wodnicki
MVP

26-11-2020

Hi,

 

Add a deduplication activity before the update data activity.

Set it to deduplicate on the table key (SVOC_ID?) and any other unique constraints present.

 

Thanks,

-Jon

Answers (0)