Error: Data could not be saved. The DELETE statement conflicted with the REFERENCE constraint FK_MERCHANDISEPRODUCTINSTANCE_VENDORID". The conflict occurred in database "3256_18116fda-3d8e-4818-8980-1a83f9cbb44f", table "dbo.MERCHANDISEPRODUCTINSTANCE"

When trying to merge or delete a vendor record; you may encounter the error Data could not be saved. The DELETE statement conflicted with the REFERENCE constraint "FK_MERCHANDISEPRODUCTINSTANCE_VENDORID". The conflict occurred in database "3256_18116fda-3d8e-4818-8980-1a83f9cbb44f", table "dbo.MERCHANDISEPRODUCTINSTANCE", column 'VENDORID'.
This issue has been resolved in version 4.5 of Altru.  All sites were updated in October 2015.

Steps to Duplicate

  1. Go to Merchandise > Vendor Search.
  2. Pull up the vendor you want to delete.
  3. Click Delete vendor under Tasks.
  4. Receive error: Data could not be saved.   The DELETE statement conflicted with the REFERENCE constraint "FK_MERCHANDISEPRODUCTINSTANCE_VENDORID". The conflict occurred in database "50919_d59b4778-f328-4ad0-9e58-a1d76ff763e7", table "dbo.MERCHANDISEPRODUCTINSTANCE", column 'VENDORID'.

Environment

 Altru Arts & Cultural
 Yes
 4.1

Was this article helpful?