WebCenter Sites 11g to 12c Schema Upgrade Failed with INSERT INTO ATTRTYPES and SEGMENTS Tables
(Doc ID 2272815.1)
Last updated on FEBRUARY 26, 2018
Applies to:Oracle WebCenter Sites - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
Upgrade from 126.96.36.199.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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!