This error occurs during a data import when a duplicate key conflict is detected in the dbo.orc_TaskRelations table. The steps to resolve it depend on which product you are using.
The full error message will appear as follows:
Orchestrate data flow import has failed. The detailed information is as follows: Cannot insert duplicate key row in object 'dbo.orc_TaskRelations' with unique index 'IX_orc_TaskRelations'. The duplicate key value is (value 1, value 2, value 3) Import Command: EXEC [wf].[pr_Merge_TaskRelations]
FactoryMaster
This error is caused by nested components with an incorrect parent-child structure, where assembly components contain phantom parts. You can resolve this by correcting the analysis code for the affected part in FactoryMaster.
In FactoryMaster, identify the part that generated the works order referenced in the error.
Check the nested components for that part and review the parent-child structure.
Correct the analysis code on the affected part — for example, change the analysis code from
BU1AtoBW0on the relevant part to remove the phantom component.Re-run the data import. All items should now be added to the plan successfully.
📌Note: If the error continues to occur after making this change, please raise a new case online and reference the title of this article.
Access Supply Chain
This error requires investigation by our support team, who will use the first number in the error message brackets to locate the relevant job code in the database.
📌Note: Please raise a new case online and reference the title of this article so our team can investigate.