Error on Update data (Update) | Community
Skip to main content
Heku_
Heku_
Level 5
January 8, 2024
Question

Error on Update data (Update)

  • January 8, 2024
  • 1 reply
  • 735 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

OscarGo
OscarGo
Level 3
June 25, 2024

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)

Terms & ConditionsAccessibility statement

Loading footer...