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 11.1.1.5.0 to 11.1.1.5.0 [Release 11g]
Information in this document applies to any platform.

Symptoms

After a fresh WebCenter Content (ECM) 11.1.1.5 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(OracleTextCollectionHandler.java:275)
at intradoc.indexer.IndexerCollectionManager.doWork(IndexerCollectionManager.java:101)
at intradoc.indexer.Indexer.doIndexing(Indexer.java:411)
at intradoc.indexer.Indexer.buildIndex(Indexer.java:319)
at intradoc.server.IndexerMonitor.doIndexing(IndexerMonitor.java:1021)
at intradoc.server.IndexerMonitor$4.run(IndexerMonitor.java:841)
Caused by: intradoc.data.DataException: !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(JdbcWorkspace.java:2461)
at intradoc.jdbc.JdbcWorkspace.executeSQL(JdbcWorkspace.java:830)
at intradoc.indexer.OracleTextCollectionHandler.updateIndexUsingBaseTable(OracleTextCollectionHandler.java:630)
at intradoc.indexer.OracleTextCollectionHandler.manageCollection(OracleTextCollectionHandler.java:269)
... 5 more
Caused by: java.sql.SQLException: ORA-01427: single-row subquery returns more than one row

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:457)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:889)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:476)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:204)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:540)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:202)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1074)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1466)
at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:6474)
at oracle.jdbc.driver.OracleStatement.doScrollStmtExecuteQuery(OracleStatement.java:6621)
at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:2127)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:2067)
at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:306)
at weblogic.jdbc.wrapper.Statement.executeUpdate(Statement.java:511)
at intradoc.jdbc.JdbcWorkspace.executeSQL(JdbcWorkspace.java:824)
... 7 more

Changes

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

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