Data could not be saved. The UPDATE statement conflicted with the REFERENCE constraint FK_MKTVENDORSERVICETYPE_VENDORID". The conflict occurred in database "[database name]", table "dbo.MKTVENDORSERVICETYPE", column 'VENDORID' when merging a vendor recor

Users cannot make a vendor from an existing record in the system, so a duplicate had to be added in order to tag the record as a vendor.  When merging the original with the duplicate the user gets Data could not be saved. The UPDATE statement conflicted with the REFERENCE constraint "FK_MKTVENDORSERVICETYPE_VENDORID". The conflict occurred in database "[database name]", table "dbo.MKTVENDORSERVICETYPE", column 'VENDORID.'

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.1534, patch 76
 2.94.1524, patch 83 ; 3.0.516, Service Pack 4

Was this article helpful?