000033822 - Clicking a Column to Sort causes an error in an RSA Archer Flat Report with multiple Relationships

Document created by RSA Customer Support Employee on Aug 20, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000033822
Applies ToRSA Product Set: Archer eGRC
RSA Version/Condition: 6.x
O/S Version: Windows Server 2012/R2
IssueClicking a Column to Sort causes an error in an RSA Archer Flat Report with multiple Relationships
A Flat Report with multiple Relationships Enforced will return a Log Reference Id error when you attempt to sort by a column if you neglect to include at least one field in each Relationship.

Sample exception from w3wp log:
<TraceRecord Severity="Error" xmlns="http://schemas.microsoft.com/2004/10/E2ETraceEvent/TraceRecord">
  <TraceIdentifier>Archer.Web</TraceIdentifier>
  <LogReferenceId>081916-213424-3056</LogReferenceId>
  <Description>Object reference not set to an instance of an object.</Description>
  <AppDomain>xxx</AppDomain>
  <ContextData>
    <BaseUrl>http://servername/RSAarcher/SearchContent/Search.aspx</BaseUrl>
    <view>Report</view>
    <Report>ReportId: ####, ReportName: Facilities Report Error, ReportType: SearchBased</Report>
    <Module>ModuleId: ##, ModuleName: Facilities, ModuleStatus: ActiveInProduction, ModuleType: Application</Module>
    <frameWidthHeight>1572,768</frameWidthHeight>
  </ContextData>
  <Exception>
    <ExceptionType>System.NullReferenceException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</ExceptionType>
    <Message>Object reference not set to an instance of an object.</Message>
    <Source>Security2000</Source>
    <StackTrace>
   at Security2000.SearchContent.Search.GetSearchSortFieldsForLevel(IEnumerable`1 searchModuleCriterium, Int32 levelId)
   at Security2000.SearchContent.Search.GetSearchSortFieldsForLevel(IEnumerable`1 searchModuleCriterium, Int32 levelId)
   at Security2000.SearchContent.Search.SetAscendingSortOrder(Int32 fieldId, Int32 levelId)
   at ArcherTech.Web.ArcherTechPage`2.CheckPreLoadPostBackEvent()
   at ArcherTech.Web.ArcherTechPage`2.OnLoad(EventArgs e)
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)</StackTrace>
  </Exception>
</TraceRecord>

CauseThis is caused by a Report having multiple Relationships, where one Relationship is created through the first Relationship, and you neglect to add a field for the first relationship as shown below.
User-added image
WorkaroundEnsure that a field is included at each level of the Relationship.

Attachments

    Outcomes