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)