Hallo zusammen,
ich nutze seit Monaten den Shopify- Connector mit JTL-Wawi. Seit heute bekomme ich beim Abgleich folgende Fehlermeldung.
Der Fehler tritt nur beim Senden von Lieferscheinen auf. Bis gestern lief alles problemlos. Ich habe keine Änderungen am System oder der Datenbank vorgenommen. Kann es sein, dass ein einzelner Lieferschein oder ein fehlerhafter Fulfillment-Eintrag den Fehler verursacht? Hat jemand das gleiche Problem gehabt oder eine Lösung?
ich nutze seit Monaten den Shopify- Connector mit JTL-Wawi. Seit heute bekomme ich beim Abgleich folgende Fehlermeldung.
Der Fehler tritt nur beim Senden von Lieferscheinen auf. Bis gestern lief alles problemlos. Ich habe keine Änderungen am System oder der Datenbank vorgenommen. Kann es sein, dass ein einzelner Lieferschein oder ein fehlerhafter Fulfillment-Eintrag den Fehler verursacht? Hat jemand das gleiche Problem gehabt oder eine Lösung?
Unbehandelte Ausnahme #959190594F6282F vom Typ System.Exception in
System.Exception: Exception: An exception occurred while executing 'SELECT fulfillment_id FROM delivery_note WHERE (host_id = ?) AND (credentials_id = ?)' with params [640, 9979]:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'shopify_connector_98635.delivery_note' doesn't exist
An exception occurred while executing 'SELECT fulfillment_id FROM delivery_note WHERE (host_id = ?) AND (credentials_id = ?)' with params [640, 9979]:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'shopify_connector_98635.delivery_note' doesn't exist
Unbehandelte Ausnahme #959190594F6282F vom Typ System.Exception in : Lieferscheine-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 delivery_note.push: An exception occurred while executing 'SELECT fulfillment_id FROM delivery_note WHERE (host_id = ?) AND (credentials_id = ?)' with params [640, 9979]:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'shopify_connector_98635.delivery_note' doesn't exist
An exception occurred while executing 'SELECT fulfillment_id FROM delivery_note WHERE (host_id = ?) AND (credentials_id = ?)' with params [640, 9979]:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'shopify_connector_98635.delivery_note' doesn't exist
Response: {"jtlrpc":"2.0","id":"8f0ccd86480c4c21bb4a4e4dcdd488ca","result":null,"error":{"code":0,"message":"An exception occurred while executing \u0027SELECT fulfillment_id FROM delivery_note WHERE (host_id = ?) AND (credentials_id = ?)\u0027 with params [640, 9979]:\n\nSQLSTATE[42S02]: Base table or view not found: 1146 Table \u0027shopify_connector_98635.delivery_note\u0027 doesn\u0027t exist","data":"Doctrine\\DBAL\\Exception\\TableNotFoundException (Code: 0) in ...\/AbstractMySQLDriver.php:61"},"warnings":[]}
Exception bei delivery_note.push: An exception occurred while executing 'SELECT fulfillment_id FROM delivery_note WHERE (host_id = ?) AND (credentials_id = ?)' with params [640, 9979]:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'shopify_connector_98635.delivery_note' doesn't exist
An exception occurred while executing 'SELECT fulfillment_id FROM delivery_note WHERE (host_id = ?) AND (credentials_id = ?)' with params [640, 9979]:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'shopify_connector_98635.delivery_note' doesn't exist
Response: {"jtlrpc":"2.0","id":"095c4c36b701430197b364318160aae5","result":null,"error":{"code":0,"message":"An exception occurred while executing \u0027SELECT fulfillment_id FROM delivery_note WHERE (host_id = ?) AND (credentials_id = ?)\u0027 with params [640, 9979]:\n\nSQLSTATE[42S02]: Base table or view not found: 1146 Table \u0027shopify_connector_98635.delivery_note\u0027 doesn\u0027t exist","data":"Doctrine\\DBAL\\Exception\\TableNotFoundException (Code: 0) in ...\/AbstractMySQLDriver.php:61"},"warnings":[]}
bei jtlCore.ControllerClasses.Connector.Abgleich.Connector.NFYXjxeQKrN(String , Object , Boolean , NetworkCredential )
bei jtlCore.ControllerClasses.Connector.Abgleich.Connector.y0rXj3vdilN(String , Object , Boolean , NetworkCredential , Boolean )
bei jtlCore.ControllerClasses.Connector.Abgleich.Connector.NFYXjxeQKrN(String , Object , Boolean , NetworkCredential )
2025-07-29T10:15:00 DEBUG - Dauer: 0ms, 3 Zeilen
2025-07-29T10:15:00 DEBUG -
SELECT Parcels.TrackingURL, Parcels.InternalId
FROM Report.Parcels
WHERE Parcels.InternalId IN (792, 798, 799)
2025-07-29T10:15:00 DEBUG - Dauer: 0ms, (bis zum Reader)
2025-07-29T10:15:00 DEBUG - Dauer: 0 ms, 3 Zeilen
2025-07-29T10:15:00 DEBUG - SELECT * FROM [tversandart] WHERE [kVersandArt] = @kVersandArt
@kVersandArt = 10
2025-07-29T10:15:00 DEBUG - Dauer: 0ms, (bis zum Reader)
2025-07-29T10:15:00 DEBUG - Dauer: 0ms, 1 Zeilen
2025-07-29T10:15:00 DEBUG - SELECT * FROM [tversandart] WHERE [kVersandArt] = @kVersandArt
@kVersandArt = 10
2025-07-29T10:15:00 DEBUG - Dauer: 0ms, (bis zum Reader)
2025-07-29T10:15:00 DEBUG - Dauer: 0ms, 1 Zeilen
2025-07-29T10:15:00 DEBUG - SELECT * FROM [tversandart] WHERE [kVersandArt] = @kVersandArt
@kVersandArt = 10
2025-07-29T10:15:00 DEBUG - Dauer: 0ms, (bis zum Reader)
2025-07-29T10:15:00 DEBUG - Dauer: 0ms, 1 Zeilen
2025-07-29T10:15:01 ERROR - Exception: An exception occurred while executing 'SELECT fulfillment_id FROM delivery_note WHERE (host_id = ?) AND (credentials_id = ?)' with params [640, 9979]:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'shopify_connector_98635.delivery_note' doesn't exist
An exception occurred while executing 'SELECT fulfillment_id FROM delivery_note WHERE (host_id = ?) AND (credentials_id = ?)' with params [640, 9979]:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'shopify_connector_98635.delivery_note' doesn't exist
2025-07-29T10:15:01 ERROR - Lieferscheine-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 delivery_note.push: An exception occurred while executing 'SELECT fulfillment_id FROM delivery_note WHERE (host_id = ?) AND (credentials_id = ?)' with params [640, 9979]:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'shopify_connector_98635.delivery_note' doesn't exist
An exception occurred while executing 'SELECT fulfillment_id FROM delivery_note WHERE (host_id = ?) AND (credentials_id = ?)' with params [640, 9979]:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'shopify_connector_98635.delivery_note' doesn't exist
Response: {"jtlrpc":"2.0","id":"8f0ccd86480c4c21bb4a4e4dcdd488ca","result":null,"error":{"code":0,"message":"An exception occurred while executing \u0027SELECT fulfillment_id FROM delivery_note WHERE (host_id = ?) AND (credentials_id = ?)\u0027 with params [640, 9979]:\n\nSQLSTATE[42S02]: Base table or view not found: 1146 Table \u0027shopify_connector_98635.delivery_note\u0027 doesn\u0027t exist","data":"Doctrine\\DBAL\\Exception\\TableNotFoundException (Code: 0) in ...\/AbstractMySQLDriver.php:61"},"warnings":[]}
Exception bei delivery_note.push: An exception occurred while executing 'SELECT fulfillment_id FROM delivery_note WHERE (host_id = ?) AND (credentials_id = ?)' with params [640, 9979]:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'shopify_connector_98635.delivery_note' doesn't exist
An exception occurred while executing 'SELECT fulfillment_id FROM delivery_note WHERE (host_id = ?) AND (credentials_id = ?)' with params [640, 9979]:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'shopify_connector_98635.delivery_note' doesn't exist
Response: {"jtlrpc":"2.0","id":"095c4c36b701430197b364318160aae5","result":null,"error":{"code":0,"message":"An exception occurred while executing \u0027SELECT fulfillment_id FROM delivery_note WHERE (host_id = ?) AND (credentials_id = ?)\u0027 with params [640, 9979]:\n\nSQLSTATE[42S02]: Base table or view not found: 1146 Table \u0027shopify_connector_98635.delivery_note\u0027 doesn\u0027t exist","data":"Doctrine\\DBAL\\Exception\\TableNotFoundException (Code: 0) in ...\/AbstractMySQLDriver.php:61"},"warnings":[]}
bei jtlCore.ControllerClasses.Connector.Abgleich.Connector.NFYXjxeQKrN(String , Object , Boolean , NetworkCredential )
bei jtlCore.ControllerClasses.Connector.Abgleich.Connector.y0rXj3vdilN(String , Object , Boolean , NetworkCredential , Boolean )
bei jtlCore.ControllerClasses.Connector.Abgleich.Connector.NFYXjxeQKrN(String , Object , Boolean , NetworkCredential )
2025-07-29T10:15:01 DEBUG -
DELETE FROM dbo.tUniqueSession WHERE cContext = @cContext
@cContext = 'ConnectorAbgleich'
2025-07-29T10:15:01 DEBUG - Dauer: 1ms, AffectedRows: 1
2025-07-29T10:15:01 INFO - Onlineshop-Abgleich beendet für 'Zooino.de'.
2025-07-29T10:15:01 DEBUG - Dauer: 4 ms, 7 Zeilen
2025-07-29T10:15:02 DEBUG - UPDATE [tSessionId] SET dLastAction = GETDATE() WHERE kSessionId = @kSessionId
@kSessionId = 1224
2025-07-29T10:15:02 DEBUG - Dauer: 1ms, AffectedRows: 1
2025-07-29T10:15:09 DEBUG - UPDATE [tSessionId] SET dLastAction = GETDATE() WHERE kSessionId = @kSessionId
@kSessionId = 1232
2025-07-29T10:15:09 DEBUG - Dauer: 1ms, AffectedRows: 1
2025-07-29T10:15:12 DEBUG - UPDATE [tSessionId] SET dLastAction = GETDATE() WHERE kSessionId = @kSessionId
@kSessionId = 1257
2025-07-29T10:15:12 DEBUG - Dauer: 1ms, AffectedRows: 1
Zeitstempel: 2025-07-29T10:15:15
Locale: German (Germany)
Locale: German (Germany)
Version: 1.10.12.0
Plattform: Wawi
WawiSeed: 1.5.89675.01301
Prozessname: JTL-Wawi
Physikalischer Speicher: 2130333696 / Peak: 2153840640
Basispriorität: 8
Prioritätsklasse: Normal
CPU-Zeit (User): 0:39:58,421875
CPU-Zeit (System): 0:07:19,171875
Page-Size (Sytem): 3507776 / Peak: 2015248384
Page-Size: 1986080768 / Peak: 2015248384
Offene Handles: 5731
Database:
Build: 2506111240 481141785179224542bba5fbdd7df399740b5369
