The full error message during the data import:-
β
β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
Please check within FactoryMaster (FM) that the nested components have the correct parent child structure. The assembly components contain phantom parts. For e.g. change the analysis code against part M101-20-0003(which generated works order 1215.00) from components BU1A to BW0 and then the import will complete successfully, and all items can be added to the plan. If the issue still continues to occur please raise a new case online and reference the title of this article.
Access Supply Chain
We need to use the first number in the error message in brackets to find the job code from the database. Please raise a new case online and reference the title of this article.
