000033822 - Clicking a column to sort causes an error in a flat report with multiple relationships for RSA Archer 6.x

Document created by RSA Customer Support Employee on Aug 20, 2016Last modified by RSA Customer Support on Jul 2, 2019
Version 5Show Document
  • View in full screen mode

Article Content

Article Number000033822
Applies ToRSA Product Set: Archer eGRC
RSA Version/Condition: 6.x
 
IssueA 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>
CauseThe error 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