OpenMRS Core Master
Build: #1894 failed
Job: Integration Test failed
Should pass if all existing drug order units and frequencies are mapped to concepts: Test case result
The below summarizes the result of the test "Should pass if all existing drug order units and frequencies are mapped to concepts" in build 1,894 of OpenMRS Core - OpenMRS Core Master - Integration Test.
- Description
- Should pass if all existing drug order units and frequencies are mapped to concepts
- Test class
- org.openmrs.util.databasechange.Database1_9_7UpgradeIT
- Method
- shouldPassIfAllExistingDrugOrderUnitsAndFrequenciesAreMappedToConcepts
- 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.shouldPassIfAllExistingDrugOrderUnitsAndFrequenciesAreMappedToConcepts(Database1_9_7UpgradeIT.java:275)