search cancel

Clarity : Clarity PPM Upgrade failing from 15.6 to 15.8

book

Article ID: 189898

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

Clarity Upgrade fails when upgrading from 15.6 to 15.8 after completing 15.7.1 upgrade.

Below is the error message :

01/01/90 2:53 PM (ExecTask) Process - table: CRV_SQL_CURVES.xml
01/01/90 2:53 PM (ExecTask) 
01/01/90 2:53 PM (ExecTask) SQL Text:
01/01/90 2:53 PM (ExecTask) 
01/01/90 2:53 PM (ExecTask) ALTER TABLE CRV_SQL_CURVES ADD NK_CURVE NK_CURVE NULL
01/01/90 2:53 PM (ExecTask) 
01/01/90 2:53 PM (ExecTask) com.ca.clarity.jdbc.oraclebase.ddc: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-38818: illegal reference to editioned object NIKU.NK_CURVE

Environment

Release : 15.6

Component : CA PPM INTEGRATIONS & INSTALLATIONS

Cause

This is caused because editioning has been enabled for the Clarity Schema.

Resolution

1. Ask DBA to take a backup of the schema.
2. Drop the Schema.
3. Create a new DB schema where editions feature is turned off.
4. Import the schema backup into new schema.

Additional Information

Run below query to test if editions feature is enabled for your clarity schema.

select EDITIONS_ENABLED from dba_users where username='<CLARITY SCHEMA NAME>';