Tuesday, February 16, 2016

Enabling SEO | Testing with IHS

To test the SEO on local, you need to have corresponding rewrites and rewrite engine turned on in
C:\IBM\HTTPServer\conf and check logs in C:\IBM\HTTPServer\conf. Also if you have multiple esites, it is important to get the virtual host for each esite and allowed host setting in wc-server.xml

<VirtualHost *:80>
RewriteEngine on

RewriteCond %{REQUEST_URI} !^/webapp.*$
RewriteCond %{REQUEST_URI} !^/wcsstore.*$


<VirtualHost  abcd.localhost.com:80>
RewriteEngine on

RewriteCond %{REQUEST_URI} !^/webapp.*$
RewriteCond %{REQUEST_URI} !^/wcsstore.*$


C:\Windows\System32\drivers\etc       localhost abcd.localhost.com

Command prompt: C:\>ipconfig /flushdns

In wc-server.xml find this section and enable context root.

<SEOConfiguration defaultUrl="" dynamicUrl="true" enable="true">
    <context-root-rewrite value="/" />

Tuesday, January 12, 2016

DB2 SQL Error: SQLCODE=-1476, SQLSTATE=40506, SQLERRMC=-964, DRIVER=4.12.55

While running preprocessing got the following error:

INFO: Error for batch element #1: DB2 SQL Error: SQLCODE=-1476, SQLSTATE=40506,
SQLERRMC=-964, DRIVER=4.12.55

C:\IBM\WCDE_ENT70\bin>di-preprocess.bat C:\IBM\WCDE_ENT70\search\pre-processConf
ig\MC_10001\DB2  -fullbuild true -localename en_US -force true

com.ibm.commerce.foundation.dataimport.preprocess.DataImportPreProcessorMain logExitCode
INFO: The program exiting with exit code: 1.
Data import pre-processing was unsuccessful. An unrecoverable error has occurred

Fix:  DB2 transaction logs are full.

Check the file size ; Goto DB2CMD
db2 get db config for mall
Ran this command:
db2 UPDATE db cfg for mall using LOGFILSIZ 4096
Windows services DB2 : restart
After this the pre-processing was successful.

Thursday, October 1, 2015

IBM Websphere Commerce Version 8.0 Announced !!

Exciting news for Websphere Commerce developers. Big news items.

    Open Source Spring framework.
    IBM Customer Service
    Management Center UI revamped.
    Upgraded RAD 9.5, WAS , DB2

As per IBM, these are 2 big modules in the new Version 8.0. Along with upgrades to application server and stack.

IBM Customer Service for WebSphere Commerce Version 8.0 delivers enhancements to Customer Service for WebSphere Commerce that offer a better customer service and support experience. The customer service representative (CSR) can utilize the same buying experience that customers use to provide assistance with site activities, for example, assist customers to manage their cart content and assist with the checkout process. As a part of the buying experience, the CSR can look up customer accounts and orders, and help customers with their account management. Customer Service for WebSphere Commerce is a separately purchased solution for

WebSphere Commerce V8.0 clients. IBM Management Center for WebSphere Commerce In Version 8.0, the Management Center is updated to use Dynamic HTML (DHTML) and the open source Spring Framework. This update makes it easier for developers to customize and embed custom tools in the Management Center. With DHTML, Management Center is no longer dependent on AdobeTM Flash technology, and developers who customize the Management Center can now view their changes IBM United States Software Announcement 215-305 IBM is a registered trademark of International Business Machines Corporation 2 without first compiling their code. Additionally, the Management Center user interface now has a new look.

    Ref: http://www-01.ibm.com/common/ssi/rep_ca/5/897/ENUS215-305/ENUS215-305.PDF

Sunday, September 13, 2015

SEO | XML | SitemapGenerate

You can create a sitemaps job using the Scheduler in the Administration Console. Create a new schedule job SitemapGenerate  with parameters


In toolkit the files are generated at the following location with pattern sitemap_10501.

The command calls SEOSitemap.jsp which internally calls the category\subcategory\PDP and all other content that needs to be added to the sitemap_storeID.xml e.g. sitemap_105010.xml.

Do not added HTML comments into the JSPs. Specially more important for JSPs used b the SEO process since these would be reflected in the SEO xml's generated.
Also do not miss to add the correct pageType for SEO friendly URLs.

Custom URL contents to be included in the Sitemap, a SEOSitemapExt.jsp is included under Stores/WebContent/AuroraStorefrontAssetStore. This file is imported at the end of SEOSitemap.jsp which generates all the urls to be included in the index by the search engine
The constructedUrlCounter and urlCounter variables need to be updated for each added URL
URLs to the sitemap by defining one or more ...

Friday, May 15, 2015


WC_PERSISTENT cookie is used to track session management in websphere commerce and session timeout is managed in WAS console. This is for global flag. If you want to enable them at the store level, this can be set using at STORE table by setting column PERSISTENTSESSION for corresponding store.

Dynacache on off | from WAS Console

On toolkit, Right click on server1-->

WAS console and remove check box on Enable servlet caching to turn off dynacache, and click apply  , save and restart server.

Saturday, May 9, 2015

Access your AWS linux instance from windows

The traditional SSH into Unix is not supported directly. You need to generate a pair of RSA keys and add public key to EC2 to login.

On your windows instance: You have to the following steps. Putty does not support the private key format (.pem) generated by Amazon EC2 so you have to generated keys using Git Bash and then convert them into keys in PuttyGen.

  • PuTTY does not natively support the private key format (.pem) generated by Amazon EC2. 

  • Install Putty (Download). 
  • Install PuttyGen, (Download).
  • Download and Install Git Bash (Download link)
  • Open Git Bash --It opens a console
  • Run the following command ssh-keygen -t rsa 
           Generating public/private rsa key pair.
              Enter file in which to save the key (/c/Users/admin/.ssh/id_rsa):
    • The above process generates a public key and a private key.
    • Open puttyGen and load private key and save private key. 
    • Open putty and in settings -->SSH->Auth--Add your private key