Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

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.

View Entire Topic

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

961 likes

Total Posts

1,090 posts

Correct Reply

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

Avatar
Establish
MVP
wodnicki
MVP

Likes

961 likes

Total Posts

1,090 posts

Correct Reply

509 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