Searches Fail and Throw Error "$ORA-01652: unable to extend temp segment by 128 in tablespace P_OCS_TEMP" (Doc ID 1395586.1)

Last updated on NOVEMBER 03, 2016

Applies to:

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

Symptoms

Upon performing an open (no criteria) Quick Search, the search does not complete and instead the below exception is thrown:

Example WebCenter Content 11g exception:

>systemdatabase/6 04.13 12:40:34.003 IdcServer-3984 0.58 ms. SELECT 1 FROM DUAL[Executed. Returned row(s): true]
>systemdatabase/6 04.13 12:40:34.003 IdcServer-3984 !csDbUnableToCreateResultSet,SELECT IdcColl2.dID\, dDocTitle\, dDocType\, dRevisionID\, dSecurityGroup\, dDocAuthor\, dDocAccount\, dRevLabel\, dFormat\, dOriginalName\, dExtension\, dWebExtension\, dInDate\, dOutDate\, dPublishType\, dRendition1\, dRendition2\, VaultFileSize\, WebFileSize\, URL\, dFullTextFormat\, dFullTextCharset\, DocMeta.*\, RevClasses.*
systemdatabase/6 04.13 12:40:34.003 IdcServer-3984 FROM IdcColl2\, DocMeta\, RevClasses
systemdatabase/6 04.13 12:40:34.003 IdcServer-3984 WHERE IdcColl2.dID=DocMeta.dID AND IdcColl2.dDocName =RevClasses.dDocName ORDER BY dInDate Desc!$ORA-01652: unable to extend temp segment by 128 in tablespace ECM_OCS_TEMP

