My Oracle Support Banner

Unique constraint on Publication table whilst mirroring site configuration (Doc ID 1535637.1)

Last updated on MARCH 29, 2019

Applies to:

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


We are trying to mirror site configuration from one managed environment to other, and receive the following errors in the target environment logs

[2013-03-06 07:18:47,683 UTC] [ERROR] [.kernel.Default (self-tuning)'] [fatwire.logging.cs.db] SQLException executing query: insert into Publication (id,name,description,pubroot,cs_preview,cs_prefix,cs_previewasset,cs_wrapperasset) select id,name,description,pubroot,cs_preview,cs_prefix,cs_previewasset,cs_wrapperasset from tt1358821928449
java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (WCSMUSER.SYS_C0013665) violated


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.