OpenMRS Core Master

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 all existing drug order units and frequencies are mapped to concepts: Test case result

The below summarizes the result of the test "Should pass if all existing drug order units and frequencies are mapped to concepts" in build 1,344 of OpenMRS Core - OpenMRS Core Master - Integration Test. View test case history
Description
Should pass if all existing drug order units and frequencies are mapped to concepts
Test class
org.openmrs.util.databasechange.Database1_9_7UpgradeIT
Method
shouldPassIfAllExistingDrugOrderUnitsAndFrequenciesAreMappedToConcepts
Duration
9 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.shouldPassIfAllExistingDrugOrderUnitsAndFrequenciesAreMappedToConcepts(Database1_9_7UpgradeIT.java:275)