Out Of Place Upgrade From 11.1.1.8 To 12.2.1.2 Is Failing But Working In Other Environments (Doc ID 2270696.1)

Last updated on APRIL 03, 2023

Applies to:

Symptoms

Out of place upgrade from 11.1.1.8 to 12.2.1.2 is failing but working in other environments. While using the upgrade documentation: https://docs.oracle.com/middleware/12212/lcm/WCCUP/GUID-27F60AFC-E814-4DFF-B595-1A3598803B0B.htm#WCCUP-GUID-F7DA971F-D21F-4A73-AD4B-7D2F93E3CFBE a previous environment upgrade went well but we've noticed that the migrate_sites_tables.sql file that gets used to migrate the schema into a current environment about half the size.

As an example:
QA Environment's PUBLICATION table SQL:
INSERT INTO WCSMGMT_WCSITES.PUBLICATION( ID,NAME,DESCRIPTION,PUBROOT,CS_PREVIEW,CS_PREFIX,CS_PREVIEWASSET,CS_WRAPPERASSET) SELECT * FROM "FEI_WCSDEVMGMT".PUBLICATION source WHERE NOT EXISTS (SELECT * FROM WCSMGMT_WCSITES.PUBLICATION dest );

DEV Environment's PUBLICATION table SQL:
INSERT INTO WCSMGMT_WCSITES.PUBLICATION( ID,NAME,DESCRIPTION,PUBROOT,CS_PREVIEW,CS_PREFIX,CS_PREVIEWASSET,CS_WRAPPERASSET) SELECT * FROM "FEI_WCSDEVMGMT".PUBLICATION source WHERE NOT EXISTS (SELECT * FROM WCSMGMT_WCSITES.PUBLICATION dest WHERE source.ID = dest.ID );

the "WHERE source.ID = dest.ID" is making all of the difference and the upgrade source schema never gets copied over to the new destination schema.

Also, we're not seeing ANY errors at this stage.

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.