PPM Patch installation fails with error ORA-02270 on PPM_DWH.CMN_ENABLE_DISABLE_SP

Document ID : KB000109473
Last Modified Date : 02/08/2018
Show Technical Document Details
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)
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: