Build #1,894

Plan branch:
OpenMRS Core Master

Build: #1894 failed Changes by segunolalive <segunolalive@gmail.com>

Stages & jobs

  1. Build and Test

  2. Deploy

  3. Release

    Requires a user to start manually

Build result summary

Details

Completed
Queue duration
2 seconds
Duration
42 minutes
Labels
None
Revisions
openmrs-core
37342c954e482d67332afc02ea3badcb0fc4e584 37342c954e482d67332afc02ea3badcb0fc4e584
openmrs-standalone
5b99613f0bffb1ab3ffd50123096c7aa265d6620 5b99613f0bffb1ab3ffd50123096c7aa265d6620
Release scripts
5b416af0a90e6a162755d06d53b81d906ec4ef36 5b416af0a90e6a162755d06d53b81d906ec4ef36
Total tests
3954
Fixed in
#1895 (Changes by dkayiwa <kayiwadaniel@gmail.com>)

Tests

Responsible

No one has taken responsibility for this failure

Code commits

openmrs-core
Author Commit Message Commit date
segunolalive <segunolalive@gmail.com> segunolalive <segunolalive@gmail.com> 37342c954e482d67332afc02ea3badcb0fc4e584 37342c954e482d67332afc02ea3badcb0fc4e584 TRUNK-5352: Create Diagnosis data access implementation (#2612)

Configuration changes

Some of the jobs or stages referenced by this result no longer exist.

Restarting failed/incomplete builds only is not possible as some of the affected jobs no longer exist.

Tests

New test failures 10
Status Test View job Duration
Collapse Failed Database1_9_7UpgradeIT shouldMigrateDrugOrders History
Integration Test 5 secs 
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)
(23 more lines...)
Collapse Failed Database1_9_7UpgradeIT shouldAddTheNecessaryPrivilegesAndAssignThemToSpecificRoles History
Integration Test 5 secs 
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)
(23 more lines...)
Collapse Failed Database1_9_7UpgradeIT shouldPassIfAllExistingDrugOrderUnitsAndFrequenciesAreMappedToConcepts History
Integration Test 4 secs 
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)
(23 more lines...)
Collapse Failed Database1_9_7UpgradeIT shouldUpgradeFromClean1_9To1_10 History
Integration Test 6 secs 
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)
(23 more lines...)
Collapse Failed Database1_9_7UpgradeIT shouldUpgradeLiquibase History
Integration Test 6 secs 
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)
(22 more lines...)
Collapse Failed Database1_9_7UpgradeIT shouldSetValuesToNullIfUnitsOrFrequencyBlank History
Integration Test 5 secs 
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)
(23 more lines...)
Collapse Failed Database1_9_7UpgradeIT shouldPassIfThereAreAnyOrderTypesInTheDatabaseOtherThanDrugOrderTypeAndTheNewColumnsExist History
Integration Test 4 secs 
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)
(23 more lines...)
Collapse Failed Database1_9_7UpgradeIT shouldCreateDiscontinuationOrderForStoppedOrders History
Integration Test 5 secs 
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)
(23 more lines...)
Collapse Failed Database1_9_7UpgradeIT shouldConcatenateDoseStrengthAndUnits History
Integration Test 6 secs 
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)
(23 more lines...)
Collapse Failed Database1_9_7UpgradeIT shouldConvertOrderersToBeingProvidersInsteadOfUsers History
Integration Test 7 secs 
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)
(23 more lines...)

Jira issues

IssueDescriptionStatus
Unknown Issue TypeTRUNK-5352Could not obtain issue details from Jira