Patch install fails with ORA-02270 on PPM_DWH.CMN_ENABLE_DISABLE_SP

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

When installing a patch an error is thrown similar to below:
 
Line 133350: 7/25/18 9:16 AM (ExecTask) Total time: 0H:0M:30S
Line 133351: 7/25/18 9:16 AM (ExecTask) Exception in thread "main" java.lang.Exception: DBDriver failed to install
Line 133352: 7/25/18 9:16 AM (ExecTask) at com.niku.dbtools.DriverApp.installSchemaDriver(DriverApp.java:893)
Line 133353: 7/25/18 9:16 AM (ExecTask) at com.niku.dbtools.Utilities.run(Utilities.java:1866)
Line 133354: 7/25/18 9:16 AM (ExecTask) at com.niku.dbtools.Utilities.main(Utilities.java:980)
Line 133355: 7/25/18 9:16 AM (ExecTask) Caused by: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-20000: Error: ORA-02270: no matching unique or primary key for this column-list
Line 133356: 7/25/18 9:16 AM (ExecTask) ORA-06512: at "PPM_DWH.CMN_ENABLE_DISABLE_SP", line 68
Line 133357: 7/25/18 9:16 AM (ExecTask) ORA-06512: at line 1
Line 133358: 7/25/18 9:16 AM (ExecTask)
 

Environment

Release: Any
Component:

Resolution

• This issue occurs when the Load Data Warehouse was not successfully run before the patch upgrade.
• Bring the system up and run Load Data Warehouse - Full until completion.
• Then stop the services and run the patch install again.

Additional Information

For more details and additional discussion check our Communities article:
Tech Tip: ORA-02270: no matching unique or primary key for this column-list ORA-06512: at "PPM_DWH.CMN_ENABLE_DISABLE_SP"