Database update script fails when upgrading to Vibe 4.0.3

  • 7020981
  • 16-Jun-2017
  • 17-Jul-2017

Environment

Micro Focus Vibe 4.0.3

Situation

When updating to Micro Focus Vibe 4.0.3 with an Oracle or MS-SQL-Server database, the database update step (as documented in the Vibe 4.0.3 Update Guide) fails with the following error:

MS-SQL-Server:

SEVERE 5/23/17 2:04 PM:liquibase: Change Set scripts/changelog/sqlserver-changelog-quartz-1.8-to-2.2.xml::6-1::jong failed.
Error: Error executing SQL alter table SSQRTZ_BLOB_TRIGGERS drop constraint PK__SSQRTZ_BLOB_TRIGGERS: 'PK__SSQRTZ_BLOB_TRIGGERS' is not a constraint.
liquibase.exception.DatabaseException: Error executing SQL alter table SSQRTZ_BLOB_TRIGGERS drop constraint PK__SSQRTZ_BLOB_TRIGGERS: 'PK__SSQRTZ_BLOB_TRIGGERS'
 is not a constraint.
 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)
 ......
 ......


Oracle:

SEVERE 6/6/17 2:30 PM:liquibase: Change Set scripts/changelog/oracle-changelog-quartz-1.8-to-2.2.xml::5-1::jong failed.  Error: Error executing SQL alter table SSQRTZ_TRIGGERS drop constraint FK_TRIGGERS_JOB_DETAILS: ORA-02443: Cannot drop constraint  - nonexistent constraint

liquibase.exception.DatabaseException: Error executing SQL alter table SSQRTZ_TRIGGERS drop constraint FK_TRIGGERS_JOB_DETAILS: ORA-02443: Cannot drop constraint  - nonexistent constraint

    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)
    .....
    .....


Note: MySQL database is not affected by this problem.

Resolution

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

Note: When using the Vibe 4.0.3 - Patch 1 installer available via the Micro Focus Patch Finder to perform the upgrade, this issue is fixed.