1. Home
  2. Labeling Software
  3. EPLS
  4. “Unable to update Items to the local server: The MERGE statement conflicted with the FOREIGN KEY constraint” – Maruchan EBI Pallet Label System Error Message

“Unable to update Items to the local server: The MERGE statement conflicted with the FOREIGN KEY constraint” – Maruchan EBI Pallet Label System Error Message

Summary

This Error Message Article explains the Maruchan EBI Pallet Label System error message “Unable to update Items to the local server: The MERGE statement conflicted with the FOREIGN KEY constraint” and details how to fix the underlying problem that caused it to appear.

Explanation

The SQL statement executed on the local client machine was unable to update the Item table on the Central Server because a foreign key referenced that table was missing in the table referenced by the foreign key (in this case Item_Material_Group_Codes).

Solution

There is a mismatch of database structure between the local workstation and center server.  Verify that the database structures are identical and come from the same EBI Pallet Label System software version.

Additional Comments

Reference Article: KBA-01108-B4C5Q5 – “Downloading Tables (by opening the Maruchan client app or using the ‘Download Tables’ button) Results in an ‘Unable to Update XXXX’ Error Message”

Error First Appeared:  Windows 7 client with SQL running on Windows 2008 Server

Updated on September 3, 2017

Was this article helpful?

Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help!
Contact Support