Error: 'Data could not be saved. The INSERT statement conflicted with the FOREIGN KEY constraint FK_BATCHREVENUERECOGNITION_ADDITIONALAPPLICATIONDESIGNATIONID"" when working in a Revenue update batch"

When working in a Revenue Update batch generated by the Generate Revenue Update Batch task and attempting to update the recognition credits on payments applied to pledges, users may receive the error:

Data could not be saved.  The INSERT statement conflicted with the FOREIGN KEY constraint "FK_BATCHREVENUERECOGNITION_ADDITIONALAPPLICATIONDESIGNATIONID". The conflict occurred in database "30656Dev_0c49b4a1-74f8-4383-9171-b47bae52eb3a", table "dbo.DESIGNATION", column 'ID'.
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.9.1001.134
 2.9.1001, patch 137

Was this article helpful?