Wednesday, 13 January 2016

Building the WebSphere Commerce search SOLR index

 Build the WebSphere Commerce search index by using the index building utility.
  • Ensure that the test server is stopped in Rational Application Developer
  • Run preprocess bat from command line     C:\IBM\WCDE_ENT70\bin\di-preprocess.bat C:/IBM/WCDE_ENT70/search/pre-processConfig/MC_10351/Cloudscape/

The list showed below temporary Tables were created and populated 

TI_CATENTRY_0
TI_CATENTREL_0
TI_ATTR_0_1
TI_ADATTR_0_1
TI_CATALOG_0
TI_CEDSOVR_0_1
TI_CASTB1_0_1
TI_CAITB1_0_1
TI_CAFTB1_0_1
TI_CATGPENREL_0
TI_SEOURL_0_1
TI_DPCATENTRY_0
TI_DCCATENTRY_0
TI_COMPONENTS_0
TI_GROUPING_0
TI_DPGROUP_0
TI_DPGRPID_0
TI_GRPNAME_0_1
TI_DPGRPNAME_0_1
TI_LISTPRICE_0
TI_LBUNDLEPRICE_0
TI_LDKITPRICE_0
TI_OFFER_0
TI_OFFERPRICE_0
TI_BUNDLEPRICE_0
TI_DKITPRICE_0
TI_PRODUCTSET_0
TI_CEATCHT_0_1
TI_CEATCHTU_0_1
TI_CGCATALOG_1
TI_CATGRPREL_1
TI_DPGROUP_1
TI_CGSEOURL_1_1
TI_DCCATGRP_1

Start the server and verify whether SOLR server is working or not,
        http://localhost/solr/Default/select?q=*%3A*

  • Ensure that the test server is started in Rational Application Developer
  • Run build index bat from command line   di-buildindex.bat -masterCatalogId 10351
Check the logs,
C:\IBM\WCDE_ENT70\logs\wc-dataimport-preprocess.log and wc-dataimport-buildindex.log