Advanced Workflow Designer fails to save changes that are made to Advanced Workflow Process when transitions are moved from one node to another and nodes are deleted at the same time. The user is presented with an error message box entitled "Workflow Builder Error" and contains the text "The Workflow builder encountered an unexpected error. Please contact your system administrator for more details." The error logs will contain the following event:
<TraceRecord Severity="Error" xmlns="http://schemas.microsoft.com/2004/10/E2ETraceEvent/TraceRecord">
<Description>The Save operation had the following error:
Update failed on table WP_PROC_NODE:
WP_PROC_NODE row error: The DELETE statement conflicted with the REFERENCE constraint "fk5_wp_tran".
The conflict occurred in database "ArcherInstance", table "dbo.WP_TRAN".
The statement has been terminated. (WP_PROC_NODE.PROC_NODE_ID = 726, WP_PROC_NODE.PROC_NODE_DB = CUST)
Save the Workflow in two steps:
Move transitions from one node to another and either create fake transitions for orphaned nodes and save Workflow.
Remove all the node(s) that are not needed and save Workflow.