Errors adding additional attributes to the Lucene index
(Doc ID 2187413.1)
Last updated on APRIL 30, 2021
Applies to:Oracle WebCenter Sites - Version 7.5.0 to 7.6.2 [Release FatWire]
Information in this document applies to any platform.
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:
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document