MustGather: Catalog Tooling (Management Center) Issues in WebSphere Commerce V7.0

Technote (troubleshooting)


MustGather: Catalog Tooling Issues in WebSphere Commerce V7.0

Resolving the problem

Gathering this MustGather information before calling IBM Support will help familiarize you with the troubleshooting process and save you time.

To improve the accuracy of complete data collection, IBM recommends you use the automated data collectors within IBM Support Assistant. Not only will the automated collector gather the equivalent of the manual process, it will also provide a secure file transfer of the collection to IBM.

IBM Support Assistant Lite IBM Support Assistant Lite (ISA Lite)
A special offering that contains just the data collector component of the IBM Support Assistant Workbench
Download  |  Demo  |  Screenshot  |  Learn more
IBM Support Assistant Workbench IBM Support Assistant Workbench (ISA Workbench)
For a full range of problem solving features, the workbench contains all the data collection capability of ISA Lite plus much more!
Download  |  Demo  |  Screenshot  |  Learn more

Collecting data using IBM Support Assistant

ISA Lite

  1. Download ISA Lite and extract it to a directory in your file system.

  2. Start ISA Lite by running runISALite.[sh|bat] .

  3. Select the following collector:
    WebSphere Commerce V7.0 > Catalog > Attribute Dictionary

  4. Follow the prompts to automatically submit the collected data to IBM Support.

ISA Workbench

  1. Download and install the ISA Workbench.

  2. Install the product add-on for WebSphere Commerce V7.0.

  3. Open the Workbench and navigate to the Collect and Send Data page.

  4. Select the following collector:
    WebSphere Commerce V7.0 > Catalog > Attribute Dictionary

  5. Follow the prompts to automatically submit the collected data to IBM Support.

Collecting data manually

Considerations before collecting data
Take note of the following before collecting the information described below:

    Large amount of trace logs will have impact to the overal performance. It is recommended to collect the trace during off-peak hours.

I. Configure environment

Follow the instructions below to configure your environment to capture the required diagnostic information:

  1. Update the size of the trace files to 20MB and the number of historical trace files retained to 20
  2. Enable the following runtime trace string:*=all:*=all:*=all

    • -Enabling trace
      What is this data These trace components increase the amount of diagnostic data logged to the WebSphere server trace file.
      Why do I need this data This data will capture more detailed diagnostic trace information for the subject component.
      Where can I find this data Please look at the following Commerce Information Center documentation for more information on enabling Commerce trace components:
      1. Configuring logging in WebSphere Commerce V7.0

II. Reproduce problem

  1. Take note of your CATALOG_ID, CATENTRY_ID, CATGROUP_ID and STORE_ID when reproducing the problem. This information will help when reviewing the traces and database extracts.
  2. Perform the necessary steps to reproduce this problem, capture the necessary screen shots to illustrate the issue. Once the problem has been reproduced, turn off the tracing that was enabled in the "Configure environment" task group.

III. Collect data

Collecting general product information
Include the general information requested in MustGather: General Issues in WebSphere Commerce V7.0 alongside the component-specific information requested below.

  1. Run the following database queries to collect the necessary information from your database (output results in CSV format):
    Query Output file name
    select * from CATALOG CATALOG.csv
    select * from CATENTRY CATENTRY.csv
    select * from CATGPENREL CATGPENREL.csv
    select * from CATENTREL CATENTREL.csv
    select * from CATGROUP CATGROUP.csv
    select * from CATENTDESC CATENTDESC.csv
    select * from STOREENT STOREENT.csv
    select * from STORECENT STORECENT.csv
    select * from STORECGRP STORECGRP.csv
    select * from CATGRPREL CATGRPREL.csv
    select * from DISPCGPREL DISPCGPREL.csv
    select * from DISPENTREL DISPENTREL.csv
    select * from CATTOGRP CATTOGRP.csv
    select * from STORECAT STORECAT.csv
    select * from STORE STORE.csv

Submitting data to IBM Support

To diagnose or identify a problem, it is sometimes necessary to provide Technical Support with data and information from your system. In addition, Technical Support might also need to provide you with tools or utilities to be used in problem determination. You can submit files using one of following methods to help speed problem diagnosis:

Document information

More support for:

WebSphere Commerce Enterprise

Software version:


Operating system(s):

AIX, Linux, Solaris, Windows

Software edition:

All Editions

Reference #:


Modified date:


Translate my page

Content navigation