16.1.0 Patch 1 failed to be applied while updating DWH

Products

• Clarity PPM On Premise

Issue/Introduction

Upgrade to Patch 1 of 16.1.0 failed with 

Current database version is infrastructure_20221021_1522
DBDriver for infrastructure_20221213_0445
Start installation of DBDriver ...

Note: Foreign Keys have been disabled

DBDriver failed to install!

Exception in thread "main" java.lang.Exception: DBDriver failed to install
        at com.niku.dbtools.DriverApp.installSchemaDriver(DriverApp.java:904)
        at com.niku.dbtools.Utilities.run(Utilities.java:2134)
        at com.niku.dbtools.Utilities.main(Utilities.java:1161)
Caused by: java.sql.SQLException: ORA-20000: Error: ORA-02270: no matching unique or primary key for this column-list
ORA-06512: at "DWH.CMN_ENABLE_DISABLE_SP", line 68
ORA-06512: at line 1

        at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509)
        at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461)
        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104)
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550)
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268)
        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655)
        at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:265)
        at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:86)

Environment

Release : 16.1.0

Cause

This indicates that some of the tables constraints might be corrupted and are missing. 

Resolution

1. Rebuild the DWH schema from 16.1.0 Base image.
2. run "admin db dwh-upgrade -Dupgrade.phase=maintenance" to update the patch for DWH.