473,721 Members | 1,803 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Column does not belong to table error

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: cb4087272964402 78fb486579b359b 15
Event sequence: 330
Event occurrence: 4
Event detail code: 0

Application information:
Application domain:
/LM/W3SVC/1314662404/ROOT/NARROWCAST2005-1-128019696752767 426
Trust level: Full
Application Virtual Path: /NARROWCAST2005
Application Path: C:\Inetpub\BFI_ info\NARROWCAST 2005\
Machine name: CARL

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

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

Request information:
Request URL:
http://www.navistechnologies.info/NA...426&To_Number=
Request path: /NARROWCAST2005/NCEditResultsOu t.aspx
User host address: 63.200.67.154
User:
Is authenticated: False
Authentication Type:
Thread account name: NT AUTHORITY\NETWO RK SERVICE

Thread information:
Thread ID: 1
Thread account name: NT AUTHORITY\NETWO RK SERVICE
Is impersonating: False
Stack trace: at System.Data.Dat aRow.GetDataCol umn(String columnName)
at System.Data.Dat aRow.get_Item(S tring columnName)
at NCEditResultsOu t.Page_Load(Obj ect sender, EventArgs e) in
C:\Inetpub\BFI_ info\Narrowcast 2005\NCEditResu ltsOut.aspx.vb: line 37
at System.Web.UI.C ontrol.OnLoad(E ventArgs e)
at System.Web.UI.C ontrol.LoadRecu rsive()
at System.Web.UI.P age.ProcessRequ estMain(Boolean
includeStagesBe foreAsyncPoint, Boolean includeStagesAf terAsyncPoint)
Custom event details:

Sep 6 '06 #1
4 15285
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" <Mi**@discussio ns.microsoft.co mwrote in message
news:3B******** *************** ***********@mic rosoft.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: cb4087272964402 78fb486579b359b 15
Event sequence: 330
Event occurrence: 4
Event detail code: 0

Application information:
Application domain:
/LM/W3SVC/1314662404/ROOT/NARROWCAST2005-1-128019696752767 426
Trust level: Full
Application Virtual Path: /NARROWCAST2005
Application Path: C:\Inetpub\BFI_ info\NARROWCAST 2005\
Machine name: CARL

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

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

Request information:
Request URL:
http://www.navistechnologies.info/NA...426&To_Number=
Request path: /NARROWCAST2005/NCEditResultsOu t.aspx
User host address: 63.200.67.154
User:
Is authenticated: False
Authentication Type:
Thread account name: NT AUTHORITY\NETWO RK SERVICE

Thread information:
Thread ID: 1
Thread account name: NT AUTHORITY\NETWO RK SERVICE
Is impersonating: False
Stack trace: at System.Data.Dat aRow.GetDataCol umn(String columnName)
at System.Data.Dat aRow.get_Item(S tring columnName)
at NCEditResultsOu t.Page_Load(Obj ect sender, EventArgs e) in
C:\Inetpub\BFI_ info\Narrowcast 2005\NCEditResu ltsOut.aspx.vb: line 37
at System.Web.UI.C ontrol.OnLoad(E ventArgs e)
at System.Web.UI.C ontrol.LoadRecu rsive()
at System.Web.UI.P age.ProcessRequ estMain(Boolean
includeStagesBe foreAsyncPoint, Boolean includeStagesAf terAsyncPoint)
Custom event details:

Sep 7 '06 #2
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
"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" <Mi**@discussio ns.microsoft.co mwrote in message
news:3B******** *************** ***********@mic rosoft.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: cb4087272964402 78fb486579b359b 15
Event sequence: 330
Event occurrence: 4
Event detail code: 0

Application information:
Application domain:
/LM/W3SVC/1314662404/ROOT/NARROWCAST2005-1-128019696752767 426
Trust level: Full
Application Virtual Path: /NARROWCAST2005
Application Path: C:\Inetpub\BFI_ info\NARROWCAST 2005\
Machine name: CARL

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

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

Request information:
Request URL:
http://www.navistechnologies.info/NA...426&To_Number=
Request path: /NARROWCAST2005/NCEditResultsOu t.aspx
User host address: 63.200.67.154
User:
Is authenticated: False
Authentication Type:
Thread account name: NT AUTHORITY\NETWO RK SERVICE

