Error executing template "Designs/Swift/Paragraph/Swift_Group_SEO_Custom.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.Products.ProductRepository.Dynamicweb.Ecommerce.Products.IProductRepository.GetProductKeysByGroupId(String groupId, Boolean useOrderBy, Boolean includeVariants, String productLanguageId, Boolean doRefactoring, Boolean useAssortments)
   at Dynamicweb.Ecommerce.Orders.Discounts.Discount.ProcessProductSelections(HashSet`1& productKeys, HashSet`1& includedQueries, HashSet`1& excludedQueries)
   at Dynamicweb.Ecommerce.Orders.Discounts.Discount.GetRelevantProductKeys()
   at Dynamicweb.Ecommerce.Orders.Discounts.DiscountService.StatelessSetLookup(Discount discount, ConcurrentDictionary`2 lookup)
   at Dynamicweb.Ecommerce.Orders.Discounts.DiscountService.InitializeLookup()
   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.Orders.Discounts.DiscountService.GetDiscounts(DiscountApplyType[] discountTypes, String[] productKeys, User user)
   at Dynamicweb.Ecommerce.Orders.Discounts.DiscountInfoCollection.LoadDiscounts()
   at Smartpage.EvaSolo.CampaignPrices.Helpers.DiscountHelper.GetDiscountInfo(Product product, Currency currency, Country country, Shop shop, User user, String format) in D:\a\1\s\Smartpage.EvaSolo.CampaignPrices\Helpers\DiscountHelper.cs:line 48
   at Custom.EvaSolo.CampaignPrices.FieldTypeProviders.OnSaleProvider.GetProductValue(Product product, Object fieldValue, String languageId, Dictionary`2 settings) in D:\a\1\s\Smartpage.EvaSolo.CampaignPrices\FieldTypeProviders\OnSaleProvider.cs:line 27
   at Dynamicweb.Ecommerce.Products.ProductFieldTypeProvider.GetProductValue(Product product, FieldType fieldType, Object fieldValue)
   at Dynamicweb.Ecommerce.Products.ProductFieldValueCollection.RefreshProviderFields(Product product)
   at Dynamicweb.Ecommerce.Products.ProductRepository.ExtractProduct(IDataReader dataReader, Nullable`1& groupProductRelationSortingExists)
   at Dynamicweb.Ecommerce.Products.ProductRepository.GetProductsBySql(CommandBuilder query, Boolean doRefactoring, Boolean bulkFill, Boolean useAssortments)
   at Dynamicweb.Ecommerce.Products.ProductRepository.GetProductsByGroup(Group group, String productLanguageId, Boolean useAssortments)
   at Dynamicweb.Ecommerce.ProductCatalog.ViewModelFactory.CreateView(ProductListViewModelSettings settings, String groupId)
   at CompiledRazorTemplates.Dynamic.RazorEngine_7439779655a2457bb734e5a73172c7a9.Execute() in D:\dynamicweb.net\Solutions\twodayco3\evasolo.cloud.dynamicweb-cms.com\Files\Templates\Designs\Swift\Paragraph\Swift_Group_SEO_Custom.cshtml:line 46
   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.<RunCompile>b__0(TextWriter writer)
   at RazorEngine.Templating.RazorEngineServiceExtensions.WithWriter(Action`1 withWriter)
   at Dynamicweb.Rendering.RazorTemplateRenderingProvider.Render(Template template)
   at Dynamicweb.Rendering.TemplateRenderingService.Render(Template template)
   at Dynamicweb.Rendering.Template.RenderRazorTemplate()
ClientConnectionId:4e02721a-f380-47cd-9b62-772c9f7310b1
Error Number:-2,State:0,Class:11


  1     @inherits Dynamicweb.Rendering.ViewModelTemplate<Dynamicweb.Frontend.ParagraphViewModel>
  2     @using System.Collections
  3     @using Dynamicweb
  4     @using Dynamicweb.Frontend.Navigation
  5     @using Dynamicweb.Ecommerce.ProductCatalog
  6     @using Dynamicweb.Ecommerce.Products.Categories
  7     @using Dynamicweb.Environment
  8     @using Dynamicweb.Frontend
  9     
 10     @* CUSTOM TEMPLATE SUPPORTED BY SWIFT (v1.25.0) *@
 11     @* TODO: Update productList defination to the latest Swift logic *@
 12     
 13     @{
 14     	ProductListViewModel productList = new ProductListViewModel();
 15     
 16     	ProductListViewModelSettings productSetting = new ProductListViewModelSettings
 17     	{
 18     		LanguageId = Dynamicweb.Ecommerce.Common.Context.LanguageID,
 19     		CurrencyCode = Dynamicweb.Ecommerce.Common.Context.Currency.Code,
 20     		CountryCode = Dynamicweb.Ecommerce.Common.Context.Country.Code2,
 21     		ShopId = Pageview.Area.EcomShopId
 22     	};
 23     
 24     	if (Dynamicweb.Context.Current.Items.Contains("ProductList"))
 25     	{
 26     		productList = (ProductListViewModel)Dynamicweb.Context.Current.Items["ProductList"];
 27     	}
 28     	else if (Pageview.Item["DummyProductGroup"] != null)
 29     	{
 30     		var pageViewModel = Dynamicweb.Frontend.ContentViewModelFactory.CreatePageInfoViewModel(Pageview.Page);
 31     		ProductListViewModel groupList = pageViewModel.Item.GetValue("DummyProductGroup") != null ? pageViewModel.Item.GetValue("DummyProductGroup") as ProductListViewModel : new ProductListViewModel();
 32     
 33     		if (groupList?.Group?.Id != null)
 34     		{
 35     			productList = ViewModelFactory.CreateView(productSetting, groupList.Group.Id);
 36     			Dynamicweb.Context.Current.Items.Add("ProductList", productList);
 37     		}
 38     		else
 39     		{
 40     			productList = ViewModelFactory.CreateView(productSetting, Dynamicweb.Ecommerce.Services.ProductGroups.GetGroups(Dynamicweb.Ecommerce.Common.Context.LanguageID).FirstOrDefault().Id);
 41     			Dynamicweb.Context.Current.Items.Add("ProductList", productList);
 42     		}
 43     	}
 44     	else if (Pageview.Item["DummyProductGroup"] == null)
 45     	{
 46     		productList = ViewModelFactory.CreateView(productSetting, Dynamicweb.Ecommerce.Services.ProductGroups.GetGroups(Dynamicweb.Ecommerce.Common.Context.LanguageID).FirstOrDefault().Id);
 47     		Dynamicweb.Context.Current.Items.Add("ProductList", productList);
 48     	}
 49     
 50     	if (productList is object && productList.Group.Id != null)
 51     	{
 52     		<div class="productlist-seo-text col-12 col-lg-11">
 53     			<h2 class="seo-heading">@productList.Group.GetGroup().GroupFields.Single(gf => gf.SystemName == "ProductGroupSEOHeadingCustom").Value</h2>
 54     			<span class="seo-text">@productList.Group.GetGroup().GroupFields.Single(gf => gf.SystemName == "ProductGroupSEOTextCustom").Value</span>
 55     		</div>
 56     	}
 57     }
 58