Wednesday 4 October 2017

Identifying if a item is eligible for placing a recurring order in WCS

In WCS OOTB provides a feature to the customers for placing the recurring orders but this option is showed only when the shopping cart has the items eligible for recurring order.

In Order to identify whether a item is eligible for recurring order or not please check the CATENTSUBS table DISALLOW_REC_ORDER column.

DISALLOW_REC_ORDER :  Indicates whether this catalog entry is prohibited from being purchased through recurring order. Default value is 0.
0
No
1
Yes

Identifying the WCS server using JSESSIONID

Most of the times debugging the Production Issues needs logs from Application Servers. In Order to Identify which application server is serving the request from browser can be known by using the JSESSIONID cookie which is OOTB cookie.

Follow the below steps for identifying the WCS Application server details

1. Install "Edit this cookie" addon for chrome (Or any other cookie manager to see the cookies on the browser).
2. Check the JSESSIONID cookie value which will be in the format of UNIQUE_ID:CLONEID get the CLONEID from the JSESSIONID cookie.
3. Open the  plugin-cfg.xml file from the webserver (IHS) and search for the mapping of the CLONEID to the server for eg: mapping shown below for cloneidabcd12 with the server xyzserver.companyname.com.

<Server CloneID="abcd12" ConnectTimeout="0" ExtendedHandshake="false" MaxConnections="-1" 
     Name="WC_demo_node_server1" ServerIOTimeout="0" WaitForContinue="false">
    <Transport Hostname="xyzserver.companyname.com" Port="9101" Protocol="http"/>
</Server>


Monday 26 June 2017

DB Query to check the Feature enabled or not in V7

Hi All,

Following are the queries which can be used to check if the store features are enabled or not (<flow:ifEnabled)

select ddef.storeent_id, e.name, e.description, ddef.content from dmemspotdef ddef left join emspot e on ddef.emspot_id = e.emspot_id where ddef.contenttype = 'FeatureEnabled' and e.name = '<feature name>';

replace <featurename> with the feature name which you want to check.


Wednesday 3 August 2016

Installing SQL Profile for Websphere Commerce V7

SQL Profiler is a powerful tool for troubleshooting the Performance Issues in Websphere Commerce. Following is the URL which shows the steps for configuring SQL profiler with RAD

https://www.ibm.com/developerworks/community/blogs/wcs/entry/Installing_SQL_Profiler_for_WebSphere_Commerce_7_Developer_Edition?lang=en


Monday 1 August 2016

Test Your Web Page Performance


Web Page performance can be tested using the below URL which will give some suggestions for improvements as well.

https://developers.google.com/speed/pagespeed/insights/

https://gtmetrix.com



Wednesday 22 June 2016

TOGAF 9.1 Study Guide

Intrested TOGAF9.1 aspirants can visit the below URL for TOGAF Study Guide.

Click here for TOGAF study guide

Monday 20 June 2016

Fetching Server or Clone ID in a Controller Command

In Order to fetch the server/ Instance name or clone ID in Controller Command use the following methods

HttpControllerRequestObject req = (HttpControllerRequestObject) getCommandContext().getRequest();
req.getServletContext().getServerInfo();

or

WCSApp.getCloneId();