Home

Results 1 to 3 of 3

Thread: unable to update Database from 4.02 to 4.03(p1)

Threaded View

  1. #1
    Join Date
    Apr 2008
    Posts
    44

    unable to update Database from 4.02 to 4.03(p1)

    Upgrade the Database (Oracle) fails after some changes with this error after executing manage-database.sh orcale updateDatabase:
    .
    .
    .
    DEBUG 8/25/17 11:38 AM:liquibase: Computed checksum for sql:[
    splitStatements="true"
    sql="alter table SSQRTZ_CRON_TRIGGERS drop primary key drop index;"
    stripComments="false"
    ] as 5f69e5fe6f5f09de3e2c2e5f45705b4a
    DEBUG 8/25/17 11:38 AM:liquibase: Computed checksum for 3:5f69e5fe6f5f09de3e2c2e5f45705b4a: as 70667ff3645ecb7eb5278bb92654bf9f
    DEBUG 8/25/17 11:38 AM:liquibase: Computed checksum for sql:[
    splitStatements="true"
    sql="alter table SSQRTZ_JOB_DETAILS drop primary key drop index;"
    stripComments="false"
    ] as 250d92ff2df96aaf98be8e986724d1da
    DEBUG 8/25/17 11:38 AM:liquibase: Computed checksum for 3:250d92ff2df96aaf98be8e986724d1da: as c9f4385d68c25ede7003b3d44a7312d1
    DEBUG 8/25/17 11:38 AM:liquibase: Running Changeset:scripts/changelog/oracle-changelog-quartz-1.8-to-2.2.xml::6-4::jong:Checksum: 3:c9f4385d68c25ede7003b3d44a7312d1)
    DEBUG 8/25/17 11:38 AM:liquibase: Computed checksum for sql:[
    splitStatements="true"
    sql="alter table SSQRTZ_JOB_DETAILS drop primary key drop index;"
    stripComments="false"
    ] as 250d92ff2df96aaf98be8e986724d1da
    DEBUG 8/25/17 11:38 AM:liquibase: Computed checksum for 3:250d92ff2df96aaf98be8e986724d1da: as c9f4385d68c25ede7003b3d44a7312d1
    DEBUG 8/25/17 11:38 AM:liquibase: Changeset scripts/changelog/oracle-changelog-quartz-1.8-to-2.2.xml::6-4::jong:Checksum: 3:c9f4385d68c25ede7003b3d44a7312d1)
    DEBUG 8/25/17 11:38 AM:liquibase: Computed checksum for sql:[
    splitStatements="true"
    sql="alter table SSQRTZ_JOB_DETAILS drop primary key drop index;"
    stripComments="false"
    ] as 250d92ff2df96aaf98be8e986724d1da
    DEBUG 8/25/17 11:38 AM:liquibase: Computed checksum for 3:250d92ff2df96aaf98be8e986724d1da: as c9f4385d68c25ede7003b3d44a7312d1
    DEBUG 8/25/17 11:38 AM:liquibase: Reading ChangeSet: scripts/changelog/oracle-changelog-quartz-1.8-to-2.2.xml::6-4::jong:Checksum: 3:c9f4385d68c25ede7003b3d44a7312d1)
    DEBUG 8/25/17 11:38 AM:liquibase: Executing Statement: alter table SSQRTZ_JOB_DETAILS drop primary key drop index
    DEBUG 8/25/17 11:38 AM:liquibase: Executing EXECUTE database command: alter table SSQRTZ_JOB_DETAILS drop primary key drop index
    SEVERE 8/25/17 11:38 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(JdbcEx ecutor.java:62)
    at liquibase.executor.jvm.JdbcExecutor.execute(JdbcEx ecutor.java:104)
    at liquibase.database.AbstractDatabase.execute(Abstra ctDatabase.java:1091)
    at liquibase.database.AbstractDatabase.executeStateme nts(AbstractDatabase.java:1075)
    at liquibase.changelog.ChangeSet.execute(ChangeSet.ja va:317)
    at liquibase.changelog.visitor.UpdateVisitor.visit(Up dateVisitor.java:27)
    at liquibase.changelog.ChangeLogIterator.run(ChangeLo gIterator.java:58)
    at liquibase.Liquibase.update(Liquibase.java:114)
    at liquibase.integration.commandline.Main.doMigration (Main.java:825)
    at liquibase.integration.commandline.Main.main(Main.j ava:134)
    Caused by: java.sql.SQLSyntaxErrorException: ORA-02273: this unique/primary key is referenced by some foreign keys

    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoe r.java:450)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoe r.java:399)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall. java:1017)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.jav a:655)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java: 249)
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:5 66)
    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStateme nt.java:202)
    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStateme nt.java:45)
    at oracle.jdbc.driver.T4CStatement.executeForRows(T4C Statement.java:933)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTi meout(OracleStatement.java:1075)
    at oracle.jdbc.driver.OracleStatement.executeInternal (OracleStatement.java:1718)
    at oracle.jdbc.driver.OracleStatement.execute(OracleS tatement.java:1678)
    at oracle.jdbc.driver.OracleStatementWrapper.execute( OracleStatementWrapper.java:332)
    at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatem entCallback.doInStatement(JdbcExecutor.java:92)
    at liquibase.executor.jvm.JdbcExecutor.execute(JdbcEx ecutor.java:55)
    ... 9 more
    DEBUG 8/25/17 11:38 AM:liquibase: Release Database Lock
    DEBUG 8/25/17 11:38 AM:liquibase: Executing UPDATE database command: UPDATE DATABASECHANGELOGLOCK SET LOCKED = 0, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1
    INFO 8/25/17 11:38 AM:liquibase: Successfully released change log lock
    Liquibase Update Failed: 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

    SEVERE 8/25/17 11:38 AM:liquibase: 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.MigrationFailedException: Migration failed for change set scripts/changelog/oracle-changelog-quartz-1.8-to-2.2.xml::6-4::jong:
    Reason: 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
    :
    Caused By: 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
    :
    Caused By: ORA-02273: this unique/primary key is referenced by some foreign keys

    at liquibase.changelog.ChangeSet.execute(ChangeSet.ja va:347)
    at liquibase.changelog.visitor.UpdateVisitor.visit(Up dateVisitor.java:27)
    at liquibase.changelog.ChangeLogIterator.run(ChangeLo gIterator.java:58)
    at liquibase.Liquibase.update(Liquibase.java:114)
    at liquibase.integration.commandline.Main.doMigration (Main.java:825)
    at liquibase.integration.commandline.Main.main(Main.j ava:134)
    Caused by: 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(JdbcEx ecutor.java:62)
    at liquibase.executor.jvm.JdbcExecutor.execute(JdbcEx ecutor.java:104)
    at liquibase.database.AbstractDatabase.execute(Abstra ctDatabase.java:1091)
    at liquibase.database.AbstractDatabase.executeStateme nts(AbstractDatabase.java:1075)
    at liquibase.changelog.ChangeSet.execute(ChangeSet.ja va:317)
    ... 5 more
    Caused by: java.sql.SQLSyntaxErrorException: ORA-02273: this unique/primary key is referenced by some foreign keys

    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoe r.java:450)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoe r.java:399)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall. java:1017)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.jav a:655)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java: 249)
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:5 66)
    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStateme nt.java:202)
    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStateme nt.java:45)
    at oracle.jdbc.driver.T4CStatement.executeForRows(T4C Statement.java:933)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTi meout(OracleStatement.java:1075)
    at oracle.jdbc.driver.OracleStatement.executeInternal (OracleStatement.java:1718)
    at oracle.jdbc.driver.OracleStatement.execute(OracleS tatement.java:1678)
    at oracle.jdbc.driver.OracleStatementWrapper.execute( OracleStatementWrapper.java:332)
    at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatem entCallback.doInStatement(JdbcExecutor.java:92)
    at liquibase.executor.jvm.JdbcExecutor.execute(JdbcEx ecutor.java:55)
    ... 9 more
    any Ideas?
    regards
    claus
    Last edited by clausw; 25-Aug-2017 at 10:52 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •