ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 129542

calendar_today

Updated On:

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
 

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.

Environment

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

Resolution

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

Attachments

1579386309877__project_risk_attribute.xml get_app