Collecting MustGather data for price rule issues

Prepare the following MustGather information before you call IBM Support to help with price rule issues.

Procedure

1. Configure the following trace strings in the Transaction server Docker container.

   com.ibm.commerce.foundation.*=all: com.ibm.commerce.price.*=all: com.ibm.websphere.commerce.WC_CONTRACT=all: com.ibm.websphere.commerce.WC_ORDER=all: com.ibm.commerce.catalog.*=all: 

   For information about how to set trace strings, see Configure logging for the Transaction Server.

2. Reproduce the problem.

   Record the specific steps that we 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/trace*.log

   Also collect the following information.

   • Name or ID's of the of Price Rule, catalog, contract, catentry_id, and store.

   • Screen-shot of the price rule in Management Center.

   • Name of the product that is affected by the price rule.

4. Run the following database queries to collect the necessary information from the database (output results in CSV format).

   select * from STORE
   select * STORECNTR
   select * CONTRACT
   select * TRADING
   select * TERMCOND
   select * STORETPC
   select * TRADEPOSCN
   select * PRICERULE
   select * PRELEMENT
   select * PRELEMENTATTR
   select * from OFFER where catentry_id=<your catentry_id>
   select * from Offerprice where offer_id in (select * from OFFER where catentry_id=<your catentry_id>)