May 26, 2009 at 2:14 am
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?
There are columns available in that table. and there were no log entry reported in MS-sql logs. and it start working after 1-2 min.
This forum also shows the same problem:::
[url= http://www.netnewsgroups.net/group/microsoft.public.dotnet.framework.aspnet/topic34227.aspx%5D
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)
May 27, 2009 at 6:35 am
This is more than likely not a sql issue, if it was your server rejecting connections (failed logon attempts etc) you would see exceptions on your sql instance.
Are you closing you connections correctly. If recycling the app pool resolves your issues then i would hazard a guess that you are not. This error is indicative of there being no data object (whether dataset or datareader). It also looks like possibly that the error you are getting is not the actual exception but rather the result of a deeper exception (possibly not able to connect to you sql server instance). Having a snippet of your code could help identify this.
May 27, 2009 at 6:40 am
in this specific case, this error:
Exception message: Column 'TFTAgentName' does not belong to table .
seems to be pretty straight forward;
I would guess that a SQL statement that is loading specific columns from a table has that column name in the SELECT list, and when the datatable is being loaded, that error occurs.
Lowell
May 27, 2009 at 6:59 am
If that were the case i think he would then have the problem for every execution, a problem that is reproducable (unless he is building dynamic sql, which is problematic for other reasons); a recycled worker process would not resolve it temporarily.
May 27, 2009 at 10:04 am
While there are several potential causes, the resulting error is most likely incorrect SQL being sent to your server. Profiler should be able to confirm this, and may give you additional clues as to where to look.
Since you mention that clearing out your threads fixes the problem, I'd guess that you have a bug in your program where you're wanting to select data from table A, but the dataset object is referencing table 'B'. I don't think that this is related to not closing connections, but rather is related to generated SQL or re-using the wrong object.
May 28, 2009 at 3:06 am
Column 'TFTAgentName' does not belong to table
Without doubt the problem is that your application is asking for a column that does not exist in the table being referenced.
You now need to work back along the application stack until you find the cause of the problem.
I noticed the use of Narrowcast - if this is from MicroStrategy or another tools vendor there is likely some tracing you can turn on in the tool to help you trace where the problem is happening.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
May 28, 2009 at 9:26 pm
It seems to be .NET issue.
This: System.Data.DataRow.GetDataColumn is a DataRow method. The table is a DataTable (disconnected recordset).
So, if you are sure that the column exists in a table:
It's the application that either sends ia bad query (you can capture those with tracing or with profiler-when it starts getting those errors) or the table gets corrupted somehow (either bad code in the application or a bug in .NET).
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply