General Exception intradoc.common.ServiceException Encountered When Doing Collection Rebuild Using Fast Rebuild Option (Doc ID 1345184.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle WebCenter Content - Version to [Release 11g]
Information in this document applies to any platform.


After a fresh WebCenter Content (ECM) installation, when logging in to Content Server, users/administrators may notice the following warning:

Index Collection needs to be synchronized, a full collection rebuild is required. Please rebuild the index collection.

This indicates that a full collection rebuild is required for this instance.

However, if administrators do a full collection rebuild with fast rebuild option checked, an error will occur and the following exception can be found in the managed server logs:

SEVERE: general exception
intradoc.common.ServiceException: !csUnableToModifyTextCollectionTable,IdcText1
at intradoc.indexer.OracleTextCollectionHandler.manageCollection(
at intradoc.indexer.IndexerCollectionManager.doWork(
at intradoc.indexer.Indexer.doIndexing(
at intradoc.indexer.Indexer.buildIndex(
at intradoc.server.IndexerMonitor.doIndexing(
at intradoc.server.IndexerMonitor$
Caused by: !csDbUnableToExecuteSql,UPDATE IdcText1 SET xInhibitUpdate = (SELECT xInhibitUpdate FROM DocMeta WHERE IdcText1.dID = DocMeta.dID)\,dWebExtension = (SELECT dWebExtension FROM Revisions WHERE IdcText1.dID = Revisions.dID)\,xDiscussionCount = (SELECT xDiscussionCount FROM DocMeta WHERE IdcText1.dID = DocMeta.dID)\,xHidden = (SELECT xHidden FROM DocMeta WHERE IdcText1.dID = DocMeta.dID)\,xReadOnly = (SELECT xReadOnly FROM DocMeta WHERE IdcText1.dID = DocMeta.dID)\,xDiscussionType = (SELECT xDiscussionType FROM DocMeta WHERE IdcText1.dID = DocMeta.dID)\,xCollectionID = (SELECT xCollectionID FROM DocMeta WHERE IdcText1.dID = DocMeta.dID)\,dDocTitle = (SELECT dDocTitle FROM Revisions WHERE IdcText1.dID = Revisions.dID)\,dExtension = (SELECT dExtension FROM Documents WHERE IdcText1.dID = Documents.dID)\,dOriginalName = (SELECT dOriginalName FROM Documents WHERE IdcText1.dID = Documents.dID)!$ORA-01427: single-row subquery returns more than one row

at intradoc.jdbc.JdbcWorkspace.handleSQLException(
at intradoc.jdbc.JdbcWorkspace.executeSQL(
at intradoc.indexer.OracleTextCollectionHandler.updateIndexUsingBaseTable(
at intradoc.indexer.OracleTextCollectionHandler.manageCollection(
... 5 more
Caused by: java.sql.SQLException: ORA-01427: single-row subquery returns more than one row

at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4C8Oall.processError(
at oracle.jdbc.driver.T4CTTIfun.receive(
at oracle.jdbc.driver.T4CTTIfun.doRPC(
at oracle.jdbc.driver.T4C8Oall.doOALL(
at oracle.jdbc.driver.T4CStatement.doOall8(
at oracle.jdbc.driver.T4CStatement.executeForRows(
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(
at oracle.jdbc.driver.OracleStatement.doScrollStmtExecuteQuery(
at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(
at oracle.jdbc.driver.OracleStatement.executeUpdate(
at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(
at weblogic.jdbc.wrapper.Statement.executeUpdate(
at intradoc.jdbc.JdbcWorkspace.executeSQL(
... 7 more


Fresh install (including a brand new install but using existing schema).


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