>systemdatabase/6 04.13 12:40:34.003 IdcServer-3984 run: 0.77 ms. total 2.00 ms. [ORA-01652: unable to extend temp segment by 128 in tablespace ECM_OCS_TEMP
systemdatabase/6 04.13 12:40:34.003 IdcServer-3984 ]
>search/6 04.13 12:40:34.003 IdcServer-3984 !csDbUnableToCreateResultSet,SELECT IdcColl2.dID\, dDocTitle\, dDocType\, dRevisionID\, dSecurityGroup\, dDocAuthor\, dDocAccount\, dRevLabel\, dFormat\, dOriginalName\, dExtension\, dWebExtension\, dInDate\, dOutDate\, dPublishType\, dRendition1\, dRendition2\, VaultFileSize\, WebFileSize\, URL\, dFullTextFormat\, dFullTextCharset\, DocMeta.*\, RevClasses.*
search/6 04.13 12:40:34.003 IdcServer-3984 FROM IdcColl2\, DocMeta\, RevClasses
search/6 04.13 12:40:34.003 IdcServer-3984 WHERE IdcColl2.dID=DocMeta.dID AND IdcColl2.dDocName =RevClasses.dDocName ORDER BY dInDate Desc!$ORA-01652: unable to extend temp segment by 128 in tablespace ECM_OCS_TEMP
search/6 04.13 12:40:34.003 IdcServer-3984 exception stack
search/6 04.13 12:40:34.003 IdcServer-3984 intradoc.data.DataException: !csDbUnableToCreateResultSet,SELECT IdcColl2.dID\, dDocTitle\, dDocType\, dRevisionID\, dSecurityGroup\, dDocAuthor\, dDocAccount\, dRevLabel\, dFormat\, dOriginalName\, dExtension\, dWebExtension\, dInDate\, dOutDate\, dPublishType\, dRendition1\, dRendition2\, VaultFileSize\, WebFileSize\, URL\, dFullTextFormat\, dFullTextCharset\, DocMeta.*\, RevClasses.*
search/6 04.13 12:40:34.003 IdcServer-3984 FROM IdcColl2\, DocMeta\, RevClasses
search/6 04.13 12:40:34.003 IdcServer-3984 WHERE IdcColl2.dID=DocMeta.dID AND IdcColl2.dDocName =RevClasses.dDocName ORDER BY dInDate Desc!$ORA-01652: unable to extend temp segment by 128 in tablespace ECM_OCS_TEMP
search/6 04.13 12:40:34.003 IdcServer-3984
search/6 04.13 12:40:34.003 IdcServer-3984 at intradoc.jdbc.JdbcWorkspace.handleSQLException(JdbcWorkspace.java:2461)
search/6 04.13 12:40:34.003 IdcServer-3984 at intradoc.jdbc.JdbcWorkspace.createResultSetSQL(JdbcWorkspace.java:791)
search/6 04.13 12:40:34.003 IdcServer-3984 at intradoc.search.DatabaseFullTextSearchImplementor.doQuery(DatabaseFullTextSearchImplementor.java:135)
search/6 04.13 12:40:34.003 IdcServer-3984 at intradoc.search.CommonSearchConnection.doQuery(CommonSearchConnection.java:158)
search/6 04.13 12:40:34.003 IdcServer-3984 at intradoc.server.SearchManager.retrieveSearchInfoAsBinder(SearchManager.java:224)
search/6 04.13 12:40:34.003 IdcServer-3984 at intradoc.server.SearchService.retrieveSearchInfo(SearchService.java:1846)
search/6 04.13 12:40:34.003 IdcServer-3984 at intradoc.server.SearchService.doLocalSearch(SearchService.java:1376)
search/6 04.13 12:40:34.003 IdcServer-3984 at intradoc.server.SearchService.getSearchResults(SearchService.java:670)
search/6 04.13 12:40:34.003 IdcServer-3984 at sun.reflect.GeneratedMethodAccessor461.invoke(Unknown Source)
search/6 04.13 12:40:34.003 IdcServer-3984 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
search/6 04.13 12:40:34.003 IdcServer-3984 at java.lang.reflect.Method.invoke(Method.java:597)
search/6 04.13 12:40:34.003 IdcServer-3984 at intradoc.common.IdcMethodHolder.invokeMethod(IdcMethodHolder.java:86)
search/6 04.13 12:40:34.003 IdcServer-3984 at intradoc.common.ClassHelperUtils.executeMethodEx(ClassHelperUtils.java:310)
search/6 04.13 12:40:34.003 IdcServer-3984 at intradoc.common.ClassHelperUtils.executeMethod(ClassHelperUtils.java:295)
search/6 04.13 12:40:34.003 IdcServer-3984 at intradoc.server.Service.doCodeEx(Service.java:550)
search/6 04.13 12:40:34.003 IdcServer-3984 at intradoc.server.Service.doCode(Service.java:505)
search/6 04.13 12:40:34.003 IdcServer-3984 at intradoc.server.ServiceRequestImplementor.doAction(ServiceRequestImplementor.java:1643)
search/6 04.13 12:40:34.003 IdcServer-3984 at intradoc.server.Service.doAction(Service.java:477)
search/6 04.13 12:40:34.003 IdcServer-3984 at intradoc.server.ServiceRequestImplementor.doActions(ServiceRequestImplementor.java:1458)
search/6 04.13 12:40:34.003 IdcServer-3984 at intradoc.server.Service.doActions(Service.java:472)
search/6 04.13 12:40:34.003 IdcServer-3984 at intradoc.server.ServiceRequestImplementor.executeActions(ServiceRequestImplementor.java:1391)
search/6 04.13 12:40:34.003 IdcServer-3984 at intradoc.server.Service.executeActions(Service.java:458)
search/6 04.13 12:40:34.003 IdcServer-3984 at intradoc.server.ServiceRequestImplementor.doRequest(ServiceRequestImplementor.java:737)
search/6 04.13 12:40:34.003 IdcServer-3984 at intradoc.server.Service.doRequest(Service.java:1890)
search/6 04.13 12:40:34.003 IdcServer-3984 at intradoc.server.ServiceManager.processCommand(ServiceManager.java:435)
search/6 04.13 12:40:34.003 IdcServer-3984 at intradoc.server.IdcServerThread.processRequest(IdcServerThread.java:265)
search/6 04.13 12:40:34.003 IdcServer-3984 at intradoc.idcwls.IdcServletRequestUtils.doRequest(IdcServletRequestUtils.java:1343)
search/6 04.13 12:40:34.003 IdcServer-3984 at intradoc.idcwls.IdcServletRequestUtils.processFilterEvent(IdcServletRequestUtils.java:1715)
search/6 04.13 12:40:34.003 IdcServer-3984 at intradoc.idcwls.IdcIntegrateWrapper.processFilterEvent(IdcIntegrateWrapper.java:222)
search/6 04.13 12:40:34.003 IdcServer-3984 at sun.reflect.GeneratedMethodAccessor256.invoke(Unknown Source)
search/6 04.13 12:40:34.003 IdcServer-3984 ... 35 more
search/6 04.13 12:40:34.003 IdcServer-3984 Caused by: java.sql.SQLException: ORA-01652: unable to extend temp segment by 128 in tablespace ECM_OCS_TEMP
search/6 04.13 12:40:34.003 IdcServer-3984
search/6 04.13 12:40:34.003 IdcServer-3984 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:457)
search/6 04.13 12:40:34.003 IdcServer-3984 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
search/6 04.13 12:40:34.003 IdcServer-3984 at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:889)
search/6 04.13 12:40:34.003 IdcServer-3984 at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:476)
search/6 04.13 12:40:34.003 IdcServer-3984 at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:204)
search/6 04.13 12:40:34.003 IdcServer-3984 at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:540)
search/6 04.13 12:40:34.003 IdcServer-3984 at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:202)
search/6 04.13 12:40:34.003 IdcServer-3984 at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:919)
search/6 04.13 12:40:34.003 IdcServer-3984 at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1261)
search/6 04.13 12:40:34.003 IdcServer-3984 at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1411)
search/6 04.13 12:40:34.003 IdcServer-3984 at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:6486)
search/6 04.13 12:40:34.003 IdcServer-3984 at oracle.jdbc.driver.OracleStatement.doScrollStmtExecuteQuery(OracleStatement.java:6621)
search/6 04.13 12:40:34.003 IdcServer-3984 at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1675)
search/6 04.13 12:40:34.003 IdcServer-3984 at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:432)
search/6 04.13 12:40:34.003 IdcServer-3984 at weblogic.jdbc.wrapper.Statement.executeQuery(Statement.java:487)
search/6 04.13 12:40:34.003 IdcServer-3984 at intradoc.jdbc.JdbcWorkspace.createResultSetSQL(JdbcWorkspace.java:763)
search/6 04.13 12:40:34.003 IdcServer-3984 ... 63 more
>search/6 04.13 12:44:08.070 IdcServer-4011 Masking status message '!csSearchUnableToRetrieveSearchResult
>systemdatabase/6 04.13 12:44:08.070 IdcServer-4011 !csMonitorActiveDbConnections,1
>systemdatabase/6 04.13 12:44:08.070 IdcServer-4011 release pool connection
>services/3 04.13 12:44:08.071 IdcServer-4011 !csUserEventMessage,weblogic,ecm.mta-bsc.org:4433!$ intradoc.common.ServiceException: !csSearchUnableToReturnResults
services/3 04.13 12:44:08.071 IdcServer-4011 *ScriptStack GET_SEARCH_RESULTS
services/3 04.13 12:44:08.071 IdcServer-4011 3:getSearchResults,**no captured values**
services/3 04.13 12:44:08.071 IdcServer-4011 at intradoc.server.SearchManager.retrieveSearchInfoAsBinder(SearchManager.java:295)
services/3 04.13 12:44:08.071 IdcServer-4011 at intradoc.server.SearchService.retrieveSearchInfo(SearchService.java:1846)
services/3 04.13 12:44:08.071 IdcServer-4011 at intradoc.server.SearchService.doLocalSearch(SearchService.java:1376)
services/3 04.13 12:44:08.071 IdcServer-4011 at intradoc.server.SearchService.getSearchResults(SearchService.java:670)
services/3 04.13 12:44:08.071 IdcServer-4011 at sun.reflect.GeneratedMethodAccessor461.invoke(Unknown Source)
services/3 04.13 12:44:08.071 IdcServer-4011 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
services/3 04.13 12:44:08.071 IdcServer-4011 at java.lang.reflect.Method.invoke(Method.java:597)
services/3 04.13 12:44:08.071 IdcServer-4011 at intradoc.common.IdcMethodHolder.invokeMethod(IdcMethodHolder.java:86)
services/3 04.13 12:44:08.071 IdcServer-4011 at intradoc.common.ClassHelperUtils.executeMethodEx(ClassHelperUtils.java:310)
services/3 04.13 12:44:08.071 IdcServer-4011 at intradoc.common.ClassHelperUtils.executeMethod(ClassHelperUtils.java:295)
services/3 04.13 12:44:08.071 IdcServer-4011 at intradoc.server.Service.doCodeEx(Service.java:550)
services/3 04.13 12:44:08.071 IdcServer-4011 at intradoc.server.Service.doCode(Service.java:505)
services/3 04.13 12:44:08.071 IdcServer-4011 at intradoc.server.ServiceRequestImplementor.doAction(ServiceRequestImplementor.java:1643)
services/3 04.13 12:44:08.071 IdcServer-4011 at intradoc.server.Service.doAction(Service.java:477)
services/3 04.13 12:44:08.071 IdcServer-4011 at intradoc.server.ServiceRequestImplementor.doActions(ServiceRequestImplementor.java:1458)
services/3 04.13 12:44:08.071 IdcServer-4011 at intradoc.server.Service.doActions(Service.java:472)
services/3 04.13 12:44:08.071 IdcServer-4011 at intradoc.server.ServiceRequestImplementor.executeActions(ServiceRequestImplementor.java:1391)
services/3 04.13 12:44:08.071 IdcServer-4011 at intradoc.server.Service.executeActions(Service.java:458)
services/3 04.13 12:44:08.071 IdcServer-4011 at intradoc.server.ServiceRequestImplementor.doRequest(ServiceRequestImplementor.java:737)
services/3 04.13 12:44:08.071 IdcServer-4011 at intradoc.server.Service.doRequest(Service.java:1890)
services/3 04.13 12:44:08.071 IdcServer-4011 at intradoc.server.ServiceManager.processCommand(ServiceManager.java:435)
services/3 04.13 12:44:08.071 IdcServer-4011 at intradoc.server.IdcServerThread.processRequest(IdcServerThread.java:265)
services/3 04.13 12:44:08.071 IdcServer-4011 at intradoc.idcwls.IdcServletRequestUtils.doRequest(IdcServletRequestUtils.java:1343)
services/3 04.13 12:44:08.071 IdcServer-4011 at intradoc.idcwls.IdcServletRequestUtils.processFilterEvent(IdcServletRequestUtils.java:1715)
services/3 04.13 12:44:08.071 IdcServer-4011 at intradoc.idcwls.IdcIntegrateWrapper.processFilterEvent(IdcIntegrateWrapper.java:222)
services/3 04.13 12:44:08.071 IdcServer-4011 at sun.reflect.GeneratedMethodAccessor256.invoke(Unknown Source)
services/3 04.13 12:44:08.071 IdcServer-4011 ... 35 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