Collecting MustGather data for price rule issues

Prepare the following MustGather information before you call HCL 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 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/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 your 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>)