Moin zusammen,
seit heute morgen wurden keine Bestellungen von Shopware zu JTL übertragen, habe den Worker mal deaktiviert und mal versucht manuell abzugleichen, kam die folgende Fehlermeldung in der Zusammenfassung, sagt mir leider nicht viel
JTL Version 1.2.3.7
Connecotr Version: 2.1.3
Shopware Version: 5.3.4
Bisher lief es immer problemlos, war auch heute morgen alles auf grün als ich im Dashboard nach dem Worker geschaut habe....
NACHTRAG, ich musste die Fehlermeldung kürzen, da das Forum wohl nur 1000 Zeichen erlaubt....
Fehler:
Exception: An exception occurred while executing 'SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT s0_.id AS id_0, s0_.ordernumber AS ordernumber_1, s0_.userID AS userID_2, s0_.status AS status_3, s0_.cleared AS cleared_4, s0_.paymentID AS paymentID_5, s0_.dispatchID AS dispatchID_6, s0_.partnerID AS partnerID_7, s0_.subshopID AS subshopID_8, s0_.invoice_amount AS invoice_amount_9, s0_.invoice_amount_net AS invoice_amount_net_10, s0_.invoice_shipping AS invoice_shipping_11, s0_.invoice_shipping_net AS invoice_shipping_net_12, s0_.ordertime AS ordertime_13, s0_.transactionID AS transactionID_14, s0_.comment AS comment_15, s0_.customercomment AS customercomment_16, s0_.internalcomment AS internalcomment_17, s0_.net AS net_18, s0_.taxfree AS taxfree_19, s0_.temporaryID AS temporaryID_20, s0_.referer AS referer_21, s0_.cleareddate AS cleareddate_22, s0_.trackingcode AS trackingcode_23, s0_.language AS language_24, s0_.currency AS currency_25, s0_.currencyfactor AS currencyfactor_26, s0_.remote_addr AS remote_addr_27, s0_.deviceType AS deviceType_28, s1_.customernumber AS customernumber_29, s1_.id AS id_30, s1_.paymentID AS paymentID_31, s1_.customergroup AS customergroup_32, s1_.subshopID AS subshopID_33, s1_.pricegroupID AS pricegroupID_34, s1_.encoder AS encoder_35, s1_.password AS password_36, s1_.active AS active_37, s1_.email AS email_38, s1_.firstlogin AS firstlogin_39, s1_.lastlogin AS lastlogin_40, s1_.accountmode AS accountmode_41, s1_.confirmationkey AS confirmationkey_42, s1_.sessionID AS sessionID_43, s1_.newsletter AS newsletter_44, s1_.validation AS validation_45, s1_.affiliate AS affiliate_46, s1_.paymentpreset AS paymentpreset_47, s1_.language AS language_48, s1_.referer AS referer_49, s1_.internalcomment AS internalcomment_50, s1_.failedlogins AS failedlogins_51, s1_.lockedUntil AS lockedUntil_52, s1_.salutation AS salutation_53, s1_.title AS title_54, s1_.firstname AS firstname_55, s1_.lastname AS lastname_56, s1_.birthday AS birthday_57, s2_.title AS title_58, s2_.stateID AS stateID_59, s2_.additional_address_line1 AS additional_address_line1_60, s2_.additional_address_line2 AS additional_address_line2_61, s2_.id AS id_62, s2_.userID AS userID_63, s2_.company AS company_64, s2_.department AS department_65, s2_.salutation AS salutation_66, s2_.firstname AS firstname_67, s2_.lastname AS lastname_68, s2_.street AS street_69, s2_.zipcode AS zipcode_70, s2_.city AS city_71, s2_.countryID AS countryID_72, s3_.id AS id_73, s3_.shippingID AS shippingID_74, s3_.text1 AS text1_75, s3_.text2 AS text2_76, s3_.text3 AS text3_77, s3_.text4 AS text4_78, s3_.text5 AS text5_79, s3_.text6 AS text6_80, s4_.payment_mean_id AS payment_mean_id_81, s4_.use_billing_data AS use_billing_data_82, s4_.bankname AS bankname_83, s4_.bic AS bic_84, s4_.iban AS iban_85, s4_.account_number AS account_number_86, s4_.bank_code AS bank_code_87, s4_.account_holder AS account_holder_88, s4_.created_at AS created_at_89, s4_.id AS id_90, s5_.id AS id_91, s5_.orderID AS orderID_92, s5_.attribute1 AS attribute1_93, s5_.attribute2 AS attribute2_94, s5_.attribute3 AS attribute3_95, s5_.attribute4 AS attribute4_96, s5_.attribute5 AS attribute5_97, s5_.attribute6 AS attribute6_98, s5_.bepado_shop_id AS bepado_shop_id_99, s5_.bepado_order_id AS bepado_order_id_100, s5_.bestit_amazon_capture_id AS bestit_amazon_capture_id_101, s5_.bestit_amazon_capture_reference AS bestit_amazon_capture_reference_102, s5_.bestit_amazon_authorization_id AS bestit_amazon_authorization_id_103, s5_.bestit_amazon_authorisation_reference AS bestit_amazon_authorisation_reference_104, s5_.bestit_amazon_refund_id AS bestit_amazon_refund_id_105, s5_.bestit_amazon_refund_reference AS bestit_amazon_refund_reference_106, s5_.bestit_amazon_cancel AS bestit_amazon_cancel_107, s5_.bestit_amazon_invoice_amount AS bestit_amazon_invoice_amount_108, s5_.bestit_amazon_simulation_code AS bestit_amazon_simulation_code_109, s5_.swag_payal_billing_agreement_id AS swag_payal_billing_agreement_id_110, s5_.swag_payal_express AS s
seit heute morgen wurden keine Bestellungen von Shopware zu JTL übertragen, habe den Worker mal deaktiviert und mal versucht manuell abzugleichen, kam die folgende Fehlermeldung in der Zusammenfassung, sagt mir leider nicht viel
JTL Version 1.2.3.7
Connecotr Version: 2.1.3
Shopware Version: 5.3.4
Bisher lief es immer problemlos, war auch heute morgen alles auf grün als ich im Dashboard nach dem Worker geschaut habe....
NACHTRAG, ich musste die Fehlermeldung kürzen, da das Forum wohl nur 1000 Zeichen erlaubt....
Fehler:
Exception: An exception occurred while executing 'SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT s0_.id AS id_0, s0_.ordernumber AS ordernumber_1, s0_.userID AS userID_2, s0_.status AS status_3, s0_.cleared AS cleared_4, s0_.paymentID AS paymentID_5, s0_.dispatchID AS dispatchID_6, s0_.partnerID AS partnerID_7, s0_.subshopID AS subshopID_8, s0_.invoice_amount AS invoice_amount_9, s0_.invoice_amount_net AS invoice_amount_net_10, s0_.invoice_shipping AS invoice_shipping_11, s0_.invoice_shipping_net AS invoice_shipping_net_12, s0_.ordertime AS ordertime_13, s0_.transactionID AS transactionID_14, s0_.comment AS comment_15, s0_.customercomment AS customercomment_16, s0_.internalcomment AS internalcomment_17, s0_.net AS net_18, s0_.taxfree AS taxfree_19, s0_.temporaryID AS temporaryID_20, s0_.referer AS referer_21, s0_.cleareddate AS cleareddate_22, s0_.trackingcode AS trackingcode_23, s0_.language AS language_24, s0_.currency AS currency_25, s0_.currencyfactor AS currencyfactor_26, s0_.remote_addr AS remote_addr_27, s0_.deviceType AS deviceType_28, s1_.customernumber AS customernumber_29, s1_.id AS id_30, s1_.paymentID AS paymentID_31, s1_.customergroup AS customergroup_32, s1_.subshopID AS subshopID_33, s1_.pricegroupID AS pricegroupID_34, s1_.encoder AS encoder_35, s1_.password AS password_36, s1_.active AS active_37, s1_.email AS email_38, s1_.firstlogin AS firstlogin_39, s1_.lastlogin AS lastlogin_40, s1_.accountmode AS accountmode_41, s1_.confirmationkey AS confirmationkey_42, s1_.sessionID AS sessionID_43, s1_.newsletter AS newsletter_44, s1_.validation AS validation_45, s1_.affiliate AS affiliate_46, s1_.paymentpreset AS paymentpreset_47, s1_.language AS language_48, s1_.referer AS referer_49, s1_.internalcomment AS internalcomment_50, s1_.failedlogins AS failedlogins_51, s1_.lockedUntil AS lockedUntil_52, s1_.salutation AS salutation_53, s1_.title AS title_54, s1_.firstname AS firstname_55, s1_.lastname AS lastname_56, s1_.birthday AS birthday_57, s2_.title AS title_58, s2_.stateID AS stateID_59, s2_.additional_address_line1 AS additional_address_line1_60, s2_.additional_address_line2 AS additional_address_line2_61, s2_.id AS id_62, s2_.userID AS userID_63, s2_.company AS company_64, s2_.department AS department_65, s2_.salutation AS salutation_66, s2_.firstname AS firstname_67, s2_.lastname AS lastname_68, s2_.street AS street_69, s2_.zipcode AS zipcode_70, s2_.city AS city_71, s2_.countryID AS countryID_72, s3_.id AS id_73, s3_.shippingID AS shippingID_74, s3_.text1 AS text1_75, s3_.text2 AS text2_76, s3_.text3 AS text3_77, s3_.text4 AS text4_78, s3_.text5 AS text5_79, s3_.text6 AS text6_80, s4_.payment_mean_id AS payment_mean_id_81, s4_.use_billing_data AS use_billing_data_82, s4_.bankname AS bankname_83, s4_.bic AS bic_84, s4_.iban AS iban_85, s4_.account_number AS account_number_86, s4_.bank_code AS bank_code_87, s4_.account_holder AS account_holder_88, s4_.created_at AS created_at_89, s4_.id AS id_90, s5_.id AS id_91, s5_.orderID AS orderID_92, s5_.attribute1 AS attribute1_93, s5_.attribute2 AS attribute2_94, s5_.attribute3 AS attribute3_95, s5_.attribute4 AS attribute4_96, s5_.attribute5 AS attribute5_97, s5_.attribute6 AS attribute6_98, s5_.bepado_shop_id AS bepado_shop_id_99, s5_.bepado_order_id AS bepado_order_id_100, s5_.bestit_amazon_capture_id AS bestit_amazon_capture_id_101, s5_.bestit_amazon_capture_reference AS bestit_amazon_capture_reference_102, s5_.bestit_amazon_authorization_id AS bestit_amazon_authorization_id_103, s5_.bestit_amazon_authorisation_reference AS bestit_amazon_authorisation_reference_104, s5_.bestit_amazon_refund_id AS bestit_amazon_refund_id_105, s5_.bestit_amazon_refund_reference AS bestit_amazon_refund_reference_106, s5_.bestit_amazon_cancel AS bestit_amazon_cancel_107, s5_.bestit_amazon_invoice_amount AS bestit_amazon_invoice_amount_108, s5_.bestit_amazon_simulation_code AS bestit_amazon_simulation_code_109, s5_.swag_payal_billing_agreement_id AS swag_payal_billing_agreement_id_110, s5_.swag_payal_express AS s