26:12 Minutes   |   25%

ERROR occured - System.Data.SqlClient.SqlException (0x80131904):

Cannot insert duplicate key row in object 'dbo.CoreMessaging_NotificationTypeActions' with unique index 'IX_CoreMessaging_NotificationTypeActions_Type'. The statement has been terminated. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:15f4e8ee-90e3-40cb-bcf3-244d18eb5eb9 Error Number:2601,State:1,Class:14 /* Remove Review action and add Approve, Reject */ DECLARE @NotificationTypeId INT SELECT @NotificationTypeId = NotificationTypeId FROM dbo.CoreMessaging_NotificationTypes WHERE Name = 'ContentWorkflowNotification' IF @NotificationTypeId IS NOT NULL BEGIN /* Delete Review notification action added int 7.3.0 */ DELETE FROM dbo.CoreMessaging_NotificationTypeActions WHERE NotificationTypeId = @NotificationTypeId AND NameResourceKey = 'Review' /* Add Approve notification action */ INSERT INTO dbo.CoreMessaging_NotificationTypeActions( [NotificationTypeID], [NameResourceKey], [DescriptionResourceKey], [ConfirmResourceKey], [Order], [APICall], [CreatedByUserID], [CreatedOnDate], [LastModifiedByUserID], [LastModifiedOnDate]) VALUES( @NotificationTypeId, 'Approve', 'Approve', NULL, 1, 'DesktopModules/InternalServices/API/ContentWorkflowService/Approve', -1, GETDATE(), -1, GETDATE() ) /* Add Reject notification action */ INSERT INTO dbo.CoreMessaging_NotificationTypeActions( [NotificationTypeID], [NameResourceKey], [DescriptionResourceKey], [ConfirmResourceKey], [Order], [APICall], [CreatedByUserID], [CreatedOnDate], [LastModifiedByUserID], [LastModifiedOnDate]) VALUES( @NotificationTypeId, 'Reject', 'Reject', NULL, 1, 'DesktopModules/InternalServices/API/ContentWorkflowService/Reject', -1, GETDATE(), -1, GETDATE() ) END System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object

@NotificationStartWorkflowTypeId = NotificationTypeId FROM dbo.CoreMessaging_NotificationTypes WHERE Name = 'ContentWorkflowStartWorkflowNotification' IF @NotificationStartWorkflowTypeId IS NOT NULL BEGIN /* Add Submit notification action */ /* also uses the existing Approve method */ INSERT INTO dbo.CoreMessaging_NotificationTypeActions( [NotificationTypeID], [NameResourceKey], [DescriptionResourceKey], [ConfirmResourceKey], [Order], [APICall], [CreatedByUserID], [CreatedOnDate], [LastModifiedByUserID], [LastModifiedOnDate]) VALUES( @NotificationStartWorkflowTypeId, 'Submit', 'Submit', NULL, 1, 'DesktopModules/InternalServices/API/ContentWorkflowService/Approve', -1, GETDATE(), -1, GETDATE() ) /* Add Discard notification action */ /* also uses the existing Reject method */ INSERT INTO dbo.CoreMessaging_NotificationTypeActions( [NotificationTypeID], [NameResourceKey], [DescriptionResourceKey], [ConfirmResourceKey], [Order], [APICall], [CreatedByUserID], [CreatedOnDate], [LastModifiedByUserID], [LastModifiedOnDate]) VALUES( @NotificationStartWorkflowTypeId, 'Discard', 'Discard', NULL, 1, 'DesktopModules/InternalServices/API/ContentWorkflowService/Reject', -1, GETDATE(), -1, GETDATE() ) END System.Data.SqlClient.SqlException (0x80131904): Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script)