Collecting MustGather data for Sterling OMS heartbeat issues

Prepare the following MustGather information before you call HCL Support to help with Sterling OMS heartbeat issues.

Procedure

  1. Configure the following trace string in the . 
    *=info:com.ibm.commerce.inventory.*=all:com.ibm.commerce.order.*=all:com.ibm.websphere.commerce.WC_ORDER=all:com.ibm.websphere.commerce.WC_SCHEDULER=all:com.ibm.commerce.foundation.logging.ServiceLogger=finest:com.ibm.websphere.commerce.WC_INVENTORY=all
    For information about how to set trace strings, see Configuring logging for the.
  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 .
    • /opt/WebSphere/AppServer/profiles/default/installedApps/localhost/ts.ear/xml/config/com.ibm.commerce.inventory.external/wc-component-client.xml
    • /opt/WebSphere/AppServer/profiles/default/installedApps/localhost/ts.ear/xml/config/com.ibm.commerce.order/wc-admin-component.xml
    • /opt/WebSphere/AppServer/profiles/default/installedApps/localhost/ts.ear/xml/config/wc-server.xml
    • /opt/WebSphere/AppServer/profiles/default/logs/server1/*.*
    • Sterling_installDir/logs/
    • Sterling_profileDir/logs/server/
  4. Run the following database queries to collect the necessary information from your database (output results in CSV format). 
    SELECT * FROM SITE
SELECT * FROM STOREENT	
SELECT * FROM SCHCONFIG WHERE SCCPATHINFO='SterlingOMSUpdateSystemState
SELECT * FROM SCHSTATUS WHERE SCSJOBNBR IN (SELECT SCCJOBREFNUM FROM SCHCONFIG WHERE SCCPATHINFO ='SterlingOMSUpdateSystemState')