Collecting MustGather data for service provider (subscriptions and recurring orders) issues
Prepare the following MustGather information before you call HCL Support to help with service provider (subscriptions and recurring orders) issues.
Procedure
-
Configure the following trace strings.
- In the Transaction server Docker container:
For information about how to set trace strings, see Configuring logging for the Transaction server.com.ibm.websphere.commerce.WC_SCHEDULER=all: com.ibm.commerce.subscription.*=all
- In the Store server Docker container:
For information about how to set trace strings, see Configuring logging for the Store server.*=info:com.ibm.commerce.foundation.logging.*=all
- In the Search server Docker container:
For information about how to set trace strings, see Configuring logging for the Search server.*=info:com.ibm.commerce.foundation.logging.*=all
- In the Transaction server Docker container:
-
Reproduce the problem.
Record the specific steps that you used to reproduce the problem and any details that might be relevant.
-
Collect the following files from the Transaction server Docker container.
- /opt/WebSphere/AppServer/profiles/default/installedApps/localhost/ts.ear/xml/config/com.ibm.commerce.order/*
- /opt/WebSphere/AppServer/profiles/default/installedApps/localhost/ts.ear/xml/config/com.ibm.commerce.subscription-ext/*
-
Run the following database queries to collect the necessary information from your database
(output results in CSV format).
SELECT * FROM SUBSCRSCHJOBS SELECT * FROM SUBSCRIPTION SELECT * FROM SCHCONFIG where SCCPATHINFO='SubscriptionSchedulerCmd' SELECT * FROM SCHSTATUS where SCSJOBNBR in (select SCCJOBREFNUM from SCHCONFIG where SCCPATHINFO ='SubscriptionSchedulerCmd') SELECT * FROM SUBSCRTEMPLATE SELECT * FROM SUBSCRTMPLITEMLIST