My Oracle Support Banner

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 NOVEMBER 04, 2022

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']

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.