Neu Kein Datenabgleich zu Shopware 5.5.4

[Timme]

Hallo Zusammen,

seit dem 28.12.23 werden keine Daten mehr über den Connector zur Wawi übermittelt.

JTL Wawi 1.8.91
Shopware 5 Version 5.5.4
JTL Connector Version 2.2.5.3 laut Shopware Webaccount die höchste Version, welche mit der 5.5.4 kompatibel ist.
PHP: 7.4.33

Ich habe den Connector bereits nochmal neu aufgesetzt und in der Wawi neu eingerichtet. Verbindungstest erfolgreich durchgeführt.

Bei einem Abgleich wird einmal alles abgeglichen, was mehrere Stunden dauert, aber es kommen keine neuen Bestellungen / Kunden rein.

Im Log steht nichts, also es ist rein gar nichts hinterlegt.

 

[Timme]

Es lag an der Verletzung der UNIQUE KEY-Einschränkung. Bin dann im Forum auf die Lösung gekommen.

-closed-

 

[Timme]

Anscheinend läuft es doch noch nicht ganz rund.

Aufträge werden mittlerweile per Connector importiert, aber die Sendungsdaten bzw. die Auftragsänderung nicht mehr zurück die Shopware exportiert.

Shopware Fehlerlog

2024-01-02 23:07:30] global.INFO: (E_USER_DEPRECATED) File (/var/www/clients/client1/web2/web/vendor/symfony/dependency-injection/Container.php, 282): The "events" service is private, getting it from the container is deprecated since Symfony 3.2 and will fail in 4.0. You should either make the service public, or stop using the container directly and use dependency injection instead. [] []
[2024-01-02 23:07:30] global.INFO: (E_USER_DEPRECATED) File (/var/www/clients/client1/web2/web/vendor/symfony/dependency-injection/Container.php, 282): The "legacy_documentid_converter" service is private, getting it from the container is deprecated since Symfony 3.2 and will fail in 4.0. You should either make the service public, or stop using the container directly and use dependency injection instead. [] []
[2024-01-02 23:07:30] global.NOTICE: (E_NOTICE) File (/var/www/clients/client1/web2/web/engine/Shopware/Plugins/Community/Frontend/jtlconnector/src/Controller/CustomerOrder.php, 111): Trying to access array offset on value of type null [] []
[2024-01-02 23:07:30] global.NOTICE: (E_NOTICE) File (/var/www/clients/client1/web2/web/engine/Shopware/Plugins/Community/Frontend/jtlconnector/src/Controller/CustomerOrder.php, 111): Trying to access array offset on value of type null [] []
[2024-01-02 23:07:30] global.NOTICE: (E_NOTICE) File (/var/www/clients/client1/web2/web/engine/Shopware/Plugins/Community/Frontend/jtlconnector/src/Controller/CustomerOrder.php, 114): Trying to access array offset on value of type null [] []
[2024-01-02 23:07:30] global.NOTICE: (E_NOTICE) File (/var/www/clients/client1/web2/web/engine/Shopware/Plugins/Community/Frontend/jtlconnector/src/Mapper/PrimaryKeyMapper.php, 26): Undefined offset: 1 [] []
[2024-01-02 23:07:30] global.NOTICE: (E_NOTICE) File (/var/www/clients/client1/web2/web/engine/Shopware/Plugins/Community/Frontend/jtlconnector/src/Mapper/PrimaryKeyMapper.php, 26): Undefined offset: 1 [] []
[2024-01-02 23:07:38] global.NOTICE: (E_NOTICE) File (/var/www/clients/client1/web2/web/vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/DocParser.php, 995): Trying to access array offset on value of type null [] []
[2024-01-02 23:07:38] global.NOTICE: (E_NOTICE) File (/var/www/clients/client1/web2/web/vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/DocParser.php, 995): Trying to access array offset on value of type null [] []
[2024-01-02 23:07:38] global.NOTICE: (E_NOTICE) File (/var/www/clients/client1/web2/web/vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/DocParser.php, 995): Trying to access array offset on value of type null [] []
[2024-01-02 23:07:39] global.INFO: (E_USER_DEPRECATED) File (/var/www/clients/client1/web2/web/vendor/symfony/dependency-injection/Container.php, 282): The "events" service is private, getting it from the container is deprecated since Symfony 3.2 and will fail in 4.0. You should either make the service public, or stop using the container directly and use dependency injection instead. [] []
[2024-01-02 23:07:39] global.INFO: (E_USER_DEPRECATED) File (/var/www/clients/client1/web2/web/vendor/symfony/dependency-injection/Container.php, 282): The "legacy_documentid_converter" service is private, getting it from the container is deprecated since Symfony 3.2 and will fail in 4.0. You should either make the service public, or stop using the container directly and use dependency injection instead. [] []
[2024-01-02 23:07:39] global.NOTICE: (E_NOTICE) File (/var/www/clients/client1/web2/web/engine/Shopware/Plugins/Community/Frontend/jtlconnector/src/Controller/CustomerOrder.php, 111): Trying to access array offset on value of type null [] []
[2024-01-02 23:07:39] global.NOTICE: (E_NOTICE) File (/var/www/clients/client1/web2/web/engine/Shopware/Plugins/Community/Frontend/jtlconnector/src/Controller/CustomerOrder.php, 111): Trying to access array offset on value of type null [] []
[2024-01-02 23:07:39] global.NOTICE: (E_NOTICE) File (/var/www/clients/client1/web2/web/engine/Shopware/Plugins/Community/Frontend/jtlconnector/src/Controller/CustomerOrder.php, 114): Trying to access array offset on value of type null [] []

