Error: Data could not be saved. The DELETE statement conflicted with the REFERENCE constraint FK_REVENUEMATCHINGGIFT_RELATIONSHIPID" - when merging constituents"

When merging two constituents in conjunction with the "Delete source constituent" option, if the source constituent has an outstanding matching gift claim, users may receive the error:

Data could not be saved. The DELETE statement conflicted with the REFERENCE constraint "FK_REVENUEMATCHINGGIFT_RELATIONSHIPID". The conflict occurred in database "[DATABASENAME]", table "dbo.REVENUEMATCHINGGIFT", column 'RELATIONSHIPID'

Download and install the latest version and patch, if applicable. 

Environment

 2.91.1535, patch 107
 4.0.131

Was this article helpful?