The following instructions describe how to collect the
necessary data and gather the required information for IBM support.
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
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
After reproducing the problem, collect the following files:
- Trace from the WebSphere Commerce Server:
<WC_profile>\logs\server1\*
- 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
- 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>
- Scenario
Describe the failing scenario in detail.
Top
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
|