Upgrade fails with unique constraint error importing Dimensions

(Doc ID 1554349.1)

Last updated on NOVEMBER 03, 2016

Applies to:

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

Goal

During upgrade to 7.6p2, 11.1.1.6.1, or 11.1.1.8.0, the following error occurs:

[2015-09-10 15:12:59,760 CEST] [ERROR] [.kernel.Default (self-tuning)'] [fatwire.logging.cs.db] SQLException executing query: insert into Dimension (id,status,createdby,createddate,updatedby,updateddate,name,description,startdate,enddate,subtype,filename,path,template,urlexternaldoc,externaldoctype,urlexternaldocxml,fw_uid) select id,status,createdby,createddate,updatedby,updateddate,name,description,startdate,enddate,subtype,filename,path,template,urlexternaldoc,externaldoctype,urlexternaldocxml,fw_uid from tt1441889109588

java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DEV_SITES.I1332262948953) violated
...
[2015-09-10 15:12:59,931 CEST] [ERROR] [.kernel.Default (self-tuning)'] [fatwire.logging.cs.install] ImportCatalogsendCommitToServer: Error commiting the table. Error number=-611
[2015-09-10 15:13:00,134 CEST] [ERROR] [.kernel.Default (self-tuning)'] [fatwire.logging.cs.install] ImportCatalog importCatalogFile: error importing the file. /kits/WebCenterSites_11.1.1.8.0/WCS_Sites/Sites/FirstSiteII/Core/Populate/Dimension.html
[2015-09-10 15:13:00,344 CEST] [ERROR] [.kernel.Default (self-tuning)'] [fatwire.logging.cs.install] ImportCatalog Importing file= /kits/WebCenterSites_11.1.1.8.0/WCS_Sites/Sites/FirstSiteII/Core/Populate/Dimension.html fail due to error -611

and the upgrade fails. 

Solution

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