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"
Download and install the latest patch which contains all fixes from previous patches. If you are running an older version, download and install the latest version and then the patch.

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
 4.0
 4.10.180.1716
 138.2

Was this article helpful?