Errors adding additional attributes to the Lucene index (Doc ID 2187413.1)

Last updated on OCTOBER 02, 2016

Applies to:

Oracle WebCenter Sites - Version 7.5.0 to 7.6.2 [Release FatWire]
Information in this document applies to any platform.

Symptoms

Sites is failing to add additional attributes to the Lucene index. A "Content server error" is encountered in the UI and the asset is removed from the list of indexed assets. Logging indicates that this problem is being caused by having too much attribute information added to the FIELDDESCRIPTOR column in the INDEXSOURCEMETADATACONFIG table.

An error similar to the following will be seen in the futuretense.txt:

[CS.DB][ERROR] Exception executing prepared statement: INSERT INTO IndexSourceMetaDataConfig (ID,NAME,UNIQUEID,DEFAULTSEARCHFIELD,SEARCHENGINENAME,SORTABLEFIELDS,FIELDDESCRIPTOR,PROPERTIES) VALUES (?,?,?,?,?,?,?,?)
ID = <asset_id>
NAME = <asset_name>
UNIQUEID = id
DEFAULTSEARCHFIELD = DefaultSearchField
SEARCHENGINENAME = lucene
SORTABLEFIELDS = name;
FIELDDESCRIPTOR = <a very long string>
PROPERTIES = FullTextIndex=true;
java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms