2.2.x-dev main.ERROR: Bulk index operation failed 1 times in index magento2_default_catalog_product_20160711_144337 for type product Error (mapper_parsing_exception) : failed to parse [option_text_attribute_s_12420] Failed doc ids sample : 1585697 #81
Comments
|
[2016-07-11 10:44:16,272][DEBUG][action.bulk ] [ossec_node1] [magento2_default_catalog_product_20160711_144337][0] failed to execute bulk item (index) index {[magento2_default_catalog_product_20160711_144337][product][1576721], source[{"entity_id":"1576721","attribute_set_id":"104","type_id":"simple","sku":"9999-342-1623","has_options":"0","required_options":"0","created_at":"2016-07-09 21:08:44","updated_at":"2016-07-09 21:48:22","etilize_product_id":"1025500659","visibility":"4","price":[{"price":"240.0600","original_price":"240.0600","is_discount":false,"customer_group_id":"0"},{"price":"240.0600","original_price":"240.0600","is_discount":false,"customer_group_id":"1"},{"price":"240.0600","original_price":"240.0600","is_discount":false,"customer_group_id":"2"},{"price":"240.0600","original_price":"240.0600","is_discount":false,"customer_group_id":"3"}],"category":[{"category_id":3},{"category_id":126,"name":"I/O & Storage Controllers"},{"category_id":127,"is_parent":true,"name":"SCSI/RAID Controllers"},{"category_id":206,"name":"Storage Components"},{"category_id":368,"name":"Information Technology"}],"name":["Dell-IMSourcing NEW F/S PERC H700 SAS Controller 342-1623"],"mfgpartno":["342-1623"],"ean_sku_code":["0609527729021"],"gtin_sku_code":["0609527729021"],"ingram_micro_usa_sku_code":["TC2689,TC2688"],"unspsc_sku_code":["43201556"],"upc_sku_code":["609527729021"],"attribute_s_1100":["8752"],"option_text_attribute_s_1100":["SAS Controller"],"attribute_s_11506":["2500"],"option_text_attribute_s_11506":["Plug-in Card"],"attribute_s_188":["14740"],"option_text_attribute_s_188":["PCI Express 2.0 x8"],"attribute_s_12749":["17187"],"option_text_attribute_s_12749":["6Gb/s SAS"],"attribute_s_12420":["5092","5094","5097","5100","9584","9586","9587"], "option_text_attribute_s_12420":{"1":"1","2":"10","3":"5","4":"50","5":"6","6":"60"}, "description":["Dell-IMSourcing NEW F/S PERC H700 SAS Controller - 6Gb/s SAS - PCI Express 2.0 x8 - Plug-in Card - RAID Supported - 0, 1, 10, 5, 50, 6, 60 RAID Level - 8 Total SAS Port(s) - 2 SAS Port(s) Internal"],"short_description":["Dell-IMSourcing NEW F/S PERC H700 SAS Controller"],"manufacturer":[70],"option_text_manufacturer":["Dell-IMSourcing"],"status":[1],"option_text_status":["Enabled"],"tax_class_id":[2],"option_text_tax_class_id":["Taxable Goods"],"attribute_s_113319":[28151],"option_text_attribute_s_113319":["Dell-IMSourcing"],"attribute_s_111115654":[4879],"option_text_attribute_s_111115654":["Yes"],"attribute_s_111119653":[12657],"option_text_attribute_s_111119653":["8"],"stock":{"is_in_stock":false,"qty":0}}]} |
|
We will see how we can secure such list containing commas. On naive question : why are you not using multi-value attributes instead ? |
|
Sorry I closed the issue by mistake. My bad. |
|
This is utilizing 3rd party import routine, which also imports one attribute with "dandh inc,._sku" as name which throws a fit as well due to having period in the attribute_code!. I am not sure how to modify the importer to behave! Is there a list of illegal characters I can try to change the attributes to avoid or escape? |
|
933 | 83 | 936 | 933 | 933 | 0 | Pathway Innovations & Technologies, Inc., | is a result of all eav_attribute_option_value where like '%,%,%'; Do you think the Contrast Ratio 5,000,000 values with two commas will get thrown out? What about MFR names with multiple comma's? |
|
Can you try the following :
public function getIndexOptionsText(AttributeInterface $attribute, $storeId, array $optionIds)
{
$mapper = function ($optionId) use ($attribute, $storeId) {
return $this->getIndexOptionText($attribute, $storeId, $optionId);
};
$optionValues = array_map($mapper, $optionIds);
return array_values($optionValues);
}If the indexer is working again we will evaluate the opportunity to merge the code. (Not sure about multiple faceting code but we will see it once indexing will be fixed). BR, |
|
Note : My point about multiple select was about the fact you have the same option (let say JBOD) in several values. It makes hard to select all device with the JBOD option (you have many value to select. I think the value should be exploded at import time. |
|
Before patch: after patch: (i selected one more option) Need to strip off "1" "2" "3" "4" "5" "6" "7" of array ? MapperParsingException[failed to parse [option_text_attribute_s_12420]]; nested: IllegalArgumentException[unknown property [1]]; I noticed on prior attribute: I believe it is multi-select but it does not have array_key (1...7)? |
|
I replaced(value,',','*') on that attribute and it still fails with no comma's present anymore? |
|
I think the following commit 9862a8a may fix this issue. BR, |
|
@southerncomputer : did you manage to test the proposed solution ? |
|
Yes and no. I thought with UPDATE on SAVE - saving the malformed product would upsert the data into the current index. It did make its call to elasticsearch without error. but now I am forced to do a catalogsearch_fulltext full reindex from command line which will take a bit of time, so far no errors on either post method which is definitely better than before! |
|
Correct me if I am wrong but what I understand with your last message is that the full reindex is only required once (to fix the products that are missing) but once done, everything works has expected. If so, can we consider the bug closed ? |
|
You can close the ticket, the error has not showed up yet and reindex takes about 3-4 hours to verify - but i would have seen the debug log throw errors by now! thanks! |
|
You're welcome. Thx for reporting. |
…session Disable session start on instant search requests.
ghost
mentioned this issue
php -q bin/magento reindex:catalogsearch_fulltext
[2016-07-11 14:45:35] main.ERROR: Bulk index operation failed 1 times in index magento2_default_catalog_product_20160711_144337 for type product Error (mapper_parsing_exception) : failed to parse [option_text_attribute_s_12420] Failed doc ids sample : 1585697 [] []
main.ERROR: Bulk index operation failed 2 times in index magento2_default_catalog_product_20160711_144337 for type product Error (mapper_parsing_exception) : failed to parse [option_text_attribute_s_12420] Failed doc ids sample : 1628343, 1628350 [] []
Any thoughts on why the indexer is failing this attribute and document?
The text was updated successfully, but these errors were encountered: