Data could not be saved. Violation of UNIQUE KEY constraint "UC_REGISTRANT_LOOKUPID". Cannot insert duplicate key in object "dbo.REGISTRANT". The duplicate key value is (XXX)

When attempting to register a constituent for an event, with a "Registration option" that has a "registration count" greater than 2 the follow error message occurs:

Data could not be saved.

Violation of UNIQUE KEY constraint "UC_REGISTRANT_LOOKUPID";. Cannot insert duplicate key in object "dbo.REGISTRANT". The duplicate key value is (XXX).

We’re currently evaluating this issue for a fix in a future service pack. 

Steps to Duplicate

1.Go to an event and create a new registration option. The count on the registration option should be 10.
2.Register a constituent and assign the registration option.
3.Save the registration and receive the error:

Data could not be saved.

Violation of UNIQUE KEY constraint 'UC_REGISTRANT_LOOKUPID'. Cannot insert duplicate key in object 'dbo.REGISTRANT'. The duplicate key value is (xxx).

Environment

 Blackbaud CRM
 4.0
 4.0.166

Was this article helpful?