Error: Data could not be saved. The DELETE statement conflicted with REFERENCE constraint FK_RECURRINGGIFTINSTALLMENTPAYMENT_RECURRINGGIFTINGTALLMENTID - when attempting to refund a recurring gift payment

When attempting to refund a recurring gift payment for a recurring gift that has already had one payment refunded (adjusted to $0.00), users may receive the error:
 
Data could not be saved.
The DELETE statement conflicted with REFERENCE constraint “FK_RECURRINGGIFTINSTALLMENTPAYMENT_RECURRINGGIFTINGTALLMENTID”. The conflict occurred in database “<database name>”, table ‘dbo.RECURRINGGIFTINGSTALLMENTPAYMENT’, column ‘RECURRINGGIFTINSTALLMENTID’.
Download and install the latest patch, which contains all fixes from previous patches. If you are running an older version, download and install the latest version and then the patch. 

Environment

 2.94.154, patch 64
 2.94.1524, patch 77 ; 3.0.516, Service Pack 4

Was this article helpful?