OpenMRS Core Master

Build: #572 failed

Job: Integration Test failed

Stages & jobs

  1. Build and Test

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 572 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
7 secs
Status
Failed (New Failure)

Error Log

java.io.IOException: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase-update-to-latest.xml::20140804-1612::Deepak,Rohan:      Reason: liquibase.exception.DatabaseException: Error executing SQL INSERT INTO concept_reference_term (code, concept_source_id, creator, date_created, description, name, uuid) VALUES ('S', (SELECT concept_source_id FROM concept_reference_source WHERE uuid = 'cb523690-9012-4e72-b8bf-4253e1b1a687'), 1, '2014-08-20 00:00:00.0', 'Duration in Second(s)', 'Second(s)', 'd0d36e69-402e-453e-8a7a-aec44c2915af'): NULL not allowed for column "RETIRED"; SQL statement: INSERT INTO concept_reference_term (code, concept_source_id, creator, date_created, description, name, uuid) VALUES ('S', (SELECT concept_source_id FROM concept_reference_source WHERE uuid = 'cb523690-9012-4e72-b8bf-4253e1b1a687'), 1, '2014-08-20 00:00:00.0', 'Duration in Second(s)', 'Second(s)', 'd0d36e69-402e-453e-8a7a-aec44c2915af') [23502-173]:           Caused By: Error executing SQL INSERT INTO concept_reference_term (code, concept_source_id, creator, date_created, description, name, uuid) VALUES ('S', (SELECT concept_source_id FROM concept_reference_source WHERE uuid = 'cb523690-9012-4e72-b8bf-4253e1b1a687'), 1, '2014-08-20 00:00:00.0', 'Duration in Second(s)', 'Second(s)', 'd0d36e69-402e-453e-8a7a-aec44c2915af'): NULL not allowed for column "RETIRED"; SQL statement: INSERT INTO concept_reference_term (code, concept_source_id, creator, date_created, description, name, uuid) VALUES ('S', (SELECT concept_source_id FROM concept_reference_source WHERE uuid = 'cb523690-9012-4e72-b8bf-4253e1b1a687'), 1, '2014-08-20 00:00:00.0', 'Duration in Second(s)', 'Second(s)', 'd0d36e69-402e-453e-8a7a-aec44c2915af') [23502-173]:           Caused By: NULL not allowed for column "RETIRED"; SQL statement: INSERT INTO concept_reference_term (code, concept_source_id, creator, date_created, description, name, uuid) VALUES ('S', (SELECT concept_source_id FROM concept_reference_source WHERE uuid = 'cb523690-9012-4e72-b8bf-4253e1b1a687'), 1, '2014-08-20 00:00:00.0', 'Duration in Second(s)', 'Second(s)', 'd0d36e69-402e-453e-8a7a-aec44c2915af') [23502-173]
java.io.IOException: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase-update-to-latest.xml::20140804-1612::Deepak,Rohan:
     Reason: liquibase.exception.DatabaseException: Error executing SQL INSERT INTO concept_reference_term (code, concept_source_id, creator, date_created, description, name, uuid) VALUES ('S', (SELECT concept_source_id FROM concept_reference_source WHERE uuid = 'cb523690-9012-4e72-b8bf-4253e1b1a687'), 1, '2014-08-20 00:00:00.0', 'Duration in Second(s)', 'Second(s)', 'd0d36e69-402e-453e-8a7a-aec44c2915af'): NULL not allowed for column "RETIRED"; SQL statement:
INSERT INTO concept_reference_term (code, concept_source_id, creator, date_created, description, name, uuid) VALUES ('S', (SELECT concept_source_id FROM concept_reference_source WHERE uuid = 'cb523690-9012-4e72-b8bf-4253e1b1a687'), 1, '2014-08-20 00:00:00.0', 'Duration in Second(s)', 'Second(s)', 'd0d36e69-402e-453e-8a7a-aec44c2915af') [23502-173]:
          Caused By: Error executing SQL INSERT INTO concept_reference_term (code, concept_source_id, creator, date_created, description, name, uuid) VALUES ('S', (SELECT concept_source_id FROM concept_reference_source WHERE uuid = 'cb523690-9012-4e72-b8bf-4253e1b1a687'), 1, '2014-08-20 00:00:00.0', 'Duration in Second(s)', 'Second(s)', 'd0d36e69-402e-453e-8a7a-aec44c2915af'): NULL not allowed for column "RETIRED"; SQL statement:
INSERT INTO concept_reference_term (code, concept_source_id, creator, date_created, description, name, uuid) VALUES ('S', (SELECT concept_source_id FROM concept_reference_source WHERE uuid = 'cb523690-9012-4e72-b8bf-4253e1b1a687'), 1, '2014-08-20 00:00:00.0', 'Duration in Second(s)', 'Second(s)', 'd0d36e69-402e-453e-8a7a-aec44c2915af') [23502-173]:
          Caused By: NULL not allowed for column "RETIRED"; SQL statement:
