Categories Error

Kindly share the link to your site

Its not live yet! Currently is deployed on a testing sever. So unfortunately there is no way to provide you access to it :(

Alright

nopcommerce 4.2
after insert abou2 53 category and some of them parent category
category page got this error
We're sorry, an internal error occurred.

Our supporting staff has been notified of this error and will address the issue shortly.

and log is
The number of rows provided for a FETCH clause must be greater then zero.
Full message
System.Data.SqlClient.SqlException (0x80131904): The number of rows provided for a FETCH clause must be greater then zero.
   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.SqlDataReader.TryHasMoreRows(Boolean& moreRows)
   at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
   at System.Data.SqlClient.SqlDataReader.Read()
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.Enumerator.BufferlessMoveNext(DbContext _, Boolean buffer)
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.Enumerator.MoveNext()
   at Microsoft.EntityFrameworkCore.Query.Internal.LinqOperatorProvider._TrackEntities[TOut,TIn](IEnumerable`1 results, QueryContext queryContext, IList`1 entityTrackingInfos, IList`1 entityAccessors)+MoveNext()
   at Microsoft.EntityFrameworkCore.Query.Internal.LinqOperatorProvider.ExceptionInterceptor`1.EnumeratorExceptionInterceptor.MoveNext()
   at System.Collections.Generic.List`1.AddEnumerable(IEnumerable`1 enumerable)
   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
   at Nop.Services.Vendors.VendorService.GetAllVendors(String name, Int32 pageIndex, Int32 pageSize, Boolean showHidden)
   at Nop.Web.Factories.CatalogModelFactory.<PrepareVendorNavigationModel>b__50_0() in C:\andrei\nopcommerce\sources\src\Presentation\Nop.Web\Factories\CatalogModelFactory.cs:line 1101
   at EasyCaching.InMemory.DefaultInMemoryCachingProvider.BaseGet[T](String cacheKey, Func`1 dataRetriever, TimeSpan expiration)
   at EasyCaching.Core.EasyCachingAbstractProvider.Get[T](String cacheKey, Func`1 dataRetriever, TimeSpan expiration)
   at Nop.Core.Caching.MemoryCacheManager.Get[T](String key, Func`1 acquire, Nullable`1 cacheTime) in C:\andrei\nopcommerce\sources\src\Libraries\Nop.Core\Caching\MemoryCacheManager.cs:line 42
   at Nop.Web.Factories.CatalogModelFactory.PrepareVendorNavigationModel() in C:\andrei\nopcommerce\sources\src\Presentation\Nop.Web\Factories\CatalogModelFactory.cs:line 1119
   at Nop.Web.Components.VendorNavigationViewComponent.Invoke() in C:\andrei\nopcommerce\sources\src\Presentation\Nop.Web\Components\VendorNavigation.cs:line 26
   at lambda_method(Closure , Object , Object[] )