CSDT Import Fails with Unique Constraint Error While Importing Template (Doc ID 1507009.1)

Last updated on JUNE 29, 2017

Applies to:

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

Symptoms

ContentServer Developer Tools (CSDT) import fails with a unique constraint error while importing a Template that already exists:

012-10-23 17:07:07,575 ERROR [logging.cs.db] [http-8080-2] [COM.FutureTense.Servlet.JDBCTable] Exception executing prepared statement: INSERT INTO Template (ID,NAME,CATEGORY,ROOTELEMENT,TTYPE,STATUS,CREATEDBY,CREATEDDATE,UPDATEDBY,UPDATEDDATE,SUBTYPE,FW_UID) VALUES (?,?,?,?,?,?,?,?,?,?,?,?)
ID = 1230987654321
NAME = MyAssetLayout
CATEGORY = page
ROOTELEMENT = MyTemplates/MyAssetLayout
TTYPE = b
STATUS = PL
CREATEDBY = fwadmin
CREATEDDATE = 2012-11-10 17:16:15.143
UPDATEDBY = fwadmin
UPDATEDDATE = 2012-11-11 11:12:13.0
SUBTYPE = MyAssetDefinition
FW_UID = abcd123e-9f87-6543-abcd-987f65ed4c32

java.sql.SQLException: ORA-00001: unique constraint (CSDBUSER.I1230987654321) violated
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)

Similar errors can occur for other asset types/tables as well.

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