Timeout error when installing latest stable release of 2SXC module


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
asked on Stack Overflow Aug 26, 2019 by Mike Dymond • edited Aug 27, 2019 by Vega

0 Answers

Nobody has answered this question yet.

User contributions licensed under CC BY-SA 3.0