Exception in template (Designs\Hummel\QueryPublisher/PLPQ-Carousel.cshtml): System.Exception: Error Running ExecuteReader: Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding., Sql: "SELECT
	                    -- Object columns
	                    O.DefinitionKey
	                    ,O.LastModified AS OjectLastModified
	                    ,O.ObjectId
	                    ,O.XmlObjectId
	                    ,O.ShopId
	                    ,O.LanguageId

	                    -- Value columns
	                    ,V.LastModified AS ValueLastModified
	                    ,V.XmlReferenceObjectId
	                    ,V.XmlReferenceObjectKey
	                    ,V.ValueId
	                    ,V.[Text]
                        ,V.FieldKey
                        ,V.SortOrder

                    FROM [LWI_Spec_Objects] AS O
                    JOIN [LWI_Spec_Values] AS V ON
	                    V.ShopId = O.ShopId
	                    AND V.LanguageId = O.LanguageId
	                    AND V.XmlObjectKey = O.DefinitionKey
	                    AND V.XmlObjectId = O.XmlObjectId
                    WHERE
                        O.DefinitionKey IN ('Product')
                        AND O.XmlObjectId IN ('645341')
                        AND O.ShopId IN ('SHOP3')
                        AND O.LanguageId IN ('LANG2')
                    ORDER BY O.DefinitionKey, O.LanguageId, O.ShopId, O.XmlObjectId
                    ", Params: '' ---> System.Data.SqlClient.SqlException: Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception: The wait operation timed out
   --- End of inner exception stack trace ---
   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 NORRIQ.Universal.DbLogWrapper.LoggedDbCommand.ExecuteReader(CommandBehavior behavior)
   at NLWI.Platforms.Dynamicweb9.Database.ADatabaseRepository.ExecuteReader(String query, Object[] ps)
   --- End of inner exception stack trace ---
   at NLWI.Platforms.Dynamicweb9.Database.ADatabaseRepository.ExecuteReader(String query, Object[] ps)
   at NLWI.Platforms.Dynamicweb9.Specs.Repositories.SpecificationRepository.GetSpecificationObjects(HashSet`1 keys) in D:\VSO Agents\00TFS01-norriq-ip\_work\3\s\src\NLWI.Platforms.Dynamicweb9.Specs\Repositories\SpecificationRepository.cs:line 265
   at NLWI.Platforms.Dynamicweb9.Specs.Services.CachedSpecificationService.b__12_1(HashSet`1 k) in D:\VSO Agents\00TFS01-norriq-ip\_work\3\s\src\NLWI.Platforms.Dynamicweb9.Specs\Services\CachedSpecificationService.cs:line 91
   at NLWI.Core.Platform.Caching.DictionaryCaching.GetOrInsert[TKey,TVal](HashSet`1 keys, Func`2 buildCacheKey, Func`2 lookupMethod, CacheOptions cacheOptions) in D:\VSO Agents\00TFS01-norriq-ip\_work\3\s\src\NLWI.Core\Platform\Caching\DictionaryCaching.cs:line 102
   at NLWI.Platforms.Dynamicweb9.Specs.Services.CachedSpecificationService.GetSpecificationObjects(HashSet`1 specificationObjectIdentifiers) in D:\VSO Agents\00TFS01-norriq-ip\_work\3\s\src\NLWI.Platforms.Dynamicweb9.Specs\Services\CachedSpecificationService.cs:line 88
   at NLWI.Platforms.Dynamicweb9.Specs.Services.CachedProductSpecificationService.GetProductSpecifications(Dictionary`2 autoIdMappings) in D:\VSO Agents\00TFS01-norriq-ip\_work\3\s\src\NLWI.Platforms.Dynamicweb9.Specs\Services\CachedProductSpecificationService.cs:line 64
   at NLWI.Platforms.Dynamicweb9.Specs.Services.CachedProductSpecificationService.GetProductSpecifications(HashSet`1 productAutoIds) in D:\VSO Agents\00TFS01-norriq-ip\_work\3\s\src\NLWI.Platforms.Dynamicweb9.Specs\Services\CachedProductSpecificationService.cs:line 59
   at NLWI.Platforms.Dynamicweb9.Specs.Services.CachedProductSpecificationService.GetProductSpecifications(Int64 productAutoId) in D:\VSO Agents\00TFS01-norriq-ip\_work\3\s\src\NLWI.Platforms.Dynamicweb9.Specs\Services\CachedProductSpecificationService.cs:line 91
   at NLWI.Platforms.Dynamicweb9.Specs.ProductSpecificationExtensionMethods.GetProductSpecifications(Int32 autoId) in D:\VSO Agents\00TFS01-norriq-ip\_work\3\s\src\NLWI.Platforms.Dynamicweb9.Specs\ProductSpecificationExtensionMethods.cs:line 48
   at CompiledRazorTemplates.Dynamic.edfbafcacefe.Execute()
   at RazorEngine.Templating.TemplateBase.RazorEngine.Templating.ITemplate.Run(ExecuteContext context)
   at RazorEngine.Templating.TemplateService.Run(ITemplate template, DynamicViewBag viewBag)
   at RazorEngine.Templating.TemplateService.Parse(String razorTemplate, Object model, DynamicViewBag viewBag, String cacheName)
   at RazorEngine.Razor.Parse[T](String razorTemplate, T model, DynamicViewBag viewBag, String cacheName)
   at Dynamicweb.Rendering.Template.RenderRazorTemplate()
