Error: Data could not be saved. The UPDATE statement conflicted with the CHECK constraint "CK_Prospect_ValidManagerStartDate" - when attempting to merge two constituents

When attempting to merge two constituents a user may receive  the error:

Data could not be saved. The UPDATE statement conflicted with the CHECK constraint "CK_Prospect_ValidManagerStartDate". The conflict occurred in database [Database Name], table "dbo.PROSPECT"
We're currently evaluating this issue for a fix in a future patch or service pack.  

Workaround: 
  1. Go to source constituent > Fundraiser tab > Prospects and Plans subtab > Prospect manager area
  2. Find any of those prospects where source constituent is prospect manager without a start date (Prospect > Prospect Team) and there are records in the prospect manager history tab (Prospect > Manager History)
  3. Add start date to the prospect manager record (Prospect > Prospect Team)

Steps to Duplicate

 
  1. Add prospect
  2. Add any prospect manager to prospect without start/end date
  3. Edit prospect manager, use source constituent as prospect manager without start/end date again
  4. Wait at least one day and then try to merge

Environment

 Blackbaud CRM
 4.0
 138.2

Was this article helpful?