Error activating marketing effort: Violation of UNIQUE KEY constraint

You may receive the following error when attempting to run an Appeal Mailing:
 
Error activating the marketing effort:  Violation of UNIQUE KEY constraint ''UC_IDSETREGISTER_NAME''. Cannot insert duplicate key in object ''dbo.IDSETREGISTER''. The duplicate key value is (Constant Contact Email (Normal gifts for Constituent Marketing Information)).
The statement has been terminated. 

Edit the name of the Appeal Mailing to change it slightly and attempt to run the mailing again.  If the mailing has the same name as another mailing, rename the appeal mailing to have a unique name.  Remove any special characters from the appeal mailing name.

If this does not resolve the issue please Chat with Support.

Environment

 3.12

Was this article helpful?