java.io.IOException: Async IO operation failed (2), reason: RC: 32 Broken pipe AND SessionAffinityManager setNextId Detected JSESSIONID with invalid length; expected length of 23, found 24, setting: 0mfjkllzj_lsYQF1v1HcS40H to null.

Changing the Configuration Manager password

You can change the password to access the Configuration Manager client. Two methods are available to change the password.

You can change the Configuration Manager password when you open the Configuration Manager by clicking Modify in the window where you enter the user ID and password.
Alternatively, to change the Configuration Manager password...

1. Goto WC_install/bin
   cd WC_install/bin
2. execute below script
   ./wcs_encrypt.sh new_password
Where new_password is the new password for the Configuration Manager.
Two encrypted versions of the new password will be generated:

• ASCII encrypted string
• HEX encrypted string

The ASCII encrypted string will be required for the next step.
4. Open the PwdMgr.xml file in a text editor.

•  WC_INSTALL/instances
•  WC_USER/instances

5. Modify LoginPassword in the PwdMgr.xml file with the ASCII encrypted password from step 3 and save the changes.

sample PwdMgr.xml file

 <User id="configadmin">
    <Role>Administrator</Role>
    <LoginPassword>APMrlvwKf3C4ceLEAdOXMg==</LoginPassword>
  </User>

</PasswordManager>

Empty Context root implementation - For Shortening the context root of a store URL in WebSphere Commerce 8

Shortening the context root of a store's URL makes it easier for shoppers to remember a link and also improves visibility in search engine results in WebSphere Commerce 8.

Step-by-Step Process

STEP 1: Modify contex root on IBM HTTPServer 

1. Go to WC_installdir/instances/instanceName/httpconf

2. Open httpd.conf

3. Uncommented the following line

LoadModule rewrite_module modules/mod_rewrite.so

4. Locate the virtualhost object: <VirtualHost servername:80> OR <VirtualHost *:80>

5. Insert the following code inside the <VirtualHost servername:80>

RewriteEngine on 

RewriteRule ^/(?!wcsstore)(.*) /webapp/wcs/stores/servlet/$1 [PT,L]

Creating a WebSphere Commerce instance Version 8 on Linux System

Creating a WebSphere Commerce instance

JAVA Considerations

1.Verify that the WebSphere Application Server default SDK level is set to 1.7:
Go To WAS_installdir/bin Folder then run below command
/opt/IBM/WebSphere/AppServer/bin/managesdk.sh -getNewProfileDefault
2. If the default SDK level is not 1.7, then run the following command to set to version 1.7.
/opt/IBM/WebSphere/AppServer/bin/managesdk.sh -setNewProfileDefault -sdkName 1.7_64

Uninstall WebSphere Commerce Server Version 8 Manually on a Linux system

Uninstall WebSphere Commerce Server Manually on a Linux system.. Some RPM packages needs to Uninstall, otherwise next installation will be failed.

While WebSphere Commerce Server Installation, Some RPM packages will install on Linux OS level automatically. So we need to uninstall all RPM packages which are related to WCS8. Below I have explained all steps. 

To uninstall WebSphere Commerce manually, complete the following steps

1. Log on as the root user.
2. Issue the following command:
rpm -qa | grep WC80
This command returns all of the WebSphere Commerce related packages that are installed on    your machine.

InstallShield Wizard Initializing InstallShield Wizard...Preparing Java(tm) Virtual Machine... wcs ibm, ./setup_linux Installation Wizard not showing, WebSphere Commerece Version 8, Redhat Linux 7.2

WebSphere Commerce Server Version 8 Installation Process on Redhat Linux 7.2, After executing ./setup_linux script, Initializing Wizard not Lunching and Script exited without any Error Message.

ERROR: After executing ./setup_linux script Below Message coming then Exited the script...

...................................
....................................InstallShield Wizard
.
Initializing InstallShield Wizard...
Preparing Java(tm) Virtual Machine...
................................... #...Then script exited and nothing is happening

Problem: OS level compatable Packages (rpms) are not installed

Solution: Below Mentioned Packages (rpms) needs to be installed

