If you are trying to complete the data import, you may come across an error similar to the one below, stopping you from completing this:

Orchestrate data flow import has failed. The detailed information is as follows:

Violation of PRIMARY KEY constraint
'PK_orctmp_CustomerOrderItemAttributeValues_RowID'. Cannot insert duplicate key in object dbo.wf.orctmp_CustomerOrderItemAttributeValues. The duplicate key value is (1)

Import Command:
SELECT 1 AS PlanID
, SalesOrderNumber AS CustomerOrderCode
, LineNumber AS ItemNumber
, OrderType AS AttribName
, OrderType AS charValue
FROM ASC_ORC_SALES_ORDER_DETAIL

Please contact support, including the error message you are seeing. We will be happy to help.