Expand my Community achievements bar.

SOLVED

Error on workflow ORA-00001 unique constraint violation

Avatar

Level 5

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.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

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