000033026 - The Weaknesses field calculation error on POA&Ms application (Federal A&A V2) in RSA Archer

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 22, 2017
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000033026
Applies ToRSA Product Set: Archer
RSA Version/Condition:
Platform: Windows
IssueUser-added image
The "Weaknesses" field will display a calculation error when more than one Allocated Control is attached to the POA&Ms record.
Calculation Error

Application Name:POA&Ms 
 Alias ID:POAMs 
 Tracking ID:212739 
 Field Name:Weaknesses 
 Field ID:Weaknesses 
 Calculation Error:A parameter "!2!A1:A2" expected to be a single value was multiple values. Parameter name: !2!A1:A2 
 Formula:REF([Allocated Control],[Comments])


CauseThe Weaknesses field calculation is not designed to reference comments from multiple related records, however the application is designed to allow the reference of multiple related records.
ResolutionThis issue will be fixed in the POA&M Management solution for Archer version 6.1.
1. Drag the weaknesses field off layout
2. Change Allocated Controls name to Related Allocated Controls
3. Switch display control to “grid”
4. Update record lookup display fields to:
User-added image
5. Check “use record lookup configuration”
User-added image
6. Drag Related Allocated Controls cross reference on Layout
7. Delete DDE Action – Hide Weaknesses Field
8. Delete DDE Rule – Hide Weaknesses Field