La page souhaitée ne peut pas être affichée!

Fehlerbeschreibung:

GEO UserError Error

RaiseTime: 20.04.2025 03:33:07
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 TbART.ID As ID , (IsNULL(TbART.Verzeichnis,'')) + '/' + IsNULL((TbART.Bildname), '') as DQLART_Bild, (TbART.zzSEA_ArtNr) + ' - ' + CONVERT(varchar(8000),IsNULL((TbART.BezFR),'')) as DQLART_WebBez, TbART.Preis, (SELECT (TcMEH.BezFR) FROM TcMEH WHERE (TbART.MEH_ID) = (TcMEH.ID)) as DQLMEH_Bez, TbART.NewItem, TbART.SpecialOffer, CONVERT(nvarchar(4000),IsNULL((TbART.LangtextFR), '')) as DQLLangtext, CONVERT(nvarchar(4000),IsNULL((TbART.TechniktextFR), '')) as DQLTechniktext, IsNULL((TbART.Bildname),'') as DQLART_DocName, CASE WHEN (IsNULL((TbART.SalesBlocked),0) = 0) THEN -1 ELSE 0 END as ShowAddToWKB, IsNULL((TbART.Variante_HeadItem),0) as DQLIsHeadItem, IsNull((select AVG(Rating) FROM TbAUR WHERE (TbART.ID) = (TbAUR.ART_ID) AND (TbAUR.Rating)>0),0) as DQLAUR_AVGRating, CONVERT(nvarchar(4000),IsNULL((TbART.ZusatztextFR), '')) as DQLZusatztext, TbART.Inventory, TbART.Signal, IsNULL((SELECT COUNT(ID) FROM TxABZ WHERE (TbART.ID) = (TxABZ.ART1_ID)),0) as DQLCount_ABZ, IsNULL((SELECT COUNT(ID) FROM TxAET WHERE (TbART.ID) = (TxAET.ART1_ID)),0) as DQLCount_AET, (TbART.TOP_KAT_ID) as DQLART_KAT_ID, 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.MinOrderQty, TbART.BezFR as Bez, CONVERT(nvarchar(4000),IsNULL((TbART.ZusatztextFR), '')) as DQLKurztext, TbART.HER_IDs, TbART.ArtNrURL_Desc, TbART.KATCodeList, TbART.HatStuecklisten, TbART.zzSEA_ArtNr, TbART.zzKatalogbezeichnung1FR as zzKatalogbezeichnung1, TbART.zzKatalogbezeichnung2FR as zzKatalogbezeichnung2, TbART.zzVerwendungFR as zzVerwendung, TbART.zzDetailbeschriebFR as zzDetailbeschrieb, TbART.zzLieferumfangFR as zzLieferumfang, TbART.zzZeichnung, TbART.zzEigenschaften, TbART.zzTechnologien, TbART.zzBaugleichFR as zzBaugleich, TbART.zzBestelloptionFR as zzBestelloption, TbART.zzBild, IIF((TbART.Bez2FR) <> '', (TbART.Bez2FR) + '
', '') + (CONVERT(nvarchar(4000),IsNULL((TbART.ZusatztextFR), '')) ) as zzDQLBez2_Zusatztext, TbART.Bildname, TbART.zzBildKatalog, TbART.zzZeichnungKatalog, TbART.zzARG, TbART.zzDRGs FROM TbART LEFT JOIN TbARC ON TbART.ID = TbARC.ART_ID WHERE ( ((TbART.ID = 28047)) AND ((IsNULL((TbART.Inaktiv),0) = 0) AND (IsNULL((TbART.Variante_Parent_ART_ID), 0) = 0)))




Additional Info:

SQL: SELECT TbART.ID As ID , (IsNULL(TbART.Verzeichnis,'')) + '/' + IsNULL((TbART.Bildname), '') as DQLART_Bild, (TbART.zzSEA_ArtNr) + ' - ' + CONVERT(varchar(8000),IsNULL((TbART.BezFR),'')) as DQLART_WebBez, TbART.Preis, (SELECT (TcMEH.BezFR) FROM TcMEH WHERE (TbART.MEH_ID) = (TcMEH.ID)) as DQLMEH_Bez, TbART.NewItem, TbART.SpecialOffer, CONVERT(nvarchar(4000),IsNULL((TbART.LangtextFR), '')) as DQLLangtext, CONVERT(nvarchar(4000),IsNULL((TbART.TechniktextFR), '')) as DQLTechniktext, IsNULL((TbART.Bildname),'') as DQLART_DocName, CASE WHEN (IsNULL((TbART.SalesBlocked),0) = 0) THEN -1 ELSE 0 END as ShowAddToWKB, IsNULL((TbART.Variante_HeadItem),0) as DQLIsHeadItem, IsNull((select AVG(Rating) FROM TbAUR WHERE (TbART.ID) = (TbAUR.ART_ID) AND (TbAUR.Rating)>0),0) as DQLAUR_AVGRating, CONVERT(nvarchar(4000),IsNULL((TbART.ZusatztextFR), '')) as DQLZusatztext, TbART.Inventory, TbART.Signal, IsNULL((SELECT COUNT(ID) FROM TxABZ WHERE (TbART.ID) = (TxABZ.ART1_ID)),0) as DQLCount_ABZ, IsNULL((SELECT COUNT(ID) FROM TxAET WHERE (TbART.ID) = (TxAET.ART1_ID)),0) as DQLCount_AET, (TbART.TOP_KAT_ID) as DQLART_KAT_ID, 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.MinOrderQty, TbART.BezFR as Bez, CONVERT(nvarchar(4000),IsNULL((TbART.ZusatztextFR), '')) as DQLKurztext, TbART.HER_IDs, TbART.ArtNrURL_Desc, TbART.KATCodeList, TbART.HatStuecklisten, TbART.zzSEA_ArtNr, TbART.zzKatalogbezeichnung1FR as zzKatalogbezeichnung1, TbART.zzKatalogbezeichnung2FR as zzKatalogbezeichnung2, TbART.zzVerwendungFR as zzVerwendung, TbART.zzDetailbeschriebFR as zzDetailbeschrieb, TbART.zzLieferumfangFR as zzLieferumfang, TbART.zzZeichnung, TbART.zzEigenschaften, TbART.zzTechnologien, TbART.zzBaugleichFR as zzBaugleich, TbART.zzBestelloptionFR as zzBestelloption, TbART.zzBild, IIF((TbART.Bez2FR) <> '', (TbART.Bez2FR) + '
', '') + (CONVERT(nvarchar(4000),IsNULL((TbART.ZusatztextFR), '')) ) as zzDQLBez2_Zusatztext, TbART.Bildname, TbART.zzBildKatalog, TbART.zzZeichnungKatalog, TbART.zzARG, TbART.zzDRGs FROM TbART LEFT JOIN TbARC ON TbART.ID = TbARC.ART_ID WHERE ( ((TbART.ID = 28047)) AND ((IsNULL((TbART.Inaktiv),0) = 0) AND (IsNULL((TbART.Variante_Parent_ART_ID), 0) = 0)))

GEO UserError Error

RaiseTime: 20.04.2025 03:33:07
ObjectStorage: oxEShop
MethodName: ox.GENESISLite.Server.CData.GetDataTableVDS
Message: Can't load Search DataObject Object! Please check prior Error-Messages.

Session-Informationen:

USR.ID: 71410889
KUN.ID: 0
KUN.Kundennummer:
BLUserID:
NavisionWebLoginType: 1
LoginName:
WAE.Code: CHF
LNG.Code: FR
Language_ID: 2

Request-Informationen:

Request.RawUrl: /fr-product-garniture_complete_ebl_1~64101010224f1nu
Request.Browser.Id: webkit
Request.Browser.Browser: Mozilla
Request.Browser.IsMobileDevice: False
Request.Browser.EcmaScriptVersion: 3.0