Build: #488 failed

Job: Integration Tests failed

Stages & jobs

  1. Build and Tests

  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 488 of OpenMRS Core - OpenMRS Core 1.10.x - Integration Tests. 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_7UpgradeTest
Method
shouldPassIfThereAreAnyOrderTypesInTheDatabaseOtherThanDrugOrderTypeAndTheNewColumnsExist
Duration
4 secs
Status
Failed (New Failure)

Error Log

java.io.IOException: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase-update-to-latest.xml::20160202-1743::rkorytkowski:      Reason: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE patient_identifier ALTER COLUMN  uuid CHAR(38) NOT NULL: Column "UUID" contains null values; SQL statement: ALTER TABLE patient_identifier ALTER COLUMN  uuid CHAR(38) NOT NULL [90081-187]:           Caused By: Error executing SQL ALTER TABLE patient_identifier ALTER COLUMN  uuid CHAR(38) NOT NULL: Column "UUID" contains null values; SQL statement: ALTER TABLE patient_identifier ALTER COLUMN  uuid CHAR(38) NOT NULL [90081-187]:           Caused By: Column "UUID" contains null values; SQL statement: ALTER TABLE patient_identifier ALTER COLUMN  uuid CHAR(38) NOT NULL [90081-187]
java.io.IOException: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase-update-to-latest.xml::20160202-1743::rkorytkowski:
     Reason: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE patient_identifier ALTER COLUMN  uuid CHAR(38) NOT NULL: Column "UUID" contains null values; SQL statement:
ALTER TABLE patient_identifier ALTER COLUMN  uuid CHAR(38) NOT NULL [90081-187]:
          Caused By: Error executing SQL ALTER TABLE patient_identifier ALTER COLUMN  uuid CHAR(38) NOT NULL: Column "UUID" contains null values; SQL statement:
ALTER TABLE patient_identifier ALTER COLUMN  uuid CHAR(38) NOT NULL [90081-187]:
          Caused By: Column "UUID" contains null values; SQL statement:
ALTER TABLE patient_identifier ALTER COLUMN  uuid CHAR(38) NOT NULL [90081-187]
	at org.openmrs.util.databasechange.DatabaseUpgradeTestUtil.upgrade(DatabaseUpgradeTestUtil.java:229)
	at org.openmrs.util.databasechange.Database1_9_7UpgradeTest.shouldPassIfThereAreAnyOrderTypesInTheDatabaseOtherThanDrugOrderTypeAndTheNewColumnsExist(Database1_9_7UpgradeTest.java:388)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:622)
	at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:47)
	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
	at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:44)
	at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
	at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
	at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
	at org.junit.rules.ExpectedException$ExpectedExceptionStatement.evaluate(ExpectedException.java:168)
	at org.junit.rules.RunRules.evaluate(RunRules.java:20)
	at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:271)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:70)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:50)
	at org.junit.runners.ParentRunner$3.run(ParentRunner.java:238)
	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:63)
	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:236)
	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:53)
	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:229)
	at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
	at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
	at org.junit.runners.ParentRunner.run(ParentRunner.java:309)
	at org.apache.maven.surefire.junit4.JUnit4TestSet.execute(JUnit4TestSet.java:59)
	at org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.executeTestSet(AbstractDirectoryTestSuite.java:115)
	at org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.execute(AbstractDirectoryTestSuite.java:102)
	at org.apache.maven.surefire.Surefire.run(Surefire.java:180)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:622)
	at org.apache.maven.surefire.booter.SurefireBooter.runSuitesInProcess(SurefireBooter.java:350)
	at org.apache.maven.surefire.booter.SurefireBooter.main(SurefireBooter.java:1021)
Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase-update-to-latest.xml::20160202-1743::rkorytkowski:
     Reason: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE patient_identifier ALTER COLUMN  uuid CHAR(38) NOT NULL: Column "UUID" contains null values; SQL statement:
ALTER TABLE patient_identifier ALTER COLUMN  uuid CHAR(38) NOT NULL [90081-187]:
          Caused By: Error executing SQL ALTER TABLE patient_identifier ALTER COLUMN  uuid CHAR(38) NOT NULL: Column "UUID" contains null values; SQL statement:
ALTER TABLE patient_identifier ALTER COLUMN  uuid CHAR(38) NOT NULL [90081-187]:
          Caused By: Column "UUID" contains null values; SQL statement:
ALTER TABLE patient_identifier ALTER COLUMN  uuid CHAR(38) NOT NULL [90081-187]
	at liquibase.changelog.ChangeSet.execute(ChangeSet.java:347)
	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)
	... 34 more
Caused by: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE patient_identifier ALTER COLUMN  uuid CHAR(38) NOT NULL: Column "UUID" contains null values; SQL statement:
ALTER TABLE patient_identifier ALTER COLUMN  uuid CHAR(38) NOT NULL [90081-187]
	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
	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)
	... 38 more
Caused by: org.h2.jdbc.JdbcSQLException: Column "UUID" contains null values; SQL statement:
ALTER TABLE patient_identifier ALTER COLUMN  uuid CHAR(38) NOT NULL [90081-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.command.ddl.AlterTableAlterColumn.checkNoNullValues(AlterTableAlterColumn.java:478)
	at org.h2.command.ddl.AlterTableAlterColumn.update(AlterTableAlterColumn.java:139)
	at org.h2.command.CommandContainer.update(CommandContainer.java:78)
	at org.h2.command.Command.executeUpdate(Command.java:254)
	at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:184)
	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)
	... 42 more