The DELETE statement conflicted with the REFERNCE constraint 'FK_BATCHCONSTITUENTADDRESSUPDATE_ADDRESSID'. The conflice occured in database [database name], table 'dbo.BATCHCONSTITUENTADDRESSUPDATE', column 'ADDRESSID'.

When removing an individual as a contact from an organization, the following error is encountered:

The DELETE statement conflicted with the REFERNCE constraint 'FK_BATCHCONSTITUENTADDRESSUPDATE_ADDRESSID'. The conflice occured in database [database name], table 'dbo.BATCHCONSTITUENTADDRESSUPDATE', column 'ADDRESSID'.
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.91.1535, patch 33 ; 2.9.1001, patch 65
 2.9.1001, patch 81 ; 3.0.516, Service Pack 6 ; 2.93.2034, patch 97 ; 2.94.1524, patch 94

Was this article helpful?