When importing data, the following error message generated:-
Orchestrate Data Flow has failed. The detailed information is as follows:
pr_Merge_Pegging_WO_CO: Missing CustomerOrderItemID 123456.00 for CustomerOrderCode CUST1
Cannot insert the value NULL into column 'CustomerOrderItemID' table ORC_live.dbo.orc_DefinedPegging_WO_CO.
Import command:
EXEC [wf].[pr_Merge_Pegging_WO_CO]
Items in Staging Database referenced Sales Orders that do not exist in Staging Database. Your ERP vendor will need to delete the offending Tasks from the staging database or fix the issue at the attribute level. This will lead them to being imported without their accompanying Orders, hence, fixing the data import.
If the sales orders are in existence, please check the the sales order item lines in the Staging Database or CSV files (depending on which integration you are using) for duplicate rows.