Solved

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

Posted on 2008-10-30
10
1,055 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
Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

 

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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

I have developed many web applications with asp & asp.net and to add and use a dropdownlist was always a very simple task, but with the new asp.net, setting the value is a bit tricky and its not similar to the old traditional method. So in this a…
I recently went through the process of creating a Calendar Control of events with the basis of using a database to keep track of the dates that are selectable, one requirement was to have the selected date pop-up in a simple lightbox.  At first this…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…
Suggested Courses

734 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