HCL Commerce Version 9.1.2.0 or later

Collecting Elasticsearch based search-related MustGather data for Rule Based Sales Category Setup

Prepare the following MustGather information before you call HCL Support to help with the troubleshooting process.

Procedure

  1. Log into the query server Docker container. Edit the file /profile/apps/search-query.ear/search-query.war/WEB-INF/classes/logback.xml. Update the trace configuration setting from "error" to "all."
    <logger name="com.hcl.commerce.search" level="all" additivity="false">
  2. The following setting controls how many seconds you must wait before your changes are registered in the system. If scanPeriod is set to a large number, you can wait, or restart the Query server so that they are picked up immediately.
    <configuration scan="true" scanPeriod="30 seconds"> 
  3. Enable the following tracing on your Transaction server.
    *=info:com.ibm.commerce.rest.*=all:com.ibm.commerce.marketing.*=all:com.ibm.commerce.foundation.*=all:com.ibm.commerce.catalog.*=finest
  4. Reproduce your Rule Based Sales Category (RBSC) setup issue. Record the specific steps that you used to reproduce the problem and any details that might be relevant.
  5. Collect the trace files generated in the following directory on your query server.
    /app/ESQueryService/logs/​ 
    Collect the trace files generated in the following directory on your Transaction server.
    /opt/WebSphere/AppServer/profiles/default/logs/container/{{container_name}}/
  6. Collect the following file from the Transaction server.
    /opt/WebSphere/AppServer/profiles/default/installedApps/localhost/ts.ear/xml/config/com.ibm.commerce.catalog-ext/wc-admin-component.xml
  7. 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_for_RBSC>;
    
    SELECT * FROM SCHSTATUS WHERE SCSJOBNBR IN (SELECT SCCJOBREFNUM FROM SCHCONFIG WHERE SCCPATHINFO = 'EvaluateRuleBasedCategories' OR SCCPATHINFO = 'RuleBasedCategoryEvaluation');
    
    SELECT * FROM SCHACTIVE WHERE SCSJOBNBR IN (SELECT SCCJOBREFNUM FROM SCHCONFIG WHERE SCCPATHINFO = 'EvaluateRuleBasedCategories' OR SCCPATHINFO = 'RuleBasedCategoryEvaluation');