My Oracle Support Banner

Upgrade Process For 11.1.1.8.0 To 12.2.1.3.0 The Upgrade Assistant Fails At 80% (Doc ID 2376140.1)

Last updated on OCTOBER 15, 2020

Applies to:

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

Symptoms

11g to 12c upgrade assistant fails at 80%. The RCU logs show a java.sql.SQLException: ORA-01427: single-row subquery returns more than one row

with query

UPDATE DEVUPGRADE_WCSITES.ASSETINDEXSOURCECONFIG dest SET ID = (SELECT ID
FROM "DEV_SITES".ASSETINDEXSOURCECONFIG source WHERE source.assettype =
dest.assettype AND source.name = dest.name ) WHERE dest.assettype IN (SELECT
assettype FROM "DEV_SITES".ASSETINDEXSOURCECONFIG) AND dest.name IN (SELECT
name FROM "DEV_SITES".ASSETINDEXSOURCECONFIG) AND dest.ID != (SELECT ID FROM
"DEV_SITES".ASSETINDEXSOURCECONFIG source WHERE source.assettype =
dest.assettype AND source.name = dest.name )



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
Cause
Solution
References


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