Build: #1344 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 1,344 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
8 secs
Status
Failed (New Failure)

Error Log

java.io.IOException: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase-update-to-latest.xml::TRUNK-4936-20160930-1000::teleivo:
     Reason: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE concept_reference_source ADD unique_id VARCHAR(250) UNIQUE: Syntax error in SQL statement "ALTER TABLE CONCEPT_REFERENCE_SOURCE ADD UNIQUE_ID VARCHAR(250) UNIQUE[*] "; SQL statement:
ALTER TABLE concept_reference_source ADD unique_id VARCHAR(250) UNIQUE [42000-187]:
          Caused By: Error executing SQL ALTER TABLE concept_reference_source ADD unique_id VARCHAR(250) UNIQUE: Syntax error in SQL statement "ALTER TABLE CONCEPT_REFERENCE_SOURCE ADD UNIQUE_ID VARCHAR(250) UNIQUE[*] "; SQL statement:
ALTER TABLE concept_reference_source ADD unique_id VARCHAR(250) UNIQUE [42000-187]:
          Caused By: Syntax error in SQL statement "ALTER TABLE CONCEPT_REFERENCE_SOURCE ADD UNIQUE_ID VARCHAR(250) UNIQUE[*] "; SQL statement:
ALTER TABLE concept_reference_source ADD unique_id VARCHAR(250) UNIQUE [42000-187]
	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.message.DbException.getSyntaxError(DbException.java:191)
	at org.h2.command.Parser.getSyntaxError(Parser.java:518)
	at org.h2.command.Parser.prepareCommand(Parser.java:245)
	at org.h2.engine.Session.prepareLocal(Session.java:461)
	at org.h2.engine.Session.prepareCommand(Session.java:403)
	at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1189)
	at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:170)
	at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:158)
	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:224)
	at org.openmrs.util.databasechange.Database1_9_7UpgradeIT.shouldPassIfThereAreAnyOrderTypesInTheDatabaseOtherThanDrugOrderTypeAndTheNewColumnsExist(Database1_9_7UpgradeIT.java:397)