Setup failed: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
один год назад
I am trying to install the version 4.50.2  and this error happens.

Setup failed: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

How can i fix this?

Thanks!
один год назад
Do you confirmed / have the correct SQl Server name / connection string ?
один год назад
Please post the entire error message (stack trace)
один год назад
I already checked the Sql timeout settings. I already have the database name, anyway.
I even managed to install on the same computer in other versions. In the last one I can't.
Other colleagues who work with me also had the same problem.

Erro message: "Setup failed: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding."
один год назад
Are there errors in the other logs
See https://www.selectsystems.com.au/checking-for-errors-on-a-new-installation-of-nopcommerce
один год назад
I am getting the same error message in 4.50.2 when trying to install it locally using VS 2022. Here is the log file:

info: Microsoft.Hosting.Lifetime[14]
      Now listening on: http://127.0.0.1:15592
info: Microsoft.Hosting.Lifetime[0]
      Application started. Press Ctrl+C to shut down.
info: Microsoft.Hosting.Lifetime[0]
      Hosting environment: Development
info: Microsoft.Hosting.Lifetime[0]
      Content root path: C:\Users\marti\Downloads\nopCommerce_4.50.2_Source\src\Presentation\Nop.Web\
info: Microsoft.AspNetCore.Hosting.Diagnostics[1]
      Request starting HTTP/1.1 DEBUG http://localhost:65283/ - 0
info: Microsoft.AspNetCore.Hosting.Diagnostics[1]
      Request starting HTTP/1.1 GET http://localhost:44369/ - -
info: Microsoft.AspNetCore.Hosting.Diagnostics[2]
      Request finished HTTP/1.1 DEBUG http://localhost:65283/ - 0 - 200 0 - 277.9646ms
info: Microsoft.AspNetCore.Hosting.Diagnostics[2]
      Request finished HTTP/1.1 GET http://localhost:44369/ - - - 302 0 - 433.2823ms
info: Microsoft.AspNetCore.Hosting.Diagnostics[1]
      Request starting HTTP/1.1 GET http://localhost:44369/install - -
info: Microsoft.AspNetCore.Routing.EndpointMiddleware[0]
      Executing endpoint 'Nop.Web.Controllers.InstallController.Index (Nop.Web)'
info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[3]
      Route matched with {action = "Index", controller = "Install", area = ""}. Executing controller action with signature Microsoft.AspNetCore.Mvc.IActionResult Index() on controller Nop.Web.Controllers.InstallController (Nop.Web).
info: Microsoft.AspNetCore.Mvc.ViewFeatures.ViewResultExecutor[1]
      Executing ViewResult, running view Index.
info: Microsoft.AspNetCore.Mvc.ViewFeatures.ViewResultExecutor[4]
      Executed ViewResult - view Index executed in 16085.2978ms.
info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[2]
      Executed action Nop.Web.Controllers.InstallController.Index (Nop.Web) in 16409.8936ms
info: Microsoft.AspNetCore.Routing.EndpointMiddleware[1]
      Executed endpoint 'Nop.Web.Controllers.InstallController.Index (Nop.Web)'
info: Microsoft.AspNetCore.Hosting.Diagnostics[2]
      Request finished HTTP/1.1 GET http://localhost:44369/install - - - 200 - text/html;+charset=utf-8 17823.6560ms
info: Microsoft.AspNetCore.Hosting.Diagnostics[1]
      Request starting HTTP/1.1 GET http://localhost:44369/_framework/aspnetcore-browser-refresh.js - -
info: Microsoft.AspNetCore.Hosting.Diagnostics[2]
      Request finished HTTP/1.1 GET http://localhost:44369/_framework/aspnetcore-browser-refresh.js - - - 200 11984 application/javascript;+charset=utf-8 30.9104ms
info: Microsoft.AspNetCore.Hosting.Diagnostics[1]
      Request starting HTTP/1.1 GET http://localhost:44369/_vs/browserLink - -
info: Microsoft.AspNetCore.Hosting.Diagnostics[2]
      Request finished HTTP/1.1 GET http://localhost:44369/_vs/browserLink - - - 200 - text/javascript;+charset=UTF-8 1568.9171ms
info: Microsoft.AspNetCore.Hosting.Diagnostics[1]
      Request starting HTTP/1.1 POST http://localhost:44369/install application/x-www-form-urlencoded 601