Thread information:
Thread ID: 1
Thread account name: NT AUTHORITY\NETWO RK SERVICE
Is impersonating: False
Stack trace: at System.Data.Dat aRow.GetDataCol umn(String columnName)
at System.Data.Dat aRow.get_Item(S tring columnName)
at NCEditResultsOu t.Page_Load(Obj ect sender, EventArgs e) in
C:\Inetpub\BFI_ info\Narrowcast 2005\NCEditResu ltsOut.aspx.vb: line 37
at System.Web.UI.C ontrol.OnLoad(E ventArgs e)
at System.Web.UI.C ontrol.LoadRecu rsive()
at System.Web.UI.P age.ProcessRequ estMain(Boolean
includeStagesBe foreAsyncPoint, Boolean includeStagesAf terAsyncPoint)
Custom event details:



Sep 7 '06 #3
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.Da taRowView' does not contain a property with the
name 'ID_PRODUCT'
or
Column 'PRODUCT_CATEGO RY_NAME' does not belong to table ProductCategory .
(ProductCategor y 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....

Mike wrote:
>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.

............... ......

Custom event details:
--
Message posted via http://www.dotnetmonster.com

Sep 12 '06 #4
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.

Sep 29 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
4716
by: robert | last post by:
i've found the solution threads on changing a column on insert. works fine. question: - will one package serve for all such triggers, or does there need to be a package defined to support each table? my o'reilly book doesn't say, nor do the threads i found.
1
32352
by: Caroline | last post by:
I need to update a table by copying a column from another table (having the same structure, but on another database), from the record having the same primary key. 1 - What is the correct query? 2 - I tried copying them record by record, but the datatype is ntext, (it displays <long
5
51580
by: Markus | last post by:
I tried this: ALTER TABLE Dokumente DROP COLUMN docPrioID but I get this errormessage: DB2 SQL error: SQLCODE: -104, SQLSTATE: 42601, SQLERRMC: COLUMN;ABLE Dokumente DROP;CONSTRAINT
0
978
by: shil | last post by:
Hi all, updating SQL database with the data.I'm stuck with an issue. One of the XML file from the list don't have a node mentioned. For example almost all XML files structure is like this <treatment_settings> <setup> <product1> <name>PSO-NO2</name>
1
2504
by: shil | last post by:
Hi all, updating SQL database with the data.I'm stuck with an issue. One of the XML file from the list don't have a node mentioned. For example almost all XML files structure is like this <treatment_settings> <setup> <product1> <name>PSO-NO2</name>
1
2249
by: satishkhachane | last post by:
-------------------------------------------------------------------------------- I want to select one or more columns from one typed datatable and add it to another table . how I can do this ? Eg :- table master it has column masterid , mastername now i select masterid and assign it to new comlunm.
2
1965
by: Rahul B | last post by:
I am new at DB2 . so please guide I am trying to change the Datatype of a column in the table. CREATE TABLE testschema.player ( NAME VARCHAR(120) NOT NULL, country VARCHAR(80) NOT NULL, club VARCHAR(120) , totalgoals SMALLINT not null with DEFAULT 0 , goalsinpresentseason SMALLINT not null with DEFAULT 0 ,
2
4866
by: Rahul B | last post by:
Hi, I dropped a not null column from a table. After that i reorganized the table. However, an update statement is giving error like "(Reason "column number out of range".) SQLSTATE=58004" So i ran stats on the table like "RUNSTATS ON TABLE <SCHEMA.TABNAME>"
6
5164
by: bogie | last post by:
Hi again I have another question, I would like to add NOT NULL column in my table. I have done like this : ALTER TABLE patent ALTER COLUMN patent_pri_date SET NOT NULL; but it doesn't work and give the following error : ERROR: ALTER TABLE: Attribute "patent_pri_date" contains NULL values is any body can help me how can i add NOT NULL column to my table ?, I use postgresql 7.4. Thank you very much.
1
9130
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9059
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6668
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5977
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4484
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4751
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3187
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2572
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2129
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.