DataDiff: Unique Constraint on {attribute_type}_SUBTYPES Table (Doc ID 2816149.1)

Last updated on OCTOBER 24, 2021

Applies to:

Symptoms

DataDiff Failing With Unique Constraint on {attribute_type}_SUBTYPES Table

When running DataDiff, the schema upgrade fails with the following ERROR:

[RCU] [ERROR] [] [upgrade.RCU.jdbcEngine] SQLException: ORA-00001: unique constraint ({12C_WCSITES}.IXXXXXXXXXXXXX) violated[[

[RCU] [ERROR] [] [upgrade.RCU.jdbcEngine] [[
java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint ({12C_WCSITES}.IXXXXXXXXXXXXX) 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.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3719)
at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1427)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3831)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1082)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.runSqlStatement(JDBCEngine.java:1277)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.callRunSqlStatement(JDBCEngine.java:936)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.executeSql(JDBCEngine.java:955)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.executeSql(JDBCEngine.java:930)
at oracle.sysman.assistants.common.dbutil.jdbc.OracleDMLStatement.execute(ANSISQLStatementType.java:792)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.executeNextSQLStatement(JDBCEngine.java:1790)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.parseNexecuteScript(JDBCEngine.java:1693)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.parseNexecuteScript(JDBCEngine.java:1603)
at oracle.ias.update.plugin.UpgradeJDBCEngine.execute(UpgradeJDBCEngine.java:192)
at oracle.ias.update.plugin.UpgradePlugin.executeJDBCEngineScript(UpgradePlugin.java:1902)
at oracle.ias.update.plugin.UpgradePlugin.executeJDBCEngineScriptAsDBA(UpgradePlugin.java:1715)
at com.oracle.sites.upgrade.plugin.SitesPluginSchema.execute11GScripts(SitesPluginSchema.java:1376)
at com.oracle.sites.upgrade.plugin.SitesPluginSchema.upgrade(SitesPluginSchema.java:536)
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 = INSERT INTO {12C_WCSITES}.{attribute_type}_SUBTYPES SELECT * FROM "{11G_SOURCE}".{attribute_type}_SUBTYPES source WHERE NOT EXISTS (SELECT * FROM {12C_WCSITES}.{attribute_type}_SUBTYPES dest WHERE source.ID = dest.ID ), OriginalSql = INSERT INTO {12C_WCSITES}.{attribute_type}_SUBTYPES SELECT * FROM "{11G_SOURCE}".{attribute_type}_SUBTYPES source WHERE NOT EXISTS (SELECT * FROM {12C_WCSITES}.{attribute_type}_SUBTYPES dest WHERE source.ID = dest.ID ), Error Msg = ORA-00001: unique constraint ({12C_WCSITES}.IXXXXXXXXXXXXX) 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.