During Harvest 14.5 Installation "ORA-02275: such a referential constraint already exists in the table"

Products

• CA Harvest Software Change Manager

Issue/Introduction

While previously uninstalling Harvest 14.0 and installing Harvest 14.5, the following error is encountered

ALTER TABLE HARREPOSITORY ADD CONSTRAINT HARREP_GITREPOSITOBJID_FK FOREIGN KEY (GITREPOSITOBJID) REFERENCES HARGITREPOSITORY(GITREPOSITOBJID)
ON DELETE CASCADE

-- RETURN CODE: DB_FAIL
[Oracle][ODBC][Ora]ORA-02275: such a referential constraint already exists in the table

SQLSTATE=S1000
2024/02/26 04:25:35 E03020003: Database error [Oracle][ODBC][Ora]ORA-02275: such a referential constraint already exists in the table

SQLSTATE=S1000 .

Environment

Harvest 14.5

Oracle 19c

Resolution

Ensure you have a working backup of the database

Drop all constraints

Rerun the Harvest Upgrade UR command again

• Reference the Section Titled "Upgrade the Repository (Oracle)"
• Upgrade the Repository (Oracle)