User unable to import data due to the following error message:
Orchestrate Data Flow import has failed. The detailed information is as follows:
Orchestrate: Error: 'Cannot insert the value NULL into column 'CustomerID', table 'Orchestrate_LIVE.dbo.orc_CustomerOrders' column does not allow nulls.INSERT fails.
Import command:
EXEC [wf].[pr_Merge_Sales_Orders]
The order has not been booked in correctly. Please check the ERP software you are importing the data from, for any orders with a blank Customer Code assigned to them. Once you have found this record, please populate the order with the relevant details or delete the order from your system.
If you are having difficulties finding the NULL customer ID value, please start a conversation on the Access Community Portal. How to contact Support via the MyAccess Portal | Orchestrate Help Centre