@using NLWI.Platforms.Dynamicweb9.Specs @using NORRIQ.Common8.Factory @using System.Web @using NORRIQ.Common8.Razor @using NORRIQ.RaptorEngine.Services @using StandardWebshop.CustomCode.Ecom.Group.GroupImages @using StandardWebshop.CustomCode.Ecom.Product @using StandardWebshop.CustomCode.Ecom.Product.ProductColors @using StandardWebshop.CustomCode.Ecom.Product.ProductPublication.Services @using StandardWebshop.CustomCode.Ecom.Seo.UrlProvider @using StandardWebshop.CustomCode.Razor @inherits Dynamicweb.Rendering.RazorTemplateBase<Dynamicweb.Rendering.RazorTemplateModel<Dynamicweb.Rendering.Template>> @functions { string FixImagePath(string path) { if (path == "") { return path; } path = path.TrimStart('/'); if (!path.StartsWith("files", StringComparison.CurrentCultureIgnoreCase)) { path = "/files/" + path; } else { path = "/" + path; } return path; } } @{ this.Pageview.ForceNoCache(); var productUrlService = ObjectFactory.GetInstance<HummelProductUrlService>(); var groupImageService = ObjectFactory.GetInstance<GroupImageService>(); var productColorService = ObjectFactory.GetInstance<ProductColorService>(); var currencyCode = Pageview.Area.EcomCurrencyId; var search = HttpUtility.HtmlEncode(System.Web.HttpContext.Current.Request.QueryString["search"] ?? ""); var HideBreadcrumb = Pageview.CurrentParagraph.Item["HideBreadcrumbOnPlp"] != null ? Pageview.CurrentParagraph.Item["HideBreadcrumbOnPlp"].ToString() : ""; var groupId = HttpContext.Current.Request.QueryString["GroupId"]; var ecomGroup = groupId != null ? Dynamicweb.Ecommerce.Products.Group.GetGroupById(groupId, Pageview.Area.EcomLanguageId) : null; var postfix = Pageview.Area.EcomShopId + currencyCode; var publicationService = ObjectFactory.GetInstance<ProductPublicationService>(); var noProductsFoundLinkParagraph = 0; Int32.TryParse((Pageview.Area.Item["PLPNoProductsFoundLink"] as string ?? "").Split('#').Last(), out noProductsFoundLinkParagraph); if (ecomGroup != null) { Pageview.Meta.Title = string.IsNullOrEmpty(ecomGroup.Meta.Title) ? ecomGroup.Name : ecomGroup.Meta.Title; if (!string.IsNullOrEmpty(ecomGroup.Meta.Description)) { Pageview.Meta.AddTag("Description", ecomGroup.Meta.Description); } if (!string.IsNullOrEmpty(ecomGroup.Meta.Keywords)) { Pageview.Meta.AddTag("Keywords", ecomGroup.Meta.Keywords); } Pageview.Meta.AddTag("OgTitle", ecomGroup.Name); Pageview.Meta.AddTag("OgType", "product.group"); } } <section class="banner-recommendations lazyload-banner"> <div class="container"> <div class="row"> <div class="col-sm-10 col-sm-offset-1"> <div class="banner-recommendations__content"> <h2 class="banner-related__headline headline headline--medium"> @Pageview.CurrentParagraph.Header </h2> @if (GetLoop("QueryResultItem").Any()) { var products = GetLoop("QueryResultItem"); <div class="banner-recommendations__carousel banner-recommendations__carousel--active carousel-@Pageview.CurrentParagraph.ID"> <div class="owl-carousel"> @foreach (var product in products) { var priceWithDiscount = product.GetDouble("DiscountPriceWithVat_" + postfix).ToString("N2"); var priceWithoutDiscount = product.GetDouble("PriceWithVat_" + postfix).ToString("N2"); var productNumber = product.GetString("ProductNumber"); var productColors = productColorService.GetProductColors(productNumber + "-at-SHOP3").Where(publicationService.ShowProduct).ToList(); var url = productUrlService.GetProductUri(new ProductColorKey(productNumber, product.GetString("ColorCode"), Pageview.Area.EcomLanguageId)).PathAndQuery; var perfion = ProductSpecificationExtensionMethods.GetProductSpecifications(product.GetInteger("AutoID")); var image = this.Pageview.CdnWrap("/Admin/Public/GetImage.ashx?Width=315&amp;Height=315&amp;Compression=85&amp;Crop=5&amp;Image=" + (perfion.HasKey("ColorImage") ? perfion.GetByKey("ColorImage").Value : "/Files/Images/Ecom/default.jpg")); <div class="recommendation-product"> <a href="@url" class="recommendation-product__anchor"> <figure class="recommendation-product__figure"> <span class="recommendation-product__figure-inner" style="background-image:url(@image);"></span> <noscript> <img class="recommendation-product__image owl-lazy" data-src="@image" /> </noscript> </figure> @if (productColors.Count > 1) { <div class="recommendation-product__colors">@productColors.Count @Translate("B2C farver", "farver")</div> } else { <div class="recommendation-product__colors">&nbsp;</div> } <div class="recommendation-product__name">@product.GetString("ProductName")</div> @if (Pageview.Area.Item["SiteHasShopping"].ToString() == "True") { <div class="recommendation-product__price"> @if (priceWithDiscount != priceWithoutDiscount) { <span class="price-discount"><span itemprop="price" content="@(product.GetDouble("PriceWithVat_" + postfix).ToString("0.00", System.Globalization.CultureInfo.InvariantCulture))">@priceWithDiscount</span> <span itemprop="priceCurrency" content="@currencyCode">@currencyCode</span></span> <span class="price-original">@priceWithoutDiscount @currencyCode</span> } else { <span itemprop="price" content="@(product.GetDouble("PriceWithVat_" + postfix).ToString("0.00", System.Globalization.CultureInfo.InvariantCulture))">@priceWithDiscount</span> <span itemprop="priceCurrency" content="@currencyCode">@currencyCode</span> } </div> } </a> </div> } </div> </div> } </div> </div> </div> </div> </section>

Login

* All fields must contain valid data.
* No user found with that email address or password



Your cart is empty

  • Size:

    Colour:

    Item no.:

    No items in stock

    GBP

    GBP

    GBP

Order details

Subtotal 1600 GBP
GBP GBP
Total GBP incl. VAT
Go to checkout Go to cart

Forgot password

* All fields must contain valid data.

If your email is found in our system an email with password resetting instructions is sent to you. Should arrive at your inbox shortly!