Collection Rebuild Fails With 'ORA-00904: SD<custom_field_name> invalid identifier' When MultiSort Component Is Used (Doc ID 1493615.1)

Last updated on APRIL 09, 2024

Applies to:

Symptoms

After adding custom fields to the OFSSortFields parameter of the MultiSort component (in <domain_home>/ucm/cs/custom/MultiSort/multisort_environment.cfg), a full collection rebuild using the OracleTextSearch engine may fail.

Enabling full verbose tracing for "systemdatabase" will reveal the following error message in the server output:

intradoc.common.ServiceException: !csIndexerOracleTextCanNotCreateTableOrIndex,IdcText1!csDbUnableToExecuteSql,
CREATE INDEX FT_IdcText1 ON IdcText1 (otsMeta) INDEXTYPE IS CTXSYS.CONTEXT
Filter By xSuperSupersededDate\,xRecordSupersededDate\,dInDate\,xcustomdate\,dCreateDate\,sdxcustomdate\,dOutDate PARAMETERS('DATASTORE IdcStore_ots1 LEXER
IdcLexer_ots1 SECTION GROUP section_group_ots1 MEMORY 20M SYNC(MANUAL) ')!$ORA-00904: "SDXCUSTOMDATE": invalid identifier
at oracletextsearch.indexer.OracleTextHandler.createCollection(OracleTextHandler.java:770)
at intradoc.indexer.IndexerExecution.createCollection(IndexerExecution.java:579)
at intradoc.indexer.IndexerExecution.prepare(IndexerExecution.java:432)
at intradoc.indexer.IndexerDriverAdaptor.prepare(IndexerDriverAdaptor.java:60)
at intradoc.indexer.DocIndexerAdaptor.prepare(DocIndexerAdaptor.java:105)
at intradoc.indexer.Indexer.doIndexing(Indexer.java:372)
at intradoc.indexer.Indexer.buildIndex(Indexer.java:348)
at intradoc.server.IndexerMonitor.doIndexing(IndexerMonitor.java:1012)
at intradoc.server.IndexerMonitor$4.run(IndexerMonitor.java:832)

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.