Hallo
bekomme beim Abgleich dem Shopware 6 folgenden Fehler
Unbehandelte Ausnahme #959190594F6282F vom Typ System.Exception in
System.Exception: Exception: Controller = Product | Action = push | JTL-Wawi PK = 20479 | SKU = 100763 | Name = Cooler Server SUPERMICRO SNK-P0047PSC (2011) 1U Passive | [182f5c52-3c57-4791-9005-192487d6f7fa] 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 (' oǪ CٯV4 C8b ',' jK¾K u,4%',NULL,' jK¾K u,4%','-vf G\Z x 1E\\\'',' jK¾K u,4%',NULL,'%k Ð!K @ :',NULL,' jK¾K u,4%',NULL,NULL,NULL,' jK¾K u,4%',NULL,'{\"cb7d2554b0ce847cd82f3ac9bd1c0dfca\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":18.941199999999998482280716416426002979278564453125,\"gross\":22.53999999999999914734871708787977695465087890625,\"linked\":true,\"listPrice\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":0,\"gross\":0,\"linked\":true,\"listPrice\":null},\"percentage\":null}}','100763','0','0','1','1','[]','[]','SNK-P0047PSC','0672042108435','1',NULL,'1',NULL,NULL,'0','{\"cb7d2554b0ce847cd82f3ac9bd1c0dfca\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":17.690000000000001278976924368180334568023681640625,\"gross\":21.051100000000001699618223938159644603729248046875,\"linked\":true,\"listPrice\":null}}','0','0','0','0','0',NULL,NULL,'2023-04-28 16:08:34.671');':
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`d03cdc7b`.`product`, CONSTRAINT `product_ibfk_1` FOREIGN KEY (`product_manufacturer_id`, `product_manufacturer_version_id`) REFERENCES `product_manufacturer` (`id`, `version_id`) ON DELETE SE)
Controller = Product | Action = push | JTL-Wawi PK = 20479 | SKU = 100763 | Name = Cooler Server SUPERMICRO SNK-P0047PSC (2011) 1U Passive | [4e0b62ca-2695-45d2-8963-4285822041da] 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 ('ߘ Wp @$ `O ',' jK¾K u,4%',NULL,' jK¾K u,4%','-vf G\Z x 1E\\\'',' jK¾K u,4%',NULL,'%k Ð!K @ :',NULL,' jK¾K u,4%',NULL,NULL,NULL,' jK¾K u,4%',NULL,'{\"cb7d2554b0ce847cd82f3ac9bd1c0dfca\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":18.941199999999998482280716416426002979278564453125,\"gross\":22.53999999999999914734871708787977695465087890625,\"linked\":true,\"listPrice\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":0,\"gross\":0,\"linked\":true,\"listPrice\":null},\"percentage\":null}}','100763','0','0','1','1','[]','[]','SNK-P0047PSC','0672042108435','1',NULL,'1',NULL,NULL,'0','{\"cb7d2554b0ce847cd82f3ac9bd1c0dfca\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":17.690000000000001278976924368180334568023681640625,\"gross\":21.051100000000001699618223938159644603729248046875,\"linked\":true,\"listPrice\":null}}','0','0','0','0','0',NULL,NULL,'2023-04-28 16:08:42.180');':
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`d03cdc7b`.`product`, CONSTRAINT `product_ibfk_1` FOREIGN KEY (`product_manufacturer_id`, `product_manufacturer_version_id`) REFERENCES `product_manufacturer` (`id`, `version_id`) ON DELETE SE)
Unbehandelte Ausnahme #959190594F6282F vom Typ System.Exception in : 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 = 20479 | SKU = 100763 | Name = Cooler Server SUPERMICRO SNK-P0047PSC (2011) 1U Passive | [182f5c52-3c57-4791-9005-192487d6f7fa] 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 (' oǪ CٯV4 C8b ',' jK¾K u,4%',NULL,' jK¾K u,4%','-vf G\Z x 1E\\\'',' jK¾K u,4%',NULL,'%k Ð!K @ :',NULL,' jK¾K u,4%',NULL,NULL,NULL,' jK¾K u,4%',NULL,'{\"cb7d2554b0ce847cd82f3ac9bd1c0dfca\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":18.941199999999998482280716416426002979278564453125,\"gross\":22.53999999999999914734871708787977695465087890625,\"linked\":true,\"listPrice\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":0,\"gross\":0,\"linked\":true,\"listPrice\":null},\"percentage\":null}}','100763','0','0','1','1','[]','[]','SNK-P0047PSC','0672042108435','1',NULL,'1',NULL,NULL,'0','{\"cb7d2554b0ce847cd82f3ac9bd1c0dfca\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":17.690000000000001278976924368180334568023681640625,\"gross\":21.051100000000001699618223938159644603729248046875,\"linked\":true,\"listPrice\":null}}','0','0','0','0','0',NULL,NULL,'2023-04-28 16:08:34.671');':
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`d03cdc7b`.`product`, CONSTRAINT `product_ibfk_1` FOREIGN KEY (`product_manufacturer_id`, `product_manufacturer_version_id`) REFERENCES `product_manufacturer` (`id`, `version_id`) ON DELETE SE)
Controller = Product | Action = push | JTL-Wawi PK = 20479 | SKU = 100763 | Name = Cooler Server SUPERMICRO SNK-P0047PSC (2011) 1U Passive | [4e0b62ca-2695-45d2-8963-4285822041da] 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 ('ߘ Wp @$ `O ',' jK¾K u,4%',NULL,' jK¾K u,4%','-vf G\Z x 1E\\\'',' jK¾K u,4%',NULL,'%k Ð!K @ :',NULL,' jK¾K u,4%',NULL,NULL,NULL,' jK¾K u,4%',NULL,'{\"cb7d2554b0ce847cd82f3ac9bd1c0dfca\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":18.941199999999998482280716416426002979278564453125,\"gross\":22.53999999999999914734871708787977695465087890625,\"linked\":true,\"listPrice\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":0,\"gross\":0,\"linked\":true,\"listPrice\":null},\"percentage\":null}}','100763','0','0','1','1','[]','[]','SNK-P0047PSC','0672042108435','1',NULL,'1',NULL,NULL,'0','{\"cb7d2554b0ce847cd82f3ac9bd1c0dfca\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":17.690000000000001278976924368180334568023681640625,\"gross\":21.051100000000001699618223938159644603729248046875,\"linked\":true,\"listPrice\":null}}','0','0','0','0','0',NULL,NULL,'2023-04-28 16:08:42.180');':
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`d03cdc7b`.`product`, CONSTRAINT `product_ibfk_1` FOREIGN KEY (`product_manufacturer_id`, `product_manufacturer_version_id`) REFERENCES `product_manufacturer` (`id`, `version_id`) ON DELETE SE)
Response: {"jtlrpc":"2.0","id":"f634ba5d7a0544c79de97f1d0d13aa06","result":null,"error":{"code":520,"message":"Controller = Product | Action = push | JTL-Wawi PK = 20479 | SKU = 100763 | Name = Cooler Server SUPERMICRO SNK-P0047PSC (2011) 1U Passive | [69bfcb5f-b2b9-4abf-abe4-f5bb5988069c] 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 (\u0027aSm\ufffd\ufffdpG\u0026\ufffd\ufffd\u0002\ufffdfM)\ufffd\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-vf\ufffd\ufffd\ufffdG\\Z\ufffd\ufffdx\ufffd1E\\\\\\\u0027\u0027,\u0027\u000f\ufffd\u001c\ufffd\ufffdjK\u00beK\ufffd\ufffdu,4%\u0027,NULL,\u0027%k\ufffd\u00d0!K\u000f\ufffd\u0003\u0018@\ufffd\u001f\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:18.941199999999998482280716416426002979278564453125,\\\u0022gross\\\u0022:22.53999999999999914734871708787977695465087890625,\\\u0022linked\\\u0022:true,\\\u0022listPrice\\\u0022:{\\\u0022currencyId\\\u0022:\\\u0022b7d2554b0ce847cd82f3ac9bd1c0dfca\\\u0022,\\\u0022net\\\u0022:0,\\\u0022gross\\\u0022:0,\\\u0022linked\\\u0022:true,\\\u0022listPrice\\\u0022:null},\\\u0022percentage\\\u0022:null}}\u0027,\u0027100763\u0027,\u00270\u0027,\u00270\u0027,\u00271\u0027,\u00271\u0027,\u0027[]\u0027,\u0027[]\u0027,\u0027SNK-P0047PSC\u0027,\u00270672042108435\u0027,\u00271\u0027,NULL,\u00271\u0027,NULL,NULL,\u00270\u0027,\u0027{\\\u0022cb7d2554b0ce847cd82f3ac9bd1c0dfca\\\u0022:{\\\u0022currencyId\\\u0022:\\\u0022b7d2554b0ce847cd82f3ac9bd1c0dfca\\\u0022,\\\u0022net\\\u0022:17.690000000000001278976924368180334568023681640625,\\\u0022gross\\\u0022:21.051100000000001699618223938159644603729248046875,\\\u0022linked\\\u0022:true,\\\u0022listPrice\\\u0022:null}}\u0027,\u00270\u0027,\u00270\u0027,\u00270\u0027,\u00270\u0027,\u00270\u0027,NULL,NULL,\u00272023-04-28 16:08:38.468\u0027);\u0027:\n\nSQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`d03cdc7b`.`product`, CONSTRAINT `product_ibfk_1` FOREIGN KEY (`product_manufacturer_id`, `product_manufacturer_version_id`) REFERENCES `product_manufacturer` (`id`, `version_id`) ON DELETE SE)","data":"Jtl\\Shopware6\\Client\\Exception\\ClientException (Code: 520) in ...\/ClientException.php:100"}}
Exception bei product.push: Controller = Product | Action = push | JTL-Wawi PK = 20479 | SKU = 100763 | Name = Cooler Server SUPERMICRO SNK-P0047PSC (2011) 1U Passive | [182f5c52-3c57-4791-9005-192487d6f7fa] 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 (' oǪ CٯV4 C8b ',' jK¾K u,4%',NULL,' jK¾K u,4%','-vf G\Z x 1E\\\'',' jK¾K u,4%',NULL,'%k Ð!K @ :',NULL,' jK¾K u,4%',NULL,NULL,NULL,' jK¾K u,4%',NULL,'{\"cb7d2554b0ce847cd82f3ac9bd1c0dfca\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":18.941199999999998482280716416426002979278564453125,\"gross\":22.53999999999999914734871708787977695465087890625,\"linked\":true,\"listPrice\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":0,\"gross\":0,\"linked\":true,\"listPrice\":null},\"percentage\":null}}','100763','0','0','1','1','[]','[]','SNK-P0047PSC','0672042108435','1',NULL,'1',NULL,NULL,'0','{\"cb7d2554b0ce847cd82f3ac9bd1c0dfca\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":17.690000000000001278976924368180334568023681640625,\"gross\":21.051100000000001699618223938159644603729248046875,\"linked\":true,\"listPrice\":null}}','0','0','0','0','0',NULL,NULL,'2023-04-28 16:08:34.671');':
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`d03cdc7b`.`product`, CONSTRAINT `product_ibfk_1` FOREIGN KEY (`product_manufacturer_id`, `product_manufacturer_version_id`) REFERENCES `product_manufacturer` (`id`, `version_id`) ON DELETE SE)
Die Kategorien werden übertragen, Bilder und Artikel nicht
bekomme beim Abgleich dem Shopware 6 folgenden Fehler
Unbehandelte Ausnahme #959190594F6282F vom Typ System.Exception in
System.Exception: Exception: Controller = Product | Action = push | JTL-Wawi PK = 20479 | SKU = 100763 | Name = Cooler Server SUPERMICRO SNK-P0047PSC (2011) 1U Passive | [182f5c52-3c57-4791-9005-192487d6f7fa] 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 (' oǪ CٯV4 C8b ',' jK¾K u,4%',NULL,' jK¾K u,4%','-vf G\Z x 1E\\\'',' jK¾K u,4%',NULL,'%k Ð!K @ :',NULL,' jK¾K u,4%',NULL,NULL,NULL,' jK¾K u,4%',NULL,'{\"cb7d2554b0ce847cd82f3ac9bd1c0dfca\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":18.941199999999998482280716416426002979278564453125,\"gross\":22.53999999999999914734871708787977695465087890625,\"linked\":true,\"listPrice\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":0,\"gross\":0,\"linked\":true,\"listPrice\":null},\"percentage\":null}}','100763','0','0','1','1','[]','[]','SNK-P0047PSC','0672042108435','1',NULL,'1',NULL,NULL,'0','{\"cb7d2554b0ce847cd82f3ac9bd1c0dfca\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":17.690000000000001278976924368180334568023681640625,\"gross\":21.051100000000001699618223938159644603729248046875,\"linked\":true,\"listPrice\":null}}','0','0','0','0','0',NULL,NULL,'2023-04-28 16:08:34.671');':
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`d03cdc7b`.`product`, CONSTRAINT `product_ibfk_1` FOREIGN KEY (`product_manufacturer_id`, `product_manufacturer_version_id`) REFERENCES `product_manufacturer` (`id`, `version_id`) ON DELETE SE)
Controller = Product | Action = push | JTL-Wawi PK = 20479 | SKU = 100763 | Name = Cooler Server SUPERMICRO SNK-P0047PSC (2011) 1U Passive | [4e0b62ca-2695-45d2-8963-4285822041da] 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 ('ߘ Wp @$ `O ',' jK¾K u,4%',NULL,' jK¾K u,4%','-vf G\Z x 1E\\\'',' jK¾K u,4%',NULL,'%k Ð!K @ :',NULL,' jK¾K u,4%',NULL,NULL,NULL,' jK¾K u,4%',NULL,'{\"cb7d2554b0ce847cd82f3ac9bd1c0dfca\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":18.941199999999998482280716416426002979278564453125,\"gross\":22.53999999999999914734871708787977695465087890625,\"linked\":true,\"listPrice\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":0,\"gross\":0,\"linked\":true,\"listPrice\":null},\"percentage\":null}}','100763','0','0','1','1','[]','[]','SNK-P0047PSC','0672042108435','1',NULL,'1',NULL,NULL,'0','{\"cb7d2554b0ce847cd82f3ac9bd1c0dfca\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":17.690000000000001278976924368180334568023681640625,\"gross\":21.051100000000001699618223938159644603729248046875,\"linked\":true,\"listPrice\":null}}','0','0','0','0','0',NULL,NULL,'2023-04-28 16:08:42.180');':
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`d03cdc7b`.`product`, CONSTRAINT `product_ibfk_1` FOREIGN KEY (`product_manufacturer_id`, `product_manufacturer_version_id`) REFERENCES `product_manufacturer` (`id`, `version_id`) ON DELETE SE)
Unbehandelte Ausnahme #959190594F6282F vom Typ System.Exception in : 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 = 20479 | SKU = 100763 | Name = Cooler Server SUPERMICRO SNK-P0047PSC (2011) 1U Passive | [182f5c52-3c57-4791-9005-192487d6f7fa] 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 (' oǪ CٯV4 C8b ',' jK¾K u,4%',NULL,' jK¾K u,4%','-vf G\Z x 1E\\\'',' jK¾K u,4%',NULL,'%k Ð!K @ :',NULL,' jK¾K u,4%',NULL,NULL,NULL,' jK¾K u,4%',NULL,'{\"cb7d2554b0ce847cd82f3ac9bd1c0dfca\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":18.941199999999998482280716416426002979278564453125,\"gross\":22.53999999999999914734871708787977695465087890625,\"linked\":true,\"listPrice\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":0,\"gross\":0,\"linked\":true,\"listPrice\":null},\"percentage\":null}}','100763','0','0','1','1','[]','[]','SNK-P0047PSC','0672042108435','1',NULL,'1',NULL,NULL,'0','{\"cb7d2554b0ce847cd82f3ac9bd1c0dfca\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":17.690000000000001278976924368180334568023681640625,\"gross\":21.051100000000001699618223938159644603729248046875,\"linked\":true,\"listPrice\":null}}','0','0','0','0','0',NULL,NULL,'2023-04-28 16:08:34.671');':
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`d03cdc7b`.`product`, CONSTRAINT `product_ibfk_1` FOREIGN KEY (`product_manufacturer_id`, `product_manufacturer_version_id`) REFERENCES `product_manufacturer` (`id`, `version_id`) ON DELETE SE)
Controller = Product | Action = push | JTL-Wawi PK = 20479 | SKU = 100763 | Name = Cooler Server SUPERMICRO SNK-P0047PSC (2011) 1U Passive | [4e0b62ca-2695-45d2-8963-4285822041da] 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 ('ߘ Wp @$ `O ',' jK¾K u,4%',NULL,' jK¾K u,4%','-vf G\Z x 1E\\\'',' jK¾K u,4%',NULL,'%k Ð!K @ :',NULL,' jK¾K u,4%',NULL,NULL,NULL,' jK¾K u,4%',NULL,'{\"cb7d2554b0ce847cd82f3ac9bd1c0dfca\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":18.941199999999998482280716416426002979278564453125,\"gross\":22.53999999999999914734871708787977695465087890625,\"linked\":true,\"listPrice\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":0,\"gross\":0,\"linked\":true,\"listPrice\":null},\"percentage\":null}}','100763','0','0','1','1','[]','[]','SNK-P0047PSC','0672042108435','1',NULL,'1',NULL,NULL,'0','{\"cb7d2554b0ce847cd82f3ac9bd1c0dfca\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":17.690000000000001278976924368180334568023681640625,\"gross\":21.051100000000001699618223938159644603729248046875,\"linked\":true,\"listPrice\":null}}','0','0','0','0','0',NULL,NULL,'2023-04-28 16:08:42.180');':
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`d03cdc7b`.`product`, CONSTRAINT `product_ibfk_1` FOREIGN KEY (`product_manufacturer_id`, `product_manufacturer_version_id`) REFERENCES `product_manufacturer` (`id`, `version_id`) ON DELETE SE)
Response: {"jtlrpc":"2.0","id":"f634ba5d7a0544c79de97f1d0d13aa06","result":null,"error":{"code":520,"message":"Controller = Product | Action = push | JTL-Wawi PK = 20479 | SKU = 100763 | Name = Cooler Server SUPERMICRO SNK-P0047PSC (2011) 1U Passive | [69bfcb5f-b2b9-4abf-abe4-f5bb5988069c] 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 (\u0027aSm\ufffd\ufffdpG\u0026\ufffd\ufffd\u0002\ufffdfM)\ufffd\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-vf\ufffd\ufffd\ufffdG\\Z\ufffd\ufffdx\ufffd1E\\\\\\\u0027\u0027,\u0027\u000f\ufffd\u001c\ufffd\ufffdjK\u00beK\ufffd\ufffdu,4%\u0027,NULL,\u0027%k\ufffd\u00d0!K\u000f\ufffd\u0003\u0018@\ufffd\u001f\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:18.941199999999998482280716416426002979278564453125,\\\u0022gross\\\u0022:22.53999999999999914734871708787977695465087890625,\\\u0022linked\\\u0022:true,\\\u0022listPrice\\\u0022:{\\\u0022currencyId\\\u0022:\\\u0022b7d2554b0ce847cd82f3ac9bd1c0dfca\\\u0022,\\\u0022net\\\u0022:0,\\\u0022gross\\\u0022:0,\\\u0022linked\\\u0022:true,\\\u0022listPrice\\\u0022:null},\\\u0022percentage\\\u0022:null}}\u0027,\u0027100763\u0027,\u00270\u0027,\u00270\u0027,\u00271\u0027,\u00271\u0027,\u0027[]\u0027,\u0027[]\u0027,\u0027SNK-P0047PSC\u0027,\u00270672042108435\u0027,\u00271\u0027,NULL,\u00271\u0027,NULL,NULL,\u00270\u0027,\u0027{\\\u0022cb7d2554b0ce847cd82f3ac9bd1c0dfca\\\u0022:{\\\u0022currencyId\\\u0022:\\\u0022b7d2554b0ce847cd82f3ac9bd1c0dfca\\\u0022,\\\u0022net\\\u0022:17.690000000000001278976924368180334568023681640625,\\\u0022gross\\\u0022:21.051100000000001699618223938159644603729248046875,\\\u0022linked\\\u0022:true,\\\u0022listPrice\\\u0022:null}}\u0027,\u00270\u0027,\u00270\u0027,\u00270\u0027,\u00270\u0027,\u00270\u0027,NULL,NULL,\u00272023-04-28 16:08:38.468\u0027);\u0027:\n\nSQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`d03cdc7b`.`product`, CONSTRAINT `product_ibfk_1` FOREIGN KEY (`product_manufacturer_id`, `product_manufacturer_version_id`) REFERENCES `product_manufacturer` (`id`, `version_id`) ON DELETE SE)","data":"Jtl\\Shopware6\\Client\\Exception\\ClientException (Code: 520) in ...\/ClientException.php:100"}}
Exception bei product.push: Controller = Product | Action = push | JTL-Wawi PK = 20479 | SKU = 100763 | Name = Cooler Server SUPERMICRO SNK-P0047PSC (2011) 1U Passive | [182f5c52-3c57-4791-9005-192487d6f7fa] 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 (' oǪ CٯV4 C8b ',' jK¾K u,4%',NULL,' jK¾K u,4%','-vf G\Z x 1E\\\'',' jK¾K u,4%',NULL,'%k Ð!K @ :',NULL,' jK¾K u,4%',NULL,NULL,NULL,' jK¾K u,4%',NULL,'{\"cb7d2554b0ce847cd82f3ac9bd1c0dfca\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":18.941199999999998482280716416426002979278564453125,\"gross\":22.53999999999999914734871708787977695465087890625,\"linked\":true,\"listPrice\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":0,\"gross\":0,\"linked\":true,\"listPrice\":null},\"percentage\":null}}','100763','0','0','1','1','[]','[]','SNK-P0047PSC','0672042108435','1',NULL,'1',NULL,NULL,'0','{\"cb7d2554b0ce847cd82f3ac9bd1c0dfca\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":17.690000000000001278976924368180334568023681640625,\"gross\":21.051100000000001699618223938159644603729248046875,\"linked\":true,\"listPrice\":null}}','0','0','0','0','0',NULL,NULL,'2023-04-28 16:08:34.671');':
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`d03cdc7b`.`product`, CONSTRAINT `product_ibfk_1` FOREIGN KEY (`product_manufacturer_id`, `product_manufacturer_version_id`) REFERENCES `product_manufacturer` (`id`, `version_id`) ON DELETE SE)
Die Kategorien werden übertragen, Bilder und Artikel nicht