000036457 - RSA Archer: Identify calculated field in Advanced Workflow Update Content node

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

Article Content

Article Number000036457
Applies To
RSA Product Set: Archer
   RSA Product/Service Type: RSA Archer
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.
ResolutionEdit the offending field and uncheck 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 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 (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. Uncheck the calculation option of the field(s) shown in the output in the Application Builder

Outcomes