NIQ:exceptionSystem.ExceptionSystem.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 ProductAutoId,ProductNumber,ProductLanguageId,ColorCode,RelatedToProductAutoId,RelatedToProductNumber,RelatedToColorCode FROM ( SELECT p.ProductAutoId, p.ProductNumber, p.ProductLanguageId, p.ColorCode, RelatedToProductAutoId = prp.ProductAutoId, RelatedToProductNumber = prp.ProductNumber, RelatedToColorCode = prp.ColorCode, pr.SortOrder, rn = ROW_NUMBER() OVER ( PARTITION BY p.ProductId, p.ProductLanguageId, p.ColorCode, prp.ProductId, prp.ColorCode ORDER BY p.ProductAutoId ) FROM EcomProducts p INNER JOIN NIQ_RelatedProducts pr ON p.ProductId = pr.ProductId AND (ISNULL(pr.ProductColor,'') = '' OR pr.ProductColor = p.ColorCode) INNER JOIN EcomProducts prp ON prp.ProductId = pr.RelatedToProductId AND (ISNULL(pr.RelatedToProductColor,'') = '' OR pr.RelatedToProductColor = prp.ColorCode) AND p.ProductLanguageId = prp.ProductLanguageId WHERE p.ProductActive = 1 AND prp.ProductActive = 1 AND p.ProductStock > 0 AND prp.ProductStock > 0 AND ISNULL(p.ProductVariantId,'') != '' AND ISNULL(prp.ProductVariantId,'') != '' AND p.ProductLanguageId = @p0 AND prp.ProductLanguageId = @p0 ) t WHERE t.rn = 1 ORDER BY t.SortOrder", Params: '@p0=LANG1' ---> 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 StandardWebshop.CustomCode.Ecom.Product.RelatedProducts.ProductRelatedToRepository.GetProductRelations(String languageId) in E:\agents\norriq.visualstudio.com\agent 1\_work\10\s\Src\StandardWebshop\CustomCode\Ecom\Product\RelatedProducts\ProductRelatedToRepository.cs:line 59 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 StandardWebshop.CustomCode.Ecom.Product.RelatedToProducts.ProductRelatedToService.GetRelations(String languageId) in E:\agents\norriq.visualstudio.com\agent 1\_work\10\s\Src\StandardWebshop\CustomCode\Ecom\Product\RelatedProducts\ProductRelatedToService.cs:line 45 at StandardWebshop.CustomCode.Ecom.Product.RelatedToProducts.ProductRelatedToService.GetProductRelations(ProductColorKey product) in E:\agents\norriq.visualstudio.com\agent 1\_work\10\s\Src\StandardWebshop\CustomCode\Ecom\Product\RelatedProducts\ProductRelatedToService.cs:line 35 at StandardWebshop.CustomCode.Ecom.Product.ProductView.ProductDisplayMode.BuildViewModel() in E:\agents\norriq.visualstudio.com\agent 1\_work\10\s\Src\StandardWebshop\CustomCode\Ecom\Product\ProductView\ProductDisplayMode.cs:line 161 at StandardWebshop.CustomCode.Ecom.Product.ProductView.ProductDisplayMode.SafeRenderFrontend() in E:\agents\norriq.visualstudio.com\agent 1\_work\10\s\Src\StandardWebshop\CustomCode\Ecom\Product\ProductView\ProductDisplayMode.cs:line 82 at NORRIQ.DisplayIt.Implementation.ADisplayMode`1.RenderFrontend()
Template:BaseUrlSystem.String/Files/Templates/Designs/Hummel/DisplayIt/Ecom/
Template:DesignBaseUrlSystem.String/Files/Templates/Designs/Hummel/
Loops
TemplateTags() in code (Designs\Hummel\DisplayIt/Ecom/Error.cshtml). Remove before going live...

Log ind

* Alle felter skal udfyldes med gyldig info.
* Ingen bruger fundet med den e-mail eller adgangskode



Der er ingen produkter i kurven

  • Størrelse:

    Farve:

    Varenr.:

    Der er ikke flere varer på lager

    DKK

    DKK

    DKK

Ordreoversigt

Subtotal 1600 DKK
DKK DKK
Total DKK inkl. moms
Gå til kassen Gå til kurv

Glemt adgangskode

* Alle felter skal udfyldes med gyldig info.

Hvis din email findes i vores system, vil du modtage en email om lidt, med instruktioner til gendannelse af dit password.