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

Last updated on MAY 17, 2017

Applies to:

Oracle WebCenter Content - Version 10.1.3.5.0 and later
Information in this document applies to any platform.

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

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