UpgradeWebCenterPortal Command Fails During Upgrade: "oracle.stellent.ridc.protocol.ServiceException: Unable to retrieve search results. Error occurred while processing. Unable to return results"

(Doc ID 2310466.1)

Last updated on SEPTEMBER 25, 2017

Applies to:

Oracle WebCenter Portal - Version 11.1.1.8.0 to 12.2.1.3.0
Information in this document applies to any platform.

Symptoms

When upgrading WebCenter Portal from 11g to 12c using the upgradeWebCenterPortal script,
the following error occurs in the UpgradeSummary.log file.


ERROR

Upgrade of N Portals/Portal Templates failed.

 

Where "N" is a number of portals that failed the upgrade.


The UpgradeDetails.log shows the following error for each portal that failed upgrade:

-------------------------------------------------------
Scope: Name=Portal1, GUID=s5e492f46_f12c_4c7b_a09f_84a1629a262c
-------------------------------------------------------
Status: Scope upgrade failed.
oracle.stellent.ridc.protocol.ServiceException: Unable to retrieve search results. Error occurred while processing. Unable to return results.
    at oracle.stellent.ridc.protocol.ServiceResponse.getResponseAsBinder(ServiceResponse.java:146)
    at oracle.stellent.ridc.protocol.ServiceResponse.getResponseAsBinder(ServiceResponse.java:112)
    at oracle.webcenter.doclib.core.WCPServiceResponse.getResponseAsBinder(WCPServiceResponse.java:87)
    at oracle.webcenter.doclib.upgrade.PortalWikiDocumentsUpgradeUtils.findWikiByQueryText(PortalWikiDocumentsUpgradeUtils.java:122)
    at oracle.webcenter.doclib.upgrade.PortalWikiDocumentsUpgradeUtils.hasWikiDocument(PortalWikiDocumentsUpgradeUtils.java:81)
    at oracle.webcenter.page.upgrade.NavigationPageUpgradeHandler.upgrade(NavigationPageUpgradeHandler.java:350)
    at oracle.webcenter.upgrade.framework.UpgradeManager.handleUpgrade(UpgradeManager.java:789)
    at oracle.webcenter.upgrade.framework.UpgradeManager._doUpgrade(UpgradeManager.java:403)
    at oracle.webcenter.upgrade.framework.UpgradeManager.doUpgradeInternal(UpgradeManager.java:327)
    at oracle.webcenter.upgrade.framework.UpgradeManager.access$000(UpgradeManager.java:91)
    at oracle.webcenter.upgrade.framework.UpgradeManager$1.run(UpgradeManager.java:184)
...

 

The WC_Spaces-diagnostic.log shows the following error:

