7020981: Database update script fails when upgrading to Vibe 4.0.3

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.

Related:

Leave a Reply