Overview
Usually, when saving item attribute values fails, a Data Import error message would occur similar to below:
Orchestrate data flow import has failed. The detailed information is as follows:
violation of PRIMARY KEY constraint
'PK_orc_ItemAtribValues, Cannot insert duplicate key in object dbo.orc_itemAttribValues, The duplicate key value is (1,2,3)
Import Command:
EXEC wf.pr_merge_orc_items
What causes this
The Item Code and Analysis Code 1 must be unique in the Access Supply Chain client when creating parts; otherwise, this error will occur.
Within FactoryMaster, the cause of this error is from multiple routes being used as a default for the same part.
Need further help?
To find which part is causing the duplicate, please contact support and include the error message that you are seeing. We will be happy to help!!