Error on Update data (Update)

[Heku_]

Hello, i have an enrichment which joins 3 recipients. I have 2 computed attributes called NUMPER and NUMPOT.

I use them to update data but I get this error.

ORA-210000 Oracle error: ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

WDB-200001 SQL statement 'CREATE UNIQUE INDEX NPK_wkf145741_401_1 ON wkf145741_401_1 (biPKey_1)' could not be executed.

Does anyone know how to fix this error, why does it create an index?

@Manoj_Kumar_ @ParthaSarathy @Parvesh_Parmar @DavidKangni

[OscarGo]

Hi @Heku_ 

It seems you are not doing the reconciliation in the Update Data correctly.

You should be using recipient-id (NMSRecipients) with foreign-key/recipient-id (Archived Tracking Logs)