HCL Commerce Version 9.1.7.0

Troubleshooting: Search index fails for newly created aurora esite

With a newly created an Aurora e-site store, the search index build can fail with a Null Pointer Exception (NPE) error.

Problem

After creating an Aurora e-site store, the search index build for the store can fail with an NPE:

Unhandled error encountered: java.lang.NullPointerException\n\tat com.hcl.software.data.ingest.controller.service.StoreControllerService.resolveConfigurations(StoreControllerService.java:205)

Solution

  1. Run the following SQL.
    INSERT INTO storeconf (STOREENT_ID, NAME, VALUE, OPTCOUNTER) VALUES (<store_id>, 'wc.price.variant', 'enabled', 1);
INSERT INTO storeconf (STOREENT_ID, NAME, VALUE, OPTCOUNTER) VALUES (<store_id>, 'wc.search.priceMode.compatiblePriceIndex', '1.0', 1);
  2. Rebuild the search index.

The search index builds correctly.