Collecting MustGather data for authoring workspaces issues

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

Procedure

  1. Configure the following trace strings.
    • In the Transaction server Docker container
      com.ibm.websphere.commerce.WC_SERVER=all: com.ibm.websphere.commerce.WC_WORKSPACE=all: com.ibm.websphere.commerce.WC_WORKSPACE_TOOL=all: com.ibm.websphere.commerce.WC_CONTENT=all
      For information about how to set trace strings, see Configuring logging for the Transaction Server.
  2. Reproduce the problem.

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

  3. Collect the following files.
    • From the Transaction server Docker container:
      • /opt/WebSphere/AppServer/profiles/default/logs/server1/SystemOut*.log
      • /opt/WebSphere/AppServer/profiles/default/logs/server1/trace*.log
  4. Run the following database queries to collect the necessary information from your database (output results in CSV format). 
    SELECT * FROM CMFTASK 
SELECT * FROM CMFTASKDSC
SELECT * FROM CMFTASKGRP
SELECT * FROM CMFTGTSKREL
SELECT * FROM CMFTSKMBREL
SELECT * FROM CMFWKSPC
SELECT * FROM CMFWKSPCDSC
SELECT * FROM CMFWSTGREL
SELECT * FROM CMMETADATA
SELECT * FROM SCHCONFIG
SELECT * FROM SCHSTATUS
SELECT * FROM SCHACTIVE
SELECT * FROM CMWORKSPACE
SELECT * FROM CMWSSCHEMA
SELECT * FROM CMFTGDSC