Collecting MustGather data for SEOURLKEYWORDGEN issues

Prepare the following MustGather information before you call HCL Support to help with SEOURLKEYWORDGEN issues.

Procedure

  1. Enter the Utility server Docker container.
  2. Open the /opt/WebSphere/CommerceServer90/ts.ear/xml/config/seourlload/logging.properties file.
  3. Change all occurrences of "=INFO" to "=FINEST".
  4. Reproduce the problem.

    Record the specific steps that you used to reproduce the problem and any details that might be relevant.

  5. Collect the /opt/WebSphere/CommerceServer90/logs/wc-seo-url-load.log file.
  6. Run the following database queries to collect the necessary information from your database (output results in CSV format).
    SELECT * SEOURL
    SELECT * FROM SEOURLKEYWORD
    SELECT * FROM STORE
    SELECT * FROM STOREENT
    select * from CATENTRY where catentry_id = (catentry you are having an issue with)
    select * from CATGROUP where catgroup_id = (catgroup you are having an issue with)