This project has moved. For the latest updates, please go here.
1
Vote

Cannot Insert duplicate key row errors

description

Install Engage 8.2.0.230
The following errors are logged in the logfile:

{panel:bgColor=#FFDDDD}
2015-08-13 10:09:57,810 [DNN-TESTPC-MK][Thread:46][ERROR] DotNetNuke.Services.Exceptions.Exceptions - System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.test_CoreMessaging_NotificationTypes' with unique index 'IX_test_CoreMessaging_NotificationTypes'. The duplicate key value is (DNNCorp_Discussions_Topic_Added).
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
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, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource
1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteScalar()
at Glimpse.Ado.AlternateType.GlimpseDbCommand.ExecuteScalar()
at PetaPoco.Database.ExecuteScalar[T](String sql, Object[] args)
at DotNetNuke.Data.PetaPoco.PetaPocoHelper.ExecuteScalar[T](String connectionString, CommandType type, String sql, Object[] args) in c:\TeamCity\buildAgent\work\DNN_Platform_742_Public\Packaging\DNN.Platform\DNN Platform\Library\Data\PetaPoco\PetaPocoHelper.cs:line 81
at DotNetNuke.Services.Social.Notifications.Data.DataService.CreateNotificationType(String name, String description, Int32 timeToLive, Int32 desktopModuleId, Int32 createUpdateUserId, Boolean isTask) in c:\TeamCity\buildAgent\work\DNN_Platform_742_Public\Packaging\DNN.Platform\DNN Platform\Library\Services\Social\Notifications\Data\DataService.cs:line 49
at DotNetNuke.Services.Social.Notifications.NotificationsController.CreateNotificationType(NotificationType notificationType) in c:\TeamCity\buildAgent\work\DNN_Platform_742_Public\Packaging\DNN.Platform\DNN Platform\Library\Services\Social\Notifications\NotificationsController.cs:line 243
at DotNetNuke.Professional.Discussions.Components.Controllers.BusinessController.AddNotificationTypes(Int32 desktopModuleId) in c:\TeamCity\buildAgent\work\Evoq_Engage_82\Compile\Evoq.Social\DesktopModules\DNNCorp\Discussions\Components\Controllers\BusinessController.cs:line 386
at DotNetNuke.Professional.Discussions.Components.Controllers.BusinessController.UpgradeModuleLocal(String version) in c:\TeamCity\buildAgent\work\Evoq_Engage_82\Compile\Evoq.Social\DesktopModules\DNNCorp\Discussions\Components\Controllers\BusinessController.cs:line 140
at DotNetNuke.Professional.Discussions.Components.Controllers.BusinessController.UpgradeModule(String version) in c:\TeamCity\buildAgent\work\Evoq_Engage_82\Compile\Evoq.Social\DesktopModules\DNNCorp\Discussions\Components\Controllers\BusinessController.cs:line 113
ClientConnectionId:d645e347-ba40-4717-a9e5-cb98c4186df2
{panel}

{panel:bgColor=#FFBBBB}
2015-08-13 10:09:58,925 [DNN-TESTPC-MK][Thread:51][ERROR] DotNetNuke.Services.Exceptions.Exceptions - System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.test_ContentTypes' with unique index 'IX_test_ContentTypes_ContentType'. The duplicate key value is (DNNCorp_SocialEvents_Event).
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
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, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource
1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteScalar()
at Glimpse.Ado.AlternateType.GlimpseDbCommand.ExecuteScalar()
at PetaPoco.Database.ExecuteScalar[T](String sql, Object[] args)
at DotNetNuke.Data.PetaPoco.PetaPocoHelper.ExecuteScalar[T](String connectionString, CommandType type, String sql, Object[] args) in c:\TeamCity\buildAgent\work\DNN_Platform_742_Public\Packaging\DNN.Platform\DNN Platform\Library\Data\PetaPoco\PetaPocoHelper.cs:line 81
at DotNetNuke.Entities.Content.ContentTypeController.AddContentType(ContentType contentType) in c:\TeamCity\buildAgent\work\DNN_Platform_742_Public\Packaging\DNN.Platform\DNN Platform\Library\Entities\Content\ContentTypeController.cs:line 85
at DotNetNuke.Professional.SocialEvents.Components.Controllers.BusinessController.UpgradeModuleLocal(String version) in c:\TeamCity\buildAgent\work\Evoq_Engage_82\Compile\Evoq.Social\DesktopModules\DNNCorp\SocialEvents\Components\Controllers\BusinessController.cs:line 63
at DotNetNuke.Professional.SocialEvents.Components.Controllers.BusinessController.UpgradeModule(String version) in c:\TeamCity\buildAgent\work\Evoq_Engage_82\Compile\Evoq.Social\DesktopModules\DNNCorp\SocialEvents\Components\Controllers\BusinessController.cs:line 36
ClientConnectionId:cceb865a-a052-425b-a56b-4cb8d6e3c8f0
{panel}

comments