Can't import data due to the following error message:-
Orchestrate Data Flow has failed. The detailed information is as follows:
Invalid OrderCode 123456.00 for Order Attribute D365SelectedResourceCodes 123456.00 has invalid attribute name D365SelectedResourceCodes
Import command:
EXEC [wf].[pr_Merge_orc_Orders]
or
Orchestrate Data Flow has failed. The detailed information is as follows:
ORDERNUMBER has invalid OrderStatusDescription 10
Import command:
EXEC [wf].[pr_Merge_orc_Orders]
Tasks in the Staging Database are likely referencing 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 you require assistance identifying the offending tasks, please start a conversation on the Access Community Portal. How to contact Support via the MyAccess Portal | Orchestrate Help Centre
For the invalid order status description data import error, please correct the status from the ERP system, or if it is a really old order, cancel the order.