Migrating WebSphere Commerce search

• WC_installdir/bin
• WCDE_installdir\bin

• migrateSearchFacet.bat
• migrateSearchFacet.bat -instance instance_name -dbuser db_user -dbuserpwd db_password
• migrateSearchFacet.sh -instance instance_name -dbuser db_user -dbuserpwd db_password

1. Run the following SQL query:

   
   select distinct srchfieldname from clsattrsrchconf where attrname is not null;
   

   Note the result for comparison. For example:

   
   SRCHFIELDNAME
   ------------------
   CAS_F1
   

2. Run the following SQL query:

   
   select srchattr_id, propertyvalue, propertyname from srchattrprop 
   where propertyname in ('facet', 'facet-classicAttribute') and propertyvalue not like 'price%'
   

   Note the result for comparison. For example:

   
   SRCHATTR_ID            |PROPERTYVALUE
   ------------------------------------------------------------------------------------------------------
   -7000000000000000127   |ads_f10001_ntk_cs
   -7000000000000000125   |ads_f10501_ntk_cs
   -7000000000000000123   |ads_f11001_ntk_cs
   -1002                  |mfName_ntk_cs
   -1039                  |parentCatgroup_id_facet
   -1013                  |parentCatgroup_id_search
   -2000                  |xf_ads_f1_ntk_cs
   1030                   |cas_f1_ntk_cs
   

3. Find and update the record that begins with the SQL select statement result from Step 5.c.i. in the propertyvalue column (case insensitive). For example, the SRCHATTR_ID with 1030 matches the sample snippets.
   Set the propertyname value from facet to facet-classicAttribute:

   
   update srchattrprop set propertyname='facet-classicAttribute' where srchattr_id='SRCHATTR_ID'
   

   Where SRCHATTR_ID contains the matching row value. For example, 1030.
4. Insert a row for each of the classic attributes into the FACET table. Ensure that the facet_id does not conflict with any existing values. For example:

   
   insert into facet (facet_id, attr_id, srchattr_id, selection, sort_order, keyword_search, 
   zero_display, storeent_id, max_display, sequence, field1, field2, field3, optcounter) 
   values (-1039, null, 1030, 0, 0, 1, 0, 10901, 20, 0.0, null, null, null, 0)
   

   Note: Ensure that your statement matches your environment. For example, by updating the correct storeent_id value.
5. Insert a row in the FACETDESC table for the attributes. For example, if the attribute name is Color:

   insert into facetdesc values(-1039, -1, 'Color', 'classic attribute COLOR', null, null, null, 1);
   

6. Trigger a delta update or perform a full index update.

UPDATE ATTR SET FACETABLE = 1 WHERE ATTR_ID IN (list_of_facetable_attribute_ids);

• WC_installdir/components/foundation/subcomponents/search/bin
• WCDE_installdir\components\foundation\subcomponents\search\bin

• migrateSolrSearch.bat -masterCatalogId masterCatalogId
• migrateSolrSearch.bat -instance instance_name -masterCatalogId masterCatalogId -dbuser db_user -dbuserpwd db_password [-searchServerName searchServerName] [-searchServerPort searchServerPort] [-indexsubtype indexsubtype] [-dbauser dbauser] [-dbauserpwd dbauserpwd]
• migrateSolrSearch.sh -instance instance_name -masterCatalogId masterCatalogId -dbuser db_user -dbuserpwd db_password [-searchServerName searchServerName] [-searchServerPort searchServerPort] [-indexsubtype indexsubtype] [-dbauser dbauser] [-dbauserpwd dbauserpwd]

1. Start Rational Application Developer.
2. Right-click the test server. Then, select Clean....

If you deployed the WebSphere Commerce search cluster, ensure that the EAR changes are propagated to all the nodes.

1. Go to the following directory:
   • WC_installdir/instances/instance_name/search/pre-processConfig
   • WCDE_installdir\search\pre-processConfig
2. Manually compare all the files in the MC_masterCatalogId.timestamp directory with the files in the MC_masterCatalogId directory.
3. Identify all the changed files, and merge the specific Feature Pack 7 changes from the MC_masterCatalogId.timestamp directory to the files with the same names in the MC_masterCatalogId directory.

