2
Vote

Cannot install DNNTweet within DNN7 in Azure

description

When installing in a DNN7 instance hosted in MS Azure I get the following error.

Package Installation Report

See below for the results of the package installation
Error loading files from temporary folder - see below
StartJob    Starting Installation
Info    Starting Installation - WillStrohl.Twitter
Info    Starting Installation - Script
Info    Begin Sql execution
Info    Creating backup of previous version - Providers\DataProviders\SqlDataProvider\01.00.00.SqlDataProvider
Info    Created - Providers\DataProviders\SqlDataProvider\01.00.00.SqlDataProvider
Info    Executing 01.00.00.SqlDataProvider
Info    Start Sql execution: 01.00.00.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): 'NOT FOR REPLICATION' is not supported in this version of SQL Server. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(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) 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:c76b3258-6f8e-4724-b9fb-6f2c45a4a916 CREATE TABLE dbo.[cccproto_dnntweet_search_history] ( [SearchId] INT IDENTITY NOT NULL CONSTRAINT [PK_cccproto_dnntweet_search_history] PRIMARY KEY CLUSTERED , [ModuleId] INT NOT NULL CONSTRAINT [FK_cccproto_dnntweet_search_history_ModuleId] FOREIGN KEY REFERENCES dbo.[cccproto_Modules] ([ModuleId]) ON DELETE CASCADE NOT FOR REPLICATION, [UserId] INT NOT NULL CONSTRAINT [FK_cccproto_dnntweet_search_history_UserId] FOREIGN KEY REFERENCES dbo.[cccproto_Users] ([UserId]), [SearchText] NVARCHAR(255) NOT NULL ); System.Data.SqlClient.SqlException (0x80131904): Cannot find the object "dbo.cccproto_dnntweet_search_history" because it does not exist or you do not have permissions. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(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) 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:8d150359-693b-4d99-bd22-5e14c47c8a35 CREATE NONCLUSTERED INDEX [IX_cccproto_dnntweet_search_history_SearchText] ON dbo.[cccproto_dnntweet_search_history] ([SearchText]) ; System.Data.SqlClient.SqlException (0x80131904): Cannot find the object "dbo.cccproto_dnntweet_search_history" because it does not exist or you do not have permissions. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(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) 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:5c38dc04-0f35-4dba-ac87-95e8642d264a CREATE NONCLUSTERED INDEX [IX_cccproto_dnntweet_search_history_UserId] ON dbo.[cccproto_dnntweet_search_history] ([UserId]) ; System.Data.SqlClient.SqlException (0x80131904): Cannot find the object "dbo.cccproto_dnntweet_search_history" because it does not exist or you do not have permissions. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(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) 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:8a492320-2a52-4a1a-aab0-b514f655d910 CREATE NONCLUSTERED INDEX [IX_cccproto_dnntweet_search_history_ModuleId] ON dbo.[cccproto_dnntweet_search_history] ([ModuleId]) ; System.Data.SqlClient.SqlException (0x80131904): Cannot find the object "dbo.cccproto_dnntweet_search_history" because it does not exist or you do not have permissions. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(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) 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:87aa8177-6f6f-40bd-8a42-9a0b6981169d CREATE NONCLUSTERED INDEX [IX_cccproto_dnntweet_search_history_ModuleId_UserId] ON dbo.[cccproto_dnntweet_search_history] ([ModuleId],[UserId]) ;
Info    End Sql execution: 01.00.00.SqlDataProvider file
Info    Finished Sql execution
Failure Installation Failed - Script
Info    Installation Failed - WillStrohl.Twitter
Info    Deleted temporary install folder
EndJob  Installation Failed

comments