Clarity upgrade fails with ORA-30556

Products

• Clarity PPM On Premise

Issue/Introduction

While upgrading from 15.9.2 and Oracle 19c Database to 16.0.2 in two steps:

1. 15.9.2 to 16.0.1
2. 16.0.1 to 16.0.2
   
   

We launched 16.0.1 install and it has failed with this error message while installing the schema: 

Process - table: INV_INVESTMENTS.xml
com.ca.clarity.jdbc.oraclebase.ddc: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-30556: either functional or bitmap join index is defined on the column to be modified

Environment

Clarity 16.0.1

Resolution

The root of the problem stems from the ORA-30556  situation, and is indicating a customisation that is on the Database tables. As per oracle forums, there may be CIAI Columns and Indexes Implemented in the Database and which is getting caught on the clarity schema validation phase. 

There were custom indexes found against INV_INVESTMENT starting I_*

example:

INDEX_NAME

I_EFM26

I_EFM42

I_EFM43

I_EFM45

I_EFM5

Drop custom indexes and restart the 16.0.1 upgrade.