Error running marketing effort export. Violation of PRIMARY KEY constraint 'PKMKTSEGME_E765BF4D26166322.' Cannot insert duplicate key in object 'dbo.mktsegmentationexporttemp_[GUID] the duplicate key value is [String of numbers]
When exporting an activated marketing effort, you might encounter the error, "Error running marketing effort export. Violation of PRIMARY KEY constraint 'PKMKTSEGME_E765BF4D26166322.' Cannot insert duplicate key in object 'dbo.mktsegmentationexporttemp_[GUID] the duplicate key value is [String of numbers]".
Article
Number:110728
Products:
Blackbaud_CRM
Blackbaud_Direct_Marketing
This error was caused by changing the Appeal on an activated marketing effort before exporting the file. To fix this, change the appeal back to the appeal used when the effort was activated and then run the marketing effort export again.