I am getting the following error upgrading one site from 7.2.1 to 7.2.2 (another site went without issues)

26% ERROR occured - System.Data.SqlClient.SqlException (0x80131904): The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.ModulePermission' and the index name 'IX_ModulePermission_Modules'. The duplicate key value is (494, 1, 0, <NULL>). The statement has been terminated. at System.Data.SqlClient.SqlConnection. (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:2f070015-7030-4f36-ad88-8338a93e3a63 CREATE UNIQUE NONCLUSTERED INDEX IX_ModulePermission_Modules ON dbo.[ModulePermission] (ModuleID, PermissionID, RoleID, UserID) INCLUDE (AllowAccess) System.Data.SqlClient.SqlException (0x80131904): The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.ModulePermission' and the index name 'IX_ModulePermission_Roles'. The duplicate key value is (0, 494, 1). The statement has been terminated. at System.Data.SqlClient.SqlConnection. (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:a2cb2320-e762-4f4f-b5ec-bbb3a8f72472 CREATE UNIQUE NONCLUSTERED INDEX IX_ModulePermission_Roles ON dbo.[ModulePermission] (RoleID, ModuleID, PermissionID) INCLUDE (AllowAccess) WHERE RoleID IS NOT Null

This site is down now so any help is appreciated

---

Regards Luís Rodrigues

Deleted the offending record - still gives the same errror

---

Regards Luís Rodrigues

recycling the application domain is required after you do a direct database update as the "bad" data will still be cached. Please log an issue to support.dnnosftware.com for this problem so we can add code to detect and delete any bad data that might cause an upgrade failure. Note: this is the 1st incident I've seen of this issue which suggests the issue is rare, and perhaps from a badly behaved 3rd party module rather than the platform itself

---

Buy the new Professional DNN7: Open Source .NET CMS Platform book Amazon US