Build #73

Plan branch:
Plan for OpenMRS Core 1.11.x

Build: #73 failed

Job: Integration Test failed

Stages & jobs

  1. Build and Test

  2. Deploy

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 73 of OpenMRS Core - OpenMRS Core 1.11.x - 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
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.shouldPassIfAllExistingDrugOrderUnitsAndFrequenciesAreMappedToConcepts(Database1_9_7UpgradeIT.java:248)
	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