I am receiving the following error message when I try to complete a task or archive multiple tasks:-
An unexpected error occurred. Please report this problem to your system administrator with the following information:
System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint “FK_orc_Actuals_orc_Resources”. The conflict occurred in database “orchestrate_prod” , table “dbo.orc_Resources”, column ‘ResourceID’. The statement has been terminated.
The error indicates there is a conflict between the Actuals and Resources table when trying to complete or archive specific works orders
Please answer the following questions:
Is there a labour resource selected when selecting the Actuals tab via Edit Tasks?
Which resources are entered in the Resources tab via Edit Tasks?
The likely cause of this issue is that there is nothing selected in the labour resource from the Actuals tab within Edit Tasks and none of the resources are specified as the primary resource. One of the resources on the offending works order needs to have the checkbox ticked under the Primary column, of the resources tab of Edit Tasks (Left-hand pane).
If the issue continues to occur, a enhancement has been completed on Orchestrate 7.71 to prevent ghost tasks generating, when after an error occurs due to the fact that the Max Offset is smaller than the Min Offset. Please upgrade to this version or above.