Column does not belong to table error

[Guest]

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:

 

[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)

 

[Guest]

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?

 

[apieczyk via DotNetMonster.com]

I have the same problem (project SQL2005_ASP.NET 2.0), error occurs from time
to time, cannot be reproduced.
Warnings generated in Event Log:
DataBinding: 'System.Data.DataRowView' does not contain a property with the
name 'ID_PRODUCT'
or
Column 'PRODUCT_CATEGORY_NAME' does not belong to table ProductCategory.
(ProductCategory is a datatable, all data are taking from db by sql
procedures)
The problem causes blocking all pages with data displayed from db (error info)
or displaying no data from db (there are empty webparts, static graphic
elements and no error info).
One way of fixing it is restarting of SQL Server service. It helps temporary.
I got info that SP1 for SQL Server 2005 stopped this problem but not in my
case, I have 9.00.2153 version and still have this problem.

Who can give the cure for this problem will be great for me....

 

[joinz79]

Hi, unfortunately I've the same problem too.

I tried all solutions in vain.

My web app (in asp.net 2.0, c# code behind, database SQL Server 2005
SP1) sometimes goes crazy, columns not in tables and similar.

The problem grew up when the app increased the number of accesses.

The code is ok, I think the problem's sql server 2005.
I don't know what could I do furthermore, I'm very depressed.

Who can give an help for this problem will be great for me, thank you
very much.