BBIS Event Registration Batches Error : Cannot insert duplicate key row in object dbo.REVENUESPLITCAMPAIGN with unique index UIX_REVENUESPLITCAMPAIGN_REVENUESPLITID_CAMPAIGNID_CAMPAIGNSUBPRIORITYID. The duplicate key value is (...)

Users may notice that Event Registrations connected to an event that is associated with a campaign may get the following error when attempting to commit the Event Registration Batch : 
Data could not be saved.  
Cannot insert duplicate key row in object 'dbo.REVENUESPLITCAMPAIGN' with unique index 'UIX_REVENUESPLITCAMPAIGN_REVENUESPLITID_CAMPAIGNID_CAMPAIGNSUBPRIORITYID'. The duplicate key value is (..., ..., ...).
 We are currently evaluating this issue for a fix in a future service pack.

Steps to Duplicate

1) In BBIS register for an event that has a campaign associated with it.
2) Download the transaction from BBEC > Web > Web Transactions > Download
3) Process the Event Registration Batch and commit.
4) Note that exceptions are generated and the following line error : Data could not be saved.  
Cannot insert duplicate key row in object 'dbo.REVENUESPLITCAMPAIGN' with unique index 'UIX_REVENUESPLITCAMPAIGN_REVENUESPLITID_CAMPAIGNID_CAMPAIGNSUBPRIORITYID'. The duplicate key value is (..., ..., ...).

Environment

 Blackbaud CRM
 4.0
 4.0.170.43

Was this article helpful?