Error: Data could not be saved. Cannot insert duplicate key row in object 'dbo.REVENUESPLITCAMPAIGN' with a unique index 'IUX_REVENUESPLITCAMPAIGN_REVENUESPLITID_CAMPAIGNID_CAMPAIGNSUBPRIORITYID'. The duplicate key value is '' when adding a Benefit

Users are finding that when attempting to add a Benefit to a payment with a Matching Gift Claim, and split Designations, the error: Data could not be saved. Cannot insert duplicate key row in object 'dbo.REVENUESPLITCAMPAIGN' with a unique index 'IUX_REVENUESPLITCAMPAIGN_REVENUESPLITID_CAMPAIGNID_CAMPAIGNSUBPRIORITYID'. The duplicate key value is '' can be received. 
We’re currently evaluating this issue for a fix in a future patch or service pack

Environment

 Blackbaud CRM
 4.0
 4.0.141

Was this article helpful?