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?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.