Uploaded image for project: 'OpenMRS Core'
  1. OpenMRS Core
  2. TRUNK-4390

Improve OpenMRS 1.10 database upgrade script

    XMLWordPrintable

Details

    Description

      If the order_type table is empty or only has the drug order type, could the database update script automatically add the new columns? It looks like the script should do this per the listed database update steps...

      Adding java_class_name column to order_type table	Add Column	wyclif
      	Adding parent column to order_type table	Add Column	wyclif
      

      Currently you have to add the columns manually (which is documented) or you get the following error...

      ??? Reason: ???
      Unable to update the database. See server error logs for the full stacktrace.
      ???:???
      ??? liquibase-update-to-latest.xml : Cannot update order_type table, please see the 1.10 release notes for how to modify the order_type table before upgrading ???
      ???There was an error while updating the database to the latest. file: liquibase-update-to-latest.xml. Error: Migration failed for change set liquibase-update-to-latest.xml::201404091110::wyclif:???
      ??? Caused By: Preconditions Failed???
      

      This happens when upgrading from OpenMRS 1.9.7.

      Gliffy Diagrams

        Attachments

          Issue Links

            Activity

              People

                wyclif Wyclif Luyima
                arbaughj James Arbaugh
                Votes:
                0 Vote for this issue
                Watchers:
                8 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  Time Tracking

                    Estimated:
                    Original Estimate - 4 hours
                    4h
                    Remaining:
                    Time Spent - 1 hour Remaining Estimate - 3 hours
                    3h
                    Logged:
                    Time Spent - 1 hour Remaining Estimate - 3 hours
                    1h