akeneo / magento2-connector-community

Akeneo Connector for Magento 2
Open Software License 3.0
81 stars 88 forks source link

Product Import Job throws thousands of "Undefined index: table_configuration" errors and skips them. #622

Open wmdkdkussin opened 1 year ago

wmdkdkussin commented 1 year ago

Hello

We are using Magento CE v2.3.7 (can't update right now), Akeneo EE v5.0.76 and Akeneo Connector CE v103.3.0.

During Product Import Job the connector throws the following issue:

product
[11:34:50] Start import
[11:34:50] Import ID : 634d3dda5ecf1
[11:34:50] Create temporary table
[11:34:50] completed Family imported in this batch: pattern
[11:34:50] Fill temporary table
[11:34:52] Notice: Undefined index: table_configuration in /var/www/clients/client4/web784/private/releases/3/vendor/akeneo/module-magento2-connector-community/Job/Product.php on line 536

I create a Composer patch to log and skip the issue and it turned out, that we have 35309 products which throw this issue and are skipped.

What causes this issue and how can it be solved?

NOTE: I don't explain how to reproduce it, because it has probably to do with our setup and it's simply caused by the product import job.

Thanks for your support.

BR, Daniel

wmdkdkussin commented 1 year ago

The issue appears here: https://github.com/akeneo/magento2-connector-community/blob/master/Job/Product.php#L540 and I did a manual api call and I received the following response:

{
    "code": "ingredients_table",
    "type": "pim_catalog_table",
    "group": "ingredients",
    "unique": false,
    "useable_as_grid_filter": false,
    "allowed_extensions": [
    ],
    "metric_family": null,
    "default_metric_unit": null,
    "reference_data_name": null,
    "available_locales": [
    ],
    "max_characters": null,
    "validation_rule": null,
    "validation_regexp": null,
    "wysiwyg_enabled": null,
    "number_min": null,
    "number_max": null,
    "decimals_allowed": null,
    "negative_allowed": null,
    "date_min": null,
    "date_max": null,
    "max_file_size": null,
    "minimum_input_length": null,
    "sort_order": 0,
    "localizable": false,
    "scopable": false,
    "labels": {
        "de_DE": "Zutaten Tabelle",
        "en_GB": "Ingredients table",
        "en_US": "Ingredients table",
        "it_IT": "Tabella occorrente"
    },
    "auto_option_sorting": null,
    "is_read_only": null,
    "default_value": null,
    "group_labels": {
        "en_US": "Ingredients",
        "de_DE": "Zutaten",
        "en_GB": "Ingredients",
        "fi_FI": "Ingredients",
        "fr_FR": "Ingredients",
        "it_IT": "Ingredients"
    }
}

How can that be? What need to be done or changed in Akeneo?