DataDiff Upgrade Fails During Schema Upgrade: SQLException: ORA-00001: unique constraint ({PREFIX}_WCSITES.I_TREETABS_ROLES_1) violated (Doc ID 2779931.1)

Last updated on MARCH 29, 2023

Applies to:

Symptoms

DataDiff Upgrade Fails During Schema Upgrade: SQLException: ORA-00001: unique constraint ({PREFIX}_WCSITES.I_TREETABS_ROLES_1) violated

[RCU] [TRACE] [] [upgrade.RCU.jdbcEngine] Error to check : 1
[RCU] [TRACE] [] [upgrade.RCU.jdbcEngine] Error array to retry: 17410
[RCU] [ERROR] [] [upgrade.RCU.jdbcEngine] SQLException: ORA-00001: unique constraint ({PREFIX}_WCSITES.I_TREETABS_ROLES_1) violated[[


[RCU] [ERROR] [] [upgrade.RCU.jdbcEngine] [[
java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint ({PREFIX}_WCSITES.I_TREETABS_ROLES_1) violated

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:510)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:462)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1105)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:551)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:656)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:271)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:92)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:971)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1280)
...
...
...
at oracle.ias.update.plugin.UpgradePlugin.executeJDBCEngineScriptAsDBA(UpgradePlugin.java:1715)
at com.oracle.sites.upgrade.plugin.SitesPluginSchema.execute11GScripts(SitesPluginSchema.java:1367)
at com.oracle.sites.upgrade.plugin.SitesPluginSchema.upgrade(SitesPluginSchema.java:537)
at oracle.ias.update.plugin.Plugin.upgrade(Plugin.java:730)
at oracle.ias.update.plan.PlanStep.upgrade(PlanStep.java:736)
at oracle.ias.update.PhaseProcessor$UpgradeProcessor.runStepPhase(PhaseProcessor.java:775)
at oracle.ias.update.PhaseProcessor.runStep(PhaseProcessor.java:382)
at oracle.ias.update.PhaseProcessor$ExtendedRunnable.run(PhaseProcessor.java:1178)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: Error : 1, Position : 0, Sql = UPDATE {PREFIX}_WCSITES.TreeTabs_Roles set cs_rolename='GeneralAdmin' where cs_rolename='MobileSitesDeveloper', OriginalSql = UPDATE {PREFIX}_WCSITES.TreeTabs_Roles set cs_rolename='GeneralAdmin' where cs_rolename='MobileSitesDeveloper', Error Msg = ORA-00001: unique constraint ({PREFIX}_WCSITES.I_TREETABS_ROLES_1) violated

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:514)
... 34 more

Changes

Cause

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