Build #73

Plan branch:
Plan for OpenMRS Core 1.11.x

Build: #73 failed Changes by Wyclif Luyima

Stages & jobs

  1. Build and Test

  2. Deploy

Build result summary

Details

Completed
Queue duration
< 1 second
Duration
7 minutes
Labels
None
Revision
b66600d193f70d3fb4e269efc22fe9becea7cc10 b66600d193f70d3fb4e269efc22fe9becea7cc10
Total tests
3230
Fixed in
#74 (Changes by Wyclif Luyima)

Tests

Responsible

Code commits

Author Commit Message Commit date
Wyclif Luyima Wyclif Luyima b66600d193f70d3fb4e269efc22fe9becea7cc10 b66600d193f70d3fb4e269efc22fe9becea7cc10 Support deriving auto_expire_date from duration and duration units for Drug Orders - TRUNK-4446
TRUNK-4446: Infer drug order auto expire date based on duration and frequency

TRUNK-4446: Use uuid for comparision. Improved javadoc for ISO8601Duration

TRUNK-4446: Changes based on PR comments

* Remove unused constants in map type
* Use uuid of concept source
* Exception when duration code is unknown
* Exception when frequency not provide for recurring interval
* Fix uuid, dates in change set.
* New change set for alter column
* Check for duration and units before infering expire date
* Use getEffectiveStartDate to handle scheduled order

TRUNK-4446: Add preconditions for inserting concept source and reference terms

TRUNK-4446: Move migrations from liquibase-core-data.xml to liquibase-update-to-latest.xml

TRUNK-4446: Validate duration units is mapped to ISO 8601 duration when auto expire date is not set

Follow up to remove concept map uuid restriction and moved logic that checks for durations mappings to DrugOrderValidator - TRUNK-4446

Follow up to fix failing tests - TRUNK-4446

Tests

New test failures 8
Status Test View job Duration
Collapse Failed Database1_9_7UpgradeIT shouldConvertOrderersToBeingProvidersInsteadOfUsers History
Integration Test 13 secs 
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]
(70 more lines...)
Collapse Failed Database1_9_7UpgradeIT shouldConcatenateDoseStrengthAndUnits History
Integration Test 8 secs 
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]
(70 more lines...)
Collapse Failed Database1_9_7UpgradeIT shouldCreateDiscontinuationOrderForStoppedOrders History
Integration Test 7 secs 
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]
(70 more lines...)
Collapse Failed Database1_9_7UpgradeIT shouldUpgradeFromClean1_9To1_10 History
Integration Test 7 secs 
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]
(70 more lines...)
Collapse Failed Database1_9_7UpgradeIT shouldMigrateDrugOrders History
Integration Test 8 secs 
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]
(70 more lines...)
Collapse Failed Database1_9_7UpgradeIT shouldSetValuesToNullIfUnitsOrFrequencyBlank History
Integration Test 8 secs 
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]
(70 more lines...)
Collapse Failed Database1_9_7UpgradeIT shouldPassIfAllExistingDrugOrderUnitsAndFrequenciesAreMappedToConcepts History
Integration Test 7 secs 
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]
(70 more lines...)
Collapse Failed Database1_9_7UpgradeIT shouldPassIfThereAreAnyOrderTypesInTheDatabaseOtherThanDrugOrderTypeAndTheNewColumnsExist History
Integration Test 8 secs 
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]
(70 more lines...)

Jira issues

IssueDescriptionStatus
Unknown Issue TypeTRUNK-4446Could not obtain issue details from Jira