Neu Fehler beim Abgleich mit Shopware 6.4.11.1

[Romsafe]

Guten Tag,

folgendes Problem besteht seit kurzem bei uns. Wir haben JTL Wawi mit dem Shopware 6 System verbunden. Bisher funktionierte der Abgleich immer problemlos. Nun werden aber keine neuen Artikel mehr aus Wawi nach Shopware übertragen. Es kommt immer eine Fehlermedlung.

JTL Wawi Verison: 1.5.55.0
Shopware 6 Version: 6.4.11.1

Fehlermeldung anhand eines neuen Artikels, wenn dieser per Abgleich übertragen werden soll:

Fehler:
Exception: Controller = Product | Action = push | JTL-Wawi PK = 184 | SKU = NA-WG19-2 | Name = 19" Wandgehäuse | [5680b885-fa11-4c8e-8585-968b8b2d1a14] The Shopware 6 Admin API responded with an error:
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `product` (`id`, `version_id`, `parent_id`, `parent_version_id`, `product_manufacturer_id`, `product_manufacturer_version_id`, `unit_id`, `tax_id`, `product_media_id`, `product_media_version_id`, `delivery_time_id`, `product_feature_set_id`, `canonical_product_id`, `cms_page_version_id`, `main_variant_id`, `price`, `product_number`, `stock`, `restock_time`, `active`, `is_closeout`, `configurator_group_config`, `variant_restrictions`, `manufacturer_number`, `ean`, `purchase_steps`, `max_purchase`, `min_purchase`, `purchase_unit`, `reference_unit`, `shipping_free`, `purchase_prices`, `mark_as_topseller`, `weight`, `width`, `height`, `length`, `release_date`, `custom_field_set_selection_active`, `created_at`) VALUES ('???\'QE??>????$`','???jK¾K??u,4%',NULL,'???jK¾K??u,4%','???@?JA$?|JQ?6?','???jK¾K??u,4%',NULL,'P3?&?C??fHÿ?4?',NULL,'???jK¾K??u,4%',NULL,NULL,NULL,'???jK¾K??u,4%',NULL,'{\"cb7d2554b0ce847cd82f3ac9bd1c0dfca\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":500.0,\"gross\":595.0,\"linked\":true,\"listPrice\":null}}','NA-WG19-2','0','0','1','1','[]','[]',NULL,NULL,'1',NULL,'1',NULL,NULL,'0','{\"cb7d2554b0ce847cd82f3ac9bd1c0dfca\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":0.0,\"gross\":0.0,\"linked\":true,\"listPrice\":null}}','0','31','0','0','0',NULL,NULL,'2022-05-31 10:09:56.965');':

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '\xE3\x0F\xD5\xC2'QE\xBD\xA7>\xB4\x87\xA8\xFA$`-\x0F\xA9\x1C\xE3\' for key 'PRIMARY'
Controller = Product | Action = push | JTL-Wawi PK = 184 | SKU = NA-WG19-2 | Name = 19" Wandgehäuse | [dbe978a1-e0eb-4154-8a3d-f2d9b6a88f70] The Shopware 6 Admin API responded with an error:
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `product` (`id`, `version_id`, `parent_id`, `parent_version_id`, `product_manufacturer_id`, `product_manufacturer_version_id`, `unit_id`, `tax_id`, `product_media_id`, `product_media_version_id`, `delivery_time_id`, `product_feature_set_id`, `canonical_product_id`, `cms_page_version_id`, `main_variant_id`, `price`, `product_number`, `stock`, `restock_time`, `active`, `is_closeout`, `configurator_group_config`, `variant_restrictions`, `manufacturer_number`, `ean`, `purchase_steps`, `max_purchase`, `min_purchase`, `purchase_unit`, `reference_unit`, `shipping_free`, `purchase_prices`, `mark_as_topseller`, `weight`, `width`, `height`, `length`, `release_date`, `custom_field_set_selection_active`, `created_at`) VALUES ('?/??B?b??c+','???jK¾K??u,4%',NULL,'???jK¾K??u,4%','???@?JA$?|JQ?6?','???jK¾K??u,4%',NULL,'P3?&?C??fHÿ?4?',NULL,'???jK¾K??u,4%',NULL,NULL,NULL,'???jK¾K??u,4%',NULL,'{\"cb7d2554b0ce847cd82f3ac9bd1c0dfca\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":500.0,\"gross\":595.0,\"linked\":true,\"listPrice\":null}}','NA-WG19-2','0','0','1','1','[]','[]',NULL,NULL,'1',NULL,'1',NULL,NULL,'0','{\"cb7d2554b0ce847cd82f3ac9bd1c0dfca\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":0.0,\"gross\":0.0,\"linked\":true,\"listPrice\":null}}','0','31','0','0','0',NULL,NULL,'2022-05-31 10:10:10.379');':

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '\xC2\x94/\xC9\xFD\xBEB\x1C\xB7b\xDA\x1B\xACc+\x0E-\x0F\xA9\x1C\x' for key 'PRIMARY'
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 = 184 | SKU = NA-WG19-2 | Name = 19" Wandgehäuse | [5680b885-fa11-4c8e-8585-968b8b2d1a14] The Shopware 6 Admin API responded with an error:
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `product` (`id`, `version_id`, `parent_id`, `parent_version_id`, `product_manufacturer_id`, `product_manufacturer_version_id`, `unit_id`, `tax_id`, `product_media_id`, `product_media_version_id`, `delivery_time_id`, `product_feature_set_id`, `canonical_product_id`, `cms_page_version_id`, `main_variant_id`, `price`, `product_number`, `stock`, `restock_time`, `active`, `is_closeout`, `configurator_group_config`, `variant_restrictions`, `manufacturer_number`, `ean`, `purchase_steps`, `max_purchase`, `min_purchase`, `purchase_unit`, `reference_unit`, `shipping_free`, `purchase_prices`, `mark_as_topseller`, `weight`, `width`, `height`, `length`, `release_date`, `custom_field_set_selection_active`, `created_at`) VALUES ('???\'QE??>????$`','???jK¾K??u,4%',NULL,'???jK¾K??u,4%','???@?JA$?|JQ?6?','???jK¾K??u,4%',NULL,'P3?&?C??fHÿ?4?',NULL,'???jK¾K??u,4%',NULL,NULL,NULL,'???jK¾K??u,4%',NULL,'{\"cb7d2554b0ce847cd82f3ac9bd1c0dfca\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":500.0,\"gross\":595.0,\"linked\":true,\"listPrice\":null}}','NA-WG19-2','0','0','1','1','[]','[]',NULL,NULL,'1',NULL,'1',NULL,NULL,'0','{\"cb7d2554b0ce847cd82f3ac9bd1c0dfca\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":0.0,\"gross\":0.0,\"linked\":true,\"listPrice\":null}}','0','31','0','0','0',NULL,NULL,'2022-05-31 10:09:56.965');':

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '\xE3\x0F\xD5\xC2'QE\xBD\xA7>\xB4\x87\xA8\xFA$`-\x0F\xA9\x1C\xE3\' for key 'PRIMARY'

Controller = Product | Action = push | JTL-Wawi PK = 184 | SKU = NA-WG19-2 | Name = 19" Wandgehäuse | [dbe978a1-e0eb-4154-8a3d-f2d9b6a88f70] The Shopware 6 Admin API responded with an error:
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `product` (`id`, `version_id`, `parent_id`, `parent_version_id`, `product_manufacturer_id`, `product_manufacturer_version_id`, `unit_id`, `tax_id`, `product_media_id`, `product_media_version_id`, `delivery_time_id`, `product_feature_set_id`, `canonical_product_id`, `cms_page_version_id`, `main_variant_id`, `price`, `product_number`, `stock`, `restock_time`, `active`, `is_closeout`, `configurator_group_config`, `variant_restrictions`, `manufacturer_number`, `ean`, `purchase_steps`, `max_purchase`, `min_purchase`, `purchase_unit`, `reference_unit`, `shipping_free`, `purchase_prices`, `mark_as_topseller`, `weight`, `width`, `height`, `length`, `release_date`, `custom_field_set_selection_active`, `created_at`) VALUES ('?/??B?b??c+','???jK¾K??u,4%',NULL,'???jK¾K??u,4%','???@?JA$?|JQ?6?','???jK¾K??u,4%',NULL,'P3?&?C??fHÿ?4?',NULL,'???jK¾K??u,4%',NULL,NULL,NULL,'???jK¾K??u,4%',NULL,'{\"cb7d2554b0ce847cd82f3ac9bd1c0dfca\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":500.0,\"gross\":595.0,\"linked\":true,\"listPrice\":null}}','NA-WG19-2','0','0','1','1','[]','[]',NULL,NULL,'1',NULL,'1',NULL,NULL,'0','{\"cb7d2554b0ce847cd82f3ac9bd1c0dfca\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":0.0,\"gross\":0.0,\"linked\":true,\"listPrice\":null}}','0','31','0','0','0',NULL,NULL,'2022-05-31 10:10:10.379');':

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '\xC2\x94/\xC9\xFD\xBEB\x1C\xB7b\xDA\x1B\xACc+\x0E-\x0F\xA9\x1C\x' for key 'PRIMARY'

Response: {"jtlrpc":"2.0","id":"111ad2ad56d5417ba92b81dfe0a94519","result":null,"error":{"code":400,"message":"Controller = Product | Action = push | JTL-Wawi PK = 184 | SKU = NA-WG19-2 | Name = 19\u0022 Wandgeh\u00e4use | [9a864ba1-5df7-4c4a-9764-981b0ca8c885] The Shopware 6 Admin API responded with an error: \nCode = 0 | Status = 500 | Detail = An exception occurred while executing \u0027INSERT INTO `product` (`id`, `version_id`, `parent_id`, `parent_version_id`, `product_manufacturer_id`, `product_manufacturer_version_id`, `unit_id`, `tax_id`, `product_media_id`, `product_media_version_id`, `delivery_time_id`, `product_feature_set_id`, `canonical_product_id`, `cms_page_version_id`, `main_variant_id`, `price`, `product_number`, `stock`, `restock_time`, `active`, `is_closeout`, `configurator_group_config`, `variant_restrictions`, `manufacturer_number`, `ean`, `purchase_steps`, `max_purchase`, `min_purchase`, `purchase_unit`, `reference_unit`, `shipping_free`, `purchase_prices`, `mark_as_topseller`, `weight`, `width`, `height`, `length`, `release_date`, `custom_field_set_selection_active`, `created_at`) VALUES (\u0027U\ufffdF\ufffd\ufffdG\ufffd\ufffd\ufffdY7[\ufffd\ufffdZ\u0027,\u0027\u000f\ufffd\u001c\ufffd\ufffdjK\u00beK\ufffd\ufffdu,4%\u0027,NULL,\u0027\u000f\ufffd\u001c\ufffd\ufffdjK\u00beK\ufffd\ufffdu,4%\u0027,\u0027\ufffd\ufffd?@\ufffdJA$\ufffd|\u0016JQ\ufffd6\ufffd\u0027,\u0027\u000f\ufffd\u001c\ufffd\ufffdjK\u00beK\ufffd\ufffdu,4%\u0027,NULL,\u0027P3\ufffd\u000f\u0026\ufffdC\ufffd\ufffdfH\u00ff\ufffd4\ufffd\u0027,NULL,\u0027\u000f\ufffd\u001c\ufffd\ufffdjK\u00beK\ufffd\ufffdu,4%\u0027,NULL,NULL,NULL,\u0027\u000f\ufffd\u001c\ufffd\ufffdjK\u00beK\ufffd\ufffdu,4%\u0027,NULL,\u0027{\\\u0022cb7d2554b0ce847cd82f3ac9bd1c0dfca\\\u0022:{\\\u0022currencyId\\\u0022:\\\u0022b7d2554b0ce847cd82f3ac9bd1c0dfca\\\u0022,\\\u0022net\\\u0022:500.0,\\\u0022gross\\\u0022:595.0,\\\u0022linked\\\u0022:true,\\\u0022listPrice\\\u0022:null}}\u0027,\u0027NA-WG19-2\u0027,\u00270\u0027,\u00270\u0027,\u00271\u0027,\u00271\u0027,\u0027[]\u0027,\u0027[]\u0027,NULL,NULL,\u00271\u0027,NULL,\u00271\u0027,NULL,NULL,\u00270\u0027,\u0027{\\\u0022cb7d2554b0ce847cd82f3ac9bd1c0dfca\\\u0022:{\\\u0022currencyId\\\u0022:\\\u0022b7d2554b0ce847cd82f3ac9bd1c0dfca\\\u0022,\\\u0022net\\

 

[muhammed671]

Hallo,
das Problem habe ich auch. Dazu habe ich auch ein Ticket beim Support aufgemacht. Noch keine Rückmeldung. Hast du schon eine Lösung dazu gefunden?

Kann eventuell ein JTL Mitarbeiter uns hierbei weiterhelfen?

JTL Wawi Verison: 1.6.38.2
Shopware 6 Version: 6.4.11.1

Meine Vermutung ist, dass das Problem bei den Merkmalen (Wawi) / Eigenschaften (Shopware) liegt. Sobald ich alle Merkmale nicht mehr übertrage, habe ich keine Fehler bei der Übertragung von Wawi zur Shopware. Gebe ich allerdings ein Merkmal für den Shop-Abgleich frei, bekomme ich diese Fehlermeldung:

Mermalname: test
Merkmalwertname: test1

Unbehandelte Ausnahme #959190594F6282F vom Typ System.Exception in
System.Exception: Exception: Controller = Product | Action = push | JTL-Wawi PK = 69 | SKU = 1 | Name = test | [c7391bde-461a-44b7-80a2-ae858ef6c60f] The Shopware 6 Admin API responded with an error:
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `product_visibility` (`id`, `product_id`, `product_version_id`, `sales_channel_id`, `visibility`, `created_at`) VALUES ('ʱ�S�yMN�\n� �x��','r�{1G[���\nl\nu','���jK¾K��u,4%','�����E��S5�~�V�','30','2022-05-31 23:01:34.427');':

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '\xCA\xB1\xA3S\xA4yMN\x8C\x0A\x89 \xE8x\x8C\x88' for key 'PRIMARY'
Controller = Product | Action = push | JTL-Wawi PK = 69 | SKU = 1 | Name = test | [918caa3e-85e2-4562-aac3-f05671a8cf7c] The Shopware 6 Admin API responded with an error:
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `product_visibility` (`id`, `product_id`, `product_version_id`, `sales_channel_id`, `visibility`, `created_at`) VALUES ('�H�b�Ei��R�HT','r�{1G[���\nl\nu','���jK¾K��u,4%','�����E��S5�~�V�','30','2022-05-31 23:01:36.490');':

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '\x93H\xCEb\x0E\xB3Ei\xAD\xF2\x07R\xC7\x1FHT' for key 'PRIMARY'
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 = 69 | SKU = 1 | Name = test | [c7391bde-461a-44b7-80a2-ae858ef6c60f] The Shopware 6 Admin API responded with an error:
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `product_visibility` (`id`, `product_id`, `product_version_id`, `sales_channel_id`, `visibility`, `created_at`) VALUES ('ʱ�S�yMN�\n� �x��','r�{1G[���\nl\nu','���jK¾K��u,4%','�����E��S5�~�V�','30','2022-05-31 23:01:34.427');':

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '\xCA\xB1\xA3S\xA4yMN\x8C\x0A\x89 \xE8x\x8C\x88' for key 'PRIMARY'

Controller = Product | Action = push | JTL-Wawi PK = 69 | SKU = 1 | Name = test | [918caa3e-85e2-4562-aac3-f05671a8cf7c] The Shopware 6 Admin API responded with an error:
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `product_visibility` (`id`, `product_id`, `product_version_id`, `sales_channel_id`, `visibility`, `created_at`) VALUES ('�H�b�Ei��R�HT','r�{1G[���\nl\nu','���jK¾K��u,4%','�����E��S5�~�V�','30','2022-05-31 23:01:36.490');':

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '\x93H\xCEb\x0E\xB3Ei\xAD\xF2\x07R\xC7\x1FHT' for key 'PRIMARY'

Response: {"jtlrpc":"2.0","id":"90f6856b1cfc46d788ccf53b135a4997","result":null,"error":{"code":400,"message":"Controller = Product | Action = push | JTL-Wawi PK = 69 | SKU = 1 | Name = test | [b4bd1470-f035-4af6-88d3-64cb1bb8e09b] The Shopware 6 Admin API responded with an error: \nCode = 0 | Status = 500 | Detail = An exception occurred while executing \u0027INSERT INTO `product_visibility` (`id`, `product_id`, `product_version_id`, `sales_channel_id`, `visibility`, `created_at`) VALUES (\u0027\ufffdR\ufffdJT\ufffdC\ufffd\ufffd\u0003p\ufffd\u0015\ufffd\ufffd\ufffd\u0027,\u0027r\u0004\u000b\ufffd{1G[\ufffd\u0007\ufffd\ufffd\\nl\\nu\u0027,\u0027\u000f\ufffd\u001c\ufffd\ufffdjK\u00beK\ufffd\ufffdu,4%\u0027,\u0027\ufffd\ufffd\u0017\ufffd\ufffd\ufffdE\ufffd\ufffdS5\ufffd~\ufffdV\ufffd\u0027,\u002730\u0027,\u00272022-05-31 23:01:35.355\u0027);\u0027:\n\nSQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry \u0027\\xDAR\\xF4JT\\xB8C\\x80\\x9A\\x03p\\xC1\\x15\\xFF\\xBD\\xBD\u0027 for key \u0027PRIMARY\u0027","data":"Jtl\\Shopware6\\Client\\Exception\\ClientException (Code: 400) in ...\/ClientException.php:100"}}
Exception bei product.push: Controller = Product | Action = push | JTL-Wawi PK = 69 | SKU = 1 | Name = test | [c7391bde-461a-44b7-80a2-ae858ef6c60f] The Shopware 6 Admin API responded with an error:
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `product_visibility` (`id`, `product_id`, `product_version_id`, `sales_channel_id`, `visibility`, `created_at`) VALUES ('ʱ�S�yMN�\n� �x��','r�{1G[���\nl\nu','���jK¾K��u,4%','�����E��S5�~�V�','30','2022-05-31 23:01:34.427');':

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '\xCA\xB1\xA3S\xA4yMN\x8C\x0A\x89 \xE8x\x8C\x88' for key 'PRIMARY'

Controller = Product | Action = push | JTL-Wawi PK = 69 | SKU = 1 | Name = test | [918caa3e-85e2-4562-aac3-f05671a8cf7c] The Shopware 6 Admin API responded with an error:
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `product_visibility` (`id`, `product_id`, `product_version_id`, `sales_channel_id`, `visibility`, `created_at`) VALUES ('�H�b�Ei��R�HT','r�{1G[���\nl\nu','���jK¾K��u,4%','�����E��S5�~�V�','30','2022-05-31 23:01:36.490');':

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '\x93H\xCEb\x0E\xB3Ei\xAD\xF2\x07R\xC7\x1FHT' for key 'PRIMARY'

Response: {"jtlrpc":"2.0","id":"4a16022a70864f28b2f7415b1e2a07be","result":null,"error":{"code":400,"message":"Controller = Product | Action = push | JTL-Wawi PK = 69 | SKU = 1 | Name = test | [c7391bde-461a-44b7-80a2-ae858ef6c60f] The Shopware 6 Admin API responded with an error: \nCode = 0 | Status = 500 | Detail = An exception occurred while executing \u0027INSERT INTO `product_visibility` (`id`, `product_id`, `product_version_id`, `sales_channel_id`, `visibility`, `created_at`) VALUES (\u0027\u02b1\ufffdS\ufffdyMN\ufffd\\n\ufffd \ufffdx\ufffd\ufffd\u0027,\u0027r\u0004\u000b\ufffd{1G[\ufffd\u0007\ufffd\ufffd\\nl\\nu\u0027,\u0027\u000f\ufffd\u001c\ufffd\ufffdjK\u00beK\ufffd\ufffdu,4%\u0027,\u0027\ufffd\ufffd\u0017\ufffd\ufffd\ufffdE\ufffd\ufffdS5\ufffd~\ufffdV\ufffd\u0027,\u002730\u0027,\u00272022-05-31 23:01:34.427\u0027);\u0027:\n\nSQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry \u0027\\xCA\\xB1\\xA3S\\xA4yMN\\x8C\\x0A\\x89 \\xE8x\\x8C\\x88\u0027 for key \u0027PRIMARY\u0027","data":"Jtl\\Shopware6\\Client\\Exception\\ClientException (Code: 400) in ...\/ClientException.php:100"}}
   bei jtlCore.ControllerClasses.Connector.Abgleich.Connector.EdK3wda8Ib4(String  , Object  , Boolean  , NetworkCredential  )
   bei jtlCore.ControllerClasses.Connector.Abgleich.Connector.wRK3wF0gges(String  , Object  , Boolean  , NetworkCredential  , Boolean  )
   bei jtlCore.ControllerClasses.Connector.Abgleich.Connector.EdK3wda8Ib4(String  , Object  , Boolean  , NetworkCredential  )

 

[Romsafe]

Hallo,

ich habe bisher keine Lösung gefunden, das Problem ist erst seit der neuen Shopware 6 Version. Evtl. gibt es hier unpassende Parameter beim Abgleich mit Wawi. Es scheint als würde etwas in der Datenbank versucht doppelt anzulegen was aber nicht zulässig ist:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '\xCA\xB1\xA3S\xA4yMN\x8C\x0A\x89 \xE8x\x8C\x88' for key 'PRIMARY'

Bitte um Antwort von JTL.

 

[csaeum]

Ja doppelte Einträge mag diese nicht.
Habt ihr "komische Zeichen" drin?

Oder Einträge wie (Grösse, Größe / Gebindegrösse, Gebindegröße). Diese Sollten am besten einheitlich gepflegt werden. Dies konnte Ihr Problem vielleicht auch schon lösen.

 

[Condorraptor]

I have faced same problem and reported it to Help Desk. Have anyone found the solution so far? If yes, please help me too.

Is it the same error code?

 

[kelkadir]

Same story here

[status] => 500
[title] => Internal Server Error
[detail] => An exception occurred while executing 'INSERT INTO `product_visibility`......
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry

 

[wawiewo?]

Jemand eine Lösung?

Es hat definitiv etwas mit den Merkmalen zu tun, ich weiß aber noch nicht "wann" der Fehler auftritt..

Fehler:
Exception: Controller = Product | Action = push | JTL-Wawi PK = 1955 | SKU = FA-DRIPLETTE-TANGERINE-WHITE | Name = HOOKAiN - DRiPLETTEN - TANGERINE & WHITE | [ddac690e-4430-4134-a098-d44f240222ff] The Shopware 6 Admin API responded with an error:
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `product` (`id`, `version_id`, `parent_id`, `parent_version_id`, `product_manufacturer_id`, `product_manufacturer_version_id`, `unit_id`, `tax_id`, `product_media_id`, `product_media_version_id`, `delivery_time_id`, `product_feature_set_id`, `canonical_product_id`, `cms_page_version_id`, `main_variant_id`, `price`, `product_number`, `stock`, `restock_time`, `active`, `is_closeout`, `configurator_group_config`, `variant_restrictions`, `manufacturer_number`, `ean`, `purchase_steps`, `max_purchase`, `min_purchase`, `purchase_unit`, `reference_unit`, `shipping_free`, `purchase_prices`, `mark_as_topseller`, `weight`, `width`, `height`, `length`, `release_date`, `custom_field_set_selection_active`, `created_at`) VALUES ('5????@??$?/?M','???jK¾K??u,4%',NULL,'???jK¾K??u,4%','R7???Of???x=','???jK¾K??u,4%',NULL,'6x?-=E?????Q??',NULL,'???jK¾K??u,4%',NULL,NULL,NULL,'???jK¾K??u,4%',NULL,'{\"cb7d2554b0ce847cd82f3ac9bd1c0dfca\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":25.1261,\"gross\":29.9,\"linked\":true,\"listPrice\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":0,\"gross\":0,\"linked\":true,\"listPrice\":null},\"percentage\":null}}','FA-DRIPLETTE-TANGERINE-WHITE','140','0','1','1','[{\"id\":\"de4235bbdd0543cc8f8ebf65abdc9223\",\"expressionForListings\":false,\"representation\":\"box\"}]','[]',NULL,NULL,'1',NULL,'1',NULL,NULL,'0','{\"cb7d2554b0ce847cd82f3ac9bd1c0dfca\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":8.5,\"gross\":10.115,\"linked\":true,\"listPrice\":null}}','1','0.5','140','50','330',NULL,NULL,'2022-11-15 14:21:37.740');':

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '5\xB0\x14\x8E\xE6\xD6@\x0C\x91\xDF\xFB$\x82/\x8BM-\x0F\xA9\x1...' for key 'PRIMARY'
Controller = Product | Action = push | JTL-Wawi PK = 1955 | SKU = FA-DRIPLETTE-TANGERINE-WHITE | Name = HOOKAiN - DRiPLETTEN - TANGERINE & WHITE | [95747c5a-e4b7-45ff-a984-219bb2b4d093] The Shopware 6 Admin API responded with an error:
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `product` (`id`, `version_id`, `parent_id`, `parent_version_id`, `product_manufacturer_id`, `product_manufacturer_version_id`, `unit_id`, `tax_id`, `product_media_id`, `product_media_version_id`, `delivery_time_id`, `product_feature_set_id`, `canonical_product_id`, `cms_page_version_id`, `main_variant_id`, `price`, `product_number`, `stock`, `restock_time`, `active`, `is_closeout`, `configurator_group_config`, `variant_restrictions`, `manufacturer_number`, `ean`, `purchase_steps`, `max_purchase`, `min_purchase`, `purchase_unit`, `reference_unit`, `shipping_free`, `purchase_prices`, `mark_as_topseller`, `weight`, `width`, `height`, `length`, `release_date`, `custom_field_set_selection_active`, `created_at`) VALUES ('@?\"uTL???K???','???jK¾K??u,4%',NULL,'???jK¾K??u,4%','R7???Of???x=','???jK¾K??u,4%',NULL,'6x?-=E?????Q??',NULL,'???jK¾K??u,4%',NULL,NULL,NULL,'???jK¾K??u,4%',NULL,'{\"cb7d2554b0ce847cd82f3ac9bd1c0dfca\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":25.1261,\"gross\":29.9,\"linked\":true,\"listPrice\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":0,\"gross\":0,\"linked\":true,\"listPrice\":null},\"percentage\":null}}','FA-DRIPLETTE-TANGERINE-WHITE','140','0','1','1','[{\"id\":\"de4235bbdd0543cc8f8ebf65abdc9223\",\"expressionForListings\":false,\"representation\":\"box\"}]','[]',NULL,NULL,'1',NULL,'1',NULL,NULL,'0','{\"cb7d2554b0ce847cd82f3ac9bd1c0dfca\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":8.5,\"gross\":10.115,\"linked\":true,\"listPrice\":null}}','1','0.5','140','50','330',NULL,NULL,'2022-11-15 14:21:50.176');':

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '@\xCD\x1F"uTL\xB0\xB1\xD4K\xD5\xEA\xB8\xB4\xEC-\x0F\xA9\x1C\x...' for key 'PRIMARY'
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 = 1955 | SKU = FA-DRIPLETTE-TANGERINE-WHITE | Name = HOOKAiN - DRiPLETTEN - TANGERINE & WHITE | [ddac690e-4430-4134-a098-d44f240222ff] The Shopware 6 Admin API responded with an error:
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `product` (`id`, `version_id`, `parent_id`, `parent_version_id`, `product_manufacturer_id`, `product_manufacturer_version_id`, `unit_id`, `tax_id`, `product_media_id`, `product_media_version_id`, `delivery_time_id`, `product_feature_set_id`, `canonical_product_id`, `cms_page_version_id`, `main_variant_id`, `price`, `product_number`, `stock`, `restock_time`, `active`, `is_closeout`, `configurator_group_config`, `variant_restrictions`, `manufacturer_number`, `ean`, `purchase_steps`, `max_purchase`, `min_purchase`, `purchase_unit`, `reference_unit`, `shipping_free`, `purchase_prices`, `mark_as_topseller`, `weight`, `width`, `height`, `length`, `release_date`, `custom_field_set_selection_active`, `created_at`) VALUES ('5????@??$?/?M','???jK¾K??u,4%',NULL,'???jK¾K??u,4%','R7???Of???x=','???jK¾K??u,4%',NULL,'6x?-=E?????Q??',NULL,'???jK¾K??u,4%',NULL,NULL,NULL,'???jK¾K??u,4%',NULL,'{\"cb7d2554b0ce847cd82f3ac9bd1c0dfca\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":25.1261,\"gross\":29.9,\"linked\":true,\"listPrice\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":0,\"gross\":0,\"linked\":true,\"listPrice\":null},\"percentage\":null}}','FA-DRIPLETTE-TANGERINE-WHITE','140','0','1','1','[{\"id\":\"de4235bbdd0543cc8f8ebf65abdc9223\",\"expressionForListings\":false,\"representation\":\"box\"}]','[]',NULL,NULL,'1',NULL,'1',NULL,NULL,'0','{\"cb7d2554b0ce847cd82f3ac9bd1c0dfca\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":8.5,\"gross\":10.115,\"linked\":true,\"listPrice\":null}}','1','0.5','140','50','330',NULL,NULL,'2022-11-15 14:21:37.740');':

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '5\xB0\x14\x8E\xE6\xD6@\x0C\x91\xDF\xFB$\x82/\x8BM-\x0F\xA9\x1...' for key 'PRIMARY'

Controller = Product | Action = push | JTL-Wawi PK = 1955 | SKU = FA-DRIPLETTE-TANGERINE-WHITE | Name = HOOKAiN - DRiPLETTEN - TANGERINE & WHITE | [95747c5a-e4b7-45ff-a984-219bb2b4d093] The Shopware 6 Admin API responded with an error:
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `product` (`id`, `version_id`, `parent_id`, `parent_version_id`, `product_manufacturer_id`, `product_manufacturer_version_id`, `unit_id`, `tax_id`, `product_media_id`, `product_media_version_id`, `delivery_time_id`, `product_feature_set_id`, `canonical_product_id`, `cms_page_version_id`, `main_variant_id`, `price`, `product_number`, `stock`, `restock_time`, `active`, `is_closeout`, `configurator_group_config`, `variant_restrictions`, `manufacturer_number`, `ean`, `purchase_steps`, `max_purchase`, `min_purchase`, `purchase_unit`, `reference_unit`, `shipping_free`, `purchase_prices`, `mark_as_topseller`, `weight`, `width`, `height`, `length`, `release_date`, `custom_field_set_selection_active`, `created_at`) VALUES ('@?\"uTL???K???','???jK¾K??u,4%',NULL,'???jK¾K??u,4%','R7???Of???x=','???jK¾K??u,4%',NULL,'6x?-=E?????Q??',NULL,'???jK¾K??u,4%',NULL,NULL,NULL,'???jK¾K??u,4%',NULL,'{\"cb7d2554b0ce847cd82f3ac9bd1c0dfca\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":25.1261,\"gross\":29.9,\"linked\":true,\"listPrice\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":0,\"gross\":0,\"linked\":true,\"listPrice\":null},\"percentage\":null}}','FA-DRIPLETTE-TANGERINE-WHITE','140','0','1','1','[{\"id\":\"de4235bbdd0543cc8f8ebf65abdc9223\",\"expressionForListings\":false,\"representation\":\"box\"}]','[]',NULL,NULL,'1',NULL,'1',NULL,NULL,'0','{\"cb7d2554b0ce847cd82f3ac9bd1c0dfca\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":8.5,\"gross\":10.115,\"linked\":true,\"listPrice\":null}}','1','0.5','140','50','330',NULL,NULL,'2022-11-15 14:21:50.176');':

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '@\xCD\x1F"uTL\xB0\xB1\xD4K\xD5\xEA\xB8\xB4\xEC-\x0F\xA9\x1C\x...' for key 'PRIMARY'

Response: {"jtlrpc":"2.0","id":"b03e9e784dec4cca870b6344da26ac4c","result":null,"error":{"code":400,"message":"Controller = Product | Action = push | JTL-Wawi PK = 1955 | SKU = FA-DRIPLETTE-TANGERINE-WHITE | Name = HOOKAiN - DRiPLETTEN - TANGERINE \u0026 WHITE | [de6f96be-5af0-4bfa-a982-cbc7eb800023] The Shopware 6 Admin API responded with an error: \nCode = 0 | Status = 500 | Detail = An exception occurred while executing \u0027INSERT INTO `product` (`id`, `version_id`, `parent_id`, `parent_version_id`, `product_manufacturer_id`, `product_manufacturer_version_id`, `unit_id`, `tax_id`, `product_media_id`, `product_media_version_id`, `delivery_time_id`, `product_feature_set_id`, `canonical_product_id`, `cms_page_version_id`, `main_variant_id`, `price`, `product_number`, `stock`, `restock_time`, `active`, `is_closeout`, `configurator_group_config`, `variant_restrictions`, `manufacturer_number`, `ean`, `purchase_steps`, `max_purchase`, `min_purchase`, `purchase_unit`, `reference

 

[tiroled]

Dieses Problem existiert bis heute immer noch. Wie habt ihr das Problem gelöst?

 

[wawiewo?]

nein bis heute kein fix

 

[abernauer]

Versucht mal folgendes:

1) JTL-Wawi starten -> (Menüleiste) Plattformen -> Verkaufskanäle -> unten den Button "Connector zurücksetzen".
2) (Menüleiste) Plattformen -> Onlineshop -> Komplettabgleich (Alle)
3) (Button unter der Menüleiste) Plattformen -> (Button links unten) Abgleich starten

