Vibe database upgrade on Oracle fails with error ORA-02273: this unique/primary key is referenced by some foreign keys

  • 7022558
  • 16-Jan-2018
  • 24-Apr-2018

Environment

Micro Focus Vibe 4.0.3
Micro Focus Vibe 4.0.4

Situation

When updating from an earlier version of Vibe to Micro Focus Vibe 4.0.3, 4.0.4 or newer with an Oracle database, the database update step (as documented in the Vibe 4.0.3 Update Guide) fails with an error that looks like:

SEVERE 9/22/17 11:33 AM:liquibase: Change Set scripts/changelog/oracle-changelog-quartz-1.8-to-2.2.xml::6-4::jong failed.  Error: Error executing SQL alter table SSQRTZ_JOB_DETAILS drop primary key drop index: ORA-02273: this unique/primary key is referenced by some foreign keys
 
liquibase.exception.DatabaseException: Error executing SQL alter table SSQRTZ_JOB_DETAILS drop primary key drop index: ORA-02273: this unique/primary key is referenced by some foreign keys
        at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
        at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
        at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)
        .....
        .....

Resolution

A fix for this issue is available for Vibe 4.0.3 / 4.0.4. Please contact Micro Focus Customer Care with reference to this TID for further assistance.