Upgrade failure during PMO Upgrade

Products

• Clarity PPM SaaS
• Clarity FedRAMP
• Clarity PPM On Premise

Issue/Introduction

As part of upgrade to 16.3.3 to 16.4.0 the upgrade failed with below error during csk upgrade

12/4/25, 11:15 PM (admin) 23:15:39.620 [main] ERROR com.niku.union.persistence.PersistenceController - Error happened with error code:42P01
12/4/25, 11:15 PM (admin) 23:15:39.627 [main] ERROR com.niku.union.persistence.PersistenceController - Error happened with error code:42P01
12/4/25, 11:15 PM (admin) Error Applying XOG: Failure occurred while applying queries/cop_programScheduleDashboard.xml
12/4/25, 11:15 PM (admin)  Check /opt/ppm/logs/content/xog/csk/queries/cop_programScheduleDashboard_out.xml for errors
12/4/25, 11:15 PM (admin) Failed to install content pack. ID: csk

 

Environment

Clarity All Supported Version 

Cause

• Review the cop_programScheduleDashboard_out.xml and below errors were seen

  XOG-3052: Query record has not been inserted com.niku.union.persistence.nsql.NSQLSyntaxException: NSQL Syntax exception: NSQL_SYNTAX_ERROR_DB_ERROR, Info: ERROR: relation "odf_cop_prj_statusrpt_v2" does not exist
    Position: 1393

Resolution

• Stop all the services 
• Login to Clarity and Navigate to Object and search for status report object
• Create an attribute of any data type and save it
• Check in database and  the view odf_cop_prj_statusrpt_v2 should be compiled
• Drop the attribute created and run the upgrade again by executing the below command 
  • admin content csk