Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of UNIQUE KEY constraint 'UQ_Participants_20ED9504'. Cannot insert duplicate key in object 'dbo.Participants' - when saving participant record

When saving a new participant to an event record in Raiser's Edge, the following error will present itself intermittently:
General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of UNIQUE KEY constraint
'UQ_Participants_20ED9504'. Cannot insert duplicate key in object 'dbo.Participants'. The duplicate key value is (ooo1-587-0000022555).
Native Error:2627
[Microsoft][ODBC SQL Server Driver][SQL Server] The statement has been terminated. 
Native error:3621
We are currently evaluating this issue and will update this article when we have more information.

Steps to Duplicate

1.  Open an Event Record within Raiser's Edge.
2.  Go to the Participants Tab
3.  Click New Registrant
4.  Search for and find an existing constituent or add a new participant
5.  Click Save and Close
6.  Add any other pertinent participant information to the participant record
7.  Click Save and Close
8.  The error message appears intermittently

Was this article helpful?