The UPDATE statement conflicted with the CHECK constraint CK_PROSPECT_VALIDMANAGERSTARTDATE. The conflict occurred in database 'database name', 'table dbo.PROSPECT'

When trying to run the prospect assignment process to assign prospects to another prospect manager and primary manager, the error "The UPDATE statement conflicted with the CHECK constraint CK_PROSPECT_VALIDMANAGERSTARTDATE. The conflict occurred in database 'database name', 'table dbo.PROSPECT'" occurs.
Download and install the latest service pack, which contains all fixes from previous service packs. If you are running an older version, download and install the latest version and then the service pack.
 

Steps to Duplicate

1. Go to Prospects\Manage Prospects and plans in bulk\Prospect Assignment Process
2. In the Prospect selection box select a selection that has been created that identifies the prospect records for which need new prospect or primary managers
3. In the Prospects assigned to box select the current prospect or primary manager
4. In the Assign to box, select the new prospect or primary manager that the prospects in the prospect selection box need to be assigned to
5. Check the checkboxes for the following:
  • Transfer prospect manager assignments
  • Transfer primary manager assignments
  • Transfer plan steps and interactions
6. Click the Start button
7. See the error occur



 

Environment

 Blackbaud CRM
 4.0
 4.0
 4.0.173.0
 4.0.155.0

Was this article helpful?