000039245 - Advanced Workflow Designer fails to save changes in RSA Archer

Document created by RSA Customer Support Employee on Aug 28, 2020
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000039245
Applies ToRSA Product Set: RSA Archer
RSA Version/Condition: 6.x
IssueAdvanced 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)

ResolutionSave the Workflow in two steps:
  1. Move transitions from one node to another and either create fake transitions for orphaned nodes and save Workflow. 
  2. Remove all the node(s) that are not needed and save Workflow.