Upgrade from 16.2.2 to 16.2.3 fails with error on POSTUPGRADE_CIT_GLOBAL_UPDATE_COST_TOTALS_RIGHT.xml

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

On a vanilla system with multiple subobject - investment extensions, attempt upgrading to 16.2.3. The upgrade fails with error on POSTUPGRADE_CIT_GLOBAL_UPDATE_COST_TOTALS_RIGHT.xml

STEPS TO REPRODUCE:

1. In Clarity 16.2.2 create multiple Investment Extension sub objects
2. Start the upgrade to 16.2.3

Expected Results: The upgrade to complete successfully

Actual Results: Upgrade fails with error:

• 8/27/24 9:57 AM (ExecTask) Process - post-upgrade: POSTUPGRADE_CIT_GLOBAL_UPDATE_COST_TOTALS_RIGHT.xml
• 8/27/24 9:57 AM (ExecTask) java.sql.BatchUpdateException: error occurred during batching: ORA-20001: P_OBJECT_CODE "odf_cst_program11" P_PERMISSION_CODE "permUpdateCITCostTotals" P_OBJECT_TYPE "RECORD" P_COMPONENT_CODE "INV" COMBINATION IS INVALID
• 8/27/24 9:57 AM (ExecTask) ORA-06512: at "NIKU.CMN_SEC_ASSGND_OBJ_PERM_INS_SP", line 175
• 8/27/24 9:57 AM (ExecTask) ORA-06512: at line 75
• 8/27/24 9:57 AM (ExecTask) ORA-06512: at line 75

Environment

Clarity 16.2.3

Cause

Data issue due to manual edit in odf_objects

Resolution

1. Run query: 
   select * from odf_objects where code <> lower(right_code) and template_extension = 'inv_extension';
2. If the resulting object has been manually changed the code in the database, it has to be changed back, after this the upgrade script will complete