Home All Groups Group Topic Archive Search About

Column does not belong to table error

Author
6 Sep 2006 8:13 PM
Mike
We are using .NET 2.0 and intermittently egt the following errors on almost
all our web pages.  The error is not repoducable and cycling the worker
process seems to temporarily fix the problems.  Has anyone seen this or have
any suggestions?

Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 9/5/2006 4:23:47 PM
Event time (UTC): 9/5/2006 11:23:47 PM
Event ID: cb408727296440278fb486579b359b15
Event sequence: 330
Event occurrence: 4
Event detail code: 0

Application information:
    Application domain:
/LM/W3SVC/1314662404/ROOT/NARROWCAST2005-1-128019696752767426
    Trust level: Full
    Application Virtual Path: /NARROWCAST2005
    Application Path: C:\Inetpub\BFI_info\NARROWCAST2005\
    Machine name: CARL

Process information:
    Process ID: 3148
    Process name: w3wp.exe
    Account name: NT AUTHORITY\NETWORK SERVICE

Exception information:
    Exception type: ArgumentException
    Exception message: Column 'TFTAgentName' does not belong to table .

Request information:
    Request URL: http://www.navistechnologies.info/NARROWCAST2005/NCEditResultsOut.aspx?uKey=2056426&To_Number=
    Request path: /NARROWCAST2005/NCEditResultsOut.aspx
    User host address: 63.200.67.154
    User: 
    Is authenticated: False
    Authentication Type: 
    Thread account name: NT AUTHORITY\NETWORK SERVICE

Thread information:
    Thread ID: 1
    Thread account name: NT AUTHORITY\NETWORK SERVICE
    Is impersonating: False
    Stack trace:    at System.Data.DataRow.GetDataColumn(String columnName)
   at System.Data.DataRow.get_Item(String columnName)
   at NCEditResultsOut.Page_Load(Object sender, EventArgs e) in
C:\Inetpub\BFI_info\Narrowcast2005\NCEditResultsOut.aspx.vb:line 37
   at System.Web.UI.Control.OnLoad(EventArgs e)
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)


Custom event details:

Author
7 Sep 2006 12:44 AM
bruce barker (sqlwork.com)
under some senerio, you fill the dataset with an unexpected result set, so
the column does not exist. it will be a bug in your code or sql

-- bruce (sqlwork.com)

