Errors adding additional attributes to the Lucene index
(Doc ID 2187413.1)
Last updated on NOVEMBER 04, 2022
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
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
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |