Upgrade of Clarity PPM Fails with "Build Failed "- Error during execution of trigger 'NIKU.T_CMN_FEATURE_CCMN_FEATURES'

book

Article ID: 141410

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

 Receive "BUILD FAILED" Message when attempting to upgrade:

12/06/19 3:09 PM (Echo) check.result = ERROR

12/06/19 3:09 PM (Target) Target "_output-log-info" started.

12/06/19 3:09 PM (UnknownElement) Task "check.java" finished with error.

D:\Install\15.7\checkinstall\scripts\imports\check-utils.xml:255: unbalanced quotes in check-logs/postcheck-results.xml check-upgrade-exception.xml ERROR UPGRADE FAILED WITH THE FOLLOWING EXCEPTION: ${exception.msg} The following error occurred while executing this line:

D:\Install\15.7\install.xml:528: The following error occurred while executing this line:

D:\Install\15.7\install.xml:927: The upgrade step for 15.5.1 failed. Please consult the

 D:\Install\15.7\install-packages\15.5.1\upgrade-repack.15.5.1.240tpexcludes/install.log for that release package.". Please check install.log for more details.

In the install.log, the following error is generated:

12/06/19 3:06 PM (ExecTask) Caused by: com.ca.clarity.jdbc.oraclebase.ddc: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00001: unique constraint (NIKU.ODF_AUD_OBJ_INST_CONTEXT_PK) violated
12/06/19 3:06 PM (ExecTask) ORA-06512: at "NIKU.T_CMN_FEATURE_CCMN_FEATURES", line 29
12/06/19 3:06 PM (ExecTask) ORA-04088: error during execution of trigger 'NIKU.T_CMN_FEATURE_CCMN_FEATURES'
12/06/19 3:06 PM (ExecTask) ORA-06512: at "NIKU.CMN_FEATURE_INS_SP", line 37
12/06/19 3:06 PM (ExecTask) ORA-01403: no data found
12/06/19 3:06 PM (ExecTask) ORA-06512: at "NIKU.CMN_FEATURE_INS_SP", line 12
12/06/19 3:06 PM (ExecTask) ORA-06512: at line 11

Cause

This issue can happen if auditing is enabled during the upgrade. It's recommended to disable auditing for the upgrade. 

Environment

Release : All Supported Releases

Component : CA PPM INTEGRATIONS & INSTALLATIONS

Resolution

1. Ensure you have disabled auditing as per our recommendations

See the following KB for steps on how to do this:

  • KB: 102304 - How to proceed if you have auditing enabled in order to upgrade CA PPM (how to disable auditing)
    This will address a big majority of the issues with auditing

2.If and ONLY IF the trigger failing is on object that's not visible in UI such as above (CMN_FEATURE):

  • Connect to the database
  • Backup the trigger
  • Manually disable and drop the trigger
  • Then run the upgrade again
  • After the upgrade is successful, re-add the trigger to the database schema
    • To restore it post upgrade, recreate the trigger from the backup which would be done by the DBA.

Note : this workaround 2 is only applicable to triggers on CMN_FEATURE. All other audits must be removed manually from Clarity UI