1. Go to the following directory:
   • WC_installdir/instances/instance_name/search/solr/home/MC_masterCatalogId/locale_name/indextype
   • WCDE_installdir\search\solr\home\MC_masterCatalogId\locale_name\indextype
2. For each core, manually compare the solrconfig.xml, wc-data-config.xml, and schema.xml files in the conf.timestamp directory with the files in the conf directory.
3. Identify all the changed files, and merge the specific previous Feature Pack changes from the conf.timestamp directory to the files with the same names in the conf directory.

1. Open the following file:
   • WC_eardir/Stores.war/storedir/Snippets/ReusableObjects/SearchFacetsDisplay.jspf
   • workspace_dir\Stores\Web Content\ storedir\Snippets\ReusableObjects\SearchFacetsDisplay.jspf
2. Find all occurrences of the following snippet.

3. 
   parentCatgroup_id_facet
   

4. Replace all occurrences with the following snippet:

   
   parentCatgroup_id_search
   

5. Find the following snippet:

   
   <c:if test="${totalCount > 1}">
      <c:forEach var="facetField" items="${globalfacets}">
      <c:if test="${facetField.value eq 'parentCatgroup_id_search'}">
      <c:if test="${fn:length(facetField.entry) > 1}">
         <%@ include file="../../Snippets/Search/CategoryFacetDisplay.jspf" %>
            <c:set var="f" value="${f + 1}" />
         </c:if>
      </c:if>
   </c:forEach>
   

6. Replace it with the following snippet:

   
   <c:if test="${totalCount > 0}">
      <c:forEach var="facetField" items="${globalfacets}">
      <c:if test="${facetField.value eq 'parentCatgroup_id_search'}">
      <c:if test="${fn:length(facetField.entry) > 0}">
         <%@ include file="../../Snippets/Search/CategoryFacetDisplay.jspf" %>
            <c:set var="f" value="${f + 1}" />
         </c:if>
      </c:if>
   </c:forEach>
   

7. Save your changes and close the file.
8. Open the following file:
   • WC_eardir/Stores.war/storedir/Snippets/Search/SearchSetup.jspf
   • workspace_dir\Stores\Web Content\storedir\Snippets\Search\SearchSetup.jspf
9. Find the following snippet:

   
   request.setAttribute("handledSearchTerm"
      ,SpecialCharacterHelper
      .getHandledString(searchTerm, false));
   
   request.setAttribute("handledFilterTerm"
      ,SpecialCharacterHelper
      .getHandledString(wcp.get("filterTerm"), false));
   
   request.setAttribute("handledManufacturer"
      ,SpecialCharacterHelper
      .getHandledString(wcp.get("manufacturer"), false));
   

10. Replace it with the following snippet:

    
    request.setAttribute("handledSearchTerm"
       ,SpecialCharacterHelper
       .escapeDollar(searchTerm));
    
    request.setAttribute("handledFilterTerm"
       ,SpecialCharacterHelper
       .escapeDollar(wcp.get("filterTerm")));
    
    request.setAttribute("handledManufacturer"
       ,SpecialCharacterHelper
       .escapeDollar(wcp.get("manufacturer")));
    

11. Save your changes and close the file.
12. Open the following file:
    • WC_eardir/Stores.war/storedir/include/BreadCrumbTrailDisplay.jsp
    • workspace_dir\Stores\Web Content\storedir\include\BreadCrumbTrailDisplay.jsp
13. Find the following snippet:

    
    <c:if test="${fn:startsWith(breadcrumbLabel, '({')}">
       <c:set var="rangeLabel" value="${fn:replace(breadcrumbLabel,'({','')}" />
       <c:set var="rangeLabel" value="${fn:replace(rangeLabel,'})','')}" />
       <c:set var="rangeLabel" value="${fn:replace(rangeLabel,'}','')}" />
    