JTL Fehlerlog

Unbehandelte Ausnahme #959190594F6282F vom Typ System.Exception in
System.Exception: Exception: Session is invalid
The EntityManager is closed.


Unbehandelte Ausnahme #959190594F6282F vom Typ System.Exception in : Versand/Zahlung-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 status_change.push: Session is invalid

The EntityManager is closed.

Response: {"result":[],"error":{"code":0,"message":"The EntityManager is closed.","data":null},"jtlrpc":"2.0","id":"5d2xxx"}
Exception bei status_change.push: Session is invalid

The EntityManager is closed.

Response: {"result":[],"error":{"code":0,"message":"The EntityManager is closed.","data":null},"jtlrpc":"2.0","id":"c4exxxx"}
bei jtlCore.ControllerClasses.Connector.Abgleich.Connector.C5Pwl64bVIS(String , Object , Boolean , NetworkCredential )
bei jtlCore.ControllerClasses.Connector.Abgleich.Connector.MAwwlB13Goe(String , Object , Boolean , NetworkCredential , Boolean )
bei jtlCore.ControllerClasses.Connector.Abgleich.Connector.C5Pwl64bVIS(String , Object , Boolean , NetworkCredential )




2024-01-03T04:09:46 DEBUG - Dauer: 16ms, (bis zum Reader)(A)
2024-01-03T04:09:46 DEBUG - Dauer: 16 ms, 1 Zeilen
2024-01-03T04:09:46 DEBUG - UPDATE [eazybusiness].[dbo].[tUserSession] SET dLastHeartbeat = @dLastHeartbeat_0 WHERE kUserSession = @kUserSession_0;

@dLastHeartbeat_0 = 01/03/2024 04:09:46 +01:00
@kUserSession_0 = 65
2024-01-03T04:09:46 DEBUG - Dauer: 29ms, AffectedRows: 1
2024-01-03T04:10:46 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 = 65
2024-01-03T04:10:46 DEBUG - Dauer: 16ms, (bis zum Reader)(A)
2024-01-03T04:10:46 DEBUG - Dauer: 17 ms, 1 Zeilen
2024-01-03T04:10:46 DEBUG - UPDATE [eazybusiness].[dbo].[tUserSession] SET dLastHeartbeat = @dLastHeartbeat_0 WHERE kUserSession = @kUserSession_0;