So werden die Links, ... neu erstellt.
Muss nicht helfen, aber kann helfen.
Am Besten nicht im Live-Modus.

☺️

Sollte dies nicht funktionieren, könnt Ihr euch nur noch beim JTL-Connector Support melden.
Die nehmen sich sodann die DB aus Shopware vor. Ist aber sicher mit Aufwand verbunden.

 

[abernauer]

Dieses Problem existiert bis heute immer noch. Wie habt ihr das Problem gelöst?

Versucht mal folgendes:

1) JTL-Wawi starten -> (Menüleiste) Plattformen -> Verkaufskanäle -> unten den Button "Connector zurücksetzen".
2) (Menüleiste) Plattformen -> Onlineshop -> Komplettabgleich (Alle)
3) (Button unter der Menüleiste) Plattformen -> (Button links unten) Abgleich starten

So werden die Links, ... neu erstellt.
Muss nicht helfen, aber kann helfen.
Am Besten nicht im Live-Modus.

☺️

Sollte dies nicht funktionieren, könnt Ihr euch nur noch beim JTL-Connector Support melden.
Die nehmen sich sodann die DB aus Shopware vor. Ist aber sicher mit Aufwand verbunden.

 

[tiroled]

Versucht mal folgendes:

1) JTL-Wawi starten -> (Menüleiste) Plattformen -> Verkaufskanäle -> unten den Button "Connector zurücksetzen".
2) (Menüleiste) Plattformen -> Onlineshop -> Komplettabgleich (Alle)
3) (Button unter der Menüleiste) Plattformen -> (Button links unten) Abgleich starten

So werden die Links, ... neu erstellt.
Muss nicht helfen, aber kann helfen.
Am Besten nicht im Live-Modus.

☺️

Sollte dies nicht funktionieren, könnt Ihr euch nur noch beim JTL-Connector Support melden.
Die nehmen sich sodann die DB aus Shopware vor. Ist aber sicher mit Aufwand verbunden.

Danke, wir haben das in der Zwischenzeit auch selber entdeckt. Wir mussten die Onlineshopdaten und den Connector zurücksetzen.

 

[Belushi]

Bin der nächste in der Liste... bei uns kommt der Integrity Constrain Violation Fehler im Zusammenhang mit einem Produktattribut:
Der Connector will ein Insert machen, obwohl es den Attribut-Namen in der DB bereits gibt und nur der Attribut-Wert aktualisiert (update) werden müsste.

Das Ticket ist vermutlich dieses?
https://issues.jtl-software.de/issues/CO-2314