Publishing fails with error -611 on source, and a unique constraint exception on target (Doc ID 1490399.1)

Last updated on OCTOBER 07, 2021

Applies to:

Symptoms

Publish fails with -611 error on source. On target, an error is logged in futuretense.txt:

[2012-09-10 12:43:25,126] [fatwire.logging.cs.db] SQLException executing query: insert into CSElement (id,name,rootelement,category,status,createdby,createddate,updatedby,updateddate,description,startdate,enddate,subtype,filename,path,template,urlexternaldoc,externaldoctype,urlexternaldocxml,fw_uid) select id,name,rootelement,category,status,createdby,createddate,updatedby,updateddate,description,startdate,enddate,subtype,filename,path,template,urlexternaldoc,externaldoctype,urlexternaldocxml,fw_uid from tt1344242861656
java.sql.SQLException: ORA-00001: unique constraint (STGCSAUTH.SYS_C0032092) violated

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1160)
at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4035)
at oracle.jdbc.driver.OracleStatement.doScrollStmtExecuteQuery(OracleStatement.java:4187)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1683)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1645)
at org.jboss.resource.adapter.jdbc.WrappedStatement.execute(WrappedStatement.java:91)
at COM.FutureTense.Servlet.B.A(y:1563)
at COM.FutureTense.Servlet.B$1.execute(y:1309)
at com.fatwire.cs.core.db.NestedTransactionBlock.execute(y:2027)
at COM.FutureTense.Servlet.B.A(y:1602)
at COM.FutureTense.Common.g.doSQL(y:1243)
at COM.FutureTense.Common.g.doSQL(y:2065)
at COM.FutureTense.CatalogManager.E.b(y:5502)
at COM.FutureTense.CatalogManager.E$1.execute(y:3761)
at com.fatwire.cs.core.db.NestedTransactionBlock.execute(y:2027)
at COM.FutureTense.CatalogManager.E.S(y:7041)
at COM.FutureTense.CatalogManager.E.c(y:192)
at COM.FutureTense.Common.R.execute(y:2573)
at COM.FutureTense.Servlet.FTServlet.execute(y:1088)
at COM.FutureTense.Servlet.FTServlet.doPost(y:3299)

Cause

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