asked on

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

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)

David Robitaille

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?

YellowbusTeam

ASKER

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.

David Robitaille

Well, i know that. but what is your question and how could I help you?

YellowbusTeam

ASKER

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?

ASKER CERTIFIED SOLUTION

David Robitaille

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

David Robitaille

did that answer your question?

YellowbusTeam

ASKER

Yeah it did cheers mate

David Robitaille

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

YellowbusTeam

ASKER

Sorry about that, i din't fully understand how the grading system worked.

your answer was of great help to us

David Robitaille

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!