Error: The UPDATE statement conflicted with the CHECK constraint "CK_PROSPECT_VALIDMANAGERSTARTDATE". The conflict occurred in database "Name", table "dbo.PROSPECT". - When editing research details on Wealth and Ratings page

If a constituent has prospect manager history but no current prospect manager, adding a new prospect manager in Wealth and Ratings > Research Details will throw the error, "Data could not be saved. The UPDATE statement conflicted with the CHECK constraint "CK_PROSPECT_VALIDMANAGERSTARTDATE". The conflict occurred in database "Name", table "dbo.PROSPECT"."
We are currently evaluating this issue for a fix in a future service pack.

Steps to Duplicate

1) Create a new constituent > Add the constituent as a prospect without a current prospect manager
2) On the constituent record, go to the Prospect tab > Prospect team sub tab > Edit prospect manager
3) Select a prospect manager and put a start date and end date in the past.
4) Go to the Wealth and Ratings page > Wealth Summary tab > Research Details > Edit > Search for a new prospect manager > Save the form

Environment

 Blackbaud CRM
 4.0
 4.0.180.1600

Was this article helpful?