Ooops! Questo non sarebbe dovuto accadere.

GENESISServer User Error

-Type: Error
RaiseTime: 22.11.2024 09:05:47
ObjectStorage: oxEShop
MethodName: ox.GENESISLite.Server.CQuerySet.OpenQuerySet
Message:
***************************************************
Data Error
---------------------------------------------------
Object: Recordset
Method: mbLoadDataSet
Message:
Transaction (Process ID 58) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.


SQL:
SELECT DISTINCT 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.BezIT)) as Title, (TcMEH.BezIT) as MEH_Bez, TbART.TYP_ID, 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.Bildname) as PfadBild, TbART.MinOrderQty, TbART.KATCodeList, TbART.BezIT 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.SuchbegriffeIT) as SearchKeywords, TbART.TOP_KAT_ID, TbART.GTIN, TbART.VendorItemNo, TbART.MEH_ID, TbART.SalesBlocked, TbART.Preis as UnitPrice, TbART.KurztextIT 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.zzLiquidation, TbART.Bez2IT as Bez2, zzARC_PIVOT.Feld_1, zzARC_PIVOT.Feld_2, zzARC_PIVOT.Feld_3, zzARC_PIVOT.Feld_4, zzARC_PIVOT.Feld_5, zzARC_PIVOT.Feld_6, zzARC_PIVOT.Feld_7, zzARC_PIVOT.Feld_8, zzARC_PIVOT.Feld_9, zzARC_PIVOT.Feld_10, zzARC_PIVOT.Feld_11, zzARC_PIVOT.Feld_12, zzARC_PIVOT.Feld_13, zzARC_PIVOT.Feld_14, zzARC_PIVOT.Feld_15, zzARC_PIVOT.Feld_16, zzARC_PIVOT.Feld_17, zzARC_PIVOT.Feld_18, zzARC_PIVOT.Feld_19, zzARC_PIVOT.Feld_20, zzARC_PIVOT.Feld_21, zzARC_PIVOT.Feld_22, zzARC_PIVOT.Feld_23, zzARC_PIVOT.Feld_24, zzARC_PIVOT.Feld_25, zzARC_PIVOT.Feld_26, zzARC_PIVOT.Feld_27, zzARC_PIVOT.Feld_28, zzARC_PIVOT.Feld_29, zzARC_PIVOT.Feld_30, zzARC_PIVOT.Feld_31, zzARC_PIVOT.Feld_32, zzARC_PIVOT.Feld_33, zzARC_PIVOT.Feld_34, zzARC_PIVOT.Feld_35, zzARC_PIVOT.Feld_36, zzARC_PIVOT.Feld_37, zzARC_PIVOT.Feld_38, zzARC_PIVOT.Feld_39, zzARC_PIVOT.Feld_40, zzARC_PIVOT.Feld_41, zzARC_PIVOT.Feld_42, zzARC_PIVOT.Feld_43, zzARC_PIVOT.Feld_44, zzARC_PIVOT.Feld_45, zzARC_PIVOT.Feld_46, zzARC_PIVOT.Feld_47, zzARC_PIVOT.Feld_48, zzARC_PIVOT.Feld_49, zzARC_PIVOT.Feld_50, TbART.zzSGR_IDs, TbART.zzTOP_KAT_Sort, TbART.zzMain_KAT_ID, TbART.HER_Suchbegriffe, TbART.zzMatchcodes, TbART.zzMain_KAT_Code, TRY_CAST((zzARC_PIVOT.Feld_23) AS DECIMAL(10,2)) as zzARP_Feld23 FROM (TbKAT LEFT JOIN TxARK ON (TbKAT.ID) = (TxARK.KAT_ID)) LEFT JOIN TbART ON (TxARK.ART_ID) = (TbART.ID) LEFT JOIN zzARC_PIVOT ON (TbART.ID) = (zzARC_PIVOT.ART_ID) INNER JOIN TcMEH ON (TbART.MEH_ID) = (TcMEH.ID) INNER JOIN TcMEH AS BaseMEH ON (TbART.Base_MEH_ID) = BaseMEH.ID WHERE (TxARK.KAT_ID) = 158 AND ( (((TbART.Inaktiv)= 0))) ORDER BY TbART.ArtNr ASC, TbART.BezIT ASC




