Collecting MustGather data for SEOURLKEYWORDGEN issues
Prepare the following MustGather information before you call HCL Support to help with SEOURLKEYWORDGEN issues.
Procedure
- Enter the Utility server Docker container.
- Open the /opt/WebSphere/CommerceServer90/ts.ear/xml/config/seourlload/logging.properties file.
- Change all occurrences of "=INFO" to "=FINEST".
-
Reproduce the problem.
Record the specific steps that you used to reproduce the problem and any details that might be relevant.
- Collect the /opt/WebSphere/CommerceServer90/logs/wc-seo-url-load.log file.
-
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)