Error: Data could not be saved. The UPDATE statement conflicted with the CHECK constraint CK_SPONSORSHIP_STARTDATEAFTERPLANNEDENDDATE" "

When attempting to Edit the Expiration Date on a Sponsorship, the error: Error: Data could not be saved. The UPDATE statement conflicted with the CHECK constraint "CK_SPONSORSHIP_STARTDATEAFTERPLANNEDENDDATE". Conflict occurred in database "1605_6fb42d91-b8a9-433f-b969-20163294d585" table "dbo.SPONSORSHIP" is received.  
This is due to a Pending Opportunity on the Sponsorship where the End Date was edited to be in the past, which made it prior to the Start Date.

For assistance, contact support and reference this article.

Environment

 Blackbaud CRM
 2.91
 2.91.1535.129

Was this article helpful?