Unique Constraint Error in Schema Update During Upgrade From 12.2.1.0.0 To 12.2.1.4.0
(Doc ID 2629370.1)
Last updated on JUNE 20, 2023
Applies to:
Oracle WebCenter Sites - Version 12.2.1.0.0 and laterInformation in this document applies to any platform.
Symptoms
While following the steps to upgrade WebCenter Sites from version 12.2.1.0.0 to 12.2.1.4.0, the following message is provided while running the Upgrade Assistant to upgrade the Sites schema:
[2019-12-05T12:54:47.991-06:00] [Framework] [NOTIFICATION] [upgrade.Framework] Progress bar updated 9 times, status text 1 times, for plugin MDS.SCHEMA_UPGRADE executing phase upgrade
[2019-12-05T12:54:47.991-06:00] [Framework] [NOTIFICATION] [upgrade.Framework] Finished upgrading components.
[2019-12-05T12:54:47.991-06:00] [Framework] [NOTIFICATION] [upgrade.Framework] 3 components upgraded with success.
[2019-12-05T12:54:47.991-06:00] [Framework] [NOTIFICATION] [upgrade.Framework] 1 components upgraded with failure.
[2019-12-05T12:54:47.991-06:00] [Framework] [NOTIFICATION] [upgrade.Framework] 2 components upgrade not necessary.
[2019-12-05T12:54:47.991-06:00] [Framework] [NOTIFICATION] [upgrade.Framework] 0 components skipped.
[2019-12-05T12:54:47.991-06:00] [Framework] [NOTIFICATION] [upgrade.Framework] 0 components upgrade that are duplicate.
[2019-12-05T12:54:47.991-06:00] [Framework] [NOTIFICATION] [upgrade.Framework] Finished upgrading components.
[2019-12-05T12:54:47.991-06:00] [Framework] [NOTIFICATION] [upgrade.Framework] 3 components upgraded with success.
[2019-12-05T12:54:47.991-06:00] [Framework] [NOTIFICATION] [upgrade.Framework] 1 components upgraded with failure.
[2019-12-05T12:54:47.991-06:00] [Framework] [NOTIFICATION] [upgrade.Framework] 2 components upgrade not necessary.
[2019-12-05T12:54:47.991-06:00] [Framework] [NOTIFICATION] [upgrade.Framework] 0 components skipped.
[2019-12-05T12:54:47.991-06:00] [Framework] [NOTIFICATION] [upgrade.Framework] 0 components upgrade that are duplicate.
The error related to the "failure" noted above is as follows:
....
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.callRunSqlStatement(JDBCEngine.java:936)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.executeSql(JDBCEngine.java:955)
... 18 more
Caused by: Error : 1, Position : 0, Sql = INSERT INTO AssetPublication (id, pubid, assettype, assetid) VALUES (u'<id1>', 0, u'WCS_AggregationTemplates', <id2>)
, OriginalSql = INSERT INTO AssetPublication (id, pubid, assettype, assetid) VALUES (N'<id1>', 0, N'WCS_AggregationTemplates', <id2>)
, Error Msg = ORA-00001: unique constraint (TST_WCSITES.I_1806990940_ASSET) violated
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:514)
... 34 more
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.callRunSqlStatement(JDBCEngine.java:936)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.executeSql(JDBCEngine.java:955)
... 18 more
Caused by: Error : 1, Position : 0, Sql = INSERT INTO AssetPublication (id, pubid, assettype, assetid) VALUES (u'<id1>', 0, u'WCS_AggregationTemplates', <id2>)
, OriginalSql = INSERT INTO AssetPublication (id, pubid, assettype, assetid) VALUES (N'<id1>', 0, N'WCS_AggregationTemplates', <id2>)
, Error Msg = ORA-00001: unique constraint (TST_WCSITES.I_1806990940_ASSET) violated
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:514)
... 34 more
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |