OpenMRS Core Master
Build: #1894 failed Changes by segunolalive <segunolalive@gmail.com>
Test results
- 3,954 tests in total
- 10 tests failed
- 10 failures are new
- 41 tests were quarantined / skipped
- 36 minutes taken in total.
| Status | Test | View job | Duration | |
|---|---|---|---|---|
| Collapse |
Database1_9_7UpgradeIT
shouldMigrateDrugOrders
|
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 |
Database1_9_7UpgradeIT
shouldAddTheNecessaryPrivilegesAndAssignThemToSpecificRoles
|
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 |
Database1_9_7UpgradeIT
shouldPassIfAllExistingDrugOrderUnitsAndFrequenciesAreMappedToConcepts
|
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 |
Database1_9_7UpgradeIT
shouldUpgradeFromClean1_9To1_10
|
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 |
Database1_9_7UpgradeIT
shouldUpgradeLiquibase
|
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 |
Database1_9_7UpgradeIT
shouldSetValuesToNullIfUnitsOrFrequencyBlank
|
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 |
Database1_9_7UpgradeIT
shouldPassIfThereAreAnyOrderTypesInTheDatabaseOtherThanDrugOrderTypeAndTheNewColumnsExist
|
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 |
Database1_9_7UpgradeIT
shouldCreateDiscontinuationOrderForStoppedOrders
|
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 |
Database1_9_7UpgradeIT
shouldConcatenateDoseStrengthAndUnits
|
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 |
Database1_9_7UpgradeIT
shouldConvertOrderersToBeingProvidersInsteadOfUsers
|
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...)
|
||||