Build #1,894

Plan branch:
OpenMRS Core Master

Build: #1894 failed

Job: Integration Test failed

Stages & jobs

  1. Build and Test

  2. Deploy

  3. Release

    Requires a user to start manually

Should pass if there are any order types in the database other than drug order type and the new columns exist: Test case result

The below summarizes the result of the test "Should pass if there are any order types in the database other than drug order type and the new columns exist" in build 1,894 of OpenMRS Core - OpenMRS Core Master - Integration Test. View test case history
Description
Should pass if there are any order types in the database other than drug order type and the new columns exist
Test class
org.openmrs.util.databasechange.Database1_9_7UpgradeIT
Method
shouldPassIfThereAreAnyOrderTypesInTheDatabaseOtherThanDrugOrderTypeAndTheNewColumnsExist
Duration
4 secs
Status
Failed (New Failure)

Error Log

java.io.IOException: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase-update-to-latest.xml::20181402-TRUNK-5339::esirkings:
     Reason: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE encounter_diagnosis (diagnosis_id INT GENERATED BY DEFAULT AS IDENTITY NOT NULL, diagnosis_coded INT, diagnosis_non_coded VARCHAR(255), diagnosis_coded_name INT, encounter_id INT NOT NULL, patient_id INT NOT NULL, condition_id INT NOT NULL, certainty VARCHAR(255) NOT NULL, rank INT NOT NULL, uuid CHAR(38) NOT NULL, creator INT NOT NULL, date_created TIMESTAMP NOT NULL, changed_by INT, date_changed TIMESTAMP, voided BOOLEAN DEFAULT FALSE NOT NULL, voided_by INT, date_voided TIMESTAMP, void_reason VARCHAR(255), patient_id INT NOT NULL, CONSTRAINT PK_ENCOUNTER_DIAGNOSIS PRIMARY KEY (diagnosis_id), UNIQUE (uuid)): Duplicate column name "PATIENT_ID"; SQL statement:
CREATE TABLE encounter_diagnosis (diagnosis_id INT GENERATED BY DEFAULT AS IDENTITY NOT NULL, diagnosis_coded INT, diagnosis_non_coded VARCHAR(255), diagnosis_coded_name INT, encounter_id INT NOT NULL, patient_id INT NOT NULL, condition_id INT NOT NULL, certainty VARCHAR(255) NOT NULL, rank INT NOT NULL, uuid CHAR(38) NOT NULL, creator INT NOT NULL, date_created TIMESTAMP NOT NULL, changed_by INT, date_changed TIMESTAMP, voided BOOLEAN DEFAULT FALSE NOT NULL, voided_by INT, date_voided TIMESTAMP, void_reason VARCHAR(255), patient_id INT NOT NULL, CONSTRAINT PK_ENCOUNTER_DIAGNOSIS PRIMARY KEY (diagnosis_id), UNIQUE (uuid)) [42121-196]:
          Caused By: Error executing SQL CREATE TABLE encounter_diagnosis (diagnosis_id INT GENERATED BY DEFAULT AS IDENTITY NOT NULL, diagnosis_coded INT, diagnosis_non_coded VARCHAR(255), diagnosis_coded_name INT, encounter_id INT NOT NULL, patient_id INT NOT NULL, condition_id INT NOT NULL, certainty VARCHAR(255) NOT NULL, rank INT NOT NULL, uuid CHAR(38) NOT NULL, creator INT NOT NULL, date_created TIMESTAMP NOT NULL, changed_by INT, date_changed TIMESTAMP, voided BOOLEAN DEFAULT FALSE NOT NULL, voided_by INT, date_voided TIMESTAMP, void_reason VARCHAR(255), patient_id INT NOT NULL, CONSTRAINT PK_ENCOUNTER_DIAGNOSIS PRIMARY KEY (diagnosis_id), UNIQUE (uuid)): Duplicate column name "PATIENT_ID"; SQL statement:
CREATE TABLE encounter_diagnosis (diagnosis_id INT GENERATED BY DEFAULT AS IDENTITY NOT NULL, diagnosis_coded INT, diagnosis_non_coded VARCHAR(255), diagnosis_coded_name INT, encounter_id INT NOT NULL, patient_id INT NOT NULL, condition_id INT NOT NULL, certainty VARCHAR(255) NOT NULL, rank INT NOT NULL, uuid CHAR(38) NOT NULL, creator INT NOT NULL, date_created TIMESTAMP NOT NULL, changed_by INT, date_changed TIMESTAMP, voided BOOLEAN DEFAULT FALSE NOT NULL, voided_by INT, date_voided TIMESTAMP, void_reason VARCHAR(255), patient_id INT NOT NULL, CONSTRAINT PK_ENCOUNTER_DIAGNOSIS PRIMARY KEY (diagnosis_id), UNIQUE (uuid)) [42121-196]:
          Caused By: Duplicate column name "PATIENT_ID"; SQL statement:
CREATE TABLE encounter_diagnosis (diagnosis_id INT GENERATED BY DEFAULT AS IDENTITY NOT NULL, diagnosis_coded INT, diagnosis_non_coded VARCHAR(255), diagnosis_coded_name INT, encounter_id INT NOT NULL, patient_id INT NOT NULL, condition_id INT NOT NULL, certainty VARCHAR(255) NOT NULL, rank INT NOT NULL, uuid CHAR(38) NOT NULL, creator INT NOT NULL, date_created TIMESTAMP NOT NULL, changed_by INT, date_changed TIMESTAMP, voided BOOLEAN DEFAULT FALSE NOT NULL, voided_by INT, date_voided TIMESTAMP, void_reason VARCHAR(255), patient_id INT NOT NULL, CONSTRAINT PK_ENCOUNTER_DIAGNOSIS PRIMARY KEY (diagnosis_id), UNIQUE (uuid)) [42121-196]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
	at org.h2.message.DbException.get(DbException.java:179)
	at org.h2.message.DbException.get(DbException.java:155)
	at org.h2.table.Table.setColumns(Table.java:428)
	at org.h2.table.TableBase.<init>(TableBase.java:45)
	at org.h2.table.RegularTable.<init>(RegularTable.java:74)
	at org.h2.schema.Schema.createTable(Schema.java:614)
	at org.h2.command.ddl.CreateTable.update(CreateTable.java:139)
	at org.h2.command.CommandContainer.update(CommandContainer.java:101)
	at org.h2.command.Command.executeUpdate(Command.java:260)
	at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:192)
	at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:164)
	at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
	at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)
	at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)
	at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
	at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
	at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
	at liquibase.Liquibase.update(Liquibase.java:114)
	at org.openmrs.util.databasechange.DatabaseUpgradeTestUtil.upgrade(DatabaseUpgradeTestUtil.java:228)
	at org.openmrs.util.databasechange.DatabaseUpgradeTestUtil.upgrade(DatabaseUpgradeTestUtil.java:221)
	at org.openmrs.util.databasechange.Database1_9_7UpgradeIT.shouldPassIfThereAreAnyOrderTypesInTheDatabaseOtherThanDrugOrderTypeAndTheNewColumnsExist(Database1_9_7UpgradeIT.java:397)