Exception The UPDATE statement conflicted with the CHECK constraint "CK_REVENUELETTER_LETTERREVENUECONSTITUENT_CURRENTUNIQUE" The conflict occurred in the database "Dbo.Prod", table "dbo.RevenueLetter""

When running a merge process we will receive the following exception message if, an acknowledgee belongs to the same letter twice on his revenue record. 

Exception "The UPDATE statement conflicted with the CHECK constraint "CK_REVENUELETTER_LETTERREVENUECONSTITUENT_CURRENTUNIQUE" The conflict occurred in the database "Dbo.Prod", table "dbo.RevenueLetter"


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

 3.0.516
 3.0.516, Service Pack 7

Was this article helpful?