info: Microsoft.AspNetCore.Routing.EndpointMiddleware[0]
      Executing endpoint 'Nop.Web.Controllers.InstallController.Index (Nop.Web)'
info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[3]
      Route matched with {action = "Index", controller = "Install", area = ""}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] Index(Nop.Web.Models.Install.InstallModel) on controller Nop.Web.Controllers.InstallController (Nop.Web).
info: FluentMigrator.Runner.MigrationRunner[1000]
      VersionMigration migrating
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1004]
      Beginning Transaction
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
      BEGIN TRANSACTION
info: FluentMigrator.Runner.MigrationRunner[1004]
      CreateTable MigrationVersionInfo
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
      CREATE TABLE [dbo].[MigrationVersionInfo] ([Version] BIGINT NOT NULL)
info: FluentMigrator.Runner.MigrationRunner[1002]
      => 0.3000247s
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1004]
      Committing Transaction
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
      COMMIT TRANSACTION
info: FluentMigrator.Runner.MigrationRunner[1004]
      VersionMigration migrated
info: FluentMigrator.Runner.MigrationRunner[1002]
      => 0.326794s
info: FluentMigrator.Runner.MigrationRunner[1000]
      VersionUniqueMigration migrating
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1004]
      Beginning Transaction
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
      BEGIN TRANSACTION
info: FluentMigrator.Runner.MigrationRunner[1004]
      CreateIndex MigrationVersionInfo (Version)
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
      CREATE UNIQUE CLUSTERED INDEX [UC_Version] ON [dbo].[MigrationVersionInfo] ([Version] ASC)
info: FluentMigrator.Runner.MigrationRunner[1002]
      => 0.1373859s
info: FluentMigrator.Runner.MigrationRunner[1004]
      AlterTable MigrationVersionInfo
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
info: FluentMigrator.Runner.MigrationRunner[1002]
      => 0.0031199s
info: FluentMigrator.Runner.MigrationRunner[1004]
      CreateColumn MigrationVersionInfo AppliedOn DateTime
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
      ALTER TABLE [dbo].[MigrationVersionInfo] ADD [AppliedOn] DATETIME
info: FluentMigrator.Runner.MigrationRunner[1002]
      => 0.0162965s
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1004]
      Committing Transaction
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
      COMMIT TRANSACTION
info: FluentMigrator.Runner.MigrationRunner[1004]
      VersionUniqueMigration migrated
info: FluentMigrator.Runner.MigrationRunner[1002]
      => 0.0242077s
info: FluentMigrator.Runner.MigrationRunner[1000]
      VersionDescriptionMigration migrating
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1004]
      Beginning Transaction
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
      BEGIN TRANSACTION
info: FluentMigrator.Runner.MigrationRunner[1004]
      AlterTable MigrationVersionInfo
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
info: FluentMigrator.Runner.MigrationRunner[1002]
      => 0.0002306s
info: FluentMigrator.Runner.MigrationRunner[1004]
      CreateColumn MigrationVersionInfo Description String
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
      ALTER TABLE [dbo].[MigrationVersionInfo] ADD [Description] NVARCHAR(1024)
info: FluentMigrator.Runner.MigrationRunner[1002]
      => 0.0068608s
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1004]
      Committing Transaction
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
      COMMIT TRANSACTION
info: FluentMigrator.Runner.MigrationRunner[1004]
      VersionDescriptionMigration migrated
info: FluentMigrator.Runner.MigrationRunner[1002]
      => 0.0218506s
info: FluentMigrator.Runner.MigrationRunner[1000]
      SchemaMigration migrating
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1004]
      Beginning Transaction
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
      BEGIN TRANSACTION
info: FluentMigrator.Runner.MigrationRunner[1004]
      CreateTable AddressAttribute
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
      CREATE TABLE [dbo].[AddressAttribute] ([Id] INT NOT NULL IDENTITY(1,1), [Name] NVARCHAR(400) NOT NULL, [IsRequired] BIT NOT NULL, [AttributeControlTypeId] INT NOT NULL, [DisplayOrder] INT NOT NULL, CONSTRAINT [PK_AddressAttribute] PRIMARY KEY ([Id]))
info: FluentMigrator.Runner.MigrationRunner[1002]
      => 0.0294509s
