I updated the files on an windows Azure deployment of DNN to 07.04.02, but it fails when updating the database with the following error:
1:19 Minutes | 26% ERROR occured - System.Data.SqlClient.SqlException (0x80131904): Tables without a clustered index are not supported in this version of SQL Server. Please create a clustered index and try again. 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:09f6a31e-86be-4a98-93f2-9e30b54e287c Error Number:40054,State:2,Class:16 /* DNN-5631: prevent duplicate keys */ /* ******************************** */ -- ensure there are no duplicate rows: DELETE FROM dbo.[PortalSettings] WHERE PortalSettingID NOT IN (SELECT Max(PortalSettingID) M FROM dbo.[PortalSettings] GROUP BY PortalID, CultureCode, SettingName) -- drop old Index IF EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'dbo.[PortalSettings]') AND name = N'IX_PortalSettings') DROP INDEX [IX_PortalSettings] ON dbo.[PortalSettings] System.Data.SqlClient.SqlException (0x80131904): The operation failed because an index or statistics with name 'IX_PortalSettings' already exists on table 'dbo.PortalSettings'. 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:09f6a31e-86be-4a98-93f2-9e30b54e287c Error Number:1913,State:1,Class:16 -- recreate Index CREATE UNIQUE CLUSTERED INDEX [IX_PortalSettings] ON dbo.[PortalSettings] ( PortalID, CultureCode, SettingName )
Any help would be appreciated!