Errors Logged while Deleting Site

(Doc ID 1996375.1)

Last updated on JULY 07, 2017

Applies to:

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

Symptoms

When trying to delete a site, there are errors in the sites.log. For example:

[2015-04-02 01:18:09,599 UTC] [ERROR] [.kernel.Default (self-tuning)'] [fatwire.logging.cs.db] Exception executing prepared statement: INSERT INTO TreeTabs_Sect (ID,NAME,OWNERID,POPULATEURL,ORDINAL) VALUES (?,?,?,?,?)
ID = 1420609626365
NAME = MobilityDevice
OWNERID = 1420609618168
POPULATEURL = OpenMarket/Xcelerate/AssetType/Device/MobilityTab
ORDINAL = 1
java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CSUSER.I1420609617974) violated

    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
    at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1044)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3593)
    at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3674)
    at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1354)
    at weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:172)
    at COM.FutureTense.Servlet.JDBCTable.executeUpdate_trans_logic(JDBCTable.java:1412)
    at COM.FutureTense.Servlet.JDBCTable.executeUpdate_trans(JDBCTable.java:1367)
    at COM.FutureTense.Servlet.JDBCTable.executeUpdate(JDBCTable.java:1234)
    at COM.FutureTense.Servlet.JDBCTable.AddRow(JDBCTable.java:966)
    at COM.FutureTense.Common.ftDBTable.insertRow(ftDBTable.java:1281)
    at COM.FutureTense.CatalogManager.CatalogEngine.addToTable_trans(CatalogEngine.java:823)
    at COM.FutureTense.CatalogManager.CatalogEngine.addToTable(CatalogEngine.java:708)
    at COM.FutureTense.Common.CatalogManager.execute(CatalogManager.java:771)
    at COM.FutureTense.Common.ContentServer.runManager(ContentServer.java:3463)
    at COM.FutureTense.Common.CS.CatalogManager(CS.java:1503)
    at COM.FutureTense.Common.CS.CatalogManager(CS.java:1457)
    at com.openmarket.basic.common.BaseTable.callCatalogManager(BaseTable.java:97)
    at com.openmarket.xcelerate.treetab.SectionsManager.setSections(SectionsManager.java:179)
    at com.openmarket.xcelerate.treetab.TreeTabManager.save(TreeTabManager.java:407)
    at com.openmarket.xcelerate.treetab.TreeTabNotifySiteDelete.notify(TreeTabNotifySiteDelete.java:71)
    at com.openmarket.xcelerate.common.EventManager.triggerEvent(EventManager.java:122)
    at com.openmarket.xcelerate.site.Publication.Delete(Publication.java:576)
    at com.fatwire.assetapi.site.SiteManagerImpl.delete(SiteManagerImpl.java:682)
    at com.fatwire.rest.service.impl.LocalWemSiteService.deleteSite(LocalWemSiteService.java:314)
    at com.fatwire.rest.resources.WemSiteResource.deleteSite(WemSiteResource.java:112)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

...

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