Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert duplicate key row in object 'dbo.GIFT' with unique index 'UK_GIFT_1'. The duplicate key value is (00001-545-0000005101). Native error: 2601 [Microsoft][ODBC SQL Serve

When creating a new Gift record, users receive Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert duplicate key row in object 'dbo.GIFT' with unique index 'UK_GIFT_1'. The duplicate key value is (00001-545-0000005101). Native error: 2601 [Microsoft][ODBC SQL Server Driver][SQL Server] The statement has been terminated. Native error: 3621.  This is received when entering through Batch, Import, or manually.
Contact Support and reference this article. 

Alternative Solution:

Use a Gift Import to enter your gifts and manually create the Gift Import ID.

Environment

 7.91.5056, patch 28

Was this article helpful?