Upgrade Assistant fails with SQLException: ORA-00001: unique constraint (WCSD_WCSITES.I_TREETABS_ROLES_1) violated

(Doc ID 2344047.1)

Last updated on JANUARY 02, 2018

Applies to:

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

Symptoms

Upgrade Assistant fails with SQLException: ORA-00001: unique constraint (WCSD_WCSITES.I_TREETABS_ROLES_1) violated

While doing the schema upgrade , it failed at 80% with below error:

 

Changes

 

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