Error on workflow ORA-00001 unique constraint violation

Avatar

Avatar
Validate 10
Level 3
thibaultb473199
Level 3

Likes

25 likes

Total Posts

77 posts

Correct reply

2 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 25
View profile

Avatar
Validate 10
Level 3
thibaultb473199
Level 3

Likes

25 likes

Total Posts

77 posts

Correct reply

2 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 25
View profile
thibaultb473199
Level 3

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
Establish
MVP
wodnicki
MVP

Likes

976 likes

Total Posts

1,096 posts

Correct reply

514 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile

Avatar
Establish
MVP
wodnicki
MVP

Likes

976 likes

Total Posts

1,096 posts

Correct reply

514 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile
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)