Free Trial

Alteryx Server Discussions

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

DataWrap2ODBC::SendBatch: ERROR: duplicate key value violates unique constraint "pk_altery

Tanaya_Singh
5 - Atom

Hi All, I am getting the above error, any ideas on how to fix it?

1 REPLY 1
jNunez
8 - Asteroid

This isn't specific to the server product but you need to clean your data before attempting to write to a database. There are likely multiple records with the same primary key in the data you're trying to write to the database table.Add a unique tool to the workflow just before you write to it and see what your duplicate records are. You may need to make some data model changes on the database side. Or add an additional column to your primary key.

Hope this helps,

Eddie