OpenMRS Core Master
Build: #2006 failed
Job: Integration Test failed
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,006 of OpenMRS Core - OpenMRS Core Master - Integration Test.
- 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
- 5 secs
- Status
- Failed (New Failure)
Error Log
java.io.IOException: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase-update-to-latest.xml::20180808-passwordreset::harisu+fanyui: Reason: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE users ADD email VARCHAR(255) UNIQUE: Syntax error in SQL statement "ALTER TABLE USERS ADD EMAIL VARCHAR(255) UNIQUE[*] "; SQL statement: ALTER TABLE users ADD email VARCHAR(255) UNIQUE [42000-196]: Caused By: Error executing SQL ALTER TABLE users ADD email VARCHAR(255) UNIQUE: Syntax error in SQL statement "ALTER TABLE USERS ADD EMAIL VARCHAR(255) UNIQUE[*] "; SQL statement: ALTER TABLE users ADD email VARCHAR(255) UNIQUE [42000-196]: Caused By: Syntax error in SQL statement "ALTER TABLE USERS ADD EMAIL VARCHAR(255) UNIQUE[*] "; SQL statement: ALTER TABLE users ADD email VARCHAR(255) UNIQUE [42000-196] 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:534) at org.h2.command.Parser.prepareCommand(Parser.java:261) at org.h2.engine.Session.prepareLocal(Session.java:578) at org.h2.engine.Session.prepareCommand(Session.java:519) at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1204) at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:176) at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:164) 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:228) at org.openmrs.util.databasechange.DatabaseUpgradeTestUtil.upgrade(DatabaseUpgradeTestUtil.java:221) at org.openmrs.util.databasechange.Database1_9_7UpgradeIT.shouldPassIfThereAreAnyOrderTypesInTheDatabaseOtherThanDrugOrderTypeAndTheNewColumnsExist(Database1_9_7UpgradeIT.java:397)