Ich habe seit 26.08. das Problem, dass bei allen Artikeln mit Varianten diese Fehlermeldung beim Shopabgleich auftritt. Wenn ich die betroffenen Artikel in JTL für den Shopify Shop deaktiviere, tritt der Fehler nicht mehr auf, es findet aber auch kein Abgleich mehr statt. Ich habe jetzt 24 getestet und probiert, aber der Fehler bleibt unverändert.
Ich habe testweise ein neues Produkt mit Varianten erstellt und auch hier kommt dieselbe Fehlermeldung.
In den Shopify Einstellungen sind unter
App-Entwicklung
Anbei der Screenshot der Fehlermeldung bei Übertragung des Testartikels.
Fehlerlog:
Unbehandelte Ausnahme #959190594F6282F vom Typ System.Exception in
System.Exception: Exception: Controller = Product | Action = push | JTL-Wawi PK = 5633 | SKU = Wert #5- | Name = Testeier aus Zürich Wert #5 | Error in response: [{"message":"Variable $options of type [OptionReorderInput!]! was provided invalid value","locations":[{"line":2,"column":29}],"extensions":{"value":null,"problems":[{"path":[],"explanation":"Expected value to not be null"}]}}]
Controller = Product | Action = push | JTL-Wawi PK = 5633 | SKU = Wert #5- | Name = Testeier aus Zürich Wert #5 | Error in response: [{"message":"Variable $options of type [OptionReorderInput!]! was provided invalid value","locations":[{"line":2,"column":29}],"extensions":{"value":null,"problems":[{"path":[],"explanation":"Expected value to not be null"}]}}]
Artikel-Senden-Fehler: Bitte beachten Sie, dass zur Fehler-Diagnose ebenfalls die Log-Datei des Servers und das Abgleich-Log der JTL-Wawi notwendig sind!
Exception bei product.push: Controller = Product | Action = push | JTL-Wawi PK = 5633 | SKU = Wert #5- | Name = Testeier aus Zürich Wert #5 | Error in response: [{"message":"Variable $options of type [OptionReorderInput!]! was provided invalid value","locations":[{"line":2,"column":29}],"extensions":{"value":null,"problems":[{"path":[],"explanation":"Expected value to not be null"}]}}]
Controller = Product | Action = push | JTL-Wawi PK = 5633 | SKU = Wert #5- | Name = Testeier aus Zürich Wert #5 | Error in response: [{"message":"Variable $options of type [OptionReorderInput!]! was provided invalid value","locations":[{"line":2,"column":29}],"extensions":{"value":null,"problems":[{"path":[],"explanation":"Expected value to not be null"}]}}]
Response: {"jtlrpc":"2.0","id":"5ce7ea8e787d4582985c638fccc28ebe","result":null,"error":{"code":0,"message":"Controller = Product | Action = push | JTL-Wawi PK = 5633 | SKU = Wert #5- | Name = Testeier aus Z\u00fcrich Wert #5 | Error in response: [{\u0022message\u0022:\u0022Variable $options of type [OptionReorderInput!]! was provided invalid value\u0022,\u0022locations\u0022:[{\u0022line\u0022:2,\u0022column\u0022:29}],\u0022extensions\u0022:{\u0022value\u0022:null,\u0022problems\u0022:[{\u0022path\u0022:[],\u0022explanation\u0022:\u0022Expected value to not be null\u0022}]}}]","data":"RuntimeException (Code: 0) in ...\/ShopifyGraphQlClient.php:139"},"warnings":[]}
Exception bei product.push: Controller = Product | Action = push | JTL-Wawi PK = 5633 | SKU = Wert #5- | Name = Testeier aus Zürich Wert #5 | Error in response: [{"message":"Variable $options of type [OptionReorderInput!]! was provided invalid value","locations":[{"line":2,"column":29}],"extensions":{"value":null,"problems":[{"path":[],"explanation":"Expected value to not be null"}]}}]
Controller = Product | Action = push | JTL-Wawi PK = 5633 | SKU = Wert #5- | Name = Testeier aus Zürich Wert #5 | Error in response: [{"message":"Variable $options of type [OptionReorderInput!]! was provided invalid value","locations":[{"line":2,"column":29}],"extensions":{"value":null,"problems":[{"path":[],"explanation":"Expected value to not be null"}]}}]
Response: {"jtlrpc":"2.0","id":"42a17cbd11f745b9be9be6cd02fe685f","result":null,"error":{"code":0,"message":"Controller = Product | Action = push | JTL-Wawi PK = 5633 | SKU = Wert #5- | Name = Testeier aus Z\u00fcrich Wert #5 | Error in response: [{\u0022message\u0022:\u0022Variable $options of type [OptionReorderInput!]! was provided invalid value\u0022,\u0022locations\u0022:[{\u0022line\u0022:2,\u0022column\u0022:29}],\u0022extensions\u0022:{\u0022value\u0022:null,\u0022problems\u0022:[{\u0022path\u0022:[],\u0022explanation\u0022:\u0022Expected value to not be null\u0022}]}}]","data":"RuntimeException (Code: 0) in ...\/ShopifyGraphQlClient.php:139"},"warnings":[]}
bei jtlCore.ControllerClasses. Connector.Abgleich.Connector.wrYYYhwnpUc(String , Object , Boolean , NetworkCredential )
bei jtlCore.ControllerClasses.Connector.Abgleich.Connector.MKWYYb2HWbb(String , Object , Boolean , NetworkCredential , Boolean )
bei jtlCore.ControllerClasses.Connector.Abgleich.Connector.wrYYYhwnpUc(String , Object , Boolean , NetworkCredential )
2025-08-27T07:32:27 DEBUG -
SELECT * FROM
(
SELECT *
FROM (SELECT kTicket FROM Ticketsystem.tTicket) AS UserQuery
WHERE kTicket IN (SELECT tTicket.kTicket
FROM Ticketsystem.tTicket
WHERE 1 = 1
AND ( tTicket.kBenutzer_Bearbeiter IS NOT NULL OR tTicket.kBenutzer_Bearbeiter IS NULL ) AND ( tTicket.kStatus = 3 OR tTicket.kStatus <> 3 ))
AND kTicket IN (
SELECT ticket.kTicket
FROM Ticketsystem.tTicket ticket
WHERE ticket.nIstInPapierkorb = 0
)
AND kTicket IN (SELECT tTicket.kTicket
FROM Ticketsystem.tTicket
WHERE NOT EXISTS(SELECT kTicketLabel FROM Ticketsystem.tTicketLabel WHERE kTicket = tTicket.kTicket)
UNION
SELECT tTicketLabel.kTicket
FROM Ticketsystem.tTicketLabel
WHERE @p0 = 1
UNION
SELECT tTicketLabel.kTicket
FROM Ticketsystem.tTicketLabel
WHERE @p0 = 0
AND tTicketLabel.kLabel IN
(
SELECT tLabelBenutzergruppeRechte.kLabel
FROM Ticketsystem.tLabelBenutzergruppeRechte
WHERE tLabelBenutzergruppeRechte.kRechtBenutzerGruppe IN (
SELECT tRechtBenutzerGruppenZuordnung.kRechtBenutzerGruppe
FROM eazybusiness.dbo.tRechtBenutzerGruppenZuordnung
WHERE tRechtBenutzerGruppenZuordnung.kBenutzer = @p1
AND tLabelBenutzergruppeRechte.nIstSichtbar = 1
)
))
) AS InnerSql
ORDER BY ROW_NUMBER() OVER (ORDER BY kTicket)
OFFSET @page * 1000 ROWS FETCH NEXT 1000 + 1 ROWS ONLY
page = 0
@p0 = 1
@p1 = 1
2025-08-27T07:32:27 DEBUG - Dauer: 0ms, (bis zum Reader)
2025-08-27T07:32:27 DEBUG - Dauer: 0 ms, 0 Zeilen
2025-08-27T07:32:27 DEBUG -
SELECT tLabel.kLabel
FROM dbo.tLabel
WHERE tLabel.nTyp = @labelTyp
@labelTyp = Ticket
2025-08-27T07:32:27 DEBUG - Dauer: 0ms, (bis zum Reader)
2025-08-27T07:32:27 DEBUG - Dauer: 0 ms, 0 Zeilen
2025-08-27T07:32:27 DEBUG -
SELECT COUNT(tTicket.kTicket) AS UnseenChanges
FROM Ticketsystem.tTicket
WHERE tTicket.nIstInPapierkorb = 0
AND tTicket.nVollstaendigAngelegt = 1
AND tTicket.kTicket NOT IN (SELECT tTicketLabel.kTicket
FROM Ticketsystem.tTicketLabel)
AND (EXISTS (SELECT tAgentAngeseheneTickets.kAgentAngeseheneTickets
FROM Ticketsystem.tAgentAngeseheneTickets
WHERE tAgentAngeseheneTickets.kTicket = tTicket.kTicket
AND tAgentAngeseheneTickets.kBenutzer = @kBenutzer)
AND ((SELECT ISNULL(tAgentAngeseheneTickets.kNachricht, 0)
FROM Ticketsystem.tAgentAngeseheneTickets
WHERE tAgentAngeseheneTickets.kTicket = tTicket.kTicket
AND tAgentAngeseheneTickets.kBenutzer = @kBenutzer) < (SELECT ISNULL(MAX(tNachricht.kNachricht), 0)
FROM Ticketsystem.tNachricht
WHERE tNachricht.kTicket = tTicket.kTicket)
OR (SELECT ISNULL(tAgentAngeseheneTickets.kNotiz, 0)
FROM Ticketsystem.tAgentAngeseheneTickets
WHERE tAgentAngeseheneTickets.kTicket = tTicket.kTicket
AND tAgentAngeseheneTickets.kBenutzer = @kBenutzer) < (SELECT ISNULL(MAX(tNotiz.kNotiz), 0)
FROM Ticketsystem.tNotiz
WHERE tNotiz.kTicket = tTicket.kTicket)
OR (SELECT ISNULL(tAgentAngeseheneTickets.kTelefonat, 0)
FROM Ticketsystem.tAgentAngeseheneTickets
WHERE tAgentAngeseheneTickets.kTicket = tTicket.kTicket
AND tAgentAngeseheneTickets.kBenutzer = @kBenutzer) < (SELECT ISNULL(MAX(tTelefonat.kTelefonat), 0)
FROM Ticketsystem.tTelefonat
WHERE tTelefonat.kTicket = tTicket.kTicket))
OR NOT EXISTS (SELECT tAgentAngeseheneTickets.kAgentAngeseheneTickets
FROM Ticketsystem.tAgentAngeseheneTickets
WHERE tAgentAngeseheneTickets.kTicket = tTicket.kTicket
AND tAgentAngeseheneTickets.kBenutzer = @kBenutzer))
@kBenutzer = 1
@p0 = 0
2025-08-27T07:32:27 DEBUG - Dauer: 0ms, (bis zum Reader)
2025-08-27T07:32:27 DEBUG - Dauer: 0ms, 1 Zeilen
2025-08-27T07:32:28 DEBUG - SELECT [tUserSession].[kUserSession]
,[tUserSession].[kOwnerUserSession]
,[tUserSession].[kBenutzer]
,[tUserSession].[kMandant]
,[tUserSession].[iApplicationId]
,[tUserSession].[cCustomIdentifier]
,[tUserSession].[cHostname]
,[tUserSession].[nProcessId]
,[tUserSession].[dLoggedIn]
,[tUserSession].[dLastHeartbeat]
,[tUserSession].[nIsSessionInterruptible]
,[tUserSession].[nSessionInterruptRequested]
,[tUserSession].[dSessionInterruptRequestTimestamp]
,[tUserSession].[cSessionInterruptHostname]
,[tUserSession].[kSessionInterruptBenutzer]
,[tUserSession].[iSessionInterruptMessage]
,[tUser].[cName] AS [cBenutzerName]
,[tMandant].[cName] AS [cMandantName]
,[tUserInterrupt].[cName] AS [cBenutzerNameInterrupt]
FROM [eazybusiness].[dbo].[tUserSession]
LEFT JOIN [eazybusiness].[dbo].[tBenutzer] tUser ON [tUserSession].[kBenutzer] = [tUser].[kBenutzer]
LEFT JOIN [eazybusiness].[dbo].[tMandant] ON [tUserSession].[kMandant] = [tMandant].[kMandant]
LEFT JOIN [eazybusiness].[dbo].[tBenutzer] tUserInterrupt ON [tUserSession].[kSessionInterruptBenutzer] = [tUserInterrupt].[kBenutzer]
WHERE [tUserSession].[kUserSession] = @kUserSession AND dSessionInvalidated IS NULL
@kUserSession = 1310
2025-08-27T07:32:28 DEBUG - Dauer: 0ms, (bis zum Reader)(A)
2025-08-27T07:32:28 DEBUG - Dauer: 5 ms, 1 Zeilen
2025-08-27T07:32:28 DEBUG - UPDATE [eazybusiness].[dbo].[tUserSession] SET dLastHeartbeat = @dLastHeartbeat_0 WHERE kUserSession = @kUserSession_0;
@dLastHeartbeat_0 = 08/27/2025 07:32:28 +02:00
@kUserSession_0 = 1310
2025-08-27T07:32:28 DEBUG - Dauer: 0ms, AffectedRows: 1
2025-08-27T07:32:57 DEBUG -
SELECT * FROM
(
SELECT *
FROM (SELECT kTicket FROM Ticketsystem.tTicket) AS UserQuery
WHERE kTicket IN (SELECT tTicket.kTicket
FROM Ticketsystem.tTicket
WHERE 1 = 1
AND ( tTicket.kBenutzer_Bearbeiter IS NOT NULL OR tTicket.kBenutzer_Bearbeiter IS NULL ) AND ( tTicket.kStatus = 3 OR tTicket.kStatus <> 3 ))
AND kTicket IN (
SELECT ticket.kTicket
FROM Ticketsystem.tTicket ticket
WHERE ticket.nIstInPapierkorb = 0
)
AND kTicket IN (SELECT tTicket.kTicket
FROM Ticketsystem.tTicket
WHERE NOT EXISTS(SELECT kTicketLabel FROM Ticketsystem.tTicketLabel WHERE kTicket = tTicket.kTicket)
UNION
SELECT tTicketLabel.kTicket
FROM Ticketsystem.tTicketLabel
WHERE @p0 = 1
UNION
SELECT tTicketLabel.kTicket
FROM Ticketsystem.tTicketLabel
WHERE @p0 = 0
AND tTicketLabel.kLabel IN
(
SELECT tLabelBenutzergruppeRechte.kLabel
FROM Ticketsystem.tLabelBenutzergruppeRechte
WHERE tLabelBenutzergruppeRechte.kRechtBenutzerGruppe IN (
SELECT tRechtBenutzerGruppenZuordnung.kRechtBenutzerGruppe
FROM eazybusiness.dbo.tRechtBenutzerGruppenZuordnung
WHERE tRechtBenutzerGruppenZuordnung.kBenutzer = @p1
AND tLabelBenutzergruppeRechte.nIstSichtbar = 1
)
))
) AS InnerSql
ORDER BY ROW_NUMBER() OVER (ORDER BY kTicket)
OFFSET @page * 1000 ROWS FETCH NEXT 1000 + 1 ROWS ONLY
page = 0
@p0 = 1
@p1 = 1
2025-08-27T07:32:57 DEBUG - Dauer: 0ms, (bis zum Reader)
2025-08-27T07:32:57 DEBUG - Dauer: 0 ms, 0 Zeilen
2025-08-27T07:32:57 DEBUG -
SELECT tLabel.kLabel
FROM dbo.tLabel
WHERE tLabel.nTyp = @labelTyp
@labelTyp = Ticket
2025-08-27T07:32:57 DEBUG - Dauer: 0ms, (bis zum Reader)
2025-08-27T07:32:57 DEBUG - Dauer: 0 ms, 0 Zeilen
2025-08-27T07:32:57 DEBUG -
SELECT COUNT(tTicket.kTicket) AS UnseenChanges
FROM Ticketsystem.tTicket
WHERE tTicket.nIstInPapierkorb = 0
AND tTicket.nVollstaendigAngelegt = 1
AND tTicket.kTicket NOT IN (SELECT tTicketLabel.kTicket
FROM Ticketsystem.tTicketLabel)
AND (EXISTS (SELECT tAgentAngeseheneTickets.kAgentAngeseheneTickets
FROM Ticketsystem.tAgentAngeseheneTickets
WHERE tAgentAngeseheneTickets.kTicket = tTicket.kTicket
AND tAgentAngeseheneTickets.kBenutzer = @kBenutzer)
AND ((SELECT ISNULL(tAgentAngeseheneTickets.kNachricht, 0)
FROM Ticketsystem.tAgentAngeseheneTickets
WHERE tAgentAngeseheneTickets.kTicket = tTicket.kTicket
AND tAgentAngeseheneTickets.kBenutzer = @kBenutzer) < (SELECT ISNULL(MAX(tNachricht.kNachricht), 0)
FROM Ticketsystem.tNachricht
WHERE tNachricht.kTicket = tTicket.kTicket)
OR (SELECT ISNULL(tAgentAngeseheneTickets.kNotiz, 0)
FROM Ticketsystem.tAgentAngeseheneTickets
WHERE tAgentAngeseheneTickets.kTicket = tTicket.kTicket
AND tAgentAngeseheneTickets.kBenutzer = @kBenutzer) < (SELECT ISNULL(MAX(tNotiz.kNotiz), 0)
FROM Ticketsystem.tNotiz
WHERE tNotiz.kTicket = tTicket.kTicket)
OR (SELECT ISNULL(tAgentAngeseheneTickets.kTelefonat, 0)
FROM Ticketsystem.tAgentAngeseheneTickets
WHERE tAgentAngeseheneTickets.kTicket = tTicket.kTicket
AND tAgentAngeseheneTickets.kBenutzer = @kBenutzer) < (SELECT ISNULL(MAX(tTelefonat.kTelefonat), 0)
FROM Ticketsystem.tTelefonat
WHERE tTelefonat.kTicket = tTicket.kTicket))
OR NOT EXISTS (SELECT tAgentAngeseheneTickets.kAgentAngeseheneTickets
FROM Ticketsystem.tAgentAngeseheneTickets
WHERE tAgentAngeseheneTickets.kTicket = tTicket.kTicket
AND tAgentAngeseheneTickets.kBenutzer = @kBenutzer))
@kBenutzer = 1
@p0 = 0
2025-08-27T07:32:57 DEBUG - Dauer: 0ms, (bis zum Reader)
2025-08-27T07:32:57 DEBUG - Dauer: 0ms, 1 Zeilen
2025-08-27T07:32:58 DEBUG - UPDATE dbo.tArtikelShop
SET dbo.tArtikelShop.nInBearbeitung = 0
WHERE dbo.tArtikelShop.kShop = 2
AND dbo.tArtikelShop.nInBearbeitung = 1
2025-08-27T07:32:58 DEBUG - Dauer: 7ms, AffectedRows: 1
Zeitstempel: 2025-08-27T07:33:05
Locale: German (Germany)
Locale: German (Germany)
Version: Der Wert wurde nicht erstellt.
Plattform: Wawi
WawiSeed: 1.7.52730.82701
Prozessname: JTL-Wawi
Physikalischer Speicher: 1072242688 / Peak: 1084600320
Basispriorität: 8
Prioritätsklasse: Normal
CPU-Zeit (User): 1:42:19,359375
CPU-Zeit (System): 0:38:37,34375
Page-Size (Sytem): 4217648 / Peak: 1664946176
Page-Size: 1651732480 / Peak: 1664946176
Offene Handles: 30747
Database:
Build: 2406071237 b0445162e2f9cb09f437bfde13d8c428f922da12
Ich habe testweise ein neues Produkt mit Varianten erstellt und auch hier kommt dieselbe Fehlermeldung.
In den Shopify Einstellungen sind unter
App-Entwicklung
JTL-Connector
alle API Zugriffsrecht aktiviert.Anbei der Screenshot der Fehlermeldung bei Übertragung des Testartikels.
Fehlerlog:
Unbehandelte Ausnahme #959190594F6282F vom Typ System.Exception in
System.Exception: Exception: Controller = Product | Action = push | JTL-Wawi PK = 5633 | SKU = Wert #5- | Name = Testeier aus Zürich Wert #5 | Error in response: [{"message":"Variable $options of type [OptionReorderInput!]! was provided invalid value","locations":[{"line":2,"column":29}],"extensions":{"value":null,"problems":[{"path":[],"explanation":"Expected value to not be null"}]}}]
Controller = Product | Action = push | JTL-Wawi PK = 5633 | SKU = Wert #5- | Name = Testeier aus Zürich Wert #5 | Error in response: [{"message":"Variable $options of type [OptionReorderInput!]! was provided invalid value","locations":[{"line":2,"column":29}],"extensions":{"value":null,"problems":[{"path":[],"explanation":"Expected value to not be null"}]}}]
Artikel-Senden-Fehler: Bitte beachten Sie, dass zur Fehler-Diagnose ebenfalls die Log-Datei des Servers und das Abgleich-Log der JTL-Wawi notwendig sind!
Exception bei product.push: Controller = Product | Action = push | JTL-Wawi PK = 5633 | SKU = Wert #5- | Name = Testeier aus Zürich Wert #5 | Error in response: [{"message":"Variable $options of type [OptionReorderInput!]! was provided invalid value","locations":[{"line":2,"column":29}],"extensions":{"value":null,"problems":[{"path":[],"explanation":"Expected value to not be null"}]}}]
Controller = Product | Action = push | JTL-Wawi PK = 5633 | SKU = Wert #5- | Name = Testeier aus Zürich Wert #5 | Error in response: [{"message":"Variable $options of type [OptionReorderInput!]! was provided invalid value","locations":[{"line":2,"column":29}],"extensions":{"value":null,"problems":[{"path":[],"explanation":"Expected value to not be null"}]}}]
Response: {"jtlrpc":"2.0","id":"5ce7ea8e787d4582985c638fccc28ebe","result":null,"error":{"code":0,"message":"Controller = Product | Action = push | JTL-Wawi PK = 5633 | SKU = Wert #5- | Name = Testeier aus Z\u00fcrich Wert #5 | Error in response: [{\u0022message\u0022:\u0022Variable $options of type [OptionReorderInput!]! was provided invalid value\u0022,\u0022locations\u0022:[{\u0022line\u0022:2,\u0022column\u0022:29}],\u0022extensions\u0022:{\u0022value\u0022:null,\u0022problems\u0022:[{\u0022path\u0022:[],\u0022explanation\u0022:\u0022Expected value to not be null\u0022}]}}]","data":"RuntimeException (Code: 0) in ...\/ShopifyGraphQlClient.php:139"},"warnings":[]}
Exception bei product.push: Controller = Product | Action = push | JTL-Wawi PK = 5633 | SKU = Wert #5- | Name = Testeier aus Zürich Wert #5 | Error in response: [{"message":"Variable $options of type [OptionReorderInput!]! was provided invalid value","locations":[{"line":2,"column":29}],"extensions":{"value":null,"problems":[{"path":[],"explanation":"Expected value to not be null"}]}}]
Controller = Product | Action = push | JTL-Wawi PK = 5633 | SKU = Wert #5- | Name = Testeier aus Zürich Wert #5 | Error in response: [{"message":"Variable $options of type [OptionReorderInput!]! was provided invalid value","locations":[{"line":2,"column":29}],"extensions":{"value":null,"problems":[{"path":[],"explanation":"Expected value to not be null"}]}}]
Response: {"jtlrpc":"2.0","id":"42a17cbd11f745b9be9be6cd02fe685f","result":null,"error":{"code":0,"message":"Controller = Product | Action = push | JTL-Wawi PK = 5633 | SKU = Wert #5- | Name = Testeier aus Z\u00fcrich Wert #5 | Error in response: [{\u0022message\u0022:\u0022Variable $options of type [OptionReorderInput!]! was provided invalid value\u0022,\u0022locations\u0022:[{\u0022line\u0022:2,\u0022column\u0022:29}],\u0022extensions\u0022:{\u0022value\u0022:null,\u0022problems\u0022:[{\u0022path\u0022:[],\u0022explanation\u0022:\u0022Expected value to not be null\u0022}]}}]","data":"RuntimeException (Code: 0) in ...\/ShopifyGraphQlClient.php:139"},"warnings":[]}
bei jtlCore.ControllerClasses. Connector.Abgleich.Connector.wrYYYhwnpUc(String , Object , Boolean , NetworkCredential )
bei jtlCore.ControllerClasses.Connector.Abgleich.Connector.MKWYYb2HWbb(String , Object , Boolean , NetworkCredential , Boolean )
bei jtlCore.ControllerClasses.Connector.Abgleich.Connector.wrYYYhwnpUc(String , Object , Boolean , NetworkCredential )
2025-08-27T07:32:27 DEBUG -
SELECT * FROM
(
SELECT *
FROM (SELECT kTicket FROM Ticketsystem.tTicket) AS UserQuery
WHERE kTicket IN (SELECT tTicket.kTicket
FROM Ticketsystem.tTicket
WHERE 1 = 1
AND ( tTicket.kBenutzer_Bearbeiter IS NOT NULL OR tTicket.kBenutzer_Bearbeiter IS NULL ) AND ( tTicket.kStatus = 3 OR tTicket.kStatus <> 3 ))
AND kTicket IN (
SELECT ticket.kTicket
FROM Ticketsystem.tTicket ticket
WHERE ticket.nIstInPapierkorb = 0
)
AND kTicket IN (SELECT tTicket.kTicket
FROM Ticketsystem.tTicket
WHERE NOT EXISTS(SELECT kTicketLabel FROM Ticketsystem.tTicketLabel WHERE kTicket = tTicket.kTicket)
UNION
SELECT tTicketLabel.kTicket
FROM Ticketsystem.tTicketLabel
WHERE @p0 = 1
UNION
SELECT tTicketLabel.kTicket
FROM Ticketsystem.tTicketLabel
WHERE @p0 = 0
AND tTicketLabel.kLabel IN
(
SELECT tLabelBenutzergruppeRechte.kLabel
FROM Ticketsystem.tLabelBenutzergruppeRechte
WHERE tLabelBenutzergruppeRechte.kRechtBenutzerGruppe IN (
SELECT tRechtBenutzerGruppenZuordnung.kRechtBenutzerGruppe
FROM eazybusiness.dbo.tRechtBenutzerGruppenZuordnung
WHERE tRechtBenutzerGruppenZuordnung.kBenutzer = @p1
AND tLabelBenutzergruppeRechte.nIstSichtbar = 1
)
))
) AS InnerSql
ORDER BY ROW_NUMBER() OVER (ORDER BY kTicket)
OFFSET @page * 1000 ROWS FETCH NEXT 1000 + 1 ROWS ONLY
page = 0
@p0 = 1
@p1 = 1
2025-08-27T07:32:27 DEBUG - Dauer: 0ms, (bis zum Reader)
2025-08-27T07:32:27 DEBUG - Dauer: 0 ms, 0 Zeilen
2025-08-27T07:32:27 DEBUG -
SELECT tLabel.kLabel
FROM dbo.tLabel
WHERE tLabel.nTyp = @labelTyp
@labelTyp = Ticket
2025-08-27T07:32:27 DEBUG - Dauer: 0ms, (bis zum Reader)
2025-08-27T07:32:27 DEBUG - Dauer: 0 ms, 0 Zeilen
2025-08-27T07:32:27 DEBUG -
SELECT COUNT(tTicket.kTicket) AS UnseenChanges
FROM Ticketsystem.tTicket
WHERE tTicket.nIstInPapierkorb = 0
AND tTicket.nVollstaendigAngelegt = 1
AND tTicket.kTicket NOT IN (SELECT tTicketLabel.kTicket
FROM Ticketsystem.tTicketLabel)
AND (EXISTS (SELECT tAgentAngeseheneTickets.kAgentAngeseheneTickets
FROM Ticketsystem.tAgentAngeseheneTickets
WHERE tAgentAngeseheneTickets.kTicket = tTicket.kTicket
AND tAgentAngeseheneTickets.kBenutzer = @kBenutzer)
AND ((SELECT ISNULL(tAgentAngeseheneTickets.kNachricht, 0)
FROM Ticketsystem.tAgentAngeseheneTickets
WHERE tAgentAngeseheneTickets.kTicket = tTicket.kTicket
AND tAgentAngeseheneTickets.kBenutzer = @kBenutzer) < (SELECT ISNULL(MAX(tNachricht.kNachricht), 0)
FROM Ticketsystem.tNachricht
WHERE tNachricht.kTicket = tTicket.kTicket)
OR (SELECT ISNULL(tAgentAngeseheneTickets.kNotiz, 0)
FROM Ticketsystem.tAgentAngeseheneTickets
WHERE tAgentAngeseheneTickets.kTicket = tTicket.kTicket
AND tAgentAngeseheneTickets.kBenutzer = @kBenutzer) < (SELECT ISNULL(MAX(tNotiz.kNotiz), 0)
FROM Ticketsystem.tNotiz
WHERE tNotiz.kTicket = tTicket.kTicket)
OR (SELECT ISNULL(tAgentAngeseheneTickets.kTelefonat, 0)
FROM Ticketsystem.tAgentAngeseheneTickets
WHERE tAgentAngeseheneTickets.kTicket = tTicket.kTicket
AND tAgentAngeseheneTickets.kBenutzer = @kBenutzer) < (SELECT ISNULL(MAX(tTelefonat.kTelefonat), 0)
FROM Ticketsystem.tTelefonat
WHERE tTelefonat.kTicket = tTicket.kTicket))
OR NOT EXISTS (SELECT tAgentAngeseheneTickets.kAgentAngeseheneTickets
FROM Ticketsystem.tAgentAngeseheneTickets
WHERE tAgentAngeseheneTickets.kTicket = tTicket.kTicket
AND tAgentAngeseheneTickets.kBenutzer = @kBenutzer))
@kBenutzer = 1
@p0 = 0
2025-08-27T07:32:27 DEBUG - Dauer: 0ms, (bis zum Reader)
2025-08-27T07:32:27 DEBUG - Dauer: 0ms, 1 Zeilen
2025-08-27T07:32:28 DEBUG - SELECT [tUserSession].[kUserSession]
,[tUserSession].[kOwnerUserSession]
,[tUserSession].[kBenutzer]
,[tUserSession].[kMandant]
,[tUserSession].[iApplicationId]
,[tUserSession].[cCustomIdentifier]
,[tUserSession].[cHostname]
,[tUserSession].[nProcessId]
,[tUserSession].[dLoggedIn]
,[tUserSession].[dLastHeartbeat]
,[tUserSession].[nIsSessionInterruptible]
,[tUserSession].[nSessionInterruptRequested]
,[tUserSession].[dSessionInterruptRequestTimestamp]
,[tUserSession].[cSessionInterruptHostname]
,[tUserSession].[kSessionInterruptBenutzer]
,[tUserSession].[iSessionInterruptMessage]
,[tUser].[cName] AS [cBenutzerName]
,[tMandant].[cName] AS [cMandantName]
,[tUserInterrupt].[cName] AS [cBenutzerNameInterrupt]
FROM [eazybusiness].[dbo].[tUserSession]
LEFT JOIN [eazybusiness].[dbo].[tBenutzer] tUser ON [tUserSession].[kBenutzer] = [tUser].[kBenutzer]
LEFT JOIN [eazybusiness].[dbo].[tMandant] ON [tUserSession].[kMandant] = [tMandant].[kMandant]
LEFT JOIN [eazybusiness].[dbo].[tBenutzer] tUserInterrupt ON [tUserSession].[kSessionInterruptBenutzer] = [tUserInterrupt].[kBenutzer]
WHERE [tUserSession].[kUserSession] = @kUserSession AND dSessionInvalidated IS NULL
@kUserSession = 1310
2025-08-27T07:32:28 DEBUG - Dauer: 0ms, (bis zum Reader)(A)
2025-08-27T07:32:28 DEBUG - Dauer: 5 ms, 1 Zeilen
2025-08-27T07:32:28 DEBUG - UPDATE [eazybusiness].[dbo].[tUserSession] SET dLastHeartbeat = @dLastHeartbeat_0 WHERE kUserSession = @kUserSession_0;
@dLastHeartbeat_0 = 08/27/2025 07:32:28 +02:00
@kUserSession_0 = 1310
2025-08-27T07:32:28 DEBUG - Dauer: 0ms, AffectedRows: 1
2025-08-27T07:32:57 DEBUG -
SELECT * FROM
(
SELECT *
FROM (SELECT kTicket FROM Ticketsystem.tTicket) AS UserQuery
WHERE kTicket IN (SELECT tTicket.kTicket
FROM Ticketsystem.tTicket
WHERE 1 = 1
AND ( tTicket.kBenutzer_Bearbeiter IS NOT NULL OR tTicket.kBenutzer_Bearbeiter IS NULL ) AND ( tTicket.kStatus = 3 OR tTicket.kStatus <> 3 ))
AND kTicket IN (
SELECT ticket.kTicket
FROM Ticketsystem.tTicket ticket
WHERE ticket.nIstInPapierkorb = 0
)
AND kTicket IN (SELECT tTicket.kTicket
FROM Ticketsystem.tTicket
WHERE NOT EXISTS(SELECT kTicketLabel FROM Ticketsystem.tTicketLabel WHERE kTicket = tTicket.kTicket)
UNION
SELECT tTicketLabel.kTicket
FROM Ticketsystem.tTicketLabel
WHERE @p0 = 1
UNION
SELECT tTicketLabel.kTicket
FROM Ticketsystem.tTicketLabel
WHERE @p0 = 0
AND tTicketLabel.kLabel IN
(
SELECT tLabelBenutzergruppeRechte.kLabel
FROM Ticketsystem.tLabelBenutzergruppeRechte
WHERE tLabelBenutzergruppeRechte.kRechtBenutzerGruppe IN (
SELECT tRechtBenutzerGruppenZuordnung.kRechtBenutzerGruppe
FROM eazybusiness.dbo.tRechtBenutzerGruppenZuordnung
WHERE tRechtBenutzerGruppenZuordnung.kBenutzer = @p1
AND tLabelBenutzergruppeRechte.nIstSichtbar = 1
)
))
) AS InnerSql
ORDER BY ROW_NUMBER() OVER (ORDER BY kTicket)
OFFSET @page * 1000 ROWS FETCH NEXT 1000 + 1 ROWS ONLY
page = 0
@p0 = 1
@p1 = 1
2025-08-27T07:32:57 DEBUG - Dauer: 0ms, (bis zum Reader)
2025-08-27T07:32:57 DEBUG - Dauer: 0 ms, 0 Zeilen
2025-08-27T07:32:57 DEBUG -
SELECT tLabel.kLabel
FROM dbo.tLabel
WHERE tLabel.nTyp = @labelTyp
@labelTyp = Ticket
2025-08-27T07:32:57 DEBUG - Dauer: 0ms, (bis zum Reader)
2025-08-27T07:32:57 DEBUG - Dauer: 0 ms, 0 Zeilen
2025-08-27T07:32:57 DEBUG -
SELECT COUNT(tTicket.kTicket) AS UnseenChanges
FROM Ticketsystem.tTicket
WHERE tTicket.nIstInPapierkorb = 0
AND tTicket.nVollstaendigAngelegt = 1
AND tTicket.kTicket NOT IN (SELECT tTicketLabel.kTicket
FROM Ticketsystem.tTicketLabel)
AND (EXISTS (SELECT tAgentAngeseheneTickets.kAgentAngeseheneTickets
FROM Ticketsystem.tAgentAngeseheneTickets
WHERE tAgentAngeseheneTickets.kTicket = tTicket.kTicket
AND tAgentAngeseheneTickets.kBenutzer = @kBenutzer)
AND ((SELECT ISNULL(tAgentAngeseheneTickets.kNachricht, 0)
FROM Ticketsystem.tAgentAngeseheneTickets
WHERE tAgentAngeseheneTickets.kTicket = tTicket.kTicket
AND tAgentAngeseheneTickets.kBenutzer = @kBenutzer) < (SELECT ISNULL(MAX(tNachricht.kNachricht), 0)
FROM Ticketsystem.tNachricht
WHERE tNachricht.kTicket = tTicket.kTicket)
OR (SELECT ISNULL(tAgentAngeseheneTickets.kNotiz, 0)
FROM Ticketsystem.tAgentAngeseheneTickets
WHERE tAgentAngeseheneTickets.kTicket = tTicket.kTicket
AND tAgentAngeseheneTickets.kBenutzer = @kBenutzer) < (SELECT ISNULL(MAX(tNotiz.kNotiz), 0)
FROM Ticketsystem.tNotiz
WHERE tNotiz.kTicket = tTicket.kTicket)
OR (SELECT ISNULL(tAgentAngeseheneTickets.kTelefonat, 0)
FROM Ticketsystem.tAgentAngeseheneTickets
WHERE tAgentAngeseheneTickets.kTicket = tTicket.kTicket
AND tAgentAngeseheneTickets.kBenutzer = @kBenutzer) < (SELECT ISNULL(MAX(tTelefonat.kTelefonat), 0)
FROM Ticketsystem.tTelefonat
WHERE tTelefonat.kTicket = tTicket.kTicket))
OR NOT EXISTS (SELECT tAgentAngeseheneTickets.kAgentAngeseheneTickets
FROM Ticketsystem.tAgentAngeseheneTickets
WHERE tAgentAngeseheneTickets.kTicket = tTicket.kTicket
AND tAgentAngeseheneTickets.kBenutzer = @kBenutzer))
@kBenutzer = 1
@p0 = 0
2025-08-27T07:32:57 DEBUG - Dauer: 0ms, (bis zum Reader)
2025-08-27T07:32:57 DEBUG - Dauer: 0ms, 1 Zeilen
2025-08-27T07:32:58 DEBUG - UPDATE dbo.tArtikelShop
SET dbo.tArtikelShop.nInBearbeitung = 0
WHERE dbo.tArtikelShop.kShop = 2
AND dbo.tArtikelShop.nInBearbeitung = 1
2025-08-27T07:32:58 DEBUG - Dauer: 7ms, AffectedRows: 1
Zeitstempel: 2025-08-27T07:33:05
Locale: German (Germany)
Locale: German (Germany)
Version: Der Wert wurde nicht erstellt.
Plattform: Wawi
WawiSeed: 1.7.52730.82701
Prozessname: JTL-Wawi
Physikalischer Speicher: 1072242688 / Peak: 1084600320
Basispriorität: 8
Prioritätsklasse: Normal
CPU-Zeit (User): 1:42:19,359375
CPU-Zeit (System): 0:38:37,34375
Page-Size (Sytem): 4217648 / Peak: 1664946176
Page-Size: 1651732480 / Peak: 1664946176
Offene Handles: 30747
Database:
Build: 2406071237 b0445162e2f9cb09f437bfde13d8c428f922da12
