PMO accelerator(csk) install failed with error ORA-00904: "ODF_PROJ"."RISK": invalid identifier during upgrade.

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

PMO accelerator(csk)  install failed with error ORA-00904: "ODF_PROJ"."RISK": invalid identifier during upgrade.
 
[exec] [exec] Applying queries/cop_projectKPIHierarchy.xml
[exec] [exec] Error Applying XOG: Failure occurred while applying queries/cop_projectKPIHierarchy.xml
[exec] [exec] Check /$clarity/logs/content/xog/csk/queries/cop_projectKPIHierarchy_out.xml for errors
[exec] [exec] Failed to install content pack. ID: csk: exec returned: 2
[exec] [exec] Failed to install content pack. ID: csk: exec returned: 2
[exec] [exec] Error occurred: $clarity/META-INF/content/xog/csk/install.xml:242: exec returned: 2
[exec] [exec] Check admin.log or use -verbose for more information.
[exec] [exec] Result: 1
 
In cop_projectKPIHierarchy_out.xml we saw errors:
 
        <Severity>FATAL</Severity>
        <Description>XOG-3052: Query record has not been inserted com.niku.union.persistence.nsql.NSQLSyntaxException: NSQL Syntax exception: NSQL_SYNTAX_ERROR_DB_ERROR, Info: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00904: "ODF_PROJ"."RISK": invalid identifier
 
 
When running this query on the Clarity database:

select risk from odf_project_v2

Error message:
ORA-00904: "ODF_PROJECT_V2"."RISK": invalid identifier
 

Environment

Release: CODFSS99000-15.5-PPM SAAS FedRAMP-Sandbox-Small Environment
Component:

Cause

The OOTB Project attribute Risk was manually deleted from customer's environment

Manually recreating it will not work in UI due to name constraints.

Resolution

1. Import the attached XOG to recreate the Risk attribute
2. Run the csk install again