Fehlerbeschreibung: GEO UserError Error
RaiseTime: 8/25/2026 1:55:52 AM
ObjectStorage: oxEShop
MethodName: ox.GENESISLite.Server.CQuerySet.OpenQuerySet
Message:
***************************************************
Data Error
---------------------------------------------------
Object: Recordset
Method: mbLoadDataSet
Message:
Transaction (Process ID 53) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
SQL:
SELECT TOP 100 TbART.ID As ID , CONVERT(nvarchar(4000),IsNULL((TbART.Zusatztext), '')) as DQLKurztext, TbART.NewItem, TbART.SpecialOffer, TbART.Preis, IsNULL((TbART.Variante_HeadItem),0) as DQLIsHeadItem, CASE WHEN (IsNULL((TbART.SalesBlocked),0) = 0) THEN -1 ELSE 0 END as ShowAddToWKB, 1 as DQLAUR_AVGRating, TbART.Inventory, TbART.Signal, 1 as DQLKUN_ArtNr_Sort_ASC, 1 as DQLKUN_ArtNr, (TbART.zzSEA_ArtNr) + ' - ' + CONVERT(varchar(8000),IsNULL((TbART.Bez),'')) as DQLART_WebBez, (SELECT (TcMEH.Bez) FROM TcMEH WHERE (TbART.MEH_ID) = (TcMEH.ID)) as DQLMEH_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) as DQLART_ArtNr, (TbART.Bez) as DQLART_Bez, (IsNULL(TbART.Verzeichnis,'')) + '/' + IsNULL((TbART.Bildname), '') as DQLART_Bild, TbART.MinOrderQty, TbART.ArtNrURL_Desc, TbART.KATCodeList, TbART.Bez as Bez, TbART.Bez2 as Bez2, TbART.Bez3 as Bez3, TbART.zzSEA_ArtNr, TbART.zzKatalogbezeichnung1 as zzKatalogbezeichnung1, TbART.zzKatalogbezeichnung2 as zzKatalogbezeichnung2, TbART.zzVerwendung as zzVerwendung, TbART.SCD_BIT_ID, TbART.zzBild, IIF((TbART.Bez2) <> '', (TbART.Bez2) + '
', '') + (CONVERT(nvarchar(4000),IsNULL((TbART.Zusatztext), '')) ) as zzDQLBez2_Zusatztext, TbART.Bildname, TbART.zzMerkmalInfo as zzMerkmalInfo, TbART.zzBildKatalog, TbART.Zusatztext as Zusatztext, TbART.Suchbegriffe as Suchbegriffe FROM (TbKAT LEFT JOIN TxARK ON (TbKAT.ID) = (TxARK.KAT_ID)) LEFT JOIN TbART ON (TxARK.ART_ID) = (TbART.ID) LEFT JOIN TbARC ON (TbART.ID) = (TbARC.ART_ID) WHERE (TxARK.KAT_ID) = 1705 AND ( ((IsNULL((TbART.Inaktiv),0) = 0) AND (IsNULL((TbART.Variante_Parent_ART_ID), 0) = 0))) ORDER BY TbART.ID ASC
Additional Info:
SQL: SELECT TOP 100 TbART.ID As ID , CONVERT(nvarchar(4000),IsNULL((TbART.Zusatztext), '')) as DQLKurztext, TbART.NewItem, TbART.SpecialOffer, TbART.Preis, IsNULL((TbART.Variante_HeadItem),0) as DQLIsHeadItem, CASE WHEN (IsNULL((TbART.SalesBlocked),0) = 0) THEN -1 ELSE 0 END as ShowAddToWKB, 1 as DQLAUR_AVGRating, TbART.Inventory, TbART.Signal, 1 as DQLKUN_ArtNr_Sort_ASC, 1 as DQLKUN_ArtNr, (TbART.zzSEA_ArtNr) + ' - ' + CONVERT(varchar(8000),IsNULL((TbART.Bez),'')) as DQLART_WebBez, (SELECT (TcMEH.Bez) FROM TcMEH WHERE (TbART.MEH_ID) = (TcMEH.ID)) as DQLMEH_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) as DQLART_ArtNr, (TbART.Bez) as DQLART_Bez, (IsNULL(TbART.Verzeichnis,'')) + '/' + IsNULL((TbART.Bildname), '') as DQLART_Bild, TbART.MinOrderQty, TbART.ArtNrURL_Desc, TbART.KATCodeList, TbART.Bez as Bez, TbART.Bez2 as Bez2, TbART.Bez3 as Bez3, TbART.zzSEA_ArtNr, TbART.zzKatalogbezeichnung1 as zzKatalogbezeichnung1, TbART.zzKatalogbezeichnung2 as zzKatalogbezeichnung2, TbART.zzVerwendung as zzVerwendung, TbART.SCD_BIT_ID, TbART.zzBild, IIF((TbART.Bez2) <> '', (TbART.Bez2) + '
', '') + (CONVERT(nvarchar(4000),IsNULL((TbART.Zusatztext), '')) ) as zzDQLBez2_Zusatztext, TbART.Bildname, TbART.zzMerkmalInfo as zzMerkmalInfo, TbART.zzBildKatalog, TbART.Zusatztext as Zusatztext, TbART.Suchbegriffe as Suchbegriffe FROM (TbKAT LEFT JOIN TxARK ON (TbKAT.ID) = (TxARK.KAT_ID)) LEFT JOIN TbART ON (TxARK.ART_ID) = (TbART.ID) LEFT JOIN TbARC ON (TbART.ID) = (TbARC.ART_ID) WHERE (TxARK.KAT_ID) = 1705 AND ( ((IsNULL((TbART.Inaktiv),0) = 0) AND (IsNULL((TbART.Variante_Parent_ART_ID), 0) = 0))) ORDER BY TbART.ID ASC
GEO UserError Error
RaiseTime: 8/25/2026 1:55:52 AM
ObjectStorage: oxEShop
MethodName: ox.GENESISLite.Server.CData.GetDataTableVDS
Message: Can't load Search DataObject Object! Please check prior Error-Messages.
EventLogId:0f6abffe-c276-4f44-aca8-a41ca36915a0
Error Description:
Error Number: 0
Error Source:
Error LineNo: 0
Error LastDllError: 203
Session-Informationen:
USR.ID: 105345811
KUN.ID: 0
KUN.Kundennummer:
BLUserID:
NavisionWebLoginType: 1
LoginName:
WAE.Code: CHF
LNG.Code:
Language_ID: 0
Request-Informationen:
Request.RawUrl: /de-product-drehknopfzylinder_rz~m1080230535144ad
Request.Browser.Id: webkit
Request.Browser.Browser: Mozilla
Request.Browser.IsMobileDevice: False
Request.Browser.EcmaScriptVersion: 3.0
Timestamp: 8/25/2026 1:55:52 AM