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
Issue:
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)
 
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:
https://communities.ca.com/thread/241780360-tech-tip-ora-02270-no-matching-unique-or-primary-key-for-this-column-list-ora-06512-at-ppmdwhcmnenabledisablesp