Upgrade Failed Due To Unique Constraint (Doc ID 1616343.1)

Last updated on APRIL 29, 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 Sites 11.1.1.6 to 11.1.1.8 failing.

In install_log.log see:

[2014-01-18 10:50:28.643][CS.INSTALL][ERROR] ActionHandlerExecuteCommand:  ExecuteCommand failed for http://172.28.16.71:9003/servlet/Install?COMMANDNAME=IMPORTCATALOG&USERNAME=ContentServer&PASSWORD=<hidden password value>&CATALOGDIRECTORY=%2Fu01%2Fapp%2Fsoftware%2Fwcs%2FWebCenterSites_11.1.1.8.0%2FWCS_Sites%2FSites%2Fwem%2FXcelerate%2FWEM&ELEMENTDIRECTORY=%2Fshared_files%2Felements
The response that was received =
HTTP/1.1 200 OK
HOST_SERVICE: FutureTenseContentServer:11.1.1.8.0
Transfer-Encoding: chunked
Date: Sat, 18 Jan 2014 15:50:26 GMT
Set-Cookie: JSESSIONID=BflbShvCL39lqhJqR8STG3hB0vmLrT5vHGpJpBvQDRbfV2HvptTw!-1077587289!NONE; path=/servlet; HttpOnly
Content-Type: text/html; charset=UTF-8
X-Powered-By: Servlet/2.5 JSP/2.1


<!--FTCS|||result=success|||reason=|||err=12|||command=mirrorgetconfig|||params=columnslowercase=true&CSVersion=11.1.1.8.0&databasetype=Oracle10&mirrorprotocolversion=3|||-->
<!--FTCS|||result=failure|||reason= Error importing the file /u01/app/software/wcs/WebCenterSites_11.1.1.8.0/WCS_Sites/Sites/wem/Xcelerate/WEM/AssetType.html|||err=-300|||command=ImportCatalog|||params=|||-->
[2014-01-18 10:50:28.661][CS.INSTALL][ERROR] ActionHandlerExecuteCommand:  Error Importing /u01/app/software/wcs/WebCenterSites_11.1.1.8.0/WCS_Sites/Sites/wem/Xcelerate/WEM
[2014-01-18 10:50:28.815][CS.INSTALL][ERROR] Worker.run.
Install failed.
Please check log file.

In sites.log see:

[2014-01-18 10:50:28,518 EST] [ERROR] [.kernel.Default (self-tuning)'] [fatwire.logging.cs.db] SQLException executing query: insert into AssetType (
id,assettype,plural,logic,description,usesearchindex,indexfile,urldescriptor,canbechild,usedimension,fw_uid) select id,assettype,plural,logic,descri
ption,usesearchindex,indexfile,urldescriptor,canbechild,usedimension,fw_uid from tt1390060088094
java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (SITES2DEL.SYS_C0037582) violated

      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)


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