Upgrade failure during PMO Upgrade
search cancel

Upgrade failure during PMO Upgrade

book

Article ID: 421325

calendar_today

Updated On:

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