Running Solr version 7.3.0 with HCL Commerce 9.1.19+

HCL Commerce 9.1.19+ introduces changes to the Transaction Server (ts-app) data import processing for search attributes. If you are continuing to use a Solr 7.3 Query application from HCL Commerce 9.1.17.x with HCL Commerce 9.1.19 or later, additional configuration is required to ensure compatibility with your existing Solr customizations.

Without this update, attribute indexing for catalog entries may not function as expected. This topic explains how to update the required configuration file to allow Solr 7.3 Query application (9.1.17.x) to work with HCL Commerce 9.1.19+.

When is this configuration required?

You must apply this change if:

You upgraded HCL Commerce ts-app to 9.1.19 or later, and
You are still using Solr 7.3 Query application from 9.1.17.x, and
You want to preserve existing Solr customizations.

If you are running Solr that matches the HCL Commerce version, no action is required.

File to update

Update the database-specific version of:

wc-dataport-preprocess-attribute.xml

Location inside the ts-app container:/profile/installedApps/hostname/ts.ear/xml/search/dataImport/v3/database/CatalogEntry

Where database is your database type (for example, db2 or oracle).

Procedure

Access the ts-app container

Connect into the Transaction Server container where HCL Commerce is running.

Open the configuration file

Edit the following file: wc-dataport-preprocess-attribute.xml

Update attribute processing logic

For DB2 users, Locate line 253 and replace:


COALESCE(NULLIF(ATTRVALDESC.IMAGE2, ''), '0') || '/' ||
COALESCE(TO_CHAR(ATTR.FIELD1), 'NULL') || '/' ||
COALESCE(TO_CHAR(ATTR.FIELD2), 'NULL') || '/' ||
COALESCE(NULLIF(ATTR.FIELD3, ''), '0') ATTRIBUTES

with:

COALESCE(NULLIF(ATTRVALDESC.IMAGE2, ''), '0') ATTRIBUTES

Also update line 299, replacing the same multi-field expression with:

COALESCE(NULLIF(ATTRVALDESC.IMAGE2, ''), '0') ATTRIBUTES

For Oracle users, Locate line 256 and replace:


COALESCE(NULLIF(ATTRVALDESC.IMAGE2, ''), '0') || '/' ||
COALESCE(TO_CHAR(ATTR.FIELD1), 'NULL') || '/' ||
COALESCE(TO_CHAR(ATTR.FIELD2), 'NULL') || '/' ||
COALESCE(NULLIF(ATTR.FIELD3, ''), '0') ATTRIBUTES

with:

COALESCE(NULLIF(ATTRVALDESC.IMAGE2, ''), '0') ATTRIBUTES

Remove the SOFTWARE_STACK parameter from the env.sh configuration file

For more information, see Deploying HCL Commerce Version 9.1 with Solr-based search and an IBM Db2 database using Docker Compose.

After you have completed these changes, rebuild your index.

Result

After applying this change:

The Solr 7.3 Query application remains compatible with HCL Commerce 9.1.19+.
Existing customizations continue to function.
The attribute export format aligns with 9.1.19+ expectations.

Note: This change is effective immediately and does not require restarting the container. However, the container image needs to be customized when running inside of Kubernetes environment.