[2017-07-11T11:38:49.763+08:00] [WC_Spaces] [ERROR] [WCS-73003] [oracle.webcenter.upgrade.framework.UpgradeManager] [tid: [ACTIVE].ExecuteThread: '12' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <id>] [ecid: <ecid>] [APP: webcenter] [partition-name: DOMAIN] [tenant-name: GLOBAL] Upgrade failed for portal Scope[name=Portal1, guid=<guid>].[[
oracle.webcenter.upgrade.framework.exception.UpgradeException: Upgrade phase failed for NAVIGATION:/oracle/webcenter/siteresources/scopedMD/s5e492f46_f12c_4c7b_a09f_94a1629a262b/navigation/gsrdb3430b9_9f4e_4d53_b046_59d3467145d0/portal-default-navigation.xml in scope Scope[name=admindirect, guid=<guid>].
    at oracle.webcenter.upgrade.internal.framework.DefaultUpgradeHandlerContext.reportUpgradePhaseFailure(DefaultUpgradeHandlerContext.java:224)
    at oracle.webcenter.page.upgrade.NavigationPageUpgradeHandler.upgrade(NavigationPageUpgradeHandler.java:369)
    at oracle.webcenter.upgrade.framework.UpgradeManager.handleUpgrade(UpgradeManager.java:789)
    at oracle.webcenter.upgrade.framework.UpgradeManager._doUpgrade(UpgradeManager.java:403)
    at oracle.webcenter.upgrade.framework.UpgradeManager.doUpgradeInternal(UpgradeManager.java:327)
    at oracle.webcenter.upgrade.framework.UpgradeManager.access$000(UpgradeManager.java:91)
...
Caused by: oracle.stellent.ridc.protocol.ServiceException: Unable to retrieve search results. Error occurred while processing. Unable to return results.
    at oracle.stellent.ridc.protocol.ServiceResponse.getResponseAsBinder(ServiceResponse.java:146)
    at oracle.stellent.ridc.protocol.ServiceResponse.getResponseAsBinder(ServiceResponse.java:112)
    at oracle.webcenter.doclib.core.WCPServiceResponse.getResponseAsBinder(WCPServiceResponse.java:87)
    at oracle.webcenter.doclib.upgrade.PortalWikiDocumentsUpgradeUtils.findWikiByQueryText(PortalWikiDocumentsUpgradeUtils.java:122)
    at oracle.webcenter.doclib.upgrade.PortalWikiDocumentsUpgradeUtils.hasWikiDocument(PortalWikiDocumentsUpgradeUtils.java:81)
    at oracle.webcenter.page.upgrade.NavigationPageUpgradeHandler.upgrade(NavigationPageUpgradeHandler.java:350)
    ... 83 more

 

And the UCM_Server1-diagnostic.log shows the following error:

[2017-07-11T11:38:49.607+08:00] [UCM_Server1] [ERROR] [UCM-CS-000009] [oracle.ucm.idccs] [tid: [ACTIVE].ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'] [ecid:<ecid>] [APP: Oracle Universal Content Management - Content Server] [partition-name: DOMAIN] [tenant-name: GLOBAL] data exception[[
intradoc.data.DataException: !csDbUnableToCreateResultSet,SELECT Revisions.dID\, dDocTitle\, dDocType\, dRevisionID\, dSecurityGroup\, dDocAuthor\, dDocAccount\, dRevLabel\, dFormat\, dOriginalName\, dExtension\, dWebExtension\, dInDate\, dOutDate\, dCreateDate\, dPublishType\, dRendition1\, dRendition2\, dFileSize AS VaultFileSize\, DocMeta.*\, RevClasses.*
FROM Revisions\, DocMeta\, Documents\, RevClasses
WHERE Revisions.dID=DocMeta.dID And Revisions.dID=Documents.dID And Revisions.dDocName = RevClasses.dDocName And dIsPrimary = 1 And dReleaseState IN ('Y'\, 'U'\, 'I') AND ((((((((( CONTAINS(dDocType\, 'Application')> 0 ) AND ( CONTAINS(dDocFunction\, 'wiki')> 0 ) AND ( CONTAINS(dDocAccount\, 'PUBLIC/s5e492f46f12c4c7ba09f94a1629a262b')> 0 ))))))))) ORDER BY dInDate Desc!$ORA-20000: Oracle Text error:
DRG-10599: column is not indexed

   at intradoc.jdbc.JdbcWorkspace.handleSQLException(JdbcWorkspace.java:2729)
   at intradoc.jdbc.JdbcWorkspace.createResultSetSQL(JdbcWorkspace.java:927)
   at intradoc.jdbc.JdbcWorkspace.createResultSetSQL(JdbcWorkspace.java:866)
   at intradoc.search.DatabaseSearchImplementor.doQuery(DatabaseSearchImplementor.java:84)
   at intradoc.search.CommonSearchConnection.doQuery(CommonSearchConnection.java:158)
   at intradoc.server.SearchManager.retrieveSearchInfoAsBinder(SearchManager.java:233)
   at intradoc.server.SearchService.retrieveSearchInfo(SearchService.java:2004)
   ...

Caused by: java.sql.SQLException: ORA-20000: Oracle Text error:
DRG-10599: column is not indexed

   at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)
   at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)
   at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1113)
   at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546)
...

and: intradoc.common.ServiceException: !csJdbcGenericErrorWithCode,ORA-20000
   at intradoc.jdbc.JdbcWorkspace.handleSQLException(JdbcWorkspace.java:2738)
   ... 36 more

]]
[2017-07-11T11:38:49.724+08:00] [UCM_Server1] [ERROR] [UCM-CS-060003] [oracle.ucm.idccs] [tid: [ACTIVE].ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'] [ecid: <ecid>] [APP: Oracle Universal Content Management - Content Server] [partition-name: DOMAIN] [tenant-name: GLOBAL] Event generated by user 'weblogic' at host 'CIS'.
[2017-07-11T11:38:49.725+08:00] [UCM_Server1] [ERROR] [UCM-CS-000008] [oracle.ucm.idccs] [tid: [ACTIVE].ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'] [ecid: <ecid>] [APP: Oracle Universal Content Management - Content Server] [partition-name: DOMAIN] [tenant-name: GLOBAL] service exception[[
intradoc.common.ServiceException: !csSearchUnableToReturnResults
*ScriptStack GET_SEARCH_RESULTS
3:getSearchResults,**no captured values**
   at intradoc.server.SearchManager.retrieveSearchInfoAsBinder(SearchManager.java:306)
   at intradoc.server.SearchService.retrieveSearchInfo(SearchService.java:2004)
   at intradoc.server.SearchService.doLocalSearch(SearchService.java:1472)
   at intradoc.server.SearchService.getSearchResults(SearchService.java:706)
...

 

 

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