info: FluentMigrator.Runner.MigrationRunner[1004]
      CreateTable AddressAttributeValue
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
      CREATE TABLE [dbo].[AddressAttributeValue] ([Id] INT NOT NULL IDENTITY(1,1), [Name] NVARCHAR(400) NOT NULL, [AddressAttributeId] INT NOT NULL, [IsPreSelected] BIT NOT NULL, [DisplayOrder] INT NOT NULL, CONSTRAINT [PK_AddressAttributeValue] PRIMARY KEY ([Id]))
info: FluentMigrator.Runner.MigrationRunner[1002]
      => 0.1006991s
info: FluentMigrator.Runner.MigrationRunner[1004]
      CreateIndex AddressAttributeValue (AddressAttributeId)
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
      CREATE INDEX [IX_AddressAttributeValue_AddressAttributeId] ON [dbo].[AddressAttributeValue] ([AddressAttributeId] ASC)
info: FluentMigrator.Runner.MigrationRunner[1002]
      => 0.0038569s
info: FluentMigrator.Runner.MigrationRunner[1004]
      CreateForeignKey FK_AddressAttributeValue_AddressAttributeId_AddressAttribute_Id AddressAttributeValue(AddressAttributeId) AddressAttribute(Id)
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
      ALTER TABLE [dbo].[AddressAttributeValue] ADD CONSTRAINT [FK_AddressAttributeValue_AddressAttributeId_AddressAttribute_Id] FOREIGN KEY ([AddressAttributeId]) REFERENCES [dbo].[AddressAttribute] ([Id]) ON DELETE CASCADE
info: FluentMigrator.Runner.MigrationRunner[1002]
      => 0.0198777s
info: FluentMigrator.Runner.MigrationRunner[1004]
      CreateTable GenericAttribute
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
      CREATE TABLE [dbo].[GenericAttribute] ([Id] INT NOT NULL IDENTITY(1,1), [KeyGroup] NVARCHAR(400) NOT NULL, [Key] NVARCHAR(400) NOT NULL, [Value] NVARCHAR(MAX) NOT NULL, [EntityId] INT NOT NULL, [StoreId] INT NOT NULL, [CreatedOrUpdatedDateUTC] DATETIME2, CONSTRAINT [PK_GenericAttribute] PRIMARY KEY ([Id]))
info: FluentMigrator.Runner.MigrationRunner[1002]
      => 0.0073885s
info: FluentMigrator.Runner.MigrationRunner[1004]
      CreateTable SearchTerm
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
      CREATE TABLE [dbo].[SearchTerm] ([Id] INT NOT NULL IDENTITY(1,1), [Keyword] NVARCHAR(MAX), [StoreId] INT NOT NULL, [Count] INT NOT NULL, CONSTRAINT [PK_SearchTerm] PRIMARY KEY ([Id]))
info: FluentMigrator.Runner.MigrationRunner[1002]
      => 0.0168649s
info: FluentMigrator.Runner.MigrationRunner[1004]
      CreateTable Country
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
      CREATE TABLE [dbo].[Country] ([Id] INT NOT NULL IDENTITY(1,1), [Name] NVARCHAR(100) NOT NULL, [TwoLetterIsoCode] NVARCHAR(2), [ThreeLetterIsoCode] NVARCHAR(3), [AllowsBilling] BIT NOT NULL, [AllowsShipping] BIT NOT NULL, [NumericIsoCode] INT NOT NULL, [SubjectToVat] BIT NOT NULL, [Published] BIT NOT NULL, [DisplayOrder] INT NOT NULL, [LimitedToStores] BIT NOT NULL, CONSTRAINT [PK_Country] PRIMARY KEY ([Id]))
info: FluentMigrator.Runner.MigrationRunner[1002]
      => 0.0053229s
info: FluentMigrator.Runner.MigrationRunner[1004]
      CreateTable Currency
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
      CREATE TABLE [dbo].[Currency] ([Id] INT NOT NULL IDENTITY(1,1), [Name] NVARCHAR(50) NOT NULL, [CurrencyCode] NVARCHAR(5) NOT NULL, [DisplayLocale] NVARCHAR(50), [CustomFormatting] NVARCHAR(50), [Rate] DECIMAL(18,4) NOT NULL, [LimitedToStores] BIT NOT NULL, [Published] BIT NOT NULL, [DisplayOrder] INT NOT NULL, [CreatedOnUtc] DATETIME2 NOT NULL, [UpdatedOnUtc] DATETIME2 NOT NULL, [RoundingTypeId] INT NOT NULL, CONSTRAINT [PK_Currency] PRIMARY KEY ([Id]))
