Collecting MustGather data for SEOURLKEYWORDGEN issues

Prepare the following MustGather information before you call IBM 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 we 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 the database (output results in CSV format).

   SELECT * SEOURL
   SELECT * FROM SEOURLKEYWORD
   SELECT * FROM STORE
   SELECT * FROM STOREENT
   select * from CATENTRY where catentry_id = (catentry we are having an issue with)
   select * from CATGROUP where catgroup_id = (catgroup we are having an issue with)