An Existing Site Entry Have Problem During Publication "Deserializing And Saving"stage. (Doc ID 1681680.1)

Last updated on JANUARY 29, 2024

Applies to:

Symptoms

Realtime publish fails when publishing SiteEntry asset.

Error in realtime publish logs is the folowing:

[Unpacker] ERROR: Save failed with error -105 for SiteEntry: {id of asset}, SiteEntryManager:save failed to update SiteCatalog error: -105 com.openmarket.basic.interfaces.AssetException: SiteEntryManager:save failed to update SiteCatalog error: -105
  at com.openmarket.assetframework.complexasset.ComplexAsset.superSaveAllNoPubLock(y:2902)
  at com.openmarket.assetframework.complexasset.AssetManager.saveAllNoPubLock(y:2140)
  at com.openmarket.assetframework.complexasset.ComplexAsset.SaveAllNoPubLock(y:227)
  .
  .
  .


The following error is seen in the destination futuretense.txt log:

[CS.XCELERATE.PUBLISH][INFO] >> Attempting to save asset SiteEntry:{id of asset}
[CS.DB][ERROR] Exception executing prepared statement: INSERT INTO SiteCatalog (PAGENAME,ROOTELEMENT,CSSTATUS,PAGELETONLY,RESARGS1,RESARGS2,PAGECRITERIA,CSCACHEINFO,SSCACHEINFO) VALUES (?,?,?,?,?,?,?,?,?)
PAGENAME = {page name of SiteCatalog entry}
ROOTELEMENT = {full name of element}
CSSTATUS = live
PAGELETONLY = F
RESARGS1 = {custom args}&seid={id of SiteEntry}
RESARGS2 = rendermode=live&site={site prefix}
PAGECRITERIA = language,rendermode,seid,site,sitepfx,ft_ss
CSCACHEINFO = false
SSCACHEINFO = false
java.sql.SQLException: ORA-00001: unique constraint ({SCHEMANAME}.SYS_C006600) 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:745)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:966)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
at COM.FutureTense.Servlet.F.B(y:2745)
at COM.FutureTense.Servlet.F.A(y:2612)
at COM.FutureTense.Servlet.F$1.execute(y:640)
at com.fatwire.cs.core.db.NestedTransactionBlock.execute(y:2027)

Cause

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