info: FluentMigrator.Runner.MigrationRunner[1002]
      => 0.0642997s
info: FluentMigrator.Runner.MigrationRunner[1004]
      CreateTable MeasureDimension
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
      CREATE TABLE [dbo].[MeasureDimension] ([Id] INT NOT NULL IDENTITY(1,1), [Name] NVARCHAR(100) NOT NULL, [SystemKeyword] NVARCHAR(100) NOT NULL, [Ratio] DECIMAL(18,8) NOT NULL, [DisplayOrder] INT NOT NULL, CONSTRAINT [PK_MeasureDimension] PRIMARY KEY ([Id]))
info: FluentMigrator.Runner.MigrationRunner[1002]
      => 0.0089741s
info: FluentMigrator.Runner.MigrationRunner[1004]
      CreateTable MeasureWeight
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
      CREATE TABLE [dbo].[MeasureWeight] ([Id] INT NOT NULL IDENTITY(1,1), [Name] NVARCHAR(100) NOT NULL, [SystemKeyword] NVARCHAR(100) NOT NULL, [Ratio] DECIMAL(18,8) NOT NULL, [DisplayOrder] INT NOT NULL, CONSTRAINT [PK_MeasureWeight] PRIMARY KEY ([Id]))
info: FluentMigrator.Runner.MigrationRunner[1002]
      => 0.0063294s
info: FluentMigrator.Runner.MigrationRunner[1004]
      CreateTable StateProvince
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
      CREATE TABLE [dbo].[StateProvince] ([Id] INT NOT NULL IDENTITY(1,1), [Name] NVARCHAR(100) NOT NULL, [Abbreviation] NVARCHAR(100), [CountryId] INT NOT NULL, [Published] BIT NOT NULL, [DisplayOrder] INT NOT NULL, CONSTRAINT [PK_StateProvince] PRIMARY KEY ([Id]))
info: FluentMigrator.Runner.MigrationRunner[1002]
      => 0.0486086s
info: FluentMigrator.Runner.MigrationRunner[1004]
      CreateIndex StateProvince (CountryId)
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
      CREATE INDEX [IX_StateProvince_CountryId] ON [dbo].[StateProvince] ([CountryId] ASC)
info: FluentMigrator.Runner.MigrationRunner[1002]
      => 0.0044083s
info: FluentMigrator.Runner.MigrationRunner[1004]
      CreateForeignKey FK_StateProvince_CountryId_Country_Id StateProvince(CountryId) Country(Id)
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
      ALTER TABLE [dbo].[StateProvince] ADD CONSTRAINT [FK_StateProvince_CountryId_Country_Id] FOREIGN KEY ([CountryId]) REFERENCES [dbo].[Country] ([Id]) ON DELETE CASCADE
info: FluentMigrator.Runner.MigrationRunner[1002]
      => 0.0078678s
info: FluentMigrator.Runner.MigrationRunner[1004]
      CreateTable Address
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
      CREATE TABLE [dbo].[Address] ([Id] INT NOT NULL IDENTITY(1,1), [CountryId] INT, [StateProvinceId] INT, [FirstName] NVARCHAR(MAX), [LastName] NVARCHAR(MAX), [Email] NVARCHAR(MAX), [Company] NVARCHAR(MAX), [County] NVARCHAR(MAX), [City] NVARCHAR(MAX), [Address1] NVARCHAR(MAX), [Address2] NVARCHAR(MAX), [ZipPostalCode] NVARCHAR(MAX), [PhoneNumber] NVARCHAR(MAX), [FaxNumber] NVARCHAR(MAX), [CustomAttributes] NVARCHAR(MAX), [CreatedOnUtc] DATETIME2 NOT NULL, CONSTRAINT [PK_Address] PRIMARY KEY ([Id]))
info: FluentMigrator.Runner.MigrationRunner[1002]
      => 0.029762s
info: FluentMigrator.Runner.MigrationRunner[1004]
      CreateIndex Address (CountryId)
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
      CREATE INDEX [IX_Address_CountryId] ON [dbo].[Address] ([CountryId] ASC)
info: FluentMigrator.Runner.MigrationRunner[1002]
      => 0.0041979s
