Upgrade From 7.6.1 to 11gR1 BP1 Failing (Doc ID 1575734.1)

Last updated on MAY 05, 2016

Applies to:

Oracle WebCenter Sites - Version 11.1.1.6.1 and later
Information in this document applies to any platform.

Symptoms

Upgrade from 7.6.1 to 11gR1 BP1 failing with these errors:

install_log.log:

[2013-08-10 17:45:11.151][CS.INSTALL][ERROR] ActionHandlerExecuteCommand:  ExecuteCommand failed for http://xxx.xxx.xxx.xxx:8380/cs/Install?ACTIONLISTNAME=CSInstallContentCenterSchema&USERNAME=ContentServer&PASSWORD=<hidden password value>&FILE=....WebCenterSites_11.1.1.6_bp1%2FWCS_Sites_11.1.1.6_bp1%2FSites%2Fcsui.xml
The response that was received =
HTTP/1.1 200 OK
HOST_SERVICE: FutureTenseContentServer:11.1.1.6.1
Date: Sat, 10 Aug 2013 21:45:11 GMT
Transfer-Encoding: chunked
Set-Cookie: JSESSIONID=2BE4C1C969C28B79AA065CE330138E50.node1; Path=/cs
Content-Type: text/html;charset=UTF-8
Server: Apache-Coyote/1.1

##SUCCESS## <BR> ##SUCCESS## <BR> ##SUCCESS## <BR> ##SUCCESS## <BR> ##SUCCESS## <BR> ##SUCCESS## <BR> ##SUCCESS## <BR> ##SUCCESS## <BR> ##SUCCESS## <BR> ##SUCCESS## <BR> ##SUCCESS## <BR> ##SUCCESS## <BR> ##SUCCESS## <BR> ##SUCCESS## <BR> ##ERROR##  errno -105 from saving asset type, Page. Upgrading the page asset type: Upgrading the page asset type failed with error -105: 01 errno -105 from saving asset type, Page.<BR> ##SUCCESS##  ##SUCCESS## <BR> ##SUCCESS## <BR> ##SUCCESS## <BR> ##SUCCESS## <BR> ##SUCCESS## <BR> ##SUCCESS## <BR> ##SUCCESS## <BR> ##SUCCESS## <BR> ##SUCCESS## <BR> ##SUCCESS## <BR> ##SUCCESS## <BR> ##SUCCESS## <BR> ##SUCCESS## <BR>
<!--FTCS|||result=success|||reason=Unknown Reason|||err=1|||command=Unknown Command|||params=UPGRADE=success&READURL=success&IF=success|||-->
[2013-08-10 17:45:11.233][CS.INSTALL][ERROR] ActionHandlerExecuteCommand:  Error Running the multiple task check the server log (futuretese.txt)
[2013-08-10 17:45:11.378][CS.INSTALL][ERROR] Worker.run.
Install failed.                
Please check log file.

futuretense.txt:

...snipped log messages...
[2013-08-10 17:44:57,873 EDT] [DEBUG] [http-xxx.xxx.xxx.xxx-4] [fatwire.logging.cs.db] SELECT tblname,defdir,systable,acl,metadata FROM SystemInfo WHERE tblname = ?
tblname = Page_DimP
[2013-08-10 17:44:57,896 EDT] [DEBUG] [http-xxx.xxx.xxx.xxx-8380-4] [fatwire.logging.cs.db] Column check required load of meta data for table SystemACL
[2013-08-10 17:44:57,897 EDT] [DEBUG] [http-xxx.xxx.xxx.xxx-8380-4] [fatwire.logging.cs.db] SELECT aclname,cataccess,description FROM SystemACL WHERE aclname = ?
aclname = Browser
[2013-08-10 17:44:57,900 EDT] [DEBUG] [http-xxx.xxx.xxx.xxx-8380-4] [fatwire.logging.cs.db]
<!--FTCS|||result=failure|||reason=No access allowed for requested action.|||err=-3|||command=renametable|||params=tablename=Page_DimP|||-->
...snipped log messages...
[2013-08-10 17:44:58,560 EDT] [DEBUG] [http-xxx.xxx.xxx.xxx-8380-4] [fatwire.logging.cs.db] SELECT tblname,defdir,systable,acl,metadata FROM SystemInfo WHERE tblname = ?
tblname = tempPage_DimP
[2013-08-10 17:44:58,571 EDT] [DEBUG] [http-xxx.xxx.xxx.xxx-8380-4] [fatwire.logging.cs.db]
<!--FTCS|||result=failure|||reason=Unable to locate catalog information tempPage_DimP|||err=-103|||command=renametable|||params=|||-->
...snipped log messages...
[2013-08-10 17:44:58,593 EDT] [ERROR] [http-xxx.xxx.xxx.xxx-8380-4] [fatwire.logging.cs.db] Exception executing prepared statement: INSERT INTO AssetType (ID,ASSETTYPE,PLURAL,LOGIC,DESCRIPTION,USESEARCHINDEX,CANBECHILD,FW_UID) VALUES (?,?,?,?,?,?,?,?)
ID = 1312487437371
ASSETTYPE = Page
PLURAL = Pages
LOGIC = com.openmarket.xcelerate.asset.Page
DESCRIPTION = Page
USESEARCHINDEX = 0
CANBECHILD = T
FW_UID = CSSystem-AssetType-PageFilter
java.sql.SQLException: ORA-00001: unique constraint (POC.SYS_C00154978) violated

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