WebSphere Commerce Database Cleanup utility

WebSphere Commerce Database Cleanup activity- Some Imp tables

Go to WCS root directory i.e
cd /opt/IBM/WebSphere/CommerceServer70/bin

1.-------------------------------cleaning records of scheduled jobs that have been completed
query for finding entries in SCHSTATUS table
db2 " select count(*) FROM SCHSTATUS WHERE (SCSSTATE = 'C' OR SCSSTATE = 'CF') AND (days(CURRENT TIMESTAMP) - days(SCSEND) >= 30)"
Cleaning SCHSTATUS table entries which are older than 30 day's
./dbclean.sh -object scheduled_job -type completed -instancexml /opt/IBM/WebSphere/CommerceServer70/instances/demo/xml/demo.xml -db RABPDB -days 30 -dbuser RABpinst  -dbpasswd xxxxx@123 -loglevel INFO -commit 10000 -max 1000000

2.--------------------------------Cleaning processed cacheivl
db2 " select count(*) from cacheivl where (days(CURRENT TIMESTAMP) - days(inserttime)) >= 30"
./dbclean.sh -object cacheivl -type obsolete -instancexml /opt/IBM/WebSphere/CommerceServer70/instances/demo/xml/demo.xml -db RABPDB -days 30 -dbuser RABpinst  -dbpasswd xxxxx@123 -loglevel INFO -commit 100000 -max 100000

Useful WCS Script Examples

WebSphere Commerce - Some useful script

1. Script to find Applications connection count (Script File Name - db_connections.sh)

RUNDAY=`date`
OUTPUT_DATE=`date '+%d%m%y'`
export RUNDAY
export OUTPUT_DATE

echo `date` >> /home/dbuser/DB_CONNECTIONS/DB_DATABASENAME_CONN$OUTPUT_DATE.txt;
db2 list applications for database <DATABASENAME> | wc -l  >> /home/dbuser/DB_CONNECTIONS/DB_dbuser_CONN$OUTPUT_DATE.txt;
echo "##############################################" >> /home/dbuser/DB_CONNECTIONS/DB_dbuser_CONN$OUTPUT_DATE.txt;
echo "##############################################" >> /home/dbuser/DB_CONNECTIONS/DB_dbuser_CONN$OUTPUT_DATE.txt;
------------------------------------------------------------------------------------------------------------------------
2. Getting the DATA from DATABASE using script

Solr Advanced Configuration in WebSphere Commerce

This summary is not available. Please click here to view the post.

How to Send an Email Using Telnet Command

The following 5 steps will show how to send Emails using Telnet command using 25 port

Here are simple steps on how to send an email using telnet. This a great way to test your mail server configuration from your local domain server

Step 1: First telnet to yor mail server using 25 port
$telnet 10.110.101.110 25

Step 2: Use HELO command to tell mail server from which domain you are coming from:
HELO local.domain.com

Step 3: Now we need to provide from email address which email will be sent
MAIL FROM:welcome@ramaswamy.com

Step 4: Now specify recipient Email address. If you would like to send a mail to multiple email address, you can use RCPT TO Command multiple times
RCPT TO: ramaswamy.karra@ril.com

Java SDK Updation for WebSphere Application Server Profiles V 8.5 using managesdk

Following steps would help to Migrating JDK version of Websphere Profiles and servers.

Default WAS V 8.5 contains jdk 1.6 version, It is not support for some Application (ex. Sterling application v 9.4). It's required to update WebSphere Application Profiles jdk version from jdk 1.6 To 1.7

Step 1: Install IBM Java for WAS through Installation Manager

Step 2: Using below commands we can see all available JDK version.

$/opt/IBM/WebSphere/AppServer/bin/managesdk.sh -listAvailable [display All avaliable SDK Names]

$/opt/IBM/WebSphere/AppServer/bin/managesdk.sh -listEnabledProfile -profileName Test_AppSrv01 [display Test_AppSrv01 configure SDK Name]

$/opt/IBM/WebSphere/AppServer/bin/managesdk.sh -enableProfile -profileName Test_AppSrv01 -sdkName 1.7.1_64 -enableServers [Configure SDK 1.7_64 for Test_AppSrv01 and Servers]