info: FluentMigrator.Runner.MigrationRunner[1004]
      CreateForeignKey FK_Address_CountryId_Country_Id Address(CountryId) Country(Id)
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
      ALTER TABLE [dbo].[Address] ADD CONSTRAINT [FK_Address_CountryId_Country_Id] FOREIGN KEY ([CountryId]) REFERENCES [dbo].[Country] ([Id])
info: FluentMigrator.Runner.MigrationRunner[1002]
      => 0.0129641s
info: FluentMigrator.Runner.MigrationRunner[1004]
      CreateIndex Address (StateProvinceId)
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
      CREATE INDEX [IX_Address_StateProvinceId] ON [dbo].[Address] ([StateProvinceId] ASC)
info: FluentMigrator.Runner.MigrationRunner[1002]
      => 0.0064071s
info: FluentMigrator.Runner.MigrationRunner[1004]
      CreateForeignKey FK_Address_StateProvinceId_StateProvince_Id Address(StateProvinceId) StateProvince(Id)
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
      ALTER TABLE [dbo].[Address] ADD CONSTRAINT [FK_Address_StateProvinceId_StateProvince_Id] FOREIGN KEY ([StateProvinceId]) REFERENCES [dbo].[StateProvince] ([Id])
info: FluentMigrator.Runner.MigrationRunner[1002]
      => 0.0400001s
info: FluentMigrator.Runner.MigrationRunner[1004]
      CreateTable Affiliate
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
      CREATE TABLE [dbo].[Affiliate] ([Id] INT NOT NULL IDENTITY(1,1), [AddressId] INT NOT NULL, [AdminComment] NVARCHAR(MAX), [FriendlyUrlName] NVARCHAR(MAX), [Deleted] BIT NOT NULL, [Active] BIT NOT NULL, CONSTRAINT [PK_Affiliate] PRIMARY KEY ([Id]))
info: FluentMigrator.Runner.MigrationRunner[1002]
      => 0.0059777s
info: FluentMigrator.Runner.MigrationRunner[1004]
      CreateIndex Affiliate (AddressId)
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
      CREATE INDEX [IX_Affiliate_AddressId] ON [dbo].[Affiliate] ([AddressId] ASC)
info: FluentMigrator.Runner.MigrationRunner[1002]
      => 0.0034459s
info: FluentMigrator.Runner.MigrationRunner[1004]
      CreateForeignKey FK_Affiliate_AddressId_Address_Id Affiliate(AddressId) Address(Id)
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
      ALTER TABLE [dbo].[Affiliate] ADD CONSTRAINT [FK_Affiliate_AddressId_Address_Id] FOREIGN KEY ([AddressId]) REFERENCES [dbo].[Address] ([Id])
info: FluentMigrator.Runner.MigrationRunner[1002]
      => 0.0045543s
info: FluentMigrator.Runner.MigrationRunner[1004]
      CreateTable CustomerAttribute
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
      CREATE TABLE [dbo].[CustomerAttribute] ([Id] INT NOT NULL IDENTITY(1,1), [Name] NVARCHAR(400) NOT NULL, [IsRequired] BIT NOT NULL, [AttributeControlTypeId] INT NOT NULL, [DisplayOrder] INT NOT NULL, CONSTRAINT [PK_CustomerAttribute] PRIMARY KEY ([Id]))
info: FluentMigrator.Runner.MigrationRunner[1002]
      => 0.0059702s
info: FluentMigrator.Runner.MigrationRunner[1004]
      CreateTable CustomerAttributeValue
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
      CREATE TABLE [dbo].[CustomerAttributeValue] ([Id] INT NOT NULL IDENTITY(1,1), [Name] NVARCHAR(400) NOT NULL, [CustomerAttributeId] INT NOT NULL, [IsPreSelected] BIT NOT NULL, [DisplayOrder] INT NOT NULL, CONSTRAINT [PK_CustomerAttributeValue] PRIMARY KEY ([Id]))
info: FluentMigrator.Runner.MigrationRunner[1002]
      => 0.0074384s
info: FluentMigrator.Runner.MigrationRunner[1004]
      CreateIndex CustomerAttributeValue (CustomerAttributeId)
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
      CREATE INDEX [IX_CustomerAttributeValue_CustomerAttributeId] ON [dbo].[CustomerAttributeValue] ([CustomerAttributeId] ASC)
info: FluentMigrator.Runner.MigrationRunner[1002]
      => 0.0037492s