INSERT INTO concept_reference_term (code, concept_source_id, creator, date_created, description, name, uuid) VALUES ('S', (SELECT concept_source_id FROM concept_reference_source WHERE uuid = 'cb523690-9012-4e72-b8bf-4253e1b1a687'), 1, '2014-08-20 00:00:00.0', 'Duration in Second(s)', 'Second(s)', 'd0d36e69-402e-453e-8a7a-aec44c2915af') [23502-173]
	at org.openmrs.util.databasechange.DatabaseUpgradeTestUtil.upgrade(DatabaseUpgradeTestUtil.java:233)
	at org.openmrs.util.databasechange.Database1_9_7UpgradeIT.shouldPassIfThereAreAnyOrderTypesInTheDatabaseOtherThanDrugOrderTypeAndTheNewColumnsExist(Database1_9_7UpgradeIT.java:370)
	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:606)
	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.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:606)
	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::20140804-1612::Deepak,Rohan:
     Reason: liquibase.exception.DatabaseException: Error executing SQL INSERT INTO concept_reference_term (code, concept_source_id, creator, date_created, description, name, uuid) VALUES ('S', (SELECT concept_source_id FROM concept_reference_source WHERE uuid = 'cb523690-9012-4e72-b8bf-4253e1b1a687'), 1, '2014-08-20 00:00:00.0', 'Duration in Second(s)', 'Second(s)', 'd0d36e69-402e-453e-8a7a-aec44c2915af'): NULL not allowed for column "RETIRED"; SQL statement:
INSERT INTO concept_reference_term (code, concept_source_id, creator, date_created, description, name, uuid) VALUES ('S', (SELECT concept_source_id FROM concept_reference_source WHERE uuid = 'cb523690-9012-4e72-b8bf-4253e1b1a687'), 1, '2014-08-20 00:00:00.0', 'Duration in Second(s)', 'Second(s)', 'd0d36e69-402e-453e-8a7a-aec44c2915af') [23502-173]:
          Caused By: Error executing SQL INSERT INTO concept_reference_term (code, concept_source_id, creator, date_created, description, name, uuid) VALUES ('S', (SELECT concept_source_id FROM concept_reference_source WHERE uuid = 'cb523690-9012-4e72-b8bf-4253e1b1a687'), 1, '2014-08-20 00:00:00.0', 'Duration in Second(s)', 'Second(s)', 'd0d36e69-402e-453e-8a7a-aec44c2915af'): NULL not allowed for column "RETIRED"; SQL statement:
INSERT INTO concept_reference_term (code, concept_source_id, creator, date_created, description, name, uuid) VALUES ('S', (SELECT concept_source_id FROM concept_reference_source WHERE uuid = 'cb523690-9012-4e72-b8bf-4253e1b1a687'), 1, '2014-08-20 00:00:00.0', 'Duration in Second(s)', 'Second(s)', 'd0d36e69-402e-453e-8a7a-aec44c2915af') [23502-173]:
          Caused By: NULL not allowed for column "RETIRED"; SQL statement:
INSERT INTO concept_reference_term (code, concept_source_id, creator, date_created, description, name, uuid) VALUES ('S', (SELECT concept_source_id FROM concept_reference_source WHERE uuid = 'cb523690-9012-4e72-b8bf-4253e1b1a687'), 1, '2014-08-20 00:00:00.0', 'Duration in Second(s)', 'Second(s)', 'd0d36e69-402e-453e-8a7a-aec44c2915af') [23502-173]
	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:228)
	... 32 more
Caused by: liquibase.exception.DatabaseException: Error executing SQL INSERT INTO concept_reference_term (code, concept_source_id, creator, date_created, description, name, uuid) VALUES ('S', (SELECT concept_source_id FROM concept_reference_source WHERE uuid = 'cb523690-9012-4e72-b8bf-4253e1b1a687'), 1, '2014-08-20 00:00:00.0', 'Duration in Second(s)', 'Second(s)', 'd0d36e69-402e-453e-8a7a-aec44c2915af'): NULL not allowed for column "RETIRED"; SQL statement:
INSERT INTO concept_reference_term (code, concept_source_id, creator, date_created, description, name, uuid) VALUES ('S', (SELECT concept_source_id FROM concept_reference_source WHERE uuid = 'cb523690-9012-4e72-b8bf-4253e1b1a687'), 1, '2014-08-20 00:00:00.0', 'Duration in Second(s)', 'Second(s)', 'd0d36e69-402e-453e-8a7a-aec44c2915af') [23502-173]
	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)
	... 36 more
Caused by: org.h2.jdbc.JdbcSQLException: NULL not allowed for column "RETIRED"; SQL statement:
INSERT INTO concept_reference_term (code, concept_source_id, creator, date_created, description, name, uuid) VALUES ('S', (SELECT concept_source_id FROM concept_reference_source WHERE uuid = 'cb523690-9012-4e72-b8bf-4253e1b1a687'), 1, '2014-08-20 00:00:00.0', 'Duration in Second(s)', 'Second(s)', 'd0d36e69-402e-453e-8a7a-aec44c2915af') [23502-173]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:331)
	at org.h2.message.DbException.get(DbException.java:171)
	at org.h2.message.DbException.get(DbException.java:148)
	at org.h2.table.Column.validateConvertUpdateSequence(Column.java:295)
	at org.h2.table.Table.validateConvertUpdateSequence(Table.java:699)
	at org.h2.command.dml.Insert.insertRows(Insert.java:123)
	at org.h2.command.dml.Insert.update(Insert.java:86)
	at org.h2.command.CommandContainer.update(CommandContainer.java:79)
	at org.h2.command.Command.executeUpdate(Command.java:235)
	at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:181)
	at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:156)
	at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
	... 40 more