Show quoteHide quote
"Mike" <M***@discussions.microsoft.com> wrote in message
news:3B72A773-A2FD-45B4-8465-6CAEF869E4DE@microsoft.com...
> We are using .NET 2.0 and intermittently egt the following errors on
> almost
> all our web pages.  The error is not repoducable and cycling the worker
> process seems to temporarily fix the problems.  Has anyone seen this or
> have
> any suggestions?
>
> Event code: 3005
> Event message: An unhandled exception has occurred.
> Event time: 9/5/2006 4:23:47 PM
> Event time (UTC): 9/5/2006 11:23:47 PM
> Event ID: cb408727296440278fb486579b359b15
> Event sequence: 330
> Event occurrence: 4
> Event detail code: 0
>
> Application information:
>    Application domain:
> /LM/W3SVC/1314662404/ROOT/NARROWCAST2005-1-128019696752767426
>    Trust level: Full
>    Application Virtual Path: /NARROWCAST2005
>    Application Path: C:\Inetpub\BFI_info\NARROWCAST2005\
>    Machine name: CARL
>
> Process information:
>    Process ID: 3148
>    Process name: w3wp.exe
>    Account name: NT AUTHORITY\NETWORK SERVICE
>
> Exception information:
>    Exception type: ArgumentException
>    Exception message: Column 'TFTAgentName' does not belong to table .
>
> Request information:
>    Request URL:
> http://www.navistechnologies.info/NARROWCAST2005/NCEditResultsOut.aspx?uKey=2056426&To_Number=
>    Request path: /NARROWCAST2005/NCEditResultsOut.aspx
>    User host address: 63.200.67.154
>    User:
>    Is authenticated: False
>    Authentication Type:
>    Thread account name: NT AUTHORITY\NETWORK SERVICE
>
> Thread information:
>    Thread ID: 1
>    Thread account name: NT AUTHORITY\NETWORK SERVICE
>    Is impersonating: False
>    Stack trace:    at System.Data.DataRow.GetDataColumn(String columnName)
>   at System.Data.DataRow.get_Item(String columnName)
>   at NCEditResultsOut.Page_Load(Object sender, EventArgs e) in
> C:\Inetpub\BFI_info\Narrowcast2005\NCEditResultsOut.aspx.vb:line 37
>   at System.Web.UI.Control.OnLoad(EventArgs e)
>   at System.Web.UI.Control.LoadRecursive()
>   at System.Web.UI.Page.ProcessRequestMain(Boolean
> includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
>
>
> Custom event details:
>
>
>
Are all your drivers up to date? click for free checkup

Author
7 Sep 2006 2:28 PM
Mike
I have trapped the error on several occasions and have displayed the table
column names and the column that it says does not exist is in fact in the
table.  Any other ideas?
--
Mike Hollibaugh


Show quoteHide quote
"bruce barker (sqlwork.com)" wrote:

> under some senerio, you fill the dataset with an unexpected result set, so
> the column does not exist. it will be a bug in your code or sql
>
> -- bruce (sqlwork.com)
>
> "Mike" <M***@discussions.microsoft.com> wrote in message
> news:3B72A773-A2FD-45B4-8465-6CAEF869E4DE@microsoft.com...
> > We are using .NET 2.0 and intermittently egt the following errors on
> > almost
> > all our web pages.  The error is not repoducable and cycling the worker
> > process seems to temporarily fix the problems.  Has anyone seen this or
> > have
> > any suggestions?
> >
> > Event code: 3005
> > Event message: An unhandled exception has occurred.
> > Event time: 9/5/2006 4:23:47 PM
> > Event time (UTC): 9/5/2006 11:23:47 PM
> > Event ID: cb408727296440278fb486579b359b15
> > Event sequence: 330
> > Event occurrence: 4
> > Event detail code: 0
> >
> > Application information:
> >    Application domain:
> > /LM/W3SVC/1314662404/ROOT/NARROWCAST2005-1-128019696752767426
> >    Trust level: Full
> >    Application Virtual Path: /NARROWCAST2005
> >    Application Path: C:\Inetpub\BFI_info\NARROWCAST2005\
> >    Machine name: CARL
> >
> > Process information:
> >    Process ID: 3148
> >    Process name: w3wp.exe
> >    Account name: NT AUTHORITY\NETWORK SERVICE
> >
> > Exception information:
> >    Exception type: ArgumentException
> >    Exception message: Column 'TFTAgentName' does not belong to table .
> >
> > Request information:
> >    Request URL:
> > http://www.navistechnologies.info/NARROWCAST2005/NCEditResultsOut.aspx?uKey=2056426&To_Number=
> >    Request path: /NARROWCAST2005/NCEditResultsOut.aspx
> >    User host address: 63.200.67.154
> >    User:
> >    Is authenticated: False
> >    Authentication Type:
> >    Thread account name: NT AUTHORITY\NETWORK SERVICE
> >
> > Thread information:
> >    Thread ID: 1
> >    Thread account name: NT AUTHORITY\NETWORK SERVICE
> >    Is impersonating: False
> >    Stack trace:    at System.Data.DataRow.GetDataColumn(String columnName)
> >   at System.Data.DataRow.get_Item(String columnName)
> >   at NCEditResultsOut.Page_Load(Object sender, EventArgs e) in
> > C:\Inetpub\BFI_info\Narrowcast2005\NCEditResultsOut.aspx.vb:line 37
> >   at System.Web.UI.Control.OnLoad(EventArgs e)
> >   at System.Web.UI.Control.LoadRecursive()
> >   at System.Web.UI.Page.ProcessRequestMain(Boolean
> > includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
> >
> >
> > Custom event details:
> >
> >
> >
>
>
>

Bookmark and Share