Build #572

Plan branch:
OpenMRS Core Master

Build: #572 failed Changes by Wyclif Luyima

Stages & jobs

  1. Build and Test

Build result summary

Details

Completed
Queue duration
2 seconds
Duration
9 minutes
Labels
None
Revisions
openmrs-core
0e8cda11ba408bfcf558972c07cebd3b9e9e4f2d 0e8cda11ba408bfcf558972c07cebd3b9e9e4f2d
openmrs-standalone
7846ba5c39c96915e4beabea86017b4afea2727f 7846ba5c39c96915e4beabea86017b4afea2727f
Total tests
3237
Fixed in
#573 (Changes by Wyclif Luyima)

Tests

Responsible

Code commits

openmrs-core
Author Commit Message Commit date
Wyclif Luyima Wyclif Luyima 0e8cda11ba408bfcf558972c07cebd3b9e9e4f2d 0e8cda11ba408bfcf558972c07cebd3b9e9e4f2d 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

Configuration changes

Some of the jobs or stages referenced by this result no longer exist.

Restarting failed/incomplete builds only is not possible as some of the affected jobs no longer exist.

Tests

New test failures 8
Status Test View job Duration
Collapse Failed Database1_9_7UpgradeIT shouldConvertOrderersToBeingProvidersInsteadOfUsers History
Integration Test 10 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 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 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 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 shouldSetValuesToNullIfUnitsOrFrequencyBlank 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 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 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...)

Jira issues

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