Troubleshooting: Deleting Attribute Dictionary attributes requires cleanup

You must clean up the search facets configuration data when an Attribute Dictionary attribute is deleted and recreated from the WebSphere Commerce database. Otherwise, no facet appears in the storefront. This applies when deleting Attribute Dictionary attributes using the Management Center or Dataload.

Identifying which attributes require cleanup

You must perform the following cleanup steps if the attribute is marked as one of the following in the attribute dictionary:

Searchable
Use in merchandising

These steps are not required if the attribute is marked as the following in the attribute dictionary:

Facetable

Solution

To resolve this issue, you must clean up the search facets configuration data in the following tables:

Otherwise, when you recreate an Attribute Dictionary attribute with the same name, it is not correctly indexed, and as a result, no facet appears in the storefront.

See Logical representation of indexed columns for more information.