Upgrade from 4.1 to 4.2 problem

5 months ago
Hi,

we upgraded from 4.1 to 4.2 following the instructions and site is up and running with all the products visible in the public store but no products in the admin area.
Also missing is all customers and orders in the admin area.

Note: on the Dashboard number of orders and customers is correct as in database but we can not see any of them through the admin interface.

Anybody had this problem? What do you suggest we try to do? Thank you!
5 months ago
Hello,

You are probably getting some error in the grid both in the products and order administration. You will most likely be able to see the error details in the system log (Administration -> System -> Log). Please share that with us for any further help.

Also, try to clear your browser cache and see if that makes a difference.

Hope that helps!

Regards,
Anton
5 months ago
We managed to get it working on one computer after clearing the cache but on the other it is still not working, I can not access the log either.
5 months ago
Hello

Please try to view sites in private/incognito window.
If you are not able to view the logs on admin may be if you have access change the logs at database level.
OR you can enable stdout logs in web.config and try to check logs in stdout folder of your website.

i think you will get some clue about issue.

if its working on one system then it should work on other system. Its looking strange.
5 months ago
I enabled log and here is a log file

************************************************************

info: Microsoft.EntityFrameworkCore.Infrastructure[10403]
      Entity Framework Core 2.2.4-servicing-10062 initialized 'NopObjectContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: MaxPoolSize=128 using lazy-loading proxies
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (56ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
      SELECT [t].[Id], [t].[Enabled], [t].[LastEndUtc], [t].[LastStartUtc], [t].[LastSuccessUtc], [t].[Name], [t].[Seconds], [t].[StopOnError], [t].[Type]
      FROM [ScheduleTask] AS [t]
      WHERE [t].[Enabled] = 1
      ORDER BY [t].[Seconds] DESC
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (4ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
      SELECT [s].[Id], [s].[CompanyAddress], [s].[CompanyName], [s].[CompanyPhoneNumber], [s].[CompanyVat], [s].[DefaultLanguageId], [s].[DisplayOrder], [s].[Hosts], [s].[Name], [s].[SslEnabled], [s].[Url]
      FROM [Store] AS [s]
      ORDER BY [s].[DisplayOrder], [s].[Id]
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (66ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
      SELECT [s].[Id], [s].[Name], [s].[StoreId], [s].[Value]
      FROM [Setting] AS [s]
      ORDER BY [s].[Name], [s].[StoreId]
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (77ms) [Parameters=[@p0='?' (DbType = DateTime2), @p1='?' (DbType = Int32), @p2='?' (Size = 4000), @p3='?' (Size = 200), @p4='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Size = 4000), @p7='?' (Size = 4000)], CommandType='Text', CommandTimeout='30']
      SET NOCOUNT ON;
      INSERT INTO [Log] ([CreatedOnUtc], [CustomerId], [FullMessage], [IpAddress], [LogLevelId], [PageUrl], [ReferrerUrl], [ShortMessage])
      VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7);
      SELECT [Id]
      FROM [Log]
      WHERE @@ROWCOUNT = 1 AND [Id] = scope_identity();
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
      SELECT [l].[Id], [l].[DefaultCurrencyId], [l].[DisplayOrder], [l].[FlagImageFileName], [l].[LanguageCulture], [l].[LimitedToStores], [l].[Name], [l].[Published], [l].[Rtl], [l].[UniqueSeoCode]
      FROM [Language] AS [l]
      WHERE [l].[Published] = 1
      ORDER BY [l].[DisplayOrder], [l].[Id]
Hosting environment: Production
Content root path: C:\Inetpub\vhosts\kinetafitness.com\httpdocs
Now listening on: http://127.0.0.1:7165
Application started. Press Ctrl+C to shut down.
info: Microsoft.AspNetCore.Hosting.Internal.WebHost[1]
      Request starting HTTP/1.1 GET http://kinetafitness.com/Admin/Order/List  
warn: Microsoft.AspNetCore.Localization.RequestLocalizationMiddleware[1]
      AcceptLanguageHeaderRequestCultureProvider returned the following unsupported cultures 'en-US, en, bs'.
info: Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker[3]
      Route matched with {area = "Admin", action = "List", controller = "Order"}. Executing controller action with signature Microsoft.AspNetCore.Mvc.IActionResult List(System.Collections.Generic.List`1[System.Int32], System.Collections.Generic.List`1[System.Int32], System.Collections.Generic.List`1[System.Int32]) on controller Nop.Web.Areas.Admin.Controllers.OrderController (Nop.Web).
info: Microsoft.EntityFrameworkCore.Infrastructure[10403]
      Entity Framework Core 2.2.4-servicing-10062 initialized 'NopObjectContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: MaxPoolSize=128 using lazy-loading proxies
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (2ms) [Parameters=[@__email_0='?' (Size = 1000)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [c].[Id], [c].[Active], [c].[AdminComment], [c].[AffiliateId], [c].[BillingAddress_Id], [c].[CannotLoginUntilDateUtc], [c].[CreatedOnUtc], [c].[CustomerGuid], [c].[Deleted], [c].[Email], [c].[EmailToRevalidate], [c].[FailedLoginAttempts], [c].[HasShoppingCartItems], [c].[IsSystemAccount], [c].[IsTaxExempt], [c].[LastActivityDateUtc], [c].[LastIpAddress], [c].[LastLoginDateUtc], [c].[RegisteredInStoreId], [c].[RequireReLogin], [c].[ShippingAddress_Id], [c].[SystemName], [c].[Username], [c].[VendorId]
      FROM [Customer] AS [c]
      WHERE [c].[Email] = @__email_0
      ORDER BY [c].[Id]
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__get_Item_0='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT [e].[Customer_Id], [e].[CustomerRole_Id]
      FROM [Customer_CustomerRole_Mapping] AS [e]
      WHERE [e].[Customer_Id] = @__get_Item_0
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__get_Item_0='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT [e].[Id], [e].[Active], [e].[DefaultTaxDisplayTypeId], [e].[EnablePasswordLifetime], [e].[FreeShipping], [e].[IsSystemRole], [e].[Name], [e].[OverrideTaxDisplayType], [e].[PurchasedWithProductId], [e].[SystemName], [e].[TaxExempt]
      FROM [CustomerRole] AS [e]
      WHERE [e].[Id] = @__get_Item_0
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__get_Item_0='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT [e].[Id], [e].[Active], [e].[DefaultTaxDisplayTypeId], [e].[EnablePasswordLifetime], [e].[FreeShipping], [e].[IsSystemRole], [e].[Name], [e].[OverrideTaxDisplayType], [e].[PurchasedWithProductId], [e].[SystemName], [e].[TaxExempt]
      FROM [CustomerRole] AS [e]
      WHERE [e].[Id] = @__get_Item_0
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (77ms) [Parameters=[@__entityId_0='?' (DbType = Int32), @__keyGroup_1='?' (Size = 400)], CommandType='Text', CommandTimeout='30']
      SELECT [ga].[Id], [ga].[EntityId], [ga].[Key], [ga].[KeyGroup], [ga].[StoreId], [ga].[Value]
      FROM [GenericAttribute] AS [ga]
      WHERE ([ga].[EntityId] = @__entityId_0) AND ([ga].[KeyGroup] = @__keyGroup_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (81ms) [Parameters=[@__customerRoleId_0='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT [pr].[Id], [pr].[Category], [pr].[Name], [pr].[SystemName]
      FROM [PermissionRecord] AS [pr]
      INNER JOIN [PermissionRecord_Role_Mapping] AS [prcrm] ON [pr].[Id] = [prcrm].[PermissionRecord_Id]
      WHERE [prcrm].[CustomerRole_Id] = @__customerRoleId_0
      ORDER BY [pr].[Id]
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@p23='?' (DbType = Int32), @p0='?' (DbType = Boolean), @p1='?' (Size = 4000), @p2='?' (DbType = Int32), @p3='?' (DbType = Int32), @p4='?' (DbType = DateTime2), @p5='?' (DbType = DateTime2), @p6='?' (DbType = Guid), @p7='?' (DbType = Boolean), @p8='?' (Size = 1000), @p9='?' (Size = 1000), @p10='?' (DbType = Int32), @p11='?' (DbType = Boolean), @p12='?' (DbType = Boolean), @p13='?' (DbType = Boolean), @p14='?' (DbType = DateTime2), @p15='?' (Size = 4000), @p16='?' (DbType = DateTime2), @p17='?' (DbType = Int32), @p18='?' (DbType = Boolean), @p19='?' (DbType = Int32), @p20='?' (Size = 400), @p21='?' (Size = 1000), @p22='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SET NOCOUNT ON;
      UPDATE [Customer] SET [Active] = @p0, [AdminComment] = @p1, [AffiliateId] = @p2, [BillingAddress_Id] = @p3, [CannotLoginUntilDateUtc] = @p4, [CreatedOnUtc] = @p5, [CustomerGuid] = @p6, [Deleted] = @p7, [Email] = @p8, [EmailToRevalidate] = @p9, [FailedLoginAttempts] = @p10, [HasShoppingCartItems] = @p11, [IsSystemAccount] = @p12, [IsTaxExempt] = @p13, [LastActivityDateUtc] = @p14, [LastIpAddress] = @p15, [LastLoginDateUtc] = @p16, [RegisteredInStoreId] = @p17, [RequireReLogin] = @p18, [ShippingAddress_Id] = @p19, [SystemName] = @p20, [Username] = @p21, [VendorId] = @p22
      WHERE [Id] = @p23;
      SELECT @@ROWCOUNT;
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@p5='?' (DbType = Int32), @p0='?' (DbType = Int32), @p1='?' (Size = 400), @p2='?' (Size = 400), @p3='?' (DbType = Int32), @p4='?' (Size = 4000)], CommandType='Text', CommandTimeout='30']
      SET NOCOUNT ON;
      UPDATE [GenericAttribute] SET [EntityId] = @p0, [Key] = @p1, [KeyGroup] = @p2, [StoreId] = @p3, [Value] = @p4
      WHERE [Id] = @p5;
      SELECT @@ROWCOUNT;
info: Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker[1]
      Executing action method Nop.Web.Areas.Admin.Controllers.OrderController.List (Nop.Web) - Validation state: Valid
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (14ms) [Parameters=[@__entityId_0='?' (DbType = Int32), @__keyGroup_1='?' (Size = 400)], CommandType='Text', CommandTimeout='30']
      SELECT [ga].[Id], [ga].[EntityId], [ga].[Key], [ga].[KeyGroup], [ga].[StoreId], [ga].[Value]
      FROM [GenericAttribute] AS [ga]
      WHERE ([ga].[EntityId] = @__entityId_0) AND ([ga].[KeyGroup] = @__keyGroup_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (0ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (4ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (0ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
      SELECT COUNT(*)
      FROM [Vendor] AS [v]
      WHERE [v].[Deleted] = 0
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__p_0='?' (DbType = Int32), @__p_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT [v].[Id], [v].[Active], [v].[AddressId], [v].[AdminComment], [v].[AllowCustomersToSelectPageSize], [v].[Deleted], [v].[Description], [v].[DisplayOrder], [v].[Email], [v].[MetaDescription], [v].[MetaKeywords], [v].[MetaTitle], [v].[Name], [v].[PageSize], [v].[PageSizeOptions], [v].[PictureId]
      FROM [Vendor] AS [v]
      WHERE [v].[Deleted] = 0
      ORDER BY [v].[DisplayOrder], [v].[Name]
      OFFSET @__p_0 ROWS FETCH NEXT @__p_1 ROWS ONLY
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
      SELECT [wh].[Id], [wh].[AddressId], [wh].[AdminComment], [wh].[Name]
      FROM [Warehouse] AS [wh]
      ORDER BY [wh].[Name]
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (105ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
      SELECT [c].[Id], [c].[AllowsBilling], [c].[AllowsShipping], [c].[DisplayOrder], [c].[LimitedToStores], [c].[Name], [c].[NumericIsoCode], [c].[Published], [c].[SubjectToVat], [c].[ThreeLetterIsoCode], [c].[TwoLetterIsoCode]
      FROM [Country] AS [c]
      ORDER BY [c].[DisplayOrder], [c].[Name]
info: Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker[2]
      Executed action method Nop.Web.Areas.Admin.Controllers.OrderController.List (Nop.Web), returned result Microsoft.AspNetCore.Mvc.ViewResult in 488.9122ms.
info: Microsoft.AspNetCore.Mvc.ViewFeatures.ViewResultExecutor[1]
      Executing ViewResult, running view List.
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (0ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.
5 months ago
Hello,

If you managed to get it working on one of your machines, then it is the cache problem and not something in the nopCommerce application. Furthermore, the log file you've shared doesn't contain any errors that I can see.

Are there any javascript errors in your browser console of the other machines that still have this issue?

Regards,
Anton
4 months ago
Hello,

I am getting same issue. Site public store is load data, when I am trying to login in admin then I am getting same error.

info: Microsoft.AspNetCore.Server.Kestrel[27]
      Connection id "0HLOAOOGAEROQ", Request id "0HLOAOOGAEROQ:00000001": the request timed out because it was not sent by the client at a minimum of 240 bytes/second.
info: Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker[2]
      Executed action Nop.Web.Controllers.CustomerController.Login (Nop.Web) in 5593.4957ms
fail: Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddleware[1]
      An unhandled exception has occurred while executing the request.
Microsoft.AspNetCore.Server.Kestrel.Core.BadHttpRequestException: Reading the request body timed out due to data arriving too slowly. See MinRequestBodyDataRate.
   at Microsoft.AspNetCore.Server.Kestrel.Core.BadHttpRequestException.Throw(RequestRejectionReason reason)
   at Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.Http1MessageBody.PumpAsync()
   at System.IO.Pipelines.PipeCompletion.ThrowLatchedException()
   at System.IO.Pipelines.Pipe.GetReadResult(ReadResult& result)
   at System.IO.Pipelines.Pipe.GetReadAsyncResult()
   at Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.MessageBody.ReadAsync(Memory`1 buffer, CancellationToken cancellationToken)
   at Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestStream.ReadAsyncInternal(Memory`1 buffer, CancellationToken cancellationToken)
   at System.IO.StreamReader.ReadBufferAsync()
   at System.IO.StreamReader.ReadAsyncInternal(Memory`1 buffer, CancellationToken cancellationToken)
   at Microsoft.AspNetCore.WebUtilities.FormReader.BufferAsync(CancellationToken cancellationToken)
   at Microsoft.AspNetCore.WebUtilities.FormReader.ReadNextPairAsyncImpl(CancellationToken cancellationToken)
   at Microsoft.AspNetCore.WebUtilities.FormReader.ReadFormAsync(CancellationToken cancellationToken)
   at Microsoft.AspNetCore.Http.Features.FormFeature.InnerReadFormAsync(CancellationToken cancellationToken)
   at Microsoft.AspNetCore.Antiforgery.Internal.DefaultAntiforgeryTokenStore.GetRequestTokensAsync(HttpContext httpContext)
   at Microsoft.AspNetCore.Antiforgery.Internal.DefaultAntiforgery.ValidateRequestAsync(HttpContext httpContext)
   at Microsoft.AspNetCore.Mvc.ViewFeatures.Internal.ValidateAntiforgeryTokenAuthorizationFilter.OnAuthorizationAsync(AuthorizationFilterContext context)
   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeFilterPipelineAsync()
   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeAsync()
   at Microsoft.AspNetCore.Builder.RouterMiddleware.Invoke(HttpContext httpContext)
   at WebMarkupMin.AspNetCore2.WebMarkupMinMiddleware.Invoke(HttpContext context)
   at StackExchange.Profiling.MiniProfilerMiddleware.Invoke(HttpContext context) in C:\projects\dotnet\src\MiniProfiler.AspNetCore\MiniProfilerMiddleware.cs:line 94
   at Nop.Services.Authentication.AuthenticationMiddleware.Invoke(HttpContext context)
   at Microsoft.AspNetCore.Localization.RequestLocalizationMiddleware.Invoke(HttpContext context)
   at Microsoft.AspNetCore.Session.SessionMiddleware.Invoke(HttpContext context)
   at Microsoft.AspNetCore.Session.SessionMiddleware.Invoke(HttpContext context)
   at Nop.Services.Installation.InstallUrlMiddleware.Invoke(HttpContext context, IWebHelper webHelper)
   at Nop.Services.Common.KeepAliveMiddleware.Invoke(HttpContext context, IWebHelper webHelper)
   at Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware.Invoke(HttpContext context)
   at Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware.Invoke(HttpContext context)
   at Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware.Invoke(HttpContext context)
   at Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware.Invoke(HttpContext context)
   at Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware.Invoke(HttpContext context)
   at Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware.Invoke(HttpContext context)
   at Microsoft.AspNetCore.ResponseCompression.ResponseCompressionMiddleware.Invoke(HttpContext context)
   at Microsoft.AspNetCore.Diagnostics.StatusCodePagesMiddleware.Invoke(HttpContext context)
   at Microsoft.AspNetCore.Diagnostics.StatusCodePagesMiddleware.Invoke(HttpContext context)
   at Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddleware.Invoke(HttpContext context)


Thanks