ArgumentException, Column 'x' does not belong to table Table

[ADV Dev]

Hi,

we are using a radgrid and randomly get the below error for the column used in GroupByExpressions. The column exists in the query and it works fine most of the time,  but sometimes it throws the below error. I have gone through many forum posts but no avail. The try catch statements too dont handle the error and we get the yellow screen of death. we have posted the server log too below. We are using version 2014.1.403.45 of the controls.
Any help would be greatly appreciated. 
aspx

001.<telerik:RadGrid ID="radProject3" runat="server"
002.                            AutoGenerateColumns="False"
003.                            AllowSorting="True"
004.                            AllowPaging="True"
005.                            ShowFooter="True"
006.                            ShowGroupPanel="true"
007.                            AllowFilteringByColumn="False"
008.                            EnableGroupsExpandAll="True"
009.                            EnableHeaderContextMenu="true"
010.                            EnableHeaderContextFilterMenu="False"
011.                            CellSpacing="0"
012.                            PageSize="25"
013.                            >
014.                            <ExportSettings HideStructureColumns="true"
015.                                ExportOnlyData="true"
016.                                IgnorePaging="true"
017.                                OpenInNewWindow="true"
018.                                FileName="TaskSheet"
019.                                >
020.                                <Csv RowDelimiter="Tab" />
021.                                <Excel Format="Html" AutoFitImages="true" />
022.                                <Pdf FontType="Link" ForceTextWrap="true" BorderColor="#000000" BorderStyle="Thin" BorderType="AllBorders" DefaultFontFamily="Arial"  >
023.                                    <PageHeader>
024.                                        <LeftCell Text="" TextAlign="Left" />
025.                                        <RightCell Text=""  TextAlign="Right" />
026.                                    </PageHeader>
027.                                </Pdf>
028.                            </ExportSettings>
029.                            <MasterTableView DataKeyNames="FullJobNo, t_Briefno, t_BriefVersionNo, t_BriefRevisionNo"
030.                                ClientDataKeyNames="FullJobNo, t_Briefno, t_BriefVersionNo, t_BriefRevisionNo"
031.                                AllowMultiColumnSorting="True"
032.                                EnableHierarchyExpandAll="true"
033.                                GroupLoadMode="Server"
034.                                Name="ARMPROJECT"
035.                                FilterItemStyle-Height="10px"
036.                                CommandItemDisplay="top"
037.                                CommandItemStyle-Height="5px"
038.                                >
039.                                 <PagerStyle Mode="NextPrevAndNumeric"  AlwaysVisible="true" PageSizes="{20, 25, 50, 75, 100, 200, 250, 500, 750, 1000, 1000}"></PagerStyle>
040.                                <GroupByExpressions>
041.                                    <telerik:GridGroupByExpression>
042.                                        <SelectFields>
043.                                            <telerik:GridGroupByField FieldName="assignedto" HeaderText="Assigned To" />
044.                                        </SelectFields>
045.                                        <GroupByFields>
046.                                            <telerik:GridGroupByField FieldName="assignedto" SortOrder="Ascending" />
047.                                        </GroupByFields>
048.                                    </telerik:GridGroupByExpression>
049.                                </GroupByExpressions>
050.                                <CommandItemSettings
051.                                    ShowExportToExcelButton="false"
052.                                    ShowRefreshButton="true"
053.                                    ShowAddNewRecordButton="false" />
054.                                <Columns>
055.                                    <telerik:GridTemplateColumn DataField="Fav" GroupByExpression="Fav Group By Fav" UniqueName="Fav" HeaderText="Fav" SortExpression="Fav" ItemStyle-Width="16px" AllowFiltering="false" HeaderStyle-Width="16px">
056.                                        <ItemTemplate>
057.                                            <asp:ImageButton runat="server" ID="ImgFav" ImageUrl='<%# String.Format("~/images/icons/{0}", Eval("imgFav"))%>' Width="16px" Height="16px" />
058.                                            <asp:HiddenField runat="server" ID="hdnFav" Value='<%#Eval("Fav") %>' />
059.                                            <asp:HiddenField runat="server" ID="hdnIntRev" Value='<%#Eval("InternalReview1") %>' />
060.                                            <asp:HiddenField runat="server" ID="hdnClPr" Value='<%#Eval("ClientPresentation1") %>' />
061.                                            <asp:HiddenField runat="server" ID="hdnDead" Value='<%#Eval("Deadline1") %>' />
062.                                        </ItemTemplate>
063.                                    </telerik:GridTemplateColumn>
064.                                     <telerik:GridBoundColumn DataField="FavText"  UniqueName="FavText" HeaderText="Fav" SortExpression="FavText" AllowFiltering="false" Visible="false" ItemStyle-Width="30px" HeaderStyle-Width="30px">
065.                                        <ColumnValidationSettings>
066.                                            <ModelErrorMessage Text=""></ModelErrorMessage>
067.                                        </ColumnValidationSettings>
068.                                    </telerik:GridBoundColumn>
069.                                    <telerik:GridBoundColumn DataField="FullJobNo" UniqueName="FullJobNo" HeaderText="Job No" SortExpression="FullJobNo" ItemStyle-Width="90px" AllowFiltering="false">
070.                                        <ColumnValidationSettings>
071.                                            <ModelErrorMessage Text=""></ModelErrorMessage>
072.                                        </ColumnValidationSettings>
073.                                    </telerik:GridBoundColumn>
074.                                    <telerik:GridTemplateColumn GroupByExpression="FullBriefNo Group By FullBriefNo" UniqueName="FullBriefNo" HeaderText="Brief No" SortExpression="FullBriefNo" AllowFiltering="false" ItemStyle-Width="70px">
075.                                        <ItemTemplate>
076.                                            <asp:Label runat="server" ID="lblFullBriefNoWithD" Text='<%#Eval("FullBriefNoWithD")%>' Width="70px"></asp:Label>
077.                                            <asp:Label runat="server" ID="lblFullBriefNo" Text='<%#Eval("FullBriefNo") %>' Visible="false"></asp:Label>
078.                                             <asp:HiddenField runat="server" ID="hdnCostCentreCode" Value='<%#Eval("t_costcentrecode") %>' />
079.                                        </ItemTemplate>
080.                                    </telerik:GridTemplateColumn>
081.                                    <telerik:GridBoundColumn DataField="t_BriefType" UniqueName="t_BriefType" HeaderText="Brief Type" SortExpression="t_BriefType" AllowFiltering="false">
082.                                        <ColumnValidationSettings>
083.                                            <ModelErrorMessage Text=""></ModelErrorMessage>
084.                                        </ColumnValidationSettings>
085.                                    </telerik:GridBoundColumn>
086.                                    <telerik:GridBoundColumn DataField="t_briefdescription" UniqueName="t_briefdescription" HeaderText="Brief Title" SortExpression="t_briefdescription" AllowFiltering="false"
087.                                        ItemStyle-HorizontalAlign="Left"  HeaderStyle-HorizontalAlign="Left">
088.                                        <ColumnValidationSettings>
089.                                            <ModelErrorMessage Text=""></ModelErrorMessage>
090.                                        </ColumnValidationSettings>
091.                                    </telerik:GridBoundColumn>
092.                                    <telerik:GridBoundColumn DataField="t_jobdescription" UniqueName="t_jobdescription" HeaderText="Job Description" SortExpression="t_jobdescription" AllowFiltering="false"
093.                                        ItemStyle-HorizontalAlign="Left"  HeaderStyle-HorizontalAlign="Left" HeaderStyle-width="200px">
094.                                        <ColumnValidationSettings>
095.                                            <ModelErrorMessage Text=""></ModelErrorMessage>
096.                                        </ColumnValidationSettings>
097.                                    </telerik:GridBoundColumn>
098.                                    <telerik:GridBoundColumn DataField="brieffeed" UniqueName="t_brieffeed" HeaderText="Feed" SortExpression="brieffeed" AllowFiltering="false">
099.                                        <ColumnValidationSettings>
100.                                            <ModelErrorMessage Text=""></ModelErrorMessage>
101.                                        </ColumnValidationSettings>
102.                                    </telerik:GridBoundColumn>
103.                                    <telerik:GridBoundColumn DataField="t_taskname" UniqueName="t_taskname" HeaderText="Task Name" SortExpression="t_taskname" AllowFiltering="false">
104.                                        <ColumnValidationSettings>
105.                                            <ModelErrorMessage Text=""></ModelErrorMessage>
106.                                        </ColumnValidationSettings>
107.                                    </telerik:GridBoundColumn>
108.                                    <telerik:GridBoundColumn DataField="assignedto" UniqueName="t_assignedto" HeaderText="Assigned To" SortExpression="assignedto" AllowFiltering="false">
109.                                        <ColumnValidationSettings>
110.                                            <ModelErrorMessage Text=""></ModelErrorMessage>
111.                                        </ColumnValidationSettings>
112.                                    </telerik:GridBoundColumn>
113.                                    <telerik:GridBoundColumn DataField="ClientName" UniqueName="ClientName" HeaderText="Client Name" SortExpression="ClientName" AllowFiltering="false">
114.                                        <ColumnValidationSettings>
115.                                            <ModelErrorMessage Text=""></ModelErrorMessage>
116.                                        </ColumnValidationSettings>
117.                                    </telerik:GridBoundColumn>
118.                                    <telerik:GridBoundColumn DataField="BrandName" UniqueName="BrandName" HeaderText="Brand Name" SortExpression="BrandName" AllowFiltering="false">
119.                                        <ColumnValidationSettings>
120.                                            <ModelErrorMessage Text=""></ModelErrorMessage>
121.                                        </ColumnValidationSettings>
122.                                    </telerik:GridBoundColumn>
123.                                    <telerik:GridTemplateColumn GroupByExpression="t_OriginalFileName Group By t_OriginalFileName" UniqueName="t_FileName" HeaderText="File Name" SortExpression="t_OriginalFileName"
124.                                        AllowFiltering="false"
125.                                        Exportable="false">
126.                                        <ItemTemplate>
127.                                           <%-- <asp:LinkButton runat="server" ID="lnkViewFile" OnClick="lnkViewFile_Click" Text='<%#Eval("t_FileName") %>'></asp:LinkButton>--%>
128.                                               <asp:Label runat="server" ID="lblViewFile" Text='<%#Eval("t_OriginalFileName")%>' Visible="true" ></asp:Label>
129.                                        </ItemTemplate>
130.                                    </telerik:GridTemplateColumn>
131.                                    <telerik:GridBoundColumn DataField="InternalReview" UniqueName="InternalReview" HeaderText="Internal Review" SortExpression="InternalReview1" AllowFiltering="false"
132.                                        HeaderStyle-HorizontalAlign="Left" ItemStyle-HorizontalAlign="Left">
133.                                        <ColumnValidationSettings>
134.                                            <ModelErrorMessage Text=""></ModelErrorMessage>
135.                                        </ColumnValidationSettings>
136.                                    </telerik:GridBoundColumn>
137.                                    <telerik:GridBoundColumn DataField="Deadline" UniqueName="Deadline" HeaderText="Deadline" SortExpression="Deadline1" AllowFiltering="false"
138.                                        HeaderStyle-HorizontalAlign="Left" ItemStyle-HorizontalAlign="Left">
139.                                        <ColumnValidationSettings>
140.                                            <ModelErrorMessage Text=""></ModelErrorMessage>
141.                                        </ColumnValidationSettings>
142.                                    </telerik:GridBoundColumn>
143.                                    <telerik:GridBoundColumn DataField="ClientPresentation" UniqueName="ClientPresentation" HeaderText="Client Presentation" SortExpression="ClientPresentation1" AllowFiltering="false"
144.                                        HeaderStyle-HorizontalAlign="Left" ItemStyle-HorizontalAlign="Left">
145.                                        <ColumnValidationSettings>
146.                                            <ModelErrorMessage Text=""></ModelErrorMessage>
147.                                        </ColumnValidationSettings>
148.                                    </telerik:GridBoundColumn>
149.                                    <telerik:GridBoundColumn DataField="t_UploadedBy" UniqueName="t_UploadedBy" HeaderText="Created By" SortExpression="t_UploadedBy" AllowFiltering="false">
150.                                        <ColumnValidationSettings>
151.                                            <ModelErrorMessage Text=""></ModelErrorMessage>
152.                                        </ColumnValidationSettings>
153.                                    </telerik:GridBoundColumn>
154.                                    <telerik:GridBoundColumn DataField="t_UploadedOn" UniqueName="t_UploadedOn" HeaderText="Created Date" SortExpression="t_UploadedOn" DataFormatString="{0:dd-MM-yyyy HH:mm:ss}" AllowFiltering="false" ItemStyle-Width="110px">
155.                                        <ColumnValidationSettings>
156.                                            <ModelErrorMessage Text=""></ModelErrorMessage>
157.                                        </ColumnValidationSettings>
158.                                    </telerik:GridBoundColumn>
159.                                    <telerik:GridBoundColumn DataField="t_ApprovalStatus" UniqueName="t_ApprovalStatus" HeaderText="Brief Status" SortExpression="t_ApprovalStatus" AllowFiltering="false">
160.                                        <ColumnValidationSettings>
161.                                            <ModelErrorMessage Text=""></ModelErrorMessage>
162.                                        </ColumnValidationSettings>
163.                                    </telerik:GridBoundColumn>
164.                                    <telerik:GridBoundColumn DataField="t_flowstatusname" UniqueName="t_flowstatusname" HeaderText="Flow Status" SortExpression="t_flowstatusname" AllowFiltering="false">
165.                                        <ColumnValidationSettings>
166.                                            <ModelErrorMessage Text=""></ModelErrorMessage>
167.                                        </ColumnValidationSettings>
168.                                    </telerik:GridBoundColumn>
169.                                    <telerik:GridBoundColumn DataField="CreativeDirectorName" UniqueName="t_CreativeDirectorCode" HeaderText="Creative Director" SortExpression="CreativeDirectorName" AllowFiltering="false">
170.                                        <ColumnValidationSettings>
171.                                            <ModelErrorMessage Text=""></ModelErrorMessage>
172.                                        </ColumnValidationSettings>
173.                                    </telerik:GridBoundColumn>
174.                                     <telerik:GridBoundColumn DataField="taskstatus" UniqueName="taskstatus" HeaderText="Status" SortExpression="taskstatus" AllowFiltering="false">
175.                                        <ColumnValidationSettings>
176.                                            <ModelErrorMessage Text=""></ModelErrorMessage>
177.                                        </ColumnValidationSettings>
178.                                    </telerik:GridBoundColumn>
179.                                </Columns>
180.                            </MasterTableView>
181.
182.                            <ClientSettings AllowDragToGroup="true" AllowColumnsReorder="true"
183.                                ReorderColumnsOnClient="true" ColumnsReorderMethod="Reorder">
184.                                <Resizing EnableRealTimeResize="True" ResizeGridOnColumnResize="True"
185.                                    AllowColumnResize="True" ClipCellContentOnResize="false" AllowResizeToFit="true"  />
186.                                <ClientEvents OnRowDblClick="RowDblClick"
187.                                    OnRowContextMenu="RowContextMenu" />
188.                            </ClientSettings>
189.                            <GroupingSettings ShowUnGroupButton="true"></GroupingSettings>
190.                        </telerik:RadGrid>

