When attempting to add a Direct Marketing effort the following an error is thrown this is seen when the communication template is set to consider exclusions as of today and is locked

When attempting to create a direct marketing effort the following error is thrown: Data could not be saved. The INSERT statement conflicted with the CHECK constraint "CK_BUSINESSPROCESSCOMMPREF_ASOFDATE". The conflict occurred in database "SMP_EC_40_14", table "dbo.BUSINESSPROCESSCOMMPREF".

This is seen when the template is set to "consider exclusions as of today" and is set to "locked"
we are currently evaluating this issue for a fix in a future release.

Environment

 Blackbaud CRM
 4.0
 4.0.158.0

Was this article helpful?