Solved

Event viewer error - ASP.NET 2.0.50727.0 - Event ID: 1309

Posted on 2008-10-30
10
1,050 Views
Last Modified: 2012-06-27
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 29/10/2008 12:36:06
Event time (UTC): 29/10/2008 12:36:06
Event ID: 7873d8a611ad445d998db4fdef25a5c9
Event sequence: 728
Event occurrence: 9
Event detail code: 0

Application information:
Application domain: /LM/W3SVC/2036148338/Root-5-128697466270360000
Trust level: Full
Application Virtual Path: /
Application Path: D:\WebFolders\test.thegmach.com\
Machine name: FORMWEB3
Process information:
Process ID: 148
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE
Exception information:
Exception type: SqlException
Exception message: INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK_CategoryRelationship_Category'. The conflict occurred in database 'thegmach', table 'Category', column 'ID'.
The statement has been terminated.
Request information:
Request URL: http://test.thegmach.com/relatedcategories.aspx
Request path: /relatedcategories.aspx
User host address: 79.66.7.235
User:
Is authenticated: False
Authentication Type:
Thread account name: NT AUTHORITY\NETWORK SERVICE
Thread information:
Thread ID: 7
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: False
Stack trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(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(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader()
at System.Data.Linq.SqlClient.SqlProvider.Execute(Expression query, QueryInfo queryInfo, IObjectReaderFactory factory, Object[] parentArgs, Object[] userArgs, ICompiledSubQuery[] subQueries, Object lastResult)
at System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(Expression query, QueryInfo[] queryInfos, IObjectReaderFactory factory, Object[] userArguments, ICompiledSubQuery[] subQueries)
at System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query)
at System.Data.Linq.ChangeDirector.StandardChangeDirector.DynamicInsert(TrackedObject item)
at System.Data.Linq.ChangeDirector.StandardChangeDirector.Insert(TrackedObject item)
at System.Data.Linq.ChangeProcessor.SubmitChanges(ConflictMode failureMode)
at System.Data.Linq.DataContext.SubmitChanges(ConflictMode failureMode)
at System.Data.Linq.DataContext.SubmitChanges()
at relatedcategories.Add_Click(Object sender, EventArgs e) in D:\WebFolders\test.thegmach.com\relatedcategories.aspx.vb:line 59
at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
0
Comment
Question by:YellowbusTeam
  • 6
  • 4
10 Comments
 
LVL 18

Expert Comment

by:David Robitaille
ID: 22842844
the important part is :
Exception type: SqlException
Exception message: INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK_CategoryRelationship_Category'. The conflict occurred in database 'thegmach', table 'Category', column 'ID'.
If you need more help, could you provide more info on what you are doing?
0
 

Author Comment

by:YellowbusTeam
ID: 22848406
The below is what I believe they are trying to do, which relates to the piece of code you highlighted above.

They are trying to insert a new record in SQL server which needs to relate to another record, but that record doesnt exist.
0
 
LVL 18

Expert Comment

by:David Robitaille
ID: 22849429
Well, i know that. but what is your question and how could I help you?
0
 

Author Comment

by:YellowbusTeam
ID: 22849674
Well im not to sure as they are a client of our and we just administer there server, they did inform however that it isn't anything to worry about and the site is still in testing mode.

Should we/they be worried about this error?
0
 
LVL 18

Accepted Solution

by:
David Robitaille earned 500 total points
ID: 22850178
Well, as you said,  it s a programming error. You should not worry too much about it...
If the site is still in testing mode, they should be aware of it, because they could left "debug="true"" in their web config. Then they got a debug error on the web page explaining the problem in a similar manner the in the event log. But they may not left it to true for security reason.
You could forward them that error, the Request URL (http://test.thegmach.com/relatedcategories.aspx )
 and the "Event time" of it.
Also, ask them if they want to be noticed of these error. Personally, if I " just administer there server" i won`t want to check those too often. So you could say that you could send them on request. Or you could just said them to do better programming :-)
 
0
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 
LVL 18

Expert Comment

by:David Robitaille
ID: 22853388
did that answer your question?
0
 

Author Comment

by:YellowbusTeam
ID: 22865421
Yeah it did cheers mate
0
 
LVL 18

Expert Comment

by:David Robitaille
ID: 22896056

Why did i get a "B"
http://www.experts-exchange.com/help.jsp#hi403
"an answer is worth an A, unless it doesn't resolve your issue"
0
 

Author Comment

by:YellowbusTeam
ID: 22896179
Sorry about that, i din't fully understand how the grading system worked.

your answer was of great help to us
0
 
LVL 18

Expert Comment

by:David Robitaille
ID: 22896361
That was the feeling i had. Could you please "Request Attention" to change the grade?
http://www.experts-exchange.com/help.jsp#hi404
"How can I change a grade?
If you feel you have graded a solution incorrectly, click the Request Attention button and the Moderators will change it for you."
 
 Glad I could help!
 
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Today is the age of broadband.  More and more people are going this route determined to experience the web and it’s multitude of services as quickly and painlessly as possible. Coupled with the move to broadband, people are experiencing the web via …
A quick way to get a menu to work on our website, is using the Menu control and assign it to a web.sitemap using SiteMapDataSource. Example of web.sitemap file: (CODE) Sample code to add to the page menu: (CODE) Running the application, we wi…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now