info: FluentMigrator.Runner.MigrationRunner[1004]
      CreateForeignKey FK_CustomerAttributeValue_CustomerAttributeId_CustomerAttribute_Id CustomerAttributeValue(CustomerAttributeId) CustomerAttribute(Id)
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
      ALTER TABLE [dbo].[CustomerAttributeValue] ADD CONSTRAINT [FK_CustomerAttributeValue_CustomerAttributeId_CustomerAttribute_Id] FOREIGN KEY ([CustomerAttributeId]) REFERENCES [dbo].[CustomerAttribute] ([Id]) ON DELETE CASCADE
info: FluentMigrator.Runner.MigrationRunner[1002]
      => 0.0035366s
info: FluentMigrator.Runner.MigrationRunner[1004]
      CreateTable Customer
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
      CREATE TABLE [dbo].[Customer] ([Id] INT NOT NULL IDENTITY(1,1), [Username] NVARCHAR(1000), [Email] NVARCHAR(1000), [EmailToRevalidate] NVARCHAR(1000), [SystemName] NVARCHAR(400), [BillingAddress_Id] INT, [ShippingAddress_Id] INT, [CustomerGuid] UNIQUEIDENTIFIER NOT NULL, [AdminComment] NVARCHAR(MAX), [IsTaxExempt] BIT NOT NULL, [AffiliateId] INT NOT NULL, [VendorId] INT NOT NULL, [HasShoppingCartItems] BIT NOT NULL, [RequireReLogin] BIT NOT NULL, [FailedLoginAttempts] INT NOT NULL, [CannotLoginUntilDateUtc] DATETIME2, [Active] BIT NOT NULL, [Deleted] BIT NOT NULL, [IsSystemAccount] BIT NOT NULL, [LastIpAddress] NVARCHAR(MAX), [CreatedOnUtc] DATETIME2 NOT NULL, [LastLoginDateUtc] DATETIME2, [LastActivityDateUtc] DATETIME2 NOT NULL, [RegisteredInStoreId] INT NOT NULL, CONSTRAINT [PK_Customer] PRIMARY KEY ([Id]))
info: FluentMigrator.Runner.MigrationRunner[1002]
      => 0.0336156s
info: FluentMigrator.Runner.MigrationRunner[1004]
      CreateIndex Customer (BillingAddress_Id)
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
      CREATE INDEX [IX_Customer_BillingAddress_Id] ON [dbo].[Customer] ([BillingAddress_Id] ASC)
info: FluentMigrator.Runner.MigrationRunner[1002]
      => 0.0029461s
info: FluentMigrator.Runner.MigrationRunner[1004]
      CreateForeignKey FK_Customer_BillingAddress_Id_Address_Id Customer(BillingAddress_Id) Address(Id)
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
      ALTER TABLE [dbo].[Customer] ADD CONSTRAINT [FK_Customer_BillingAddress_Id_Address_Id] FOREIGN KEY ([BillingAddress_Id]) REFERENCES [dbo].[Address] ([Id])
info: FluentMigrator.Runner.MigrationRunner[1002]
      => 0.0035411s
info: FluentMigrator.Runner.MigrationRunner[1004]
      CreateIndex Customer (ShippingAddress_Id)
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
      CREATE INDEX [IX_Customer_ShippingAddress_Id] ON [dbo].[Customer] ([ShippingAddress_Id] ASC)
info: FluentMigrator.Runner.MigrationRunner[1002]
      => 0.0035285s
info: FluentMigrator.Runner.MigrationRunner[1004]
      CreateForeignKey FK_Customer_ShippingAddress_Id_Address_Id Customer(ShippingAddress_Id) Address(Id)
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
      ALTER TABLE [dbo].[Customer] ADD CONSTRAINT [FK_Customer_ShippingAddress_Id_Address_Id] FOREIGN KEY ([ShippingAddress_Id]) REFERENCES [dbo].[Address] ([Id])
info: FluentMigrator.Runner.MigrationRunner[1002]
      => 0.0037254s
info: FluentMigrator.Runner.MigrationRunner[1004]
      CreateTable CustomerPassword
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
      CREATE TABLE [dbo].[CustomerPassword] ([Id] INT NOT NULL IDENTITY(1,1), [CustomerId] INT NOT NULL, [Password] NVARCHAR(MAX), [PasswordFormatId] INT NOT NULL, [PasswordSalt] NVARCHAR(MAX), [CreatedOnUtc] DATETIME2 NOT NULL, CONSTRAINT [PK_CustomerPassword] PRIMARY KEY ([Id]))
