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 30, 2022
Applies to:
Oracle WebCenter Portal - Version 11.1.1.8.0 to 12.2.1.3.0Information 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:
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=<PORTAL_NAME>, GUID=<GUID>
-------------------------------------------------------
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:
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:
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
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 |