Error on workflow ORA-00001 unique constraint violation
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.