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 .
  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)