User received the following error message when trying to export the data to Access Supply Chain:-
Orchestrate data flow import has failed. The detailed information is as follows:
Violation of PRIMARY KEY constraint
'PK_orc_Orders_ERP_OpSteps_OrderID_OpStep'. Cannot insert duplicate key in object dbo.orc_Orders_ERP_OpSteps. The duplicate key value is (1,2)
Import Command:
EXEC [wf].[updateASC]@DataSourceName = 'Core Supply Chain'. @DatabaseName = 'the database name'
@Days_HistoryToKepp=90
Please start a conversation on the Access Community Portal. How to contact Support via the MyAccess Portal | Orchestrate Help Centre