@dLastHeartbeat_0 = 01/03/2024 04:10:46 +01:00
@kUserSession_0 = 65
2024-01-03T04:10:46 DEBUG - Dauer: 15ms, AffectedRows: 1
2024-01-03T04:11:46 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 = 65
2024-01-03T04:11:46 DEBUG - Dauer: 15ms, (bis zum Reader)(A)
2024-01-03T04:11:46 DEBUG - Dauer: 15 ms, 1 Zeilen
2024-01-03T04:11:46 DEBUG - UPDATE [eazybusiness].[dbo].[tUserSession] SET dLastHeartbeat = @dLastHeartbeat_0 WHERE kUserSession = @kUserSession_0;

@dLastHeartbeat_0 = 01/03/2024 04:11:46 +01:00
@kUserSession_0 = 65
2024-01-03T04:11:46 DEBUG - Dauer: 15ms, AffectedRows: 1
2024-01-03T04:12:46 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 = 65
2024-01-03T04:12:46 DEBUG - Dauer: 15ms, (bis zum Reader)(A)
2024-01-03T04:12:46 DEBUG - Dauer: 19 ms, 1 Zeilen
2024-01-03T04:12:46 DEBUG - UPDATE [eazybusiness].[dbo].[tUserSession] SET dLastHeartbeat = @dLastHeartbeat_0 WHERE kUserSession = @kUserSession_0;

@dLastHeartbeat_0 = 01/03/2024 04:12:46 +01:00
@kUserSession_0 = 65
2024-01-03T04:12:46 DEBUG - Dauer: 15ms, AffectedRows: 1
2024-01-03T04:13:32 DEBUG - [TableTable] Eintrag TableCache.toptions entfernt - Expired
2024-01-03T04:13:46 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 = 65
2024-01-03T04:13:46 DEBUG - Dauer: 16ms, (bis zum Reader)(A)
2024-01-03T04:13:46 DEBUG - Dauer: 17 ms, 1 Zeilen
2024-01-03T04:13:46 DEBUG - UPDATE [eazybusiness].[dbo].[tUserSession] SET dLastHeartbeat = @dLastHeartbeat_0 WHERE kUserSession = @kUserSession_0;

@dLastHeartbeat_0 = 01/03/2024 04:13:46 +01:00
@kUserSession_0 = 65
2024-01-03T04:13:46 DEBUG - Dauer: 15ms, AffectedRows: 1
Zeitstempel: 2024-01-03T04:14:38
Locale: German (Germany)
Locale: German (Germany)
Version: 1.8.9.1
Plattform: Wawi
WawiSeed: 1.5.30405.72001
Prozessname: JTL-Wawi
Physikalischer Speicher: 657956864 / Peak: 1581432832
Basispriorität: 8
Prioritätsklasse: Normal
CPU-Zeit (User): 0:17:01,578125
CPU-Zeit (System): 0:04:46,578125
Page-Size (Sytem): 2670168 / Peak: 1595834368
Page-Size: 705327104 / Peak: 1595834368
Offene Handles: 2580
Database:
Build: 2311301555 d8999b5bxxx

 

[Timme]

Wenn ich bei Shopware die Bestellungen einzeln auf komplett ausgeliefert setzen möchte, kommt folgende Fehlermeldung

Fehler
Beim Speichern der Bestellung 116762 ist ein Fehler aufgetreten.
An exception occurred while executing 'UPDATE s_order SET invoice_shipping = ?, invoice_shipping_net = ?, invoice_shipping_tax_rate = ?, ordertime = ?, cleareddate = ?, currencyfactor = ?, deviceType = ?, status = ?, changed = ? WHERE id = ?' with params [0, 0, 19, "2023-12-28 17:31:56", "2023-12-28 00:00:00", 1, "", 2, "2024-01-03 09:14:21", 102872]: SQLSTATE[42S02]: Base table or view not found: 1146 Table '[Datenbank].jtl_connector_payment' doesn't exist