StartJob
Starting Installation
Info
Starting Installation - AdvancedLogin
Starting Installation - Script
Begin Sql execution
Folder Created - C:\Projects\FiberizerWeb\__Externals\fiberizer-web\DesktopModules\AdvancedLogin\
Created - 45.01.07.SqlDataProvider
Executing 45.01.07.SqlDataProvider
Start Sql execution: 45.01.07.SqlDataProvider file
Warning
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.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.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ClientConnectionId:8c196f31-674f-4754-b56f-771d5a520638 /************************************************************/ /***** SqlDataProvider *****/ /***** *****/ /***** *****/ /***** Note: To manually execute this script you must *****/ /***** perform a search and replace operation *****/ /***** for dbo. and dnn_ *****/ /***** *****/ /************************************************************/ /** Create Table **/ if not exists (select * from dbo.sysobjects where id = object_id(N'dbo.dnn_iWebs_AL_ReDir') and OBJECTPROPERTY(id, N'IsUserTable') = 1) BEGIN CREATE TABLE dbo.dnn_iWebs_AL_ReDir ( [ID] [int] IDENTITY (1, 1) NOT NULL , [ModuleId] [int] NOT NULL , [Role] [nvarchar] (100) NOT NULL , [URL] [nvarchar] (1000) NULL ) ON [PRIMARY] ALTER TABLE dbo.dnn_iWebs_AL_ReDir ADD CONSTRAINT PK_dnn_iWebs_AL_ReDir PRIMARY KEY CLUSTERED (ID) ALTER TABLE dbo.dnn_iWebs_AL_ReDir WITH NOCHECK ADD CONSTRAINT FK_dnn_iWebs_AL_ReDir_dnn_Modules FOREIGN KEY (ModuleID) REFERENCES dbo.dnn_Modules (ModuleID) ON DELETE CASCADE NOT FOR REPLICATION END -- DROP GET PROCEDURE -------------------------------------------------------------------------------------%> if exists (select * from dbo.sysobjects where id = object_id(N'dbo.dnn_iWebs_AL_ReDirGet') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure dbo.dnn_iWebs_AL_ReDirGet
End Sql execution: 45.01.07.SqlDataProvider file
Created - 45.01.09.SqlDataProvider
Executing 45.01.09.SqlDataProvider
Start Sql execution: 45.01.09.SqlDataProvider file
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'dbo.dnn_iWebs_AL_ReDir'. at System.Data.SqlClient.SqlConnection.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.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ClientConnectionId:83f1c28a-2dae-447e-b685-64ab7561bc3f UPDATE dbo.dnn_iWebs_AL_ReDir SET ViewOrder=ID
End Sql execution: 45.01.09.SqlDataProvider file
Created - 45.01.10.SqlDataProvider
Executing 45.01.10.SqlDataProvider
Start Sql execution: 45.01.10.SqlDataProvider file
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.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.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ClientConnectionId:26a23955-3ed2-4964-8c40-5be3f1b81680 /************************************************************/ /***** SqlDataProvider *****/ /***** *****/ /***** *****/ /***** Note: To manually execute this script you must *****/ /***** perform a search and replace operation *****/ /***** for dbo. and dnn_ *****/ /***** *****/ /************************************************************/ /* ===================================================================================== / TABLE: iWebs_AL_IP / ===================================================================================== */ if not exists (select * from dbo.sysobjects where id = object_id(N'dbo.dnn_iWebs_AL_IP') and OBJECTPROPERTY(id, N'IsUserTable') = 1) BEGIN CREATE TABLE dbo.dnn_iWebs_AL_IP ( [ID] [int] IDENTITY (1, 1) NOT NULL , [ModuleId] [int] NOT NULL , [IP] [nvarchar] (1000) NOT NULL , [Allowed] [bit] NOT NULL , [URL] [nvarchar] (1000) NULL , [ViewOrder] [int] NOT NULL ) ON [PRIMARY] ALTER TABLE dbo.dnn_iWebs_AL_IP ADD CONSTRAINT PK_dnn_iWebs_AL_IP PRIMARY KEY CLUSTERED (ID) ALTER TABLE dbo.dnn_iWebs_AL_IP WITH NOCHECK ADD CONSTRAINT FK_dnn_iWebs_AL_IP_dnn_Modules FOREIGN KEY (ModuleID) REFERENCES dbo.dnn_Modules (ModuleID) ON DELETE CASCADE NOT FOR REPLICATION END System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'dbo.dnn_iWebs_AL_IP'. at System.Data.SqlClient.SqlConnection.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.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ClientConnectionId:0a8a0ac0-0d5c-4dfe-8363-ba56e112991f UPDATE dbo.dnn_iWebs_AL_IP SET ViewOrder=ID
End Sql execution: 45.01.10.SqlDataProvider file
Created - 45.02.11.SqlDataProvider
Executing 45.02.11.SqlDataProvider
Start Sql execution: 45.02.11.SqlDataProvider file
End Sql execution: 45.02.11.SqlDataProvider file
Created - 45.03.02.SqlDataProvider
Executing 45.03.02.SqlDataProvider
Start Sql execution: 45.03.02.SqlDataProvider file
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.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.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ClientConnectionId:8c196f31-674f-4754-b56f-771d5a520638 /************************************************************/ /***** SqlDataProvider *****/ /***** *****/ /***** *****/ /***** Note: To manually execute this script you must *****/ /***** perform a search and replace operation *****/ /***** for dbo. and dnn_ *****/ /***** *****/ /************************************************************/ /* ===================================================================================== / TABLE: iwebs_AL_AdvRole / ===================================================================================== */ if not exists (select * from dbo.sysobjects where id = object_id(N'dbo.dnn_iwebs_AL_AdvRole') and OBJECTPROPERTY(id, N'IsUserTable') = 1) BEGIN CREATE TABLE dbo.dnn_iwebs_AL_AdvRole ( ID INT IDENTITY (1, 1) NOT NULL , ModuleID INT NOT NULL , Role NVARCHAR(50) NOT NULL , SubscribeLength NVARCHAR(50) NULL , Notify NVARCHAR(10) NULL ) ON [PRIMARY] ALTER TABLE dbo.dnn_iwebs_AL_AdvRole ADD CONSTRAINT PK_dnn_iwebs_AL_AdvRole PRIMARY KEY CLUSTERED (ID) ALTER TABLE dbo.dnn_iwebs_AL_AdvRole WITH NOCHECK ADD CONSTRAINT FK_dnn__iwebs_AL_AdvRole_dnn_Modules FOREIGN KEY (ModuleID) REFERENCES dbo.dnn_Modules (ModuleID) ON DELETE CASCADE NOT FOR REPLICATION END
End Sql execution: 45.03.02.SqlDataProvider file
Created - 45.06.23.SqlDataProvider
Executing 45.06.23.SqlDataProvider
Start Sql execution: 45.06.23.SqlDataProvider file
End Sql execution: 45.06.23.SqlDataProvider file
Created - Uninstall.SqlDataProvider