When I try to install the latest release of 2SXC I get the following error. Anyone come across this before? Anyone know how to fix it? I am trying to run the latest DNN on Azure.
StartJob Starting Installation
Info Starting Installation - 2SexyContent
Info Starting Installation - Script
Info Begin Sql execution
Info Creating backup of previous version - SqlDataProvider\00.99.00.SqlDataProvider
Info Created - SqlDataProvider\00.99.00.SqlDataProvider
Info Executing 00.99.00.SqlDataProvider
Info Start Sql execution: 00.99.00.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Changed language setting to us_english. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out 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, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDatabaseConnectionProvider.ExecuteNonQuery(String connectionString, CommandType commandType, Int32 commandTimeout, String query) at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script, Int32 timeoutSec) ClientConnectionId:e6508eea-250c-4078-b350-2b0ac452bab8 Error Number:-2,State:0,Class:11 ClientConnectionId before routing:d050f369-854f-49f3-93dd-84047979567a Routing Destination:cac86af208c3.tr45.northeurope1-a.worker.database.windows.net,11314
-- Set session language to english to ensure DateTime format is correct (all following insert statements in this script expect that) SET LANGUAGE English
-- Check for custom Object Qualifier - break installation if it's configured (2sxc does not support object qualifier) IF '' <> '' BEGIN RAISERROR(N'Your SQL installation is non-standard using a Custom Object Qualifier. 2sic uses the standard Microsoft Entity Framework which doesn''t work well with this feature - installation aborted.', 16, 1) RETURN END -- Script Block for 2SexyContent
05.05.00 Update -- --------------------------------------------- -- This SQL Script Block must be included in every .SqlDataProvider file
-- for 2SexyContent <= 05.05.00 because of the rename of the internal -- module name. It does not have to be included for newer SQL scripts. -- This script changes the module name and the breaks the installation -- so the DNN cache is refreshed. After the upgrade is triggered again, -- the installation works. DECLARE @IsUpgradeFromPreviousVersion int SELECT @IsUpgradeFromPreviousVersion = CASE WHEN EXISTS(SELECT * FROM DesktopModules WHERE ModuleName = N'2SexyContent') THEN CAST (1 AS BIT) ELSE CAST (0 AS BIT) END If @IsUpgradeFromPreviousVersion = 1 BEGIN UPDATE DesktopModules SET ModuleName = N'2sxc' WHERE (ModuleName = N'2SexyContent') RAISERROR(N'Please run this upgrade again to finish the process. This is a necessary step because of the internal rename of the 2SexyContent module.
************************************************************************************************************************************************************************** PLEASE RUN THIS UPGRADE AGAIN TO FINISH THE PROCESS. This is a necessary step because of the internal rename of the 2SexyContent module.
**************************************************************************************************************************************************************************', 16, 1) RETURN END -- End of the Script Block for 2SexyContent
05.05.00 Update
-- Start of install procedure which replaces all install scripts and code updates until and including version 08.11.00
-------------------------------------------------
-- make sure sql rolls back automatically in case of error. SET XACT_ABORT ON BEGIN TRANSACTION SexyContentUpdate; EXEC(' /****** Object: Table [dbo].[ToSIC_EAV_Apps] Script Date: 20.02.2017
User contributions licensed under CC BY-SA 3.0