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 migrate drug orders: Test case result

The below summarizes the result of the test "Should migrate drug orders" in build 2,199 of OpenMRS Core - OpenMRS Core Master - Integration Test. View test case history
Description
Should migrate drug orders
Test class
org.openmrs.util.databasechange.Database1_9_7UpgradeIT
Method
shouldMigrateDrugOrders
Duration
13 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.shouldMigrateDrugOrders(Database1_9_7UpgradeIT.java:197)
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.shouldMigrateDrugOrders(Database1_9_7UpgradeIT.java:197)
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.shouldMigrateDrugOrders(Database1_9_7UpgradeIT.java:197)
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.shouldMigrateDrugOrders(Database1_9_7UpgradeIT.java:197)