Skip to main content

Error: 'Invalid order code for order attribute has invalid attribute name' for Order ID table Affected Attrib Values

Written by Charnjit Singh Dharival

User cannot 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 IssueStatus 123456.00 has invalid attribute name IssueStatus Cannot insert the value NULL into column 'OrderID', table @AffectedAttribValues'; column does not allow nulls. INSERT fails.

Import command:
EXEC [wf].[pr_Merge_orc_Orders]


The issue status had not been set on the relevant works order from FactoryMaster, when the data import was initially run. Run the data import again and it will complete.

Did this answer your question?