Error: Data could not be saved. The MERGE statement conflicted with the SAME TABLE REFERENCE constraint 'FK_FINANCIALTRANSACTIONITEM_SOURCELINEITEMID - when changing the constituent on a payment"

When attempting to change the constituent on a payment that was previously connected to a matching gift claim and error message is given. In this case the payment and the claim payments have already been posted, but the original payment had been adjusted to change it's application so as to free it from association with the claim and claim payment.

Data could not be saved.  The MERGE statement conflicted with the SAME TABLE REFERENCE constraint 'FK_FINANCIALTRANSACTIONITEM_SOURCELINEITEMID".  The conflict occurred in database '{DBNAME.EN_US}, table "dbo.FINANCIALTRANSACTIONLINEITEM", column "SOURCELINEITEMID'
 We are currently evaluating this issue and will update this article when we have more information.

Environment

 4.0.138, service pack 1 ; 3.0.516 Service pack 10

Was this article helpful?