Upgrade Assistant: Schema Upgrade failing from 11.1.1.8.0 Delivery Install to Sites 12.2.1: java.sql.SQLException: ORA-01407: cannot update ("WCS12C_WCSITES"."TREETABS"."ID") to NULL (Doc ID 2294259.1)

Last updated on AUGUST 09, 2017

Applies to:

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

Symptoms

Upgrade Assistant: Schema Upgrade failing from 11.1.1.8.0 Delivery Install to Sites 12.2.1:

The following error is seen in the ua.log:
oracle.sysman.assistants.common.dbutil.SQLFatalErrorException: java.sql.SQLException: ORA-01407: cannot update ("WCS12C_WCSITES"."TREETABS"."ID") to NULL


The ua.out log shows the following:

Error encountered executing SQL statement FileName: '{MW_HOME}/oracle_common/upgrade/logs/wcsites_upgrade/schema2017-08-03-14-27-08/11.1.1.8.0/oracle/ddl/migrate_sites_tables.sql' LineNumber: '708'
SQL Statement: [UPDATE WCS12C_WCSITES.TREETABS dest SET ID = (SELECT ID FROM "CSUSER".TREETABS WHERE title = 'Site Plan') where dest.title = 'Site Navigation']

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