Code

01.Private Sub radProject_NeedDataSource(sender As Object, e As GridNeedDataSourceEventArgs) Handles radProject3.NeedDataSource
02.       Try
03.           Dim dsData As DataSet = New DataSet
04.           dsData = LoadBrief()
05.           radProject3.DataSource = dsData
06.       Catch ex As Exception
07.
08.       End Try
09.   End Sub

Server Error Log

01.Exception information:
02.    Exception type: ArgumentException
03.    Exception message: Column 'assignedto' does not belong to table Table.
04.   at System.Data.DataRow.GetDataColumn(String columnName)
05.   at System.Data.DataRow.get_Item(String columnName)
06.   at lambda_method(Closure , DataRowView )
07.   at System.Linq.Lookup`2.Create[TSource](IEnumerable`1 source, Func`2 keySelector, Func`2 elementSelector, IEqualityComparer`1 comparer)
08.   at System.Linq.GroupedEnumerable`3.GetEnumerator()
09.   at System.Linq.Buffer`1..ctor(IEnumerable`1 source)
10.   at System.Linq.OrderedEnumerable`1.<GetEnumerator>d__0.MoveNext()
11.   at Telerik.Web.UI.GridLinqGroupingHelper.CreateAllGroups(IEnumerable enumerable, List`1 groupFields, GridGroup parentGroup, Int32 level)
12.   at Telerik.Web.UI.GridLinqGroupingHelper.GetGroupedItemsForCurrentPage(IQueryable queryable)
13.   at Telerik.Web.UI.GridDataTableFromEnumerable.FillData35()
14.   at Telerik.Web.UI.GridDataTableFromEnumerable.FillData()
15.   at Telerik.Web.UI.GridResolveEnumerable.Initialize()
16.   at Telerik.Web.UI.GridResolveEnumerable.EnsureInitialized()
17.   at Telerik.Web.UI.GridEnumerableFromDataView..ctor(GridTableView owner, DataView dataView, Boolean autoGenerateColumns, GridColumnCollection presentColumns, String[] additionalField, Boolean retrieveAllFields, Boolean enableSplitHeaderText)
18.   at Telerik.Web.UI.GridDataSourceHelper.CreateGridEnumerable(GridTableView owner, IEnumerable enumerable, Boolean caseSensitive, Boolean autoGenerateColumns, GridColumnCollection presentColumns, String[] additionalField, Boolean retrieveAllFields, Boolean enableSplitHeaderText)
19.   at Telerik.Web.UI.GridDataSourceHelper.GetResolvedDataSource(GridTableView owner, Object dataSource, String dataMember, Boolean caseSensitive, Boolean autoGenerateColumns, GridColumnCollection presentColumns, String[] additionalField, Boolean retrieveAllFields, Boolean enableSplitHeaderText)
20.   at Telerik.Web.UI.GridTableView.get_ResolvedDataSource()
21.   at Telerik.Web.UI.GridTableView.CreateChildControls(IEnumerable dataSource, Boolean useDataSource)
22.   at System.Web.UI.WebControls.CompositeDataBoundControl.PerformDataBinding(IEnumerable data)
23.   at System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data)
24.   at System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback)
25.   at System.Web.UI.WebControls.DataBoundControl.PerformSelect()
26.   at Telerik.Web.UI.GridTableView.PerformSelect()
27.   at System.Web.UI.WebControls.BaseDataBoundControl.DataBind()
28.   at Telerik.Web.UI.GridTableView.DataBind()
29.   at Telerik.Web.UI.RadGrid.DataBind()
30.   at Telerik.Web.UI.RadGrid.AutoDataBind(GridRebindReason rebindReason)
31.   at Telerik.Web.UI.RadGrid.OnLoad(EventArgs e)
32.   at System.Web.UI.Control.LoadRecursive()
33.   at System.Web.UI.Control.LoadRecursive()
34.   at System.Web.UI.Control.LoadRecursive()
35.   at System.Web.UI.Control.LoadRecursive()
36.   at System.Web.UI.Control.LoadRecursive()
37.   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

