Peter,
I got the following error upgrading to the newest version. Please advise:
Info Start Sql execution: 06.00.00.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): The index '_dta_index_DMX_Entries_18_1926297922__K17_K8_K9_K14_K11_K19_K20_1_2_3_4_5_6_7_10_13_15_16_21_22_23_24_25_26_27_28_29_30_31_32_' is dependent on column 'Description'. The index '_dta_index_DMX_Entries_18_1926297922__K17_K11_K8_K9_1_2_3_4_5_6_7_10_13_14_15_16_19_20_21_22_23_24_25_26_27_28_29_30_31_32_33' is dependent on column 'Description'. The index '_dta_index_DMX_Entries_18_1926297922__K19_K17_K11_K8_K9_1_2_3_4_5_6_7_10_13_14_15_16_20_21_22_23_24_25_26_27_28_29_30_31_32_33' is dependent on column 'Description'. The index '_dta_index_DMX_Entries_18_1926297922__K2_K17_K11_K19_K20_K8_K9_K14_1_3_4_5_6_7_10_13_15_16_21_22_23_24_25_26_27_28_29_30_31_32_' is dependent on column 'Description'. The index '_dta_index_DMX_Entries_18_1926297922__K17_K9_K8_K14_K11_K19_K20_1_2_3_4_5_6_7_10_13_15_16_21_22_23_24_25_26_27_28_29_30_31_32_' is dependent on column 'Description'. The index '_dta_index_DMX_Entries_18_1926297922__K17_K9_K11_K19_K20_K8_K14_1_2_3_4_5_6_7_10_13_15_16_21_22_23_24_25_26_27_28_29_30_31_32_' is dependent on column 'Description'. ALTER TABLE DROP COLUMN Description failed because one or more objects access this column. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'DMX_Entries' AND COLUMN_NAME = 'Description') BEGIN EXEC('UPDATE dbo.DMX_Entries SET [Title]=[Description]'); EXEC('ALTER TABLE dbo.DMX_Entries DROP COLUMN [Description]'); END IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'dbo.DMX_DirectAccessKeys') AND OBJECTPROPERTY(id, N'IsTable') = 1) CREATE TABLE dbo.DMX_DirectAccessKeys ( [PortalId] INT NOT NULL, [Downloads] INT, [Email] NVARCHAR (100), [EntryId] INT, [Expires] DATETIME, [Key] NVARCHAR (100) NOT NULL, [UserId] INT ) ON [PRIMARY] System.Data.SqlClient.SqlException (0x80131904): Cannot find the object "dbo.DMX_DirectAccessKeys" because it does not exist or you do not have permissions. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'PK_DMX_DirectAccessKeys') AND OBJECTPROPERTY(id, N'IsPrimaryKey') = 1) ALTER TABLE dbo.DMX_DirectAccessKeys ADD CONSTRAINT PK_DMX_DirectAccessKeys PRIMARY KEY CLUSTERED ( [PortalId], [Key] ) ON [PRIMARY] System.Data.SqlClient.SqlException (0x80131904): Cannot find the object "dbo.DMX_DirectAccessKeys" because it does not exist or you do not have permissions. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'FK_DMX_DirectAccessKeys_Entries') AND OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE dbo.DMX_DirectAccessKeys ADD CONSTRAINT FK_DMX_DirectAccessKeys_Entries FOREIGN KEY ( EntryId ) REFERENCES dbo.DMX_Entries ( EntryId ) ON DELETE CASCADE NOT FOR REPLICATION
|