"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 SEPTEMBER 18, 2023
Applies to:
Oracle WebCenter Content - Version 11.1.1.3.0 and laterInformation 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
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 |
Cause |
Solution |
References |