Ooops! Das hätte nicht passieren dürfen.

Der eingegebene URL ist falsch.

GENESISServer User Error

-Type: Error
RaiseTime: 4/6/2025 12:11:34 AM
ObjectStorage: oxEShop
MethodName: ox.GENESISLite.Server.CQuerySet.OpenQuerySet
Message:
***************************************************
Data Error
---------------------------------------------------
Object: Recordset
Method: mbLoadDataSet
Message:
Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.


SQL:
SELECT TOP 100 TbART.ID As ID , TbART.NewProduct, TbART.SpecialOffer, TbART.Preis, IsNull((select AVG(Convert(Decimal(18,4),(TbAUR.Rating))) FROM TbAUR WHERE (TbART.ID) = (TbAUR.ART_ID) AND (TbAUR.Rating)>0),0) as AUR_AVGRating, TbART.Inventory, TbART.Signal, 0.00 as Line_Discount, IsNULL((SELECT TOP 1 (TxKAR.ArtNr) FROM TxKAR WHERE (TbART.ID) = (TxKAR.ART_ID) AND ((TxKAR.Kundennummer) = '')),'') as KUN_ArtNr, (TbART.ArtNr) + CASE WHEN (IsNULL((SELECT TOP 1 (TxKAR.ArtNr) FROM TxKAR WHERE (TbART.ID) = (TxKAR.ART_ID) AND ((TxKAR.Kundennummer) = '')),'')) = '' THEN '' ELSE ' ' + char(91) + (IsNULL((SELECT TOP 1 (TxKAR.ArtNr) FROM TxKAR WHERE (TbART.ID) = (TxKAR.ART_ID) AND ((TxKAR.Kundennummer) = '')),'')) + char(93) END + ' - ' + CONVERT(nvarchar(max),(TbART.Bez)) as Title, (TcMEH.Bez) as MEH_Bez, TbART.TYP_ID, TbARC.Feld_A, TbARC.Feld_B, TbARC.Feld_C, TbARC.Feld_D, TbARC.Feld_E, TbARC.Feld_F, TbARC.Feld_G, TbARC.Feld_H, TbARC.Feld_I, TbARC.Feld_J, TbARC.Feld_K, TbARC.Feld_L, TbARC.Feld_M, TbARC.Feld_N, TbARC.Feld_O, TbARC.Feld_P, TbARC.Feld_Q, TbARC.Feld_R, TbARC.Feld_S, TbARC.Feld_T, TbART.ArtNr, (TbART.ArtNr) + CASE WHEN (IsNULL((SELECT TOP 1 (TxKAR.ArtNr) FROM TxKAR WHERE (TbART.ID) = (TxKAR.ART_ID) AND ((TxKAR.Kundennummer) = '')),'')) = '' THEN '' ELSE ' ' + char(91) + (IsNULL((SELECT TOP 1 (TxKAR.ArtNr) FROM TxKAR WHERE (TbART.ID) = (TxKAR.ART_ID) AND ((TxKAR.Kundennummer) = '')),'')) + char(93) END as KundenArtikelNr, TbART.Verzeichnis + '/' + (TbART.Bildname) as PfadBild, TbART.MinOrderQty, TbART.KATCodeList, TbART.Bez as Bez, TbART.HER_IDs, (TcMEH.Code) as MEH_Code, TbART.Variante_HeadProduct as HeadProduct, TbART.MultiAME, (IsNULL((SELECT TOP 1 (TxKAR.ArtNr) FROM TxKAR WHERE (TbART.ID) = (TxKAR.ART_ID) AND ((TxKAR.Kundennummer) = '')),'')) + ' ' + (TbART.Suchbegriffe) as SearchKeywords, TbART.TOP_KAT_ID, TbART.GTIN, TbART.VendorItemNo, TbART.MEH_ID, TbART.SalesBlocked, TbART.Preis as UnitPrice, TbART.Kurztext as Kurztext, TbART.Bildname, BaseMEH.Bez as BaseMEH_Bez, TbART.URLArtNr, IsNull((select Count(id) FROM TbAUR WHERE (TbART.ID) = (TbAUR.ART_ID) AND (TbAUR.Rating)>0),0) as AUR_Count, IsNull((Select sum((TbBDH.Quantity)) FROM TbBDH WHERE (TbART.ID) = (TbBDH.ART_ID)),0) as BestsellerQuantityTotal, TbART.zzParentProduct, TbART.zzParentCharacteristics, TbART.Langtext as Langtext, TbART.zzParentProductArtID FROM TbART LEFT JOIN TbARC ON (TbART.ID) = (TbARC.ART_ID) INNER JOIN TcMEH ON (TbART.MEH_ID) = (TcMEH.ID) INNER JOIN TcMEH AS BaseMEH ON (TbART.Base_MEH_ID) = BaseMEH.ID WHERE ( ((TbART.URLArtNr = '101_338_016')) AND (((TbART.Inaktiv)= 0))) ORDER BY (TbART.SalesBlocked) DESC, (IsNULL((SELECT TOP 1 (TxKAR.ArtNr) FROM TxKAR WHERE (TbART.ID) = (TxKAR.ART_ID) AND ((TxKAR.Kundennummer) = '')),'ZZZZZZZ')) ASC, (TbART.Bez)




