By default, the size and type of the CATGRPDESC.KEYWORD column is VARCHAR (254). If
necessary, you can increase the size.
Procedure
-
Run the following SQL statement:
ALTER TABLE CATGRPDESC ALTER COLUMN KEYWORD SET DATA TYPE VARCHAR(32500)
-
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
.
-
Preprocess and build the WebSphere Commerce search index.