1

Closed

table missing clustered index

description

this module cannot be installed on azure, azure sql seems to require clustered indexes on a table.i get the following errorSQL uitvoer leverde de volgende uitzonderingen op: 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. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) 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:63f46876-feff-4213-85b3-e5ba7bb28b17 INSERT INTO dbo.activeforums_Content_Attachments (ContentId, AttachId) SELECT ContentId, AttachId from dbo.activeforums_Attachments WHERE ContentId > 0
Closed Dec 20, 2012 at 9:00 PM by ActiveModules

comments

rfcdejong wrote Dec 8, 2012 at 8:07 PM

ActiveModules wrote Dec 18, 2012 at 8:22 PM

This has been fixed for 5.0.2

sradel wrote Feb 18, 2013 at 5:34 AM

I have tried both version 5.0.2 and 5.0.3 Beta. Both versions install just fine on Windows Azure, but they both throw and error when trying to back up the DNN DB iwth SQL Management Studio. Still seems to be an issue with the clustered indexes. See error below thanks.

TITLE: Microsoft SQL Server Management Studio

One or more unsupported elements were found in the schema used as part of a data package.
Error SQL71564: Table Table: [dbo].[activeforums_Security] does not have a clustered index. Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[activeforums_Queue] does not have a clustered index. Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[activeforums_Topics_Tags] does not have a clustered index. Clustered indexes are required for inserting data in this version of SQL Server.
(Microsoft.SqlServer.Dac)