Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of UNIQUE KEY constraint 'UQ_ParticipantsAttributes_20ED9504'. Cannot insert duplicate key in object 'dbo.Participants' - when downloading transactions

When processing event registrations from Online Express Events, users may see this error upon clicking the process button:
Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of UNIQUE KEY constraint 'UQ_ParticipantAttri_23CA01AF.' Cannot insert duplicate key in object 'dbo.ParticipantAttributes'. The duplicate key value is (00001-583-0000001004)
Native error:2627
[Microsoft][ODBC SQL Server Driver][SQL Server] The statement has been terminated.
Native error:3621
To resolve this issue: 

1.  Download and install the Regenerate Import ID’s plug-in (KB 42799)
2.  Instead of running the plug-in for ALL Import ID tables, select the options for ParticipantAttributes table
3.  Run the plug-in 
4.  Go to File > Exit & Sign out and log back in to The Raiser’s Edge 
5.  Event registrations should successfully process

**If error persists, run the Regenerate Import ID plugin again.  Select all options for Participants and Events to regenerate the Import ID's.  Once complete, the transaction should process successfully.

Steps to Duplicate

  1. Log into RE
  2. Enter Online Express Module
  3. Click on Events 
  4. Download Transactions
  5. Choose Registration to process.
  6. Process now
  7. Receive error.

Environment

 Blackbaud Online Express

Was this article helpful?