Exception: Violation of PRIMARY KEY constraint 'PK_HyperLinks_Hosts_Discoveries'. Cannot insert duplicate key in object 'dbo.HyperLinks_Hosts_Discoveries'. The statement has been terminated.

megetron posted on Thu, Sep 3 2009 3:41 PM

rated by 0 users

Hi, here is the third exception. it happens with 1.2 releasse version:

Created ID AbsoluteUri1 AbsoluteUri2 HelpLink Message Source StackTrace
2009-09-04 00:41:38.327 7 http://sratim.co.il/users http://sratim.co.il/users/usersbyroles.aspx NULL Violation of PRIMARY KEY constraint 'PK_HyperLinks_Hosts_Discoveries'. Cannot insert duplicate key in object 'dbo.HyperLinks_Hosts_Discoveries'.  The statement has been terminated. .Net SqlClient Data Provider    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.ExecuteScalar()     at Arachnode.DataSource.ArachnodeDataSetTableAdapters.QueriesTableAdapter.InsertHyperLink(String WebPageAbsoluteUri, String HyperLinkAbsoluteUri, Nullable`1 ClassifyAbsoluteUri, Nullable`1& HyperLinkID) in E:\DEVELOPMENT\yeshira12\DataSource\ArachnodeDataSet.Designer.cs:line 12878     at Arachnode.DataAccess.ArachnodeDAO.InsertHyperLink(String webPageAbsoluteUri, String hyperLinkAbsoluteUri) in E:\DEVELOPMENT\yeshira12\DataAccess\ArachnodeDAO.cs:line 1066