Unable to install PMO Accelerator in v15.5

Document ID : KB000117538
Last Modified Date : 17/10/2018
Show Technical Document Details
Issue:
We have recently upgraded Clarity ppm from v14.4 to v15.5 successfully in our sandbox environment. But when installing PMO Accelerator (clarity/bin> admin content csk). It throws few error messages, please help to resolve it?

ERROR 09-10 05:39:40,226 - Problem creating object or updating custom object table for object fiscaltimeperiod
10/9/18 5:39 AM (admin) com.niku.union.persistence.PersistenceException: 
10/9/18 5:39 AM (admin) SQL error code: 2264
10/9/18 5:39 AM (admin) Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-02264: name already used by an existing constraint
10/9/18 5:39 AM (admin) Executed:
10/9/18 5:39 AM (admin) alter table ODF_CA_FISCALTIMEPERIOD add constraint ODF_CA_FISCALTIMEPERIOD_pk primary key ( id ) using index tablespace INDX_LARGE 

10/9/18 5:59 AM (admin) ERROR 09-10 05:59:11,110 - Database Error thrown 
10/9/18 5:59 AM (admin) com.niku.union.persistence.PersistenceException: 
10/9/18 5:59 AM (admin) SQL error code: 4098
10/9/18 5:59 AM (admin) Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-04098: trigger 'NIKU.NOK_SRM_ADD_CALENDAR_LINK' is invalid and failed re-validation
Resolution:
1. There was a table ODF_CA_FISCALTIMEPERIOD_ORIG which is not live table, it is a copy of the ODF_CA_FISCALTIMEPERIOD table.

Advised to drop constaint and index from the ODF_CA_FISCALTIMEPERIOD_ORIG Table. 

Used below command:
ALTER TABLE ODF_CA_FISCALTIMEPERIOD_ORIG

DROP index ODF_CA_FISCALTIMEPERIOD_PK  
DROP constraint ODF_CA_FISCALTIMEPERIOD_PK

2. Disabled custom trigger NOK_SRM_ADD_CALENDAR_LINK