We have a Dev server, and I would like to start fresh with a clean Service Desk instance. I've been clearing everything out by deleting all desks, and all Stage Entry/Exit, Goal, Escalation, etc. procedures. I've had no trouble deleting these. However, when I get to deleting the Sub Procedures, I am getting an error:
Error #50000: The DELETE statement conflicted with the REFERENCE constraint "FK_treePresNodeCallee". The conflict occurred in database "ksubscribers", table "dbo.treePresNodeXref". on line 308. Execution Duration: 12:45:33 PM - 12:45:33 PM SQL Command: Stored Procedure: sp_DeleteTreeNode @partitionID = 1 @nodeID = 42531581645189318315717161 @tranID = @effId =
When I try to delete the folders instead of just the individual procedures, I get a similar error:
Error #50000: The DELETE statement conflicted with the REFERENCE constraint "FK_treePresNodeCallee". The conflict occurred in database "ksubscribers", table "dbo.treePresNodeXref". on line 308. Execution Duration: 12:45:48 PM - 12:45:48 PM SQL Command: Stored Procedure: [dbo].[sp_DeleteTreeNode] @NODEID = 68761323362312325536647571 @PARTITIONID = 1 @TRANID = 20150711119408544562183018 @EFFID = 201507186399999
Any thoughts on how I can delete these sub procedures? I've tried uninstalling and reinstalling Service Desk, but those scripts came back.
Thanks