Increasing the size of the CATGRPDESC table KEYWORD column

By default, the size and type of the CATGRPDESC.KEYWORD column is VARCHAR (254). If necessary, you can increase the size.

Procedure

  1. Run the following SQL statement: 
    ALTER TABLE CATGRPDESC ALTER COLUMN KEYWORD SET DATA TYPE VARCHAR(32500)
  2. Open the solrhome/MC_masterCatalogId/locale/CatalogGroup/conf/wc-data-config.xml file for editing.
    Change <field column= "KEYWORD" name= "keyword" /> to <field column= "KEYWORD" clob= "true" />.
    Note: Solr uses the wc-data-config.xml file which imports data from the database. To indicate that the import is from database is from a varchar column with a larger than normal the type is set to clob=true.
  3. Preprocess and build the WebSphere Commerce search index.