I migrated from Magento 1.9.3.3 to Magento 2.1.7 EE. I have one issue, that is some of the attributes(multiple select) not shown in layer navigation.
Create new category called test,
Assign two products to test category, that two products have multiple select attributes.
Multiple select attribute have the below properties
but it is not rendering in layer navigation.
If anyone faces this issue before, please post the solution.
Note: Migrated attributes only have this issues, If I create a new attribute with similar fashion, it works!
Best Answer
The steps to resolve this issue after migrating is first to open the attribute and save it again, this will set the type from text to varchar. After this run the SQL below to copy all data from the text to the varchar table.
Now delete the data from the text table
Run in terminal
If the reindex is giving a duplication error, search for the entity_id in the catalog_product_entity_varchar table and check if there is a duplicate value for the attribute id in the field.