Build #2,199

Plan branch:
OpenMRS Core Master

Build: #2199 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 2,199 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
12 secs
Status
Failed (New Failure)

Error Log

java.io.IOException: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase-update-to-latest.xml::TRUNK-5728-2020-04-15::samuel34:
     Reason: liquibase.exception.DatabaseException: Constraint "ENCOUNTER_ID_FK" already exists; SQL statement:
ALTER TABLE PUBLIC.conditions ADD CONSTRAINT encounter_id_fk FOREIGN KEY (encounter_id) REFERENCES PUBLIC.encounter (encounter_id) [90045-199] [Failed SQL: (90045) ALTER TABLE PUBLIC.conditions ADD CONSTRAINT encounter_id_fk FOREIGN KEY (encounter_id) REFERENCES PUBLIC.encounter (encounter_id)]
java.io.IOException: 
liquibase.exception.MigrationFailedException: Migration failed for change set liquibase-update-to-latest.xml::TRUNK-5728-2020-04-15::samuel34:
     Reason: liquibase.exception.DatabaseException: Constraint "ENCOUNTER_ID_FK" already exists; SQL statement:
ALTER TABLE PUBLIC.conditions ADD CONSTRAINT encounter_id_fk FOREIGN KEY (encounter_id) REFERENCES PUBLIC.encounter (encounter_id) [90045-199] [Failed SQL: (90045) ALTER TABLE PUBLIC.conditions ADD CONSTRAINT encounter_id_fk FOREIGN KEY (encounter_id) REFERENCES PUBLIC.encounter (encounter_id)]
	at org.openmrs.util.databasechange.Database1_9_7UpgradeIT.shouldPassIfThereAreAnyOrderTypesInTheDatabaseOtherThanDrugOrderTypeAndTheNewColumnsExist(Database1_9_7UpgradeIT.java:402)
Caused by: liquibase.exception.MigrationFailedException: 
Migration failed for change set liquibase-update-to-latest.xml::TRUNK-5728-2020-04-15::samuel34:
     Reason: liquibase.exception.DatabaseException: Constraint "ENCOUNTER_ID_FK" already exists; SQL statement:
ALTER TABLE PUBLIC.conditions ADD CONSTRAINT encounter_id_fk FOREIGN KEY (encounter_id) REFERENCES PUBLIC.encounter (encounter_id) [90045-199] [Failed SQL: (90045) ALTER TABLE PUBLIC.conditions ADD CONSTRAINT encounter_id_fk FOREIGN KEY (encounter_id) REFERENCES PUBLIC.encounter (encounter_id)]
	at org.openmrs.util.databasechange.Database1_9_7UpgradeIT.shouldPassIfThereAreAnyOrderTypesInTheDatabaseOtherThanDrugOrderTypeAndTheNewColumnsExist(Database1_9_7UpgradeIT.java:402)
Caused by: liquibase.exception.DatabaseException: 
Constraint "ENCOUNTER_ID_FK" already exists; SQL statement:
ALTER TABLE PUBLIC.conditions ADD CONSTRAINT encounter_id_fk FOREIGN KEY (encounter_id) REFERENCES PUBLIC.encounter (encounter_id) [90045-199] [Failed SQL: (90045) ALTER TABLE PUBLIC.conditions ADD CONSTRAINT encounter_id_fk FOREIGN KEY (encounter_id) REFERENCES PUBLIC.encounter (encounter_id)]
	at org.openmrs.util.databasechange.Database1_9_7UpgradeIT.shouldPassIfThereAreAnyOrderTypesInTheDatabaseOtherThanDrugOrderTypeAndTheNewColumnsExist(Database1_9_7UpgradeIT.java:402)
Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: 
Constraint "ENCOUNTER_ID_FK" already exists; SQL statement:
ALTER TABLE PUBLIC.conditions ADD CONSTRAINT encounter_id_fk FOREIGN KEY (encounter_id) REFERENCES PUBLIC.encounter (encounter_id) [90045-199]
	at org.openmrs.util.databasechange.Database1_9_7UpgradeIT.shouldPassIfThereAreAnyOrderTypesInTheDatabaseOtherThanDrugOrderTypeAndTheNewColumnsExist(Database1_9_7UpgradeIT.java:402)