Thursday, 14 July 2016

ERROR On Federating Process (ADMU0038E: The Deployment Manager's IP address resolves as 127.0.0.1)

The below Error is ocured whenever Federating the AppServer to Dmgr in different Linux Boxes 

ADMU0038E: The Deployment Manager's IP address resolves as 127.0.0.1, but the Deployment Manager is not on the local machine.  The Deployment Manager's host name configuration or DNS is configured incorrectly

Log File : [7/13/16 12:58:43:331 IST] 00000000 NodeFederatio E   ADMU0010E: Error obtaining repository client com.ibm.websphere.management.exception.AdminException: ADMU0038E: The Deployment Manager's IP address resolves as 127.0.0.1, but the Deployment Manager is not on the local machine.  The Deployment Manager's host name configuration or DNS is configured incorrectly.

Saturday, 11 June 2016

Publishing an extended site advanced model in WebSphere Commerce part 1

Extended Site publishing process is a series of store archives publishing, It has more control on Site Organization structure and Stores.

Store archives list for Extended Site Publishing
ExtendedSitesOrganizationStructure.sar
ExtendedSitesHub.sar
ExtendedSitesCatalogAssetStore-FEP.sar
AuroraStorefrontAssetStore.sar(Choose the storefront asset store based on requirement as b2c\b2b)

Follow the below steps to publish an extended sites for set up the high-level organization structure

Monday, 14 March 2016

WCS Required rpms for Installing the WCS in Graphical mod

Rpms Installation process
packages installation in Linux
when we insert the CD we get one extra mound point go to that mount point "cd/mountpoint/packages/>"  then give below commands
-----------------------------------------------------------------
rpm -ivh libXau-1.0.5-1.el6.x86_64.rpm
rpm -ivh libXau-1.0.5-1.el6.i686.rpm
rpm -ivh libxcb-1.5-1.el6.x86_64.rpm
rpm -ivh libxcb-1.5-1.el6.i686.rpm
rpm -ivh libX11-1.3-2.el6.i686.rpm
rpm -ivh libX11-1.3-2.el6.x86_64.rpm
rpm -ivh libX11-common-1.3-2.el6.noarch.rpm
rpm -ivh libXext-1.1-3.el6.x86_64.rpm
rpm -ivh libXext-1.1-3.el6.i686.rpm

Thursday, 25 February 2016

ERRORCODE=-4472, SQLSTATE=null WCS Instance Creation Error

ERROR : When WCS Instance Creation 

Failure in loading native library db2jcct2, java.lang.UnsatisfiedLinkError: db2jcct2 (/opt/IBM/db2/V9.7/lib32/libdb2jcct2.so: wrong ELF class: ELFCLASS32):  ERRORCODE=-4472, SQLSTATE=null

[2016.02.24 12:31:06]       [copy] Copying 1 file to /opt/IBM/WebSphere/CommerceServer70/schema/xml
[2016.02.24 12:31:07]   [Massload] Massloading /opt/IBM/WebSphere/CommerceServer70/schema/xml/wcs.keys.xml
[2016.02.24 12:31:07]   [Massload] -dbname NEWSITDB -dbuser Instance_Name -dbpwd ****** -infile /opt/IBM/WebSphere/CommerceServer70/schema/xml/wcs.keys.xml -method sqlimport -commitcount 1000 -maxerror 1 -customizer  -schemaname Instance_Name
com.ibm.db2.jcc.am.SqlException: [jcc][10389][12245][4.14.113] Failure in loading native library db2jcct2, java.lang.UnsatisfiedLinkError: db2jcct2 (/opt/IBM/db2/V9.7/lib32/libdb2jcct2.so: wrong ELF class: ELFCLASS32):  ERRORCODE=-4472, SQLSTATE=null

DB2 SQL Error: SQLCODE=-601, SQLSTATE=42710, SQLERRMC=InstanceName.FILEPROCREL;TABLE, DRIVER=4.14.113

ERROR : When Enable The Foundation 


RunSQLFile:
SET SCHEMA InstanceName
Executing file: /opt/IBM/WebSphere/CommerceServer70/components/foundation/schema/fep1/db2/wcs.schema.foundation.sql
Failed to execute:   CREATE TABLE fileprocrel ( uploadfile_id        BIGINT NOT NULL, processfile_id       BIGINT NOT NULL, optcounter           SMALLINT NOT NULL DEFAULT 0 ) IN USERSPACE1 INDEX IN USERSPACE1

BUILD FAILED

Sunday, 21 February 2016

DB2 Normal Backup, Online Backup and Restore Commands

Normal Backup Process : 
     1. Connect to Database    
         $db2 connect to DataBase_Name
     2. Create Backup Folder (backup-current date)
         $mkdir backup-01012016
     3. Stop All Applications which are accessing the DataBase.
     4. Restart DataBase
         $db2stop force
         $db2start
      5. Command for DataBase Backup
         $db2 backup database RAMADB to /opt/backup/backup_01012016/
      Output :

Thursday, 18 February 2016

10 Commerce Tables should be update while Order Transaction complete.

10 Commerce Tables Required to Know the Order complete details (i.e Order Status, Timeplaced, Used Promocodes, Payment Mode, Plug-in Name .. etc.)

ORDERS : Each row in this table represents an order in a store
$db2 "select * from orders where orders_id=(orders_id)"

ORDERITEMS : Each row of this table represents an order item in an order
$db2 "select * from orderitems where orders_id=(orders_id)"

PX_CDUSAGE : This table contains all the promotion code usage information.
$db2 "select * from px_cdusage where orders_id=(orders_id)"

PX_USAGE : This table contains statistics about promotion usage
$db2 "select * from px_usage  where orders_id=(orders_id)"

Wednesday, 17 February 2016

Creating new DB2 Data Base and Instance AND Delete existing DB2 Data Base Instance.


Before Creating new DB2 Data Base and Instance, Need to delete existing DB2 Data Base Instance.

Step 1 : Delete Existing DB2 Data Base and Instance
1. Login to db user and run below commands
     $db2start
     $db2 force application all
     $db2 drop db SAMPLE(database name)
     $db2stop force
     $su - root
     #cd /opt/IBM/db2/V9.7/instance/
     #db2idrop Instance_Name
Step 2 : Creating New DB2 Instance and Data Base

Tuesday, 16 February 2016

An unrecoverable error has occurred. Throwable occurred: org.apache.solr.common.SolrException when di-buildindex utility failed

di-buildindex utility failed due to this Error (An unrecoverable error has occurred. Throwable occurred: org.apache.solr.common.SolrException)

di-buildindex process is failed because of below error then follow these steps to resolve. This Error would be happen when more data is loaded.

Error :
INFO: Data import process was unsuccessful. An unrecoverable error has occurred.
Throwable occurred: org.apache.solr.common.SolrException: /MC_10001_CatalogEntry_en_US/dataimport Indexing failed