[Maria Ilieva]

Hello,

 As the version you are using is rather old, i would suggest you to update your application to the latest Q1 2015 version of the controls and let me know this fixes the issue.

Regards,
Maria Ilieva
Telerik

 

 

[ADV Dev]

Hello,

We updated to the following version '2014.3.1209'  yesterday based on our license, but still we get the below error randomly. Also it doesn't get caught even if try catch statements are presents. Any suggestions would be greatly appreciated. Below is the server log

Thread information:
    Thread ID: 52
    Thread account name: xxx\xxx
    Is impersonating: False
    Stack trace:    at System.Data.DataRowView.get_Item(String property)
   at lambda_method(Closure , DataRowView )
   at System.Linq.EnumerableSorter`2.ComputeKeys(TElement[] elements, Int32 count)
   at System.Linq.EnumerableSorter`1.Sort(TElement[] elements, Int32 count)
   at System.Linq.OrderedEnumerable`1.<GetEnumerator>d__0.MoveNext()
   at System.Linq.Lookup`2.Create[TSource](IEnumerable`1 source, Func`2 keySelector, Func`2 elementSelector, IEqualityComparer`1 comparer)
   at System.Linq.GroupedEnumerable`3.GetEnumerator()
   at System.Linq.Buffer`1..ctor(IEnumerable`1 source)
   at System.Linq.OrderedEnumerable`1.<GetEnumerator>d__0.MoveNext()
   at Telerik.Web.UI.GridLinqGroupingHelper.CreateAllGroups(IEnumerable enumerable, List`1 groupFields, GridGroup parentGroup, Int32 level)
   at Telerik.Web.UI.GridLinqGroupingHelper.GetGroupedItemsForCurrentPage(IQueryable queryable)
   at Telerik.Web.UI.GridDataTableFromEnumerable.FillData35()
   at Telerik.Web.UI.GridDataTableFromEnumerable.FillData()
   at Telerik.Web.UI.GridResolveEnumerable.Initialize()
   at Telerik.Web.UI.GridResolveEnumerable.EnsureInitialized()
   at Telerik.Web.UI.GridEnumerableFromDataView..ctor(GridTableView owner, DataView dataView, 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.GridDataSourceHelper.GetResolvedDataSource(GridTableView owner, Object dataSource, String dataMember, 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 System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback)
   at System.Web.UI.WebControls.DataBoundControl.PerformSelect()
   at Telerik.Web.UI.GridTableView.PerformSelect()
   at System.Web.UI.WebControls.BaseDataBoundControl.DataBind()
   at Telerik.Web.UI.GridTableView.DataBind()
   at Telerik.Web.UI.RadGrid.DataBind()
   at Telerik.Web.UI.RadGrid.AutoDataBind(GridRebindReason rebindReason)
   at Telerik.Web.UI.RadGrid.Rebind()
   at ADVinciPlus.BriefStatusSheet.Page_Load(Object sender, EventArgs e)
   at System.EventHandler.Invoke(Object sender, EventArgs e)
   at System.Web.UI.Control.OnLoad(EventArgs e)
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

[ADV Dev]

Polite follow up

[Maria Ilieva]

Hi,

Тhe presented behavior is rather strange more that the error occurs randomly on your end. Therefore it will be best if you can open a regular support ticket and send us sample runnable version of your application that demonstrates the issue. Thus we will be able to replicate it locally and do our best to isolate the root cause of the error.

Regards,
Maria Ilieva
Telerik