IBM WCS ( Websphere Commerce ) - Quick Reference / Cheat Sheet


Bookmark this Page!

Important Links

Managment center (CMC)
https://localhost:8000/lobtools - wcsadmin/wcsadmin
Accelerator  
https://localhost:8000/webapp/wcs/tools/servlet/ToolsLogon?XMLFile=common.mcLogon&storeId=0
Admin Console

https://localhost:8002/webapp/wcs/admin/servlet/ToolsLogon?XMLFile=adminconsole.AdminConsoleLogon&storeId=0
Org Admin Console
https://localhost:8004/webapp/wcs/orgadmin/servlet/ToolsLogon?XMLFile=buyerconsole.BuyAdminConsoleLogon&storeId=0

Dynacache

https://localhost:9043/cachemonitor/
WasAdminConsole

https://hostname:9043/ibm/console

Config Files

WC config 
[Toolkit Folder]/xml/config/wc-server.xml

Promotion Engine Configuration
[Toolkit Folder]/xml/PromotionEngineConfiguration/WCSPromotionEngineConfig.xml

Folders

Log Files
[Toolkit folder]/wasprofile/logs/server1/*.log

Temp folder
[Toolkit folder]/wasprofile/temp

Changing DB 
 
Go to WCTK\bin
Execute the following command -

setdbtype oracle C:\oracle\product\10.2.0\db_1 <ServiceName> <DBAName> <DBAPwd> <DBUserID> <DBUserPwd> <DBHost> <DBServerPort>

Enabling Traces 

Tracing log into wasconsole 
Right click on the server -> goto admin console
Upon logging in go to  Servers  -> Application Servers
Click Server 1 
Click "Logging and Tracing" under Troubleshooting.
Click "Change Log Detail Level"
Enter the following and click Ok.

*=info:enable.trace.log.*=all:
com.ibm.websphere.commerce.WC_USER=all:
com.ibm.websphere.commerce.WC_SERVER=all:
com.ibm.websphere.commerce.WC_ACCESSCONTROL=all


Tracing SQL logs into wasconsole 
Follow the above steps and add following 
*=info: com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement=all

EJB Tracing 
*=info:EJBContainer=all:PMGR=all.

Promotion Engine Tracing
Go to folder WCTK -> xml -> PromotionEngineConfiguration
Open WCSPromotionEngineConfig.xml 

Set <Debug>true</Debug>

Enabling CMC ( open laszlo logs ) 
Right-click LOBTools and click Properties. Select OpenLaszlo Settings.
Click Enable the debug console check box. Click Apply.



Important SQLs

Reset WCS admin password 
update userreg set logonpassword = '74434f61354f51593862415655304d5268424e54723865685653356151374a2b353163506c4261363730633d202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020'
where logonid='wcsadmin';
update userreg set salt = 'hsdbacehyoyn' where logonid='wcsadmin';
update userreg set status = 1 where logonid='wcsadmin';
 update userreg set passwordexpired = 0 where logonid='wcsadmin'; commit;

Roles of user
select u.logonid,r.name,org.orgentityname from mbrrole mbr, userreg u,orgentity org,role r where mbr.member_id=u.users_id and org.orgentity_id=mbr.orgentity_id
and mbr.role_id=r.role_id
and u.logonid ='wcsadmin';
Last created promotions 
select * from PX_PROMOTION where rownum <5 order by PX_PROMOTION_ID desc;

Active promotions
select * from PX_PROMOTION where status = 1;


Start Dev Environment
startWCToolkit.bat in [Toolkit Folder]\bin 

IBM WCS tips file
[Toolkit Folder]\hintsandtips.html

Related Links

http://www.buggybread.com/2012/12/ibm-wcs-promotions-sql-to-check.html
http://www.buggybread.com/2012/12/ibm-wcs-configuration-to-point-to-new.html
http://www.buggybread.com/2012/12/ibm-wcs-enabling-debug-trace-for.html
http://www.buggybread.com/2012/11/ibm-wcs-websphere-commerce-suite-reset.html


author

This post was written by:

Vivek Vermani

WCS Developer

Get Free Email Updates to your Inbox!