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.
Patch install fails with ORA-02270 on PPM_DWH.CMN_ENABLE_DISABLE_SP
Article ID: 109473
Clarity PPM SaaSClarity PPM On Premise
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)
Release: Any Component:
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.