000038641 - RSA Archer Report export cross-reference field has colon after data

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

Article Content

Article Number000038641
Applies ToRSA Product Set: RSA Archer
Versions: 6x
IssueWhen a user tries to pull a report from an application a cross-reference field has a colon (:) at the end of its values. The customer checked the referenced application and extracted a report directly from it – which doesn’t have any : in it. Data seems to be fine while checking in Archer but a colon (:) appears in report extracts. 

ResolutionThe cross-referenced application was leveled. The cross-reference had a key at each level. Each level had a key.

User-added image

Archer uses the : character as a level delimiter for report export. In this case, it was adding the : at the end even though nothing was in the next level.

User-added image

In this example look at line 2. It has both. The : is a separator. There is no way to get rid of the colon because the levels each have a required key.
This is functioning as designed.