Project creation errors with the following message. "System Error: please contact the administrator" on CA PPM user interface.

Products

• Clarity PPM On Premise

Issue/Introduction

Question:

We are unable to create Projects if we click on the "New" or "New from Template" buttons.

This error is generated in the app_ca.log file; 

"Caused by: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-04098: trigger 'niku.T_PROJECT_OODF_CA_PROJECT' is invalid 

 and failed re-validation"

What is the reason for this?

 

Answer:

The trigger 'T_PROJECT_OODF_CA_PROJECT' is created by the audit trail of the project object. 

In order to re-validate the trigger, you can remove all fields from the auditing section of the project object, save the changes and add back the fields again.

This will clear the error.

Environment

Release: ESPCLA99000-13.3-Clarity-Extended Support Plus
Component: