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 MAY 31, 2017

Applies to:

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

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.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms