Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2008-10-30
10
Medium Priority
?
1,061 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

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 1500 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
 
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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this Article, I will provide a few tips in problem and solution manner. Opening an ASPX page in Visual studio 2003 is very slow. To make it fast, please do follow below steps:   Open the Solution/Project. Right click the ASPX file to b…
Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

670 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