14. Replace it with the following snippet:

    
    <c:if test="${fn:startsWith(breadcrumbLabel, '{')}">
       <c:set var="rangeLabel" value="${fn:replace(breadcrumbLabel,'{','')}" />
       <c:set var="rangeLabel" value="${fn:replace(rangeLabel,'}','')}" />
    

15. Save your changes and close the file.
16. Restart your WebSphere Commerce server.
17. Deploy the changes for the JSP files you updated. For more information, see Deploying J2EE assets for a single file.

1. Open the following file:
   • WC_eardir/Stores.war/storedir/Layouts/CategoryNavigationResults.jsp
   • workspace_dir\Stores\Web Content\storedir\Layouts\CategoryNavigationResults.jsp
2. Find the following snippet:

   
   <c:when test="${!empty WCParam.searchTerm || !empty WCParam.manufacturer || !empty WCParam.facet || !empty WCParam.metaData}">
   

3. Replace it with the following snippet:

   
   <c:when test="${!empty WCParam.searchTerm || !empty WCParam.manufacturer || !empty WCParam.filterTerm || !empty WCParam.facet || !empty WCParam.metaData}">
   

4. Save your changes and close the file.
5. Open the following file:
   • WC_eardir/Stores.war/storedir/Layouts/SearchBasedCategoryPage.jsp
   • workspace_dir\Stores\Web Content\storedir\Layouts\SearchBasedCategoryPage.jsp
6. Find the following snippet:

   
   <c:when test = "${empty WCParam.searchTerm && empty WCParam.manufacturer && empty WCParam.facet && empty WCParam.metaData}">
   

7. Replace it with the following snippet:

   
   <c:when test = "${empty WCParam.searchTerm && empty WCParam.manufacturer && empty WCParam.facet && empty WCParam.filterTerm && empty WCParam.metaData}">
   

8. Save your changes and close the file.
9. Deploy the changes for the JSP files you updated. For more information, see Deploying J2EE assets for a single file.

1. Open the following file:
   For the Madisons starter store and Elite starter store:

   • WC_eardir/Stores.war/storedir/include/JSTLEnvironmentSetupExtForSearch.jspf
   • WC_eardir/Stores.war/storedir/Snippets/Search/AutoSuggestSerialize.jsp
   • workspace_dir\Stores\Web Content\storedir\include\JSTLEnvironmentSetupExtForSearch.jspf
   • workspace_dir\Stores\Web Content\storedir\Snippets\Search\AutoSuggestSerialize.jsp
   For the Aurora starter store:

   • WC_eardir/Stores.war/storedir/Widgets/Search/JSTLEnvironmentSetupExtForSearch.jspf
   • WC_eardir/Stores.war/storedir/Widgets/Search/AutoSuggestSerialize.jsp
   • workspace_dir\Stores\Web Content\storedir\Widgets\Search\JSTLEnvironmentSetupExtForSearch.jspf
   • workspace_dir\Stores\Web Content\storedir\Widgets\Search\AutoSuggestSerialize.jsp
2. Find the following snippet:

   
   <%@ page import="org.apache.solr.client.solrj.impl.CommonsHttpSolrServer" %>
   

3. Replace it with the following snippet:

   
   <%@ page import="org.apache.solr.client.solrj.impl.HttpSolrServer" %>
   

4. Find the following snippet:

   
   if(solrServer instanceof CommonsHttpSolrServer ){
               serverURL = ((CommonsHttpSolrServer )solrServer).getBaseURL();
   

5. Replace it with the following snippet:

   
   if(solrServer instanceof HttpSolrServer){
               serverURL = ((HttpSolrServer)solrServer).getBaseURL();
   

6. Save your changes and close the file.
7. Deploy the changes for the JSP files you updated. For more information, see Deploying J2EE assets for a single file.

• working_dir/search/instance_name/search/solr/home

1. Click the server name.
2. Under Server Infrastructure, go to Java and Process Management > Process Definitions.
3. Under Additional Properties, click Java Virtual Machine.
4. Under Additional Properties, click Custom Properties.
5. Click New and set the following values:

   Custom properties

   Name	Value
   solr.allow.unsafe.resourceloading	true

   By default, the resource loader does not load files from external servers for security reasons.
6. Click Apply.