Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Update: Insert if new does not work


I am getting the following Oracle Error:

Error: Output Data (114): DataWrap2OCI::SendBatch: ORA-00001: unique constraint (ALTERYX_REP.AUDIT_KEY_PK) violated Insert into SCHEMA.TABLE_NAME.


I have a primary key and it's contrained and yet it still doesn't work.


Any thoughts?

Alteryx Certified Partner


You tried to execute an INSERT or UPDATE statement that has created a duplicate value in a field restricted by a unique index. You may try following:

1) Drop the unique constraint.
2) Change the constraint to allow duplicate values.
3) Modify your SQL so that a duplicate value is not created.