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

Last updated on NOVEMBER 03, 2016

Applies to:

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

Symptoms

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

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