ORA-00904: "ODF_PROJ"."RISK": invalid identifier when installing 'csk'

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

• PMO accelerator (csk) installation fails with the following error message:
  ORA-00904: "ODF_PROJ"."RISK": invalid identifier during upgrade.
  
• Error in admin.log:
  [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 the following error is seen:
  <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

 

Resolution

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

Additional Information

• The same issue can happen with other attributes such as "risk_score". Depending on the attribute / column affected, an appropriate measure should be taken
• Do not just change the attached XML, and insert the wrong attribute code into it. This can lead to attribute corruption. No changes should be made to the attached XML
• Use the attached XML in a non-production system, and test, before using it in Production.