"SELECT PND_CID FROM CTXSYS.DR$PENDING WHERE PND_CID = 6637)!$ORA-00942: table or view does not exist" Error When Rebuilding the Index (Doc ID 1574261.1)

Last updated on NOVEMBER 03, 2016

Applies to:

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

Symptoms

In the WebCenter Content (WCC) application, when attempting to rebuild the collection index it will fail with the following error in the server output:

>systemdatabase/6 08.01 10:18:15.324 index rebuild work !csDbUnableToCreateResultSet,QoracleTextPendingDocIDs(SELECT PND_CID FROM CTXSYS.DR$PENDING WHERE PND_CID = 6637)!$ORA-00942: table or view does not exist

>systemdatabase/6 08.01 10:18:15.324 index rebuild work run: 1.45 ms. total 4.17 ms. [ORA-00942: table or view does not exist
 systemdatabase/6 08.01 10:18:15.324 index rebuild work ]
>systemdatabase/6 08.01 10:18:15.324 index rebuild work Closing active result set
>systemdatabase/6 08.01 10:18:15.324 index rebuild work Closing statement in closing internals
>systemdatabase/7 08.01 10:18:15.324 index rebuild work (start) ALTER SESSION SET NLS_LENGTH_SEMANTICS = 'CHAR'
>systemdatabase/6 08.01 10:18:15.325 index rebuild work 1.04 ms. ALTER SESSION SET NLS_LENGTH_SEMANTICS = 'CHAR'[Executed. 0 row(s) affected.]
>systemdatabase/6 08.01 10:18:15.325 index rebuild work Removing query: QFastRebuildColumns
>systemdatabase/6 08.01 10:18:15.325 index rebuild work Closing statement.
>systemdatabase/6 08.01 10:18:15.325 index rebuild work Removing query: UFastRebuildOtsMeta
>systemdatabase/6 08.01 10:18:15.325 index rebuild work Closing statement.
>systemdatabase/6 08.01 10:18:15.325 index rebuild work Removing query: CdropTextPreference
>systemdatabase/6 08.01 10:18:15.326 index rebuild work Closing statement.
>systemdatabase/6 08.01 10:18:15.342 index rebuild work Removing query: CaddTextPreference
>systemdatabase/6 08.01 10:18:15.342 index rebuild work Closing statement.
>systemdatabase/6 08.01 10:18:15.342 index rebuild work Removing query: CaddTextPrefAttribute
>systemdatabase/6 08.01 10:18:15.342 index rebuild work Closing statement.
>systemdatabase/6 08.01 10:18:15.342 index rebuild work Removing query: CdropSectionGroup
>systemdatabase/6 08.01 10:18:15.342 index rebuild work Closing statement.
>systemdatabase/6 08.01 10:18:15.342 index rebuild work Removing query: CaddSectionGroup
>systemdatabase/6 08.01 10:18:15.342 index rebuild work Closing statement.
>systemdatabase/6 08.01 10:18:15.342 index rebuild work Removing query: CaddSDATASection
>systemdatabase/6 08.01 10:18:15.342 index rebuild work Closing statement.
>systemdatabase/6 08.01 10:18:15.342 index rebuild work Removing query: CaddZoneSection
>systemdatabase/6 08.01 10:18:15.342 index rebuild work Closing statement.
>systemdatabase/6 08.01 10:18:15.342 index rebuild work Removing query: CoracleTextDropShadowIndex
>systemdatabase/6 08.01 10:18:15.342 index rebuild work Closing statement.
>systemdatabase/6 08.01 10:18:15.342 index rebuild work Removing query: CoracleTextCreateShadowIndex
>systemdatabase/6 08.01 10:18:15.342 index rebuild work Closing statement.
>systemdatabase/6 08.01 10:18:15.342 index rebuild work Removing query: CoracleTextPopulatePending
>systemdatabase/6 08.01 10:18:15.342 index rebuild work Closing statement.
>systemdatabase/6 08.01 10:18:15.343 index rebuild work !csMonitorActiveDbConnections,0
>systemdatabase/6 08.01 10:18:15.343 index rebuild work Connection with id of 'index rebuild work.115' is removed from active connections with key of 'index rebuild work'.
>systemdatabase/6 08.01 10:18:15.343 index rebuild work release pool connection
>(internal)/3 08.01 10:18:15.343 index rebuild work !csIndexerAbortedMsg intradoc.common.ServiceException: !csOracleTextUnableRebuildIndex
 (internal)/3 08.01 10:18:15.343 index rebuild work at intradoc.indexer.OracleTextCollectionHandler.manageCollection(OracleTextCollectionHandler.java:500)
 (internal)/3 08.01 10:18:15.343 index rebuild work at intradoc.indexer.IndexerCollectionManager.doWork(IndexerCollectionManager.java:101)
 (internal)/3 08.01 10:18:15.343 index rebuild work at intradoc.indexer.Indexer.doIndexing(Indexer.java:411)
 (internal)/3 08.01 10:18:15.343 index rebuild work at intradoc.indexer.Indexer.buildIndex(Indexer.java:319)
 (internal)/3 08.01 10:18:15.343 index rebuild work at intradoc.server.IndexerMonitor.doIndexing(IndexerMonitor.java:1021)
 (internal)/3 08.01 10:18:15.343 index rebuild work at intradoc.server.IndexerMonitor$4.run(IndexerMonitor.java:842)
 (internal)/3 08.01 10:18:15.343 index rebuild work Caused by: intradoc.data.DataException:
 (internal)/3 08.01 10:18:15.343 index rebuild work at intradoc.jdbc.JdbcWorkspace.handleSQLException(JdbcWorkspace.java:2553)
 (internal)/3 08.01 10:18:15.343 index rebuild work at intradoc.jdbc.JdbcWorkspace.createResultSet(JdbcWorkspace.java:704)
 (internal)/3 08.01 10:18:15.343 index rebuild work at intradoc.indexer.OracleTextCollectionHandler.checkSyncStatus(OracleTextCollectionHandler.java:1102)
 (internal)/3 08.01 10:18:15.343 index rebuild work at intradoc.indexer.OracleTextCollectionHandler.manageCollection(OracleTextCollectionHandler.java:478)
 (internal)/3 08.01 10:18:15.343 index rebuild work ... 5 more

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