Additional Info:

SQL: SELECT DISTINCT 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.BezIT)) as Title, (TcMEH.BezIT) as MEH_Bez, TbART.TYP_ID, 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.Bildname) as PfadBild, TbART.MinOrderQty, TbART.KATCodeList, TbART.BezIT 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.SuchbegriffeIT) as SearchKeywords, TbART.TOP_KAT_ID, TbART.GTIN, TbART.VendorItemNo, TbART.MEH_ID, TbART.SalesBlocked, TbART.Preis as UnitPrice, TbART.KurztextIT 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.zzLiquidation, TbART.Bez2IT as Bez2, zzARC_PIVOT.Feld_1, zzARC_PIVOT.Feld_2, zzARC_PIVOT.Feld_3, zzARC_PIVOT.Feld_4, zzARC_PIVOT.Feld_5, zzARC_PIVOT.Feld_6, zzARC_PIVOT.Feld_7, zzARC_PIVOT.Feld_8, zzARC_PIVOT.Feld_9, zzARC_PIVOT.Feld_10, zzARC_PIVOT.Feld_11, zzARC_PIVOT.Feld_12, zzARC_PIVOT.Feld_13, zzARC_PIVOT.Feld_14, zzARC_PIVOT.Feld_15, zzARC_PIVOT.Feld_16, zzARC_PIVOT.Feld_17, zzARC_PIVOT.Feld_18, zzARC_PIVOT.Feld_19, zzARC_PIVOT.Feld_20, zzARC_PIVOT.Feld_21, zzARC_PIVOT.Feld_22, zzARC_PIVOT.Feld_23, zzARC_PIVOT.Feld_24, zzARC_PIVOT.Feld_25, zzARC_PIVOT.Feld_26, zzARC_PIVOT.Feld_27, zzARC_PIVOT.Feld_28, zzARC_PIVOT.Feld_29, zzARC_PIVOT.Feld_30, zzARC_PIVOT.Feld_31, zzARC_PIVOT.Feld_32, zzARC_PIVOT.Feld_33, zzARC_PIVOT.Feld_34, zzARC_PIVOT.Feld_35, zzARC_PIVOT.Feld_36, zzARC_PIVOT.Feld_37, zzARC_PIVOT.Feld_38, zzARC_PIVOT.Feld_39, zzARC_PIVOT.Feld_40, zzARC_PIVOT.Feld_41, zzARC_PIVOT.Feld_42, zzARC_PIVOT.Feld_43, zzARC_PIVOT.Feld_44, zzARC_PIVOT.Feld_45, zzARC_PIVOT.Feld_46, zzARC_PIVOT.Feld_47, zzARC_PIVOT.Feld_48, zzARC_PIVOT.Feld_49, zzARC_PIVOT.Feld_50, TbART.zzSGR_IDs, TbART.zzTOP_KAT_Sort, TbART.zzMain_KAT_ID, TbART.HER_Suchbegriffe, TbART.zzMatchcodes, TbART.zzMain_KAT_Code, TRY_CAST((zzARC_PIVOT.Feld_23) AS DECIMAL(10,2)) as zzARP_Feld23 FROM (TbKAT LEFT JOIN TxARK ON (TbKAT.ID) = (TxARK.KAT_ID)) LEFT JOIN TbART ON (TxARK.ART_ID) = (TbART.ID) LEFT JOIN zzARC_PIVOT ON (TbART.ID) = (zzARC_PIVOT.ART_ID) INNER JOIN TcMEH ON (TbART.MEH_ID) = (TcMEH.ID) INNER JOIN TcMEH AS BaseMEH ON (TbART.Base_MEH_ID) = BaseMEH.ID WHERE (TxARK.KAT_ID) = 158 AND ( (((TbART.Inaktiv)= 0))) ORDER BY TbART.ArtNr ASC, TbART.BezIT ASC