info: FluentMigrator.Runner.MigrationRunner[1002]
      => 0.0064295s
info: FluentMigrator.Runner.MigrationRunner[1004]
      CreateIndex CustomerPassword (CustomerId)
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
      CREATE INDEX [IX_CustomerPassword_CustomerId] ON [dbo].[CustomerPassword] ([CustomerId] ASC)
info: FluentMigrator.Runner.MigrationRunner[1002]
      => 0.0059385s
info: FluentMigrator.Runner.MigrationRunner[1004]
      CreateForeignKey FK_CustomerPassword_CustomerId_Customer_Id CustomerPassword(CustomerId) Customer(Id)
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
      ALTER TABLE [dbo].[CustomerPassword] ADD CONSTRAINT [FK_CustomerPassword_CustomerId_Customer_Id] FOREIGN KEY ([CustomerId]) REFERENCES [dbo].[Customer] ([Id]) ON DELETE CASCADE
info: FluentMigrator.Runner.MigrationRunner[1002]
      => 0.0038752s
info: FluentMigrator.Runner.MigrationRunner[1004]
      CreateTable CustomerAddresses
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
      CREATE TABLE [dbo].[CustomerAddresses] ([Address_Id] INT NOT NULL, [Customer_Id] INT NOT NULL, CONSTRAINT [PK_CustomerAddresses] PRIMARY KEY ([Address_Id], [Customer_Id]))
info: FluentMigrator.Runner.MigrationRunner[1002]
      => 0.0082661s
info: FluentMigrator.Runner.MigrationRunner[1004]
      CreateIndex CustomerAddresses (Address_Id)
info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
      CREATE INDEX [IX_CustomerAddresses_Address_Id] ON [dbo].[CustomerAddresses] ([Address_Id] ASC)
info: FluentMigrator.Runner.MigrationRunner[1002]
      => 0.0039714s
