Build: #488 failed
Job: Unit and Component Tests 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 488 of OpenMRS Core - OpenMRS Core 1.10.x - Unit and Component Tests.
- 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