Die gewünschte Seite kann nicht angezeigt werden!

Sehr geehrter Kunde

Leider ist während der Verarbeitung ein unerwartetes Problem aufgetreten! Bitte versuchen Sie es später erneut.

Sollte das Problem weiterhin auftreten, dann benutzen Sie bitte das Kontaktformular um uns das Problem mitzuteilen.

1/10/2025 5:21:28 AM / d9095f6b-a520-4f7b-be36-f628996aefe1

Fehlerbeschreibung:

GEO UserError Error

RaiseTime: 1/10/2025 5:21:28 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 , 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, IsNull((select AVG(Rating) FROM TbAUR WHERE (TbART.ID) = (TbAUR.ART_ID) AND (TbAUR.Rating)>0),0) as DQLAUR_AVGRating, TbART.Inventory, TbART.Signal, IsNULL((SELECT TOP 1 (TxKAR.ArtNr) FROM TxKAR WHERE (TbART.ID) = (TxKAR.ART_ID) AND ((TxKAR.Kundennummer) = '')),'ZZZZZZZ') as DQLKUN_ArtNr_Sort_ASC, IsNULL((SELECT TOP 1 (TxKAR.ArtNr) FROM TxKAR WHERE (TbART.ID) = (TxKAR.ART_ID) AND ((TxKAR.Kundennummer) = '')),'') 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) + 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 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.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 FROM TbART LEFT JOIN TbARC ON (TbART.ID) = (TbARC.ART_ID) WHERE ( ((TbART.ArtNrURL_Desc = '01373aa00000066')) AND ((IsNULL((TbART.Variante_Parent_ART_ID), 0) = 0) AND (IsNULL((TbART.Inaktiv),0) = 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 , 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, IsNull((select AVG(Rating) FROM TbAUR WHERE (TbART.ID) = (TbAUR.ART_ID) AND (TbAUR.Rating)>0),0) as DQLAUR_AVGRating, TbART.Inventory, TbART.Signal, IsNULL((SELECT TOP 1 (TxKAR.ArtNr) FROM TxKAR WHERE (TbART.ID) = (TxKAR.ART_ID) AND ((TxKAR.Kundennummer) = '')),'ZZZZZZZ') as DQLKUN_ArtNr_Sort_ASC, IsNULL((SELECT TOP 1 (TxKAR.ArtNr) FROM TxKAR WHERE (TbART.ID) = (TxKAR.ART_ID) AND ((TxKAR.Kundennummer) = '')),'') 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) + 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 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.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 FROM TbART LEFT JOIN TbARC ON (TbART.ID) = (TbARC.ART_ID) WHERE ( ((TbART.ArtNrURL_Desc = '01373aa00000066')) AND ((IsNULL((TbART.Variante_Parent_ART_ID), 0) = 0) AND (IsNULL((TbART.Inaktiv),0) = 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)

GEO UserError Error

RaiseTime: 1/10/2025 5:21:28 AM
ObjectStorage: oxEShop
MethodName: ox.GENESISLite.Server.CData.GetDataTableVDS
Message: Can't load Search DataObject Object! Please check prior Error-Messages.


EventLogId:d9095f6b-a520-4f7b-be36-f628996aefe1
Error Description:
Error Number: 0
Error Source:
Error LineNo: 0
Error LastDllError: 0

Session-Informationen:

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

Request-Informationen:

Request.RawUrl: /de-product-halbzylinder_euro_profil~01373aa00000066
Request.Browser.Id: webkit
Request.Browser.Browser: Mozilla
Request.Browser.IsMobileDevice: False
Request.Browser.EcmaScriptVersion: 3.0

Timestamp: 1/10/2025 5:21:28 AM