My Oracle Support Banner

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.


During upgrade to 7.6p2,, or, 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.
[2015-09-10 15:13:00,344 CEST] [ERROR] [.kernel.Default (self-tuning)'] [fatwire.logging.cs.install] ImportCatalog Importing file= /kits/WebCenterSites_11. fail due to error -611

and the upgrade fails. 


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.