000038450 - RSA Archer-to-Archer Data Feeds have warnings: Values list value contains extra colons within the field

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

Article Content

Article Number000038450
Applies ToRSA Product Set: RSA Archer
RSA Version/Condition: 6.x
IssueWhen running the Data Feed, a warning "Values list value contains extra colons within the field" is displayed and the data in the field is not transferred to the destination as expected.

User-added image
CauseDue to a design limitation of the out of the box transform, when using an Archer-to-Archer data feed (Archer Web Services Transporter), it is required for all fields in the report to have at least one value before "Load Fields" functions properly on the Source Definition tab of a Data Feed.  

If the requirement is not met, then "Load Fields" does not properly create values list fields on the Source Definition tab of the Data Feed and the Data Feed will have these warnings and fail to transfer data as expected after being mapped.

This is already documented in the Archer Help:

User-added image
 
WorkaroundWorkaround #1 (During Data Feed design/Development):
  1. Add records until the report has at least one value in every field of the report.
  2. "Load Fields" on the Source Definition Tab.
  3. Remap all fields.

Workaround #2 (Manually fix the source definition).
For each values list field that is causing this Warning to be reported. 

  1. Source Definition tab of the Data Feed
  2. Click "Add Child" on the right of the Values List field that does not have any child items.
  3. Name the child "Item" so it appears the same as other Values List fields on the source definition.
  4. Set the child to "Raw Data" type so it appears the same as other Values List fields on the source definition.
NotesThe following related Product Enhancement Request is available to be voted on:
Remove requirement that all fields in a report need to have a value in at least one record when building A2A Data Feeds

Attachments

    Outcomes