WebCenter Sites 11g to 12c Schema Upgrade Failed with INSERT INTO ATTRTYPES and SEGMENTS Tables
Last updated on FEBRUARY 26, 2018
Applies to:Oracle WebCenter Sites - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
Upgrade from 220.127.116.11.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.
The error noticed in logs is:
ORA-12899: value too large for column "SCHEMA_NAME"."ATTRTYPES"."STATUS" (actual: 11, maximum: 2)
The 11g environment was an upgraded environment from WebCenter Sites 7.6.x.
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