-464.jpg)
Error executing template "Designs/DLF/eCom/ProductCatalog/seeds_ListSlider.cshtml" System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> 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.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.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at Dynamicweb.Data.Database.CreateDataReader(IDbCommand command, CommandBehavior behavior) at Dynamicweb.Data.Database.CreateDataReader(CommandBuilder commandBuilder, IDbConnection connection, IDbTransaction transaction, CommandBehavior behavior, Int32 commandTimeout) at Dynamicweb.Data.Database.CreateDataReader(CommandBuilder commandBuilder, IDbConnection connection, IDbTransaction transaction, Int32 commandTimeout) at Dynamicweb.Ecommerce.Variants.VariantCombinationRepository.GetAll() at Dynamicweb.Ecommerce.Variants.VariantCombinationService.InitializeVariantCombinations() at System.Lazy`1.CreateValue() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Lazy`1.get_Value() at Dynamicweb.Ecommerce.Variants.VariantCombinationService.GetVariantCombinations(String productId) at Dynamicweb.Ecommerce.Products.ProductService.IsVariantMaster(Product product) at DLF.MyDLF.Webshop.Web.CustomCode.Products.ProductVariantService.<>c__DisplayClass4_0.b__1(Product s) at System.Linq.Enumerable.WhereListIterator`1.MoveNext() at System.Linq.Buffer`1..ctor(IEnumerable`1 source) at System.Linq.OrderedEnumerable`1. d__1.MoveNext() at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source) at DLF.MyDLF.Webshop.Web.CustomCode.Products.ProductVariantService.<>c__DisplayClass5_0. b__0() at NORRIQ.Common8.Caching.CacheItemContainer.BuildItem[T](Func`1 buildmethod, Type dependencyType) at NORRIQ.Common8.Caching.HttpCache.GetOrInsert[T](String cacheKey, Func`1 buildCacheDependency, Func`1 buildNewItem) at NORRIQ.Common8.Caching.HttpCache`1.GetOrInsert[T](String cacheKey, Func`1 buildNewItem) at DLF.MyDLF.Webshop.Web.CustomCode.Products.ProductVariantService.GetMostExpensiveActiveVariant(String productId, String languageId) at CompiledRazorTemplates.Dynamic.RazorEngine_9922cef1518b4b0c9a13469a4986e51c.Execute() in C:\inetpub\solutions\DLF.MyDLF.Webshop\Live\Files\Templates\Designs\DLF\eCom\ProductCatalog\seeds_ListSlider.cshtml:line 34 at RazorEngine.Templating.TemplateBase.RazorEngine.Templating.ITemplate.Run(ExecuteContext context, TextWriter reader) at RazorEngine.Templating.RazorEngineService.RunCompile(ITemplateKey key, TextWriter writer, Type modelType, Object model, DynamicViewBag viewBag) at RazorEngine.Templating.RazorEngineServiceExtensions.<>c__DisplayClass16_0. b__0(TextWriter writer) at RazorEngine.Templating.RazorEngineServiceExtensions.WithWriter(Action`1 withWriter) at Dynamicweb.Rendering.Template.RenderRazorTemplate() ClientConnectionId:9447e1d8-9d1f-42c9-b81c-124e5d7d1d6a Error Number:-2,State:0,Class:11 ClientConnectionId before routing:940936b2-32e0-4b3a-8425-578c2e958966 Routing Destination:f4a89a657752.tr30954.westeurope1-a.worker.database.windows.net,11040
1 @using Dynamicweb.Ecommerce 2 @using Dynamicweb.Rendering 3 @using Dynamicweb.Ecommerce.ProductCatalog 4 @using NORRIQ.Common8.Ecom 5 @using Dynamicweb.Ecommerce.Products 6 @using Dynamicweb.Environment 7 @using NLWI.Core.Factory 8 @using DLF.MyDLF.Webshop.Web.CustomCode.AsyncProductList.Models 9 @using DLF.MyDLF.Webshop.Web.CustomCode.Products 10 @using Dynamicweb.Frontend 11 @using ProductKey = NORRIQ.Common8.Ecom.ProductKey; 12 @inherits ViewModelTemplate<ProductListViewModel> 13 @{ 14 var productService = ObjectFactory.GetInstance<ProductVariantService>(); 15 } 16 17 @if (Model.Products.Any()) 18 { 19 <product-list-slider inline-template> 20 <section class="seeds_listslider"> 21 <header class="seeds_listslider-header"> 22 <h2> 23 @Pageview.CurrentParagraph.Header 24 </h2> 25 </header> 26 <slick ref="slick" 27 class="basic_listview-grid" 28 :options="slickOptionsPlpSlider"> 29 @foreach (var product in Model.Products) 30 { 31 var productKey = new ProductKey(product.Id, product.VariantId, product.LanguageId); 32 var image = NORRIQ.EcomMedia.Frontend.GetProductMedia(productKey); 33 var link = "/Default.aspx?ID=" + @NORRIQ.Common8.Razor.Navigation.GetPageIdByNavigationTag("plp") + "&ProductID=" + @product.Id; 34 var defaultVariant = productService.GetMostExpensiveActiveVariant(product.Id, product.LanguageId); 35 var price = defaultVariant != null ? defaultVariant.PriceWithoutVat : product.Price.PriceWithoutVat; 36 var defaultVariantId = defaultVariant != null ? defaultVariant.VariantId : string.Empty; 37 38 <div class="basic_listview-item"> 39 <article itemscope="itemscope" itemtype="https://schema.org/Product" class="basic_listview-product"> 40 <a href="@link" itemprop="url" class="basic_listview-link"> 41 <picture class="basic_listview-image"> 42 <source media="(max-width:767.98px)" srcset="/Admin/Public/GetImage.ashx?Width=360&Height=360&Compression=85&Crop=5&fillcanvas=true&Image=@image.GetFirstImage().Url" /> 43 <source media="(max-width:991.98px)" srcset="/Admin/Public/GetImage.ashx?Width=300&Height=300&Compression=85&Crop=5&fillcanvas=true&Image=@image.GetFirstImage().Url" /> 44 <img src="/Admin/Public/GetImage.ashx?Width=240&Height=240&Compression=85&Crop=5&fillcanvas=true&Image=@image.GetFirstImage().Url" alt="@product.Name" itemprop="image" class="img-fluid" /> 45 </picture> 46 <header class="basic_listview-specs"> 47 <h1 itemprop="name">@product.Name</h1> 48 <p itemprop="sku" data-caption="Product Number" class="basic_listview-sku">@product.Number</p> 49 </header> 50 </a> 51 <footer class="basic_listview-foot"> 52 53 <async-price class-type="basic_view-related--price" 54 default-price-without-vat="@price" 55 product-id="@product.Id" 56 variant-id="@defaultVariantId" 57 unit-of-measure="" 58 has-kg-base-unit="@product.HasKgBaseUnit()" 59 ></async-price> 60 </footer> 61 </article> 62 </div> 63 } 64 </slick> 65 </section> 66 </product-list-slider> 67 } 68