on Aug 20, 2016Article Content
| Article Number | 000033822 |
| Applies To | RSA Product Set: Archer eGRC RSA Version/Condition: 6.x |
| Issue | 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> |
| Cause | The 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: |
| Workaround | Ensure that a field is included at each level of the relationship. |