Technote

(FAQ)
MustGather: WebSphere Commerce Inventory Issues
MustGather for issues with WebSphere Commerce servers that experience problems with inventory. Gathering this information before calling IBM support will help familiarize you with the troubleshooting process and save you time.


Answer

The following instructions describe how to collect the necessary data and gather the required information for IBM support.

Part A: Enable trace
Part B: Reproduce the problem
Part C: Collect all necessary data
Part D: Submit information to IBM Support



Part A: Enable trace


Enable the following trace components on your WebSphere Commerce instance server:

com.ibm.websphere.commerce.WC_ORDER=all:com.ibm.websphere.
commerce.WC_INVENTORY=all

Top

Part B: Reproduce the problem

The environment is now configured to capture the necessary data when the problem occurs. Reproduce the problem on your environment and proceed to the next step.

Top

Part C: Collect all necessary data

After reproducing the problem, collect the following files:

  1. Trace from the WebSphere Commerce Server:
    <WC_profile>\logs\server1\*

  2. What type of inventory system are you using for your store? i.e. Are you using WebSphere Commerce to manage your inventory, are you integrating with a backend system, or are you not tracking inventory at all?
    To determine the type of inventory, run the following query:

    SELECT INVENTORYSYSTEM FROM STORE WHERE STORE_ID=<your_store_id>

    The possible values are:
    -1=ATP
    -2=Non-ATP
    -3=No inventory
    -4=External inventory management system (introduced in WC 6.0.0.1)

    For more information about inventory assets, please visit the following links:
    http://publib.boulder.ibm.com/infocenter/wchelp/v6r0m0/index.jsp?topic=/com.ibm.commerce.data.doc/concepts/cin_iminventoryasset.htm
    http://publib.boulder.ibm.com/infocenter/wchelp/v6r0m0/index.jsp?topic=/com.ibm.commerce.data.doc/concepts/cin_iminventoryasset2.htm
    http://publib.boulder.ibm.com/infocenter/wchelp/v6r0m0/index.jsp?topic=/com.ibm.commerce.data.doc/concepts/cin_iminventoryasset3.htm

  3. Configuration Datafrom the Database
    a) SELECT * FROM STORE

    b) SELECT * FROM FFMCENTER

    c) SELECT * FROM SHPARRANGE

    d) If you are using the ATP inventory, collect the following data:

    SELECT * FROM BASEITEM WHERE BASEITEM_ID=(SELECT BASEITEM_ID FROM CATENTRY WHERE CATENTRY_ID=<your_catentry_id>)

    SELECT * FROM STOREITEM WHERE BASEITEM_ID=<your_base_item_id>

    SELECT * FROM ITEMSPC WHERE BASEITEM_ID=<your_base_item_id>

    SELECT * FROM INVSTVW WHERE STORE_ID=<your_store_id> AND
    ITEMSPC_ID=(SELECT ITEMSPC_ID FROM CATENTRY WHERE CATENTRY_ID=<your_catentry_id>)

    Otherwise, if you are using non-ATP inventory, collect the following data:
    SELECT * FROM INVENTORY WHERE STORE_ID=<your_store_id> AND CATENTRY_ID=<your_catentry_id>

  4. Scenario
    Describe the failing scenario in detail.


Top


Part D: Submit files to IBM Support

Include the information collected in Part C in the package that you send to IBM. Refer to the MustGather: Read first for all WebSphere Commerce products technote for details on submitting data to IBM.

Top
 

Document Information

Current web document: http://www.ibm.com/support/docview.wss?uid=swg21286053