info: FluentMigrator.Runner.MigrationRunner[1004]
      CreateForeignKey FK_CustomerAddresses_Address_Id_Address_Id CustomerAddresses(Address_Id) Address(
один год назад
Here is the local DB log record:
2022-05-25 11:15:33.08 spid51      Starting up database 'Nopcommerce'.
2022-05-25 11:15:33.25 spid51      Setting database option DISABLE_BROKER to ON for database 'Nopcommerce'.
2022-05-25 11:15:33.25 spid51      Setting database option ANSI_NULLS to ON for database 'Nopcommerce'.
2022-05-25 11:15:33.25 spid51      Setting database option ANSI_PADDING to ON for database 'Nopcommerce'.
2022-05-25 11:15:33.25 spid51      Setting database option ANSI_WARNINGS to ON for database 'Nopcommerce'.
2022-05-25 11:15:33.25 spid51      Setting database option ARITHABORT to ON for database 'Nopcommerce'.
2022-05-25 11:15:33.25 spid51      Setting database option CONCAT_NULL_YIELDS_NULL to ON for database 'Nopcommerce'.
2022-05-25 11:15:33.25 spid51      Setting database option NUMERIC_ROUNDABORT to OFF for database 'Nopcommerce'.
2022-05-25 11:15:33.25 spid51      Setting database option QUOTED_IDENTIFIER to ON for database 'Nopcommerce'.
2022-05-25 11:15:33.25 spid51      Setting database option ANSI_NULL_DEFAULT to ON for database 'Nopcommerce'.
2022-05-25 11:15:33.25 spid51      Setting database option CURSOR_DEFAULT to LOCAL for database 'Nopcommerce'.
2022-05-25 11:15:33.26 spid51      Setting database option RECOVERY to FULL for database 'Nopcommerce'.
2022-05-25 11:15:33.26 spid51      Setting database option CURSOR_CLOSE_ON_COMMIT to OFF for database 'Nopcommerce'.
2022-05-25 11:15:33.26 spid51      Setting database option AUTO_CREATE_STATISTICS to ON for database 'Nopcommerce'.
2022-05-25 11:15:33.26 spid51      Setting database option AUTO_SHRINK to OFF for database 'Nopcommerce'.
2022-05-25 11:15:33.26 spid51      Setting database option AUTO_UPDATE_STATISTICS to ON for database 'Nopcommerce'.
2022-05-25 11:15:33.26 spid51      Setting database option RECURSIVE_TRIGGERS to OFF for database 'Nopcommerce'.
2022-05-25 11:15:33.26 spid51      Setting database option AUTO_CLOSE to OFF for database 'Nopcommerce'.
2022-05-25 11:15:33.26 spid51      Setting database option PAGE_VERIFY to CHECKSUM for database 'Nopcommerce'.

Here is the connection string:
Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=Nopcommerce;Integrated Security=True;Connect Timeout=60;Encrypt=False;TrustServerCertificate=True;ApplicationIntent=ReadWrite;MultiSubnetFailover=False

Initially, I had created an empty database. After the failed installation, the database has tables.
один год назад
So you use SSMS and can connect to the database using (localdb)\MSSQLLocalDB ?
Are you running the website in Visual Studio or IIS
What is the error in the Log ?
один год назад
ccdmfc wrote:
Here is the local DB log record:
2022-05-25 11:15:33.08 spid51      Starting up database 'Nopcommerce'.
2022-05-25 11:15:33.25 spid51      Setting database option DISABLE_BROKER to ON for database 'Nopcommerce'.
2022-05-25 11:15:33.25 spid51      Setting database option ANSI_NULLS to ON for database 'Nopcommerce'.
2022-05-25 11:15:33.25 spid51      Setting database option ANSI_PADDING to ON for database 'Nopcommerce'.
2022-05-25 11:15:33.25 spid51      Setting database option ANSI_WARNINGS to ON for database 'Nopcommerce'.
2022-05-25 11:15:33.25 spid51      Setting database option ARITHABORT to ON for database 'Nopcommerce'.
2022-05-25 11:15:33.25 spid51      Setting database option CONCAT_NULL_YIELDS_NULL to ON for database 'Nopcommerce'.
2022-05-25 11:15:33.25 spid51      Setting database option NUMERIC_ROUNDABORT to OFF for database 'Nopcommerce'.
2022-05-25 11:15:33.25 spid51      Setting database option QUOTED_IDENTIFIER to ON for database 'Nopcommerce'.
2022-05-25 11:15:33.25 spid51      Setting database option ANSI_NULL_DEFAULT to ON for database 'Nopcommerce'.
2022-05-25 11:15:33.25 spid51      Setting database option CURSOR_DEFAULT to LOCAL for database 'Nopcommerce'.
2022-05-25 11:15:33.26 spid51      Setting database option RECOVERY to FULL for database 'Nopcommerce'.
2022-05-25 11:15:33.26 spid51      Setting database option CURSOR_CLOSE_ON_COMMIT to OFF for database 'Nopcommerce'.
2022-05-25 11:15:33.26 spid51      Setting database option AUTO_CREATE_STATISTICS to ON for database 'Nopcommerce'.
2022-05-25 11:15:33.26 spid51      Setting database option AUTO_SHRINK to OFF for database 'Nopcommerce'.
2022-05-25 11:15:33.26 spid51      Setting database option AUTO_UPDATE_STATISTICS to ON for database 'Nopcommerce'.
2022-05-25 11:15:33.26 spid51      Setting database option RECURSIVE_TRIGGERS to OFF for database 'Nopcommerce'.
2022-05-25 11:15:33.26 spid51      Setting database option AUTO_CLOSE to OFF for database 'Nopcommerce'.
2022-05-25 11:15:33.26 spid51      Setting database option PAGE_VERIFY to CHECKSUM for database 'Nopcommerce'.

Here is the connection string:
Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=Nopcommerce;Integrated Security=True;Connect Timeout=60;Encrypt=False;TrustServerCertificate=True;ApplicationIntent=ReadWrite;MultiSubnetFailover=False

Initially, I had created an empty database. After the failed installation, the database has tables.


Try to change the 'Connect Timeout=60' to let's say 180 or remove it completely (even if its not related to the command (query, transaction) execution timeout its worth trying because it might be related to some commit/rollback timeout issue (if any)).
один год назад
Yidna wrote:
So you use SSMS and can connect to the database using (localdb)\MSSQLLocalDB ?
Are you running the website in Visual Studio or IIS
What is the error in the Log ?


I am running from VS 2022 on the local machine. The error I get on the Nopcommerce start-up site is "Setup failed: Execution Timeout Expired. ..."

In the LocalDB log and the asp.net logs which I have copied in my previous messages, I cannot see any error.
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.