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, ONLY select the 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
 

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?