My Oracle Support Banner

Error Generated when Performing Collection Rebuild: "ORA-01408: such column list already indexed" (Doc ID 2057087.1)

Last updated on MARCH 07, 2023

Applies to:

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

Symptoms

On : 11.1.1.7.0 version, Content Server

Below error occurs during the collection rebuilt:   (While logs show this error the Collection rebuild will continue to work)


!csDbUnableToExecuteSql,CREATE INDEX IdcText1_dDocName ON IdcText1(dDocName)!$ORA-01408: such column list already indexed 

systemdatabase/6       09.02 12:24:54.379      index rebuild work      !csDbUnableToExecuteSql,CREATE INDEX IdcText1_dDocName ON IdcText1(dDocName)!$ORA-01408: such column list already indexed

>systemdatabase/6       09.02 12:24:54.379      index rebuild work      run: 0.87 ms.  total 2.30 ms. [ORA-01408: such column list already indexed
systemdatabase/6       09.02 12:24:54.379      index rebuild work      ]
>systemdatabase/6       09.02 12:24:54.379      index rebuild work       exception backtrace:intradoc.data.DataException:
systemdatabase/6       09.02 12:24:54.379      index rebuild work              at intradoc.jdbc.JdbcWorkspace.handleSQLException(JdbcWorkspace.java:2553)
systemdatabase/6       09.02 12:24:54.379      index rebuild work              at intradoc.jdbc.JdbcWorkspace.executeSQL(JdbcWorkspace.java:851)
systemdatabase/6       09.02 12:24:54.379      index rebuild work              at intradoc.jdbc.JdbcWorkspace.addIndex(JdbcWorkspace.java:2318)
systemdatabase/6       09.02 12:24:54.379      index rebuild work              at intradoc.indexer.OracleTextCollectionHandler.addIndexes(OracleTextCollectionHandler.java:1668)
systemdatabase/6       09.02 12:24:54.379      index rebuild work              at intradoc.indexer.OracleTextCollectionHandler.createCollection(OracleTextCollectionHandler.java:1249)
systemdatabase/6       09.02 12:24:54.379      index rebuild work              at intradoc.indexer.OracleTextCollectionHandler.manageCollection(OracleTextCollectionHandler.java:265)
systemdatabase/6       09.02 12:24:54.379      index rebuild work              at intradoc.indexer.IndexerCollectionManager.doWork(IndexerCollectionManager.java:101)
systemdatabase/6       09.02 12:24:54.379      index rebuild work              at intradoc.indexer.Indexer.doIndexing(Indexer.java:411)
systemdatabase/6       09.02 12:24:54.379      index rebuild work              at intradoc.indexer.Indexer.buildIndex(Indexer.java:319)
systemdatabase/6       09.02 12:24:54.379      index rebuild work              at intradoc.server.IndexerMonitor.doIndexing(IndexerMonitor.java:1021)
systemdatabase/6       09.02 12:24:54.379      index rebuild work              at intradoc.server.IndexerMonitor$4.run(IndexerMonitor.java:841)
>systemdatabase/6       09.02 12:24:54.576      index rebuild work      Closing active result set

Changes

Collection rebuild is started.

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


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