My Oracle Support Banner

Unique Constraint Error in Schema Update During Upgrade From To (Doc ID 2629370.1)

Last updated on JUNE 20, 2023

Applies to:

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


While following the steps to upgrade WebCenter Sites from version to, 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.

The error related to the "failure" noted above is as follows:

at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.callRunSqlStatement(
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.executeSql(
... 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(
... 34 more




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

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