not exact problem

[mascix]

my site has healthmonitoring which helps me to get exceptions via mail. there is something wrong about it which I am not sure yet.

I took about 15 mails in a day about data parts of my site. I think its about the overloading http://www.motosikletpazari.com which takes about 350 visits in a day and makes about 3500 page view and normally it works perfectly fine. the site looks fine and fast to me. but still there are unexplainable sql data reading errors.

some of them

Exception information:
Exception type: System.ArgumentException
Exception message: Column 'markaName' does not belong to table Table.

Request information:
Request URL: http://www.motosikletpazari.com/search.aspx?tur=6
Request path: /search.aspx
User host address: 85.100.96.69
User:
Is authenticated: False
Authentication Type:
Thread account name: WEB131\aspnet_241450

Thread information:
Thread ID: 5
Thread account name: WEB131\aspnet_241450
Is impersonating: False
Stack trace: at System.Data.DataRow.GetDataColumn(String columnName)
at System.Data.DataRow.get_Item(String columnName)
at Search.Page_Load(Object sender, EventArgs e) in e:\web\motosiklet1\htdocs\Search.aspx.cs:line 37

Exception information:
Exception type: System.Data.SqlClient.SqlException
Exception message: Server failed to resume the transaction, desc: 650000033c.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Request information:
Request URL: http://www.motosikletpazari.com/default.aspx
Request path: /default.aspx
User host address: 213.74.116.50
User: china
Is authenticated: True
Authentication Type: Forms
Thread account name: WEB131\aspnet_241450

Thread information:
Thread ID: 1
Thread account name: WEB131\aspnet_241450
Is impersonating: False
Stack trace: at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaDat a()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteRead er(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderT ds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataRead er(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbComman d.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(Data Set dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at dbRelated.dbSelect(String SQL) in e:\web\motosiklet1\htdocs\App_Code\dbRelated.cs:li ne 44
at Bussiness.getUcuzlar() in e:\web\motosiklet1\htdocs\App_Code\Bussiness.cs:li ne 43
at Controls_Last6.Page_Load(Object sender, EventArgs e) in e:\web\motosiklet1\htdocs\Controls2\default.ascx.c s:line 102
at System.Web.Util.CalliHelper.EventArgFunctionCaller (IntPtr fp, Object o, Object t, EventArgs e)
at System.Web.Util.CalliEventHandlerDelegateProxy.Cal lback(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

like I told site works fast and fine but how can I solve these problems ?

[bruce]

There are 2 different issues here

1) Column 'markaName' does not belong to table Table.

this usually means that your application is trying to read / write something to a table but the column specified is not valid

Can't really provide much help here. but it should be a easy fix.

2) Server failed to resume the transaction, desc: 650000033c.

This is a weird error. Is your code calling a stored proc that uses transaction? I did some research on the net and this error is usually related to JDBC but apparently you are not using that.

Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

[mascix]

1) that markaName column is there and its working normally. there is nothing to fix about it.
2) I use asp.net 2 and sql 2005 and all .net stuff no java. btw I dont call stored procs.

[joelnet]

mascix said...
1) that markaName column is there and its working normally. there is nothing to fix about it.
2) I use asp.net 2 and sql 2005 and all .net stuff no java. btw I dont call stored procs.

"Exception message: Column 'markaName' does not belong to table Table."

You have a table named Table? Are you 100% sure you have a column named 'markaName' in table 'Table' ? Also could you be querying a second base that doesn't have the table 'Table' or 'markaName' column?





Joel Thoms
DiscountASP.NET
http://www.DiscountASP.NET

[mascix]

in table markalar. you see there is markaName there is no table that I have which named as 'Table'
ID int Unchecked
markaName nvarchar(50) Unchecked

in search there are a lot of options and tables to check which generates a long SQL sometimes it like this:

select distinct dbo.advertisement.ID, dbo.advertisement.userID, CAST(dbo.advertisement.fiyat AS money) AS fiyat, dbo.advertisement.modelName, dbo.advertisement.motorHacmi, dbo.advertisement.renk, dbo.advertisement.kiloMetre, dbo.advertisement.yil, dbo.advertisement.tur, dbo.advertisement.kimden, dbo.advertisement.advertisementBaslangicDate, dbo.advertisement.advertisementBitisDate, dbo.advertisement.advertisementGirisDate, dbo.advertisement.anonymStatistic, dbo.advertisement.userStatistic, dbo.advertisement.lastVisitorsID, SUBSTRING(dbo.advertisement.aciklama, 0, 20) AS aciklama, dbo.modeller.tipAdi, dbo.markalar.markaName, dbo.city.name, dbo.county.name AS ilceadi, dbo.tipler.name AS tipismi, dbo.advertisement.isimSoyisim, dbo.advertisement.Telefon, dbo.advertisement.EMail, dbo.advertisement.havePhoto from dbo.advertisement left outer JOIN dbo.modeller ON dbo.advertisement.modelName = dbo.modeller.tipAdi INNER JOIN dbo.markalar ON dbo.advertisement.markaID = dbo.markalar.ID INNER JOIN dbo.city ON dbo.advertisement.cityID = dbo.city.ID INNER JOIN dbo.county ON dbo.advertisement.countyID = dbo.county.ID INNER JOIN dbo.tipler ON dbo.advertisement.tipID = dbo.tipler.ID where dbo.advertisement.enable=1 and advertisement.tipID=3 order by dbo.advertisement.advertisementBaslangicDate desc

I can run this query on my database and its working. I am %100 sure of that I dont have a table as 'Table' and I am %100 sure this query working.

[mascix]

https://my.discountasp.net/mssql2005-manager.aspx

Unavailable at this time.

I dunno why. strange is it just me thinking that sql 2005 service is little bit unprofessional or just shit happens ? btw before discountasp I used to work with another hosting they have this kind of unstable sql 2005 service thats why I choosed to move discountasp. maybe just sql2005 is a bad database I lost my trust on it.

[bruce]

we had a hardware issue last night on one of the SQL 2k5 server. Our sysadmin team managed to get the service restored once the monitoring system notified us.

Our experience w/ SQL 2k5 has been pretty good. It is far more stable than SQL 2k. To be honest, i have no idea what is causing this error. I doubt many others are seeing this as I couldn't find anything related on Google.

Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)