HCL Commerce Version 9.1.4.0

Troubleshooting: Index changes are not reflected in storefront after Elasticsearch push-to-live

In Version 9.1.4.0 only, you need to ensure that WCT+ESINDEX invalidation is triggered after a push-to-live operation. This ensures that index changes are reflected in the live store.

Problem

HCL CommerceAfter a push-to-live operation, Catalog data changes are not available in live stores because there has been no corresponding cache invalidation.

Solution

To propagate index changes to a live store, trigger WCT+ESINDEX invalidation in the following caches:
services/cache/SearchSystemDistributedMapCache
services/cache/SearchDistributedMapCache
services/cache/SearchFacetDistributedMapCache
services/cache/SearchCatHierarchyDistributedMapCache
services/cache/SearchQueryDistributedMapCache
baseCache
You can invalidate the caches using one of two methods. You can use the Version 9.1.4 Cache Manager by issuing the following REST commands:
curl -X DELETE "https://{cachemanager_host}/cm/cache/invalidate?cache=services%2Fcache%2FSearchSystemDistributedMapCache&id=WCT%2BESINDEX" -H "accept: /"
curl -X DELETE "https://{cachemanager_host}/cm/cache/invalidate?cache=services%2Fcache%2FSearchDistributedMapCache&id=WCT%2BESINDEX" -H "accept: /"
curl -X DELETE "https://{cachemanager_host}/cm/cache/invalidate?cache=services%2Fcache%2FSearchFacetDistributedMapCache&id=WCT%2BESINDEX" -H "accept: /"
curl -X DELETE "https://{cachemanager_host}/cm/cache/invalidate?cache=services%2Fcache%2FSearchCatHierarchyDistributedMapCache&id=WCT%2BESINDEX" -H "accept: /"
curl -X DELETE "https://{cachemanager_host}/cm/cache/invalidate?cache=services%2Fcache%2FSearchQueryDistributedMapCache&id=WCT%2BESINDEX" -H "accept: /"
curl -X DELETE "https://{cachemanager_host}/cm/cache/invalidate?cache=baseCache&id=WCT%2BESINDEX" -H "accept: /" 
For more information, see HCL Cache.
Alternatively, you can invalidate using the CACHEIVL table. This method may take up to four minutes to activate:
insert into cacheivl (template, dataid) values ('dmap:services/cache/SearchSystemDistributedMapCache','WCT+ESINDEX')
insert into cacheivl (template, dataid) values ('dmap:services/cache/SearchDistributedMapCache', 'WCT+ESINDEX')
insert into cacheivl (template, dataid) values ('dmap:services/cache/SearchFacetDistributedMapCache','WCT+ESINDEX')
insert into cacheivl (template, dataid) values ('dmap:services/cache/SearchCatHierarchyDistributedMapCache','WCT+ESINDEX')
insert into cacheivl (template, dataid) values ('dmap:services/cache/SearchQueryDistributedMapCache','WCT+ESINDEX')
insert into cacheivl (dataid) values ('WCT+ESINDEX')