Hello all, I'm having a serious problem with tasks being unassigned when someone tries to add an assignee target. It doesn't happen to every single tasks in ServiceDesk but it is happening on a good number of tickets it is being a serious problem.
A case scenario is that a task is assigned to a 'Support' group. A worker wants to add himself as an assign so they click on 'Reassign' and click on 'Add'. The ticket ends up being unassigned. At this point it won't be assigned to both 'Support' and the user. The task just ends up having no assignees at all. Below is the two log entries that I get when this happens. Any help is appreciated.
Application Name: SD.IncidentManagement
Process ID: 2308
Date :Apr-04-2011 12:52:51 PM
Log Level :Error
Log Category :Ensemble.WorkflowTasks.AddTaskAssigment
Message:
Exception at Run method with message :Server was unable to process request. ---> Error executing sql query. ---> The INSERT statement conflicted with the FOREIGN KEY constraint "FK_TaskAssignment_Task". The conflict occurred in database "Ensemble", table "dbo.Task", column 'TaskID'.
The statement has been terminated.
Application Name: SD.IncidentManagement
Process ID: 2308
Date :Apr-04-2011 12:55:06 PM
Log Level :Error
Log Category :LogicBase.Components.Default.Logging.CreateLogEntryComponent
Message:
Assignment System could not Create Assignment for: 60ded9da-3cd0-4dd3-a4bc-d5e40d1fe4bb