000036457 - Warning message "Calculated Fields are not allowed to be updated by the Update Content node" in RSA Archer

Document created by RSA Customer Support Employee on Jun 28, 2018•Last modified by RSA Customer Support Employee on Jul 26, 2018
Version 3Show Document
  • Comment • 0
  • View in full screen mode

Article Content

Article Number000036457
Applies ToRSA Product Set: Archer
RSA Product/Service Type: Advanced Workflow, User Interface
RSA Version/Condition: 6.3.0.1
IssueFields that are referenced by an Update Content node are not prevented from being configured as a calculated field after the node has been configured. Should a field referenced by an Update Content node be changed to calculated, any current and future AWF jobs that use that node will error.

When troubleshooting the AWF job in the Job Troubleshooting window, selecting the node will cause the calculated field to be removed from the node and result in the following error:

Calculated Fields are not allowed to be updated by the Update Content node. Please re-configure the field settings.


Calculated Fields are not allowed to be updated by the Update Content node. Please re-configure the field settings
CauseField referenced by Update Content node has been changed to calculated.
ResolutionTo resolve the issue, edit the offending field and deselect the calculation option in the Application Builder.

If the field that was changed to a calculated field is not known, a script is provided below to identify the calculated field(s). Perform the following steps:
  1. Place a record into Advanced Workflow.
  2. Open that record’s AWF job in the Advanced Workflow > Job Troubleshooting window.
  3. Select the ellipses (…) next to the Save button in the upper-left corner and click Cancel then Save. (This prevents the popup error and removal of offending field.)
  4. Select the Update Content node that has the calculated field.
  5. In the Activity Node Properties window on the right side of the screen, scroll down to the User Data section.
  6. For each _FieldValues entry that contains data, select the Edit icon then copy the content from the window that appears into a text editor. (Take note which _FieldValue the content is from.)
  7. The GUIDs are to be used in the WHERE clause of their respective scripts. Edit the data so that it conforms to the format required by SQL
     
    Edit GUIDs
     
  8. Open the attached script, which has four SELECT statements, in SQL Manager and perform the following:
    1. Replace the word ‘GUIDs’ in the respective WHERE clauses with the edited data. Each script is preceded by a notation that corresponds to the _FieldValue.
    2. Execute the scripts. Unedited scripts will have no output.
  9. Fields that have the calculation option enabled will be displayed.
  10. Deselect the calculation option of the field(s) shown in the output in the Application Builder.

Attachments

Outcomes