WebCenter Sites 11g to 12c Schema Upgrade Failed with INSERT INTO ATTRTYPES and SEGMENTS Tables (Doc ID 2272815.1)

Last updated on JULY 07, 2017

Applies to:

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

Symptoms

Upgrade from 11.1.1.8.0 Patch 12+ to 12c PatchSet 2 failed during the upgrade of schema:

a. Upgrade of schema failed with INSERT INTO ATTRTYPES table.

b. Upgrade of schema failed with INSERT INTO SEGMENTS table.

 

It's observed that:

a. In 11g ATTRTYPES table, the VALUETYPE column is the last column, while in 12g ATTRTYPES table the VALUETYPE column is the 3rd column. The order of the other columns remains the same.

b. In 11g SEGMENTS table, the NAME column is the 7th column, while in 12g SEGMENTS table, the NAME column is the 2nd column. The order of the other columns remains the same.

Changes

The 11g environment was an upgraded environment from WebCenter Sites 7.6.x.

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