User unable to import data due to the following error:-
Orchestrate Data Flow import has failed. The detailed information is as follows:
Cannot insert the value NULL into column 'ResourceGroupID', table 'orc_Testing20220517_1500.dbo.orc_TaskSecondaryResourceGroups'. Column does not allow nulls. INSERT fails.
import command: EXEC [wf].[pr_Merge_TaskSecondaryResourceGroups]
or
Orchestrate Data Flow import has failed. The detailed information is as follows:
Merge Task Secondary Resource Groups: Unknown resource group code '_[L} LAB 3'
Cannot insert the value NULL into column 'ResourceGroupID', table 'orc_Testing20220517_1500.dbo.orc_TaskSecondaryResourceGroups'. Column does not allow nulls. INSERT fails.
import command: EXEC [wf].[pr_Merge_TaskSecondaryResourceGroups]
If you receive the second error where the unknown resource group code is specified, please create the relevant resource group from within Orchestrate and save the plan:-
Please complete the following steps to delete machine resource groups:
Select resources
Resource groups
Click edit
Click New Row
Enter code and description from Resource Groups section and Resources section.
Click Apply and OK
or,
To create Labour resource groups:
Select resources
Labour groups
Click edit
Click New Row
Enter code and description from Resource Groups section and Resources section.
Click Apply and OK
If the first error message displays, please start a conversation on the Access Community Portal. How to contact Support via the MyAccess Portal | Orchestrate Help Centre