$/opt/IBM/WebSphere/AppServer/bin/managesdk.sh -enableProfileAll -sdkname 1.7_64 -enableServers [Enable SDK 1.7_64 for all Profiles and servers]

all the best..!

Reference Links: http://www-01.ibm.com/support/docview.wss?uid=nas8N1019730

Configure FTP Server on RHEL6 for Files moving from Server to Client

This blog explains how to configure FTP Server in Linux step by step with examples.

This is required when we are installing WebSphere Commerce Server, Instance creation process will create WebServer on Remote Box [Remote IP]

Step 1: Configur host entries in both Linux boxes
vi /etc/hosts

Step 2: On Application Server box (FTP server)
vsftpd and ftp package is required for FTP Server. Check whether package is installed or not.
#rpm -qa vsftpd  [If vsftpd rpm is not installed. install it first]
#rmp -qa ftp
#yum install ftp  [installing ftp rmp]
#yum install vsftpd  [installing vsftpd rmp]
#service vsftpd status [checking vsftpd status]
#service vsftpd start/stop/restart [start/stop/restart commands]

Script for gzip / delete Access and Error logs / moving old files to new directory based on date

1. EXECUTE COMMAND

#!/bin/bash
# changing ownership of order xml files
find /order/OrderXML/*.xml -mmin -60 -exec chmod 664 {} \;

2. GZIP LOGS AND DELETING LOGS

# gzip access log older than 2 day
find /HTTPServer/logs -mmin +1440 -type f -iname "access*" ! -iname "access*.gz" -exec gzip {} \;
# Deleting access logs older than 20 days
find /HTTPServer/logs -mtime +20 -type f -iname "access*" -delete
find /HTTPServer/logs -mmin +1440 -type f -iname "error*" ! -iname "error*.gz" -exec gzip {} \;
find /HTTPServer/logs -mtime +20 -type f -iname "error*" -delete

3. MOVING FILES BASED ON DATE

find /sourcedirectory -mtime +365 -type f -exec mv "{}" /destination/directory/ \;
find /sourcedirectory -mtime +365 -type f -exec ls -l "{}" /destination/directory/ \;
find /OrderXML/ -mtime +600 -type f -exec ls -l "{}" /OrderXML/OrderXmlBackup/ \;
find /sourcedirectory -maxdepth 1 -mtime +365 -exec mv "{}" /destination/directory/ \;
find /sourcedirectory -type f -mtime +365 -exec mv "{}" /destination/directory/ \;

Getting OutofMemory error [java/lang/OutOfMemoryError] while deploying a large application [sterling ear file - smcfs.ear] in WebSphere Application Server

We are finding the following exception thrown in the SystemOut.log file when we deploy a large application (ex. sterling ear file - smcfs.ear) in WebSphere Application Server

Error in SystemOut.log file

[10/30/17 14:53:21:745 IST] 00000093 DeployEJBTask I   ADMA0158I: [EJBDeploy] Starting workbench.

[10/30/17 14:53:21:751 IST] 00000093 DeployEJBTask I   ADMA0158I: [EJBDeploy]   @build@
[10/30/17 14:53:21:842 IST] 00000093 DeployEJBTask I   ADMA0158I: [EJBDeploy] EJB Deploy configuration directory: /opt/IBM/WebSphere/AppServer_STER/profiles/AppSrv01/ejbdeploy/configuration/
[10/30/17 14:53:21:846 IST] 00000093 DeployEJBTask I   ADMA0158I: [EJBDeploy] framework search path: /opt/IBM/WebSphere/AppServer_STER/deploytool/itp/plugins
[10/30/17 14:53:21:863 IST] 00000093 DeployEJBTask I   ADMA0158I: [EJBDeploy] build:RAD851-I20121103_1921
[10/30/17 14:53:33:186 IST] 00000093 DeployEJBTask I   ADMA0158I: [EJBDeploy] Creating the project.
[10/30/17 14:54:06:259 IST] 00000092 DeployEJBTask I   ADMA0158I: [EJBDeploy] JVMDUMP039I Processing dump event "systhrow", detail "java/lang/OutOfMemoryError" at 2017/10/30 14:54:06 - please wait.

ORACLE START / STOP AND STATUS CHECKING COMMANDS

ORACLE START / STOP AND STATUS CHECKING COMMANDS

• Export environment variables

export ORACLE_SID=sterdb

export ORACLE_HOME=/home/oracle1/app/oracle1/product/12.2.0/dbhome_1

export PATH=$ORACLE_HOME/bin:$PATH

     $ps -ef|grep pmon [checking database status]

   Username: oracle1

   Dbname: sterdb

   $sqlplus '/ as sysdba' [connecting to Oracle Database]

How to add user and update password never expire flag

How to Add User and Set password as never expire flag

[root@RAMASystem ~]# adduser rama  [new user rama added]
[root@RAMASystem ~]# passwd rama   [set password]  [provide password for user rama]
Changing password for user rama.
New password:
Retype new password:
passwd: all authentication tokens updated successfully.
[root@RAMASystem ~]# chage -l rama  [checking password expire flag]
Last password change                                    : Nov 06, 2017
Password expires                                        : Dec 21, 2017
Password inactive                                       : never
Account expires                                         : never
Minimum number of days between password change          : 0
Maximum number of days between password change          : 45
Number of days of warning before password expires       : 7

Java JDK 1.8 Installation/Migration Process in Linux/Unix System

Installation / Migration JAVA JDK 1.8 In Unix / Linux System..

Step 1: Java Installation process
             Download Java JDK 1.8 Version (http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html)
             Copy JDK Software (jdk1.8.0_77.zip) to this path ..[root@RAMA jdk1.8.0_77]#cd  /usr/java/
             Go to this path ..[root@RAMA jdk1.8.0_77]#cd /usr/java
             And unzip Java software  [root@RAMA jdk1.8.0_77]#unzip jdk1.8.0_77.zip
             Open following file and set the java home directory for all users
             [root@RAMA jdk1.8.0_77]#cat /etc/profile
             [root@RAMA jdk1.8.0_77]#export JAVA_HOME=/usr/java/jdk1.8.0_77
             [root@RAMA jdk1.8.0_77]#export PATH=$JAVA_HOME/bin:$PATH
             [root@RAMA jdk1.8.0_77]#source /etc/profile
             [root@RAMA jdk1.8.0_77]#java -version
             If Java version showing older version then we need to update java version

CREATING CRONJOB FOR NON-ROOT USER

login as root
Open cron.allow file ex. vi /etc/cron.allow And Add non-root user, below format
root
wcuser
cat /etc/cron.allow
Output:

REORG INDEXES/TABLE COMMANDS

REORG INDEXES/TABLE COMMANDS
db2 -x "select 'reorg table',substr(rtrim(tabschema)||'.'||rtrim(tabname),1,50),';'from syscat.tables where type = 'T' " > 08_08_2017reorg.txt
db2 -tvf 08_08_2017reorg.txt -z 08_08_2017reorg.txt.out --> reord Process
db2 -x "select 'runstats on table',substr(rtrim(tabschema)||'.'||rtrim(tabname),1,50),' and indexes all;'from syscat.tables where type = 'T' " > 08_08_2017_runstats.txt
db2 -tvf 08_08_2017_runstats.txt -z 08_08_2017_runstats.txt.out --> runstat process

CATALOG Creation From AppServer to DB2 In WCS STAG And PROD Environments

CATALOG Creation From AppServer to DB2  In WCS STAG And PROD Environments


1. CATALOG for AppServer to DB2 Database For Connecting From AppServer To DB2

db2 "CATALOG TCPIP NODE  NODENAME REMOTE 10.129.xx.xx SERVER 50001 REMOTE_INSTANCE pprdinst SYSTEM RFDRPPWCSCOM"
db2 "CATALOG DATABASE PPRDADB AS PPRDADB AT NODE RILANODE AUTHENTICATION SERVER"

• Catalog STAGE DB2 Database on Staging Search Server(10.129.xx.xx) as pprdinst