000037528 - RSA Archer: Searching on a cross reference lookup with expand all checked throws an unexpected error

Document created by RSA Customer Support Employee on May 29, 2019
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000037528
Applies ToRSA Product Set: Archer
RSA Product/Service Type: Search, Cross reference
RSA Version/Condition: 5.5.x,6.x
 
IssueUser-added image

Users were experiencing an unexpected error when searching on a cross-reference field with expand all checked. 

User-added image
 

<TraceRecord Severity="Error" xmlns="http://schemas.microsoft.com/2004/10/E2ETraceEvent/TraceRecord">
<TraceIdentifier>Archer.Web</TraceIdentifier>
<LogReferenceId>110118-192641-1881</LogReferenceId>
<Description>A column named '20239' already belongs to this DataTable.</Description>
<AppDomain>/LM/W3SVC/1/ROOT/RSAarcher-1-131855551933260816</AppDomain>
<ContextData>
<BaseUrl>[http://X.X.XX.XXX/RSAarcher/SearchContent/Search.aspx]</BaseUrl>
<view>Lookup</view>
<Report>ReportId: 8673, ReportName: XREF Lookup Report, ReportType: SearchBased</Report>
<Field>FieldId: 20244, FieldName: Control Library, FieldType: CrossReference, IsActive: true, LevelId: 39</Field>
<Module>ModuleId: 528, ModuleName: Control Library, ModuleStatus: ActiveInDevelopment, ModuleType: Application</Module>
<maxValue>1</maxValue>
<IncludeNoSelection>true</IncludeNoSelection>
</ContextData>
<Exception>
<ExceptionType>System.Data.DuplicateNameException, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</ExceptionType>
*<Message>A column named '20239' already belongs to this DataTable.</Message>*
*<Source>System.Data</Source>*
<StackTrace> at System.Data.DataColumnCollection.RegisterColumnName(String name, DataColumn column)
at System.Data.DataColumnCollection.BaseAdd(DataColumn column)
at System.Data.DataColumnCollection.AddAt(Int32 index, DataColumn column)
at Telerik.Web.UI.GridDataTableFromEnumerable.CreateColumn(PropertyDescriptor descriptor, String fieldName)
at Telerik.Web.UI.GridResolveEnumerable.ParseProperties()
at Telerik.Web.UI.GridResolveEnumerable.Initialize()
at Telerik.Web.UI.GridResolveEnumerable.EnsureInitialized()
at Telerik.Web.UI.GridEnumerableFromDataView..ctor(GridTableView owner, IEnumerable enumerable, Boolean CaseSensitive, Boolean autoGenerateColumns, GridColumnCollection presentColumns, String[] additionalField, Boolean retrieveAllFields, Boolean enableSplitHeaderText)
at Telerik.Web.UI.GridDataSourceHelper.CreateGridEnumerable(GridTableView owner, IEnumerable enumerable, Boolean caseSensitive, Boolean autoGenerateColumns, GridColumnCollection presentColumns, String[] additionalField, Boolean retrieveAllFields, Boolean enableSplitHeaderText)
at Telerik.Web.UI.GridTableView.get_ResolvedDataSource()
at Telerik.Web.UI.GridTableView.CreateChildControls(IEnumerable dataSource, Boolean useDataSource)
at System.Web.UI.WebControls.CompositeDataBoundControl.PerformDataBinding(IEnumerable data)
at System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data)
at Telerik.Web.UI.GridTableView.PerformSelect()
at Telerik.Web.UI.GridTableView.DataBind()
at Telerik.Web.UI.GridItemBuilder.BindDetailTables(GridDataItem parentItem, GridNestedViewItem detailItem)
at Telerik.Web.UI.GridItemBuilder.CreateItems(GridGroupingContext group)
at Telerik.Web.UI.GridTableView.CreateItems(IEnumerator enumerator, GridColumn[] columns, ControlCollection controls)
at Telerik.Web.UI.GridTableView.CreateControlHierarchy(Boolean useDataSource)
at Telerik.Web.UI.GridTableView.CreateChildControls(IEnumerable dataSource, Boolean useDataSource)
at System.Web.UI.WebControls.CompositeDataBoundControl.PerformDataBinding(IEnumerable data)
at System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data)
at Telerik.Web.UI.GridTableView.PerformSelect()
at Telerik.Web.UI.GridTableView.DataBind()
at ArcherTech.Web.UI.Controls.GenericContent.GridLookupSearchResultView.OnPreRender(EventArgs e)
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)</StackTrace>



 
Cause
  1. This issue occurs when we do a lookup on a cross-reference field and search for content with a record at 4th level on target leveled application checking the Expand All.
  2. Configuration Causes this issue: This issue occurs when the Cross-reference field is Configured with Maximum Selection value as 1.

     
    ResolutionThis has been logged as an internal defect: ARCHER-59676: Cross-reference lookup throws an unexpected error when Expand All is checked. 
    WorkaroundWorkaround: Immediate workaround for the customer is to change the Maximum Selection value as 2 or more/ or else use the column flat.

    Steps are as follows:
    1. Open the application via manage Application
    2. Go to Fields -> Click on Field -> Click on Options -> Scroll down till the end of the page and set the Maximum Selection value as 2 or more.
    3. Another workaround is to Go to Fields -> Click on Control Library Field -> Click on Options => use column flat Display Format in Record Lookup Configuration.
    NotesARCHER-59676: Cross-reference lookup throws an unexpected error when Expand All is checked.

    Attachments

      Outcomes