Collecting Solr based search-related MustGather data for search Rules Based Sales Categories issues
Prepare the following MustGather information before you call HCL Support to help with the troubleshooting process.
Procedure
-
Configure the following trace specifications.
- In the Transaction server Docker container:
For information about how to set trace strings, see Configuring logging for the Transaction server.:*=info:com.ibm.commerce.rest.*=all:com.ibm.commerce.marketing.*=all:com.ibm.commerce.foundation.*=all:com.ibm.commerce.catalog.*=finest
- In the Search server Docker container:
For information about how to set trace strings, Configuring logging for the Search server.com.ibm.commerce.rest.*=all:com.ibm.commerce.foundation.*=all
For information about how to configure trace strings, see - In the Transaction server Docker container:
-
Reproduce the problem.
Record the specific steps that you used to reproduce the problem and any details that might be relevant.
-
Collect the following files.
In the Search server Docker container:
- /opt/WebSphere/Liberty/usr/servers/default/resources/search/index/managed-solr/config/v3/*
- /opt/WebSphere/Liberty/usr/servers/default/resources/search/index/managed-solr/config/v3-index-ext/*
-
Run the following database queries to collect the necessary information from your database
(output results in CSV format).
-
SELECT * FROM CATGRPRULE;
-
SELECT * from CATGPENREL where catgroup_id=<catgroup ID>;
-