Publishing A Template Failed With Unique Constraint Error

(Doc ID 1505906.1)

Last updated on JANUARY 05, 2016

Applies to:

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


Publishing of a template failed with this error on the Target environment on save to the Template table:

[2012-10-22 14:13:35,046] [logging.cs.xcelerate.publish] >> Attempting to save asset Template:1300144041955
[2012-10-22 14:13:35,056] [fatwire.logging.cs.db] Exception executing prepared statement: INSERT INTO Template (ID,NAME,CATEGORY,ROOTELEMENT,TTYPE,STATUS,CREATEDBY,CREATEDDATE,UPDATEDBY,UPDATEDDATE,DESCRIPTION,SUBTYPE,FW_UID) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?)

ID = 1300144041955
NAME = SomeTemplateName
CATEGORY = SomeCategory
ROOTELEMENT = SomeSubTypeName/SomeTemplateName
CREATEDBY = fwadmin
CREATEDDATE = 2012-06-21 22:10:12.0
UPDATEDBY = fwadmin
UPDATEDDATE = 2012-10-22 14:13:14.0
DESCRIPTION = SomeTemplateName
SUBTYPE = SomeSubTypeName
FW_UID = 066d198a-5d4d-4bc2-98cb-7d86be1c3145
java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (FATWIRE.I1306870538620) violated


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