Additional Info:

SQL: SELECT TOP 100 TbART.ID As ID , TbART.NewProduct, TbART.SpecialOffer, TbART.Preis, IsNull((select AVG(Convert(Decimal(18,4),(TbAUR.Rating))) FROM TbAUR WHERE (TbART.ID) = (TbAUR.ART_ID) AND (TbAUR.Rating)>0),0) as AUR_AVGRating, TbART.Inventory, TbART.Signal, 0.00 as Line_Discount, IsNULL((SELECT TOP 1 (TxKAR.ArtNr) FROM TxKAR WHERE (TbART.ID) = (TxKAR.ART_ID) AND ((TxKAR.Kundennummer) = '')),'') as KUN_ArtNr, (TbART.ArtNr) + CASE WHEN (IsNULL((SELECT TOP 1 (TxKAR.ArtNr) FROM TxKAR WHERE (TbART.ID) = (TxKAR.ART_ID) AND ((TxKAR.Kundennummer) = '')),'')) = '' THEN '' ELSE ' ' + char(91) + (IsNULL((SELECT TOP 1 (TxKAR.ArtNr) FROM TxKAR WHERE (TbART.ID) = (TxKAR.ART_ID) AND ((TxKAR.Kundennummer) = '')),'')) + char(93) END + ' - ' + CONVERT(nvarchar(max),(TbART.Bez)) as Title, (TcMEH.Bez) as MEH_Bez, TbART.TYP_ID, TbARC.Feld_A, TbARC.Feld_B, TbARC.Feld_C, TbARC.Feld_D, TbARC.Feld_E, TbARC.Feld_F, TbARC.Feld_G, TbARC.Feld_H, TbARC.Feld_I, TbARC.Feld_J, TbARC.Feld_K, TbARC.Feld_L, TbARC.Feld_M, TbARC.Feld_N, TbARC.Feld_O, TbARC.Feld_P, TbARC.Feld_Q, TbARC.Feld_R, TbARC.Feld_S, TbARC.Feld_T, TbART.ArtNr, (TbART.ArtNr) + CASE WHEN (IsNULL((SELECT TOP 1 (TxKAR.ArtNr) FROM TxKAR WHERE (TbART.ID) = (TxKAR.ART_ID) AND ((TxKAR.Kundennummer) = '')),'')) = '' THEN '' ELSE ' ' + char(91) + (IsNULL((SELECT TOP 1 (TxKAR.ArtNr) FROM TxKAR WHERE (TbART.ID) = (TxKAR.ART_ID) AND ((TxKAR.Kundennummer) = '')),'')) + char(93) END as KundenArtikelNr, TbART.Verzeichnis + '/' + (TbART.Bildname) as PfadBild, TbART.MinOrderQty, TbART.KATCodeList, TbART.Bez as Bez, TbART.HER_IDs, (TcMEH.Code) as MEH_Code, TbART.Variante_HeadProduct as HeadProduct, TbART.MultiAME, (IsNULL((SELECT TOP 1 (TxKAR.ArtNr) FROM TxKAR WHERE (TbART.ID) = (TxKAR.ART_ID) AND ((TxKAR.Kundennummer) = '')),'')) + ' ' + (TbART.Suchbegriffe) as SearchKeywords, TbART.TOP_KAT_ID, TbART.GTIN, TbART.VendorItemNo, TbART.MEH_ID, TbART.SalesBlocked, TbART.Preis as UnitPrice, TbART.Kurztext as Kurztext, TbART.Bildname, BaseMEH.Bez as BaseMEH_Bez, TbART.URLArtNr, IsNull((select Count(id) FROM TbAUR WHERE (TbART.ID) = (TbAUR.ART_ID) AND (TbAUR.Rating)>0),0) as AUR_Count, IsNull((Select sum((TbBDH.Quantity)) FROM TbBDH WHERE (TbART.ID) = (TbBDH.ART_ID)),0) as BestsellerQuantityTotal, TbART.zzParentProduct, TbART.zzParentCharacteristics, TbART.Langtext as Langtext, TbART.zzParentProductArtID FROM TbART LEFT JOIN TbARC ON (TbART.ID) = (TbARC.ART_ID) INNER JOIN TcMEH ON (TbART.MEH_ID) = (TcMEH.ID) INNER JOIN TcMEH AS BaseMEH ON (TbART.Base_MEH_ID) = BaseMEH.ID WHERE ( ((TbART.URLArtNr = '101_338_016')) AND (((TbART.Inaktiv)= 0))) ORDER BY (TbART.SalesBlocked) DESC, (IsNULL((SELECT TOP 1 (TxKAR.ArtNr) FROM TxKAR WHERE (TbART.ID) = (TxKAR.ART_ID) AND ((TxKAR.Kundennummer) = '')),'ZZZZZZZ')) ASC, (TbART.Bez)

GENESISServer User Error

-Type: Error
RaiseTime: 4/6/2025 12:11:34 AM
ObjectStorage: oxEShop
MethodName: ox.GENESISLite.Server.CData.GetVDS
Message: Can't load Search DataObject Object for ART(Artikelliste_Shop) ! Please check prior Error-Messages.