Cannot import data into the application. The following error generates:-
Orchestrate Data Flow import has failed. The detailed information is as follows:
Invalid PrimaryResourceGroupCode AB_123
Cannot insert the value NULL into column 'PrimaryResourceGroupID'.
Table 'OrchestratePlanner_ABC.dbo.orc_ProcessSteps, column does not allow nulls.
INSERT fails.
import command:
EXEC [wf].[pr_merge_orc_ProcessSteps]
This error is a data issue. Please check the routing of the works orders on the ERP system. For example, the relevant resource may be disabled for scheduling (within FactoryMaster) or the process step is missing work duration time (within Orchestrate).
You can enable the resource to be included in the schedule by completing the following steps:
Select production
resource maintenance
Hit enter and select relevant resource
Select Yes under the Include In Schedule column
To add work duration to a process, please complete the following steps:
Select planning
processes
select the relevant process and click Edit
select process details
select relevant op step and enter a figure in field Process Duration (Mins)