Details

    • Type: Bug
    • Status: Closed
    • Priority: Must
    • Resolution: Fixed
    • Affects Version/s: OpenMRS 1.9.0
    • Fix Version/s: OpenMRS 1.9.0, 1.9 Beta Sprint
    • Component/s: None
    • Labels:
      None
    • Complexity:
      Low

      Description

      While trying to upgrade from 1.8 to 1.9, i got the exception below:

      
      SEVERE 10/17/11 5:41 PM:liquibase: Change Set liquibase-update-to-latest.xml::20110301-1030f::wyclif failed.  Error: liquibase.exception.CustomChangeException: Failed to insert one or more concept map types
      liquibase.exception.UnexpectedLiquibaseException: liquibase.exception.CustomChangeException: Failed to insert one or more concept map types
      	at liquibase.change.custom.CustomChangeWrapper.generateStatements(CustomChangeWrapper.java:115)
      	at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:996)
      	at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
      	at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
      	at org.openmrs.util.DatabaseUpdater$1OpenmrsUpdateVisitor.visit(DatabaseUpdater.java:199)
      	at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
      	at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:224)
      	at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:164)
      	at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:149)
      	at org.openmrs.web.filter.update.UpdateFilter$UpdateFilterCompletion$1.run(UpdateFilter.java:577)
      	at java.lang.Thread.run(Thread.java:680)
      Caused by: liquibase.exception.CustomChangeException: Failed to insert one or more concept map types
      	at org.openmrs.util.databasechange.AddConceptMapTypesChangeset.runBatchInsert(AddConceptMapTypesChangeset.java:169)
      	at org.openmrs.util.databasechange.AddConceptMapTypesChangeset.execute(AddConceptMapTypesChangeset.java:72)
      	at liquibase.change.custom.CustomChangeWrapper.generateStatements(CustomChangeWrapper.java:110)
      	... 10 more
      INFO 10/17/11 5:41 PM:liquibase: Successfully released change log lock
      ERROR - UpdateFilter$UpdateFilterCompletion$1.run(595) |2011-10-17 17:41:34,407| Unable to update the database
      org.openmrs.util.DatabaseUpdateException: 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::20110301-1030f::wyclif:
           Reason: liquibase.exception.UnexpectedLiquibaseException: liquibase.exception.CustomChangeException: Failed to insert one or more concept map types:
                Caused By: liquibase.exception.CustomChangeException: Failed to insert one or more concept map types:
                Caused By: Failed to insert one or more concept map types
      	at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:152)
      	at org.openmrs.web.filter.update.UpdateFilter$UpdateFilterCompletion$1.run(UpdateFilter.java:577)
      	at java.lang.Thread.run(Thread.java:680)
      Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase-update-to-latest.xml::20110301-1030f::wyclif:
           Reason: liquibase.exception.UnexpectedLiquibaseException: liquibase.exception.CustomChangeException: Failed to insert one or more concept map types:
                Caused By: liquibase.exception.CustomChangeException: Failed to insert one or more concept map types:
                Caused By: Failed to insert one or more concept map types
      	at liquibase.changelog.ChangeSet.execute(ChangeSet.java:347)
      	at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
      	at org.openmrs.util.DatabaseUpdater$1OpenmrsUpdateVisitor.visit(DatabaseUpdater.java:199)
      	at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
      	at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:224)
      	at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:164)
      	at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:149)
      	... 2 more
      Caused by: liquibase.exception.UnexpectedLiquibaseException: liquibase.exception.CustomChangeException: Failed to insert one or more concept map types
      	at liquibase.change.custom.CustomChangeWrapper.generateStatements(CustomChangeWrapper.java:115)
      	at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:996)
      	at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
      	... 8 more
      Caused by: liquibase.exception.CustomChangeException: Failed to insert one or more concept map types
      	at org.openmrs.util.databasechange.AddConceptMapTypesChangeset.runBatchInsert(AddConceptMapTypesChangeset.java:169)
      	at org.openmrs.util.databasechange.AddConceptMapTypesChangeset.execute(AddConceptMapTypesChangeset.java:72)
      	at liquibase.change.custom.CustomChangeWrapper.generateStatements(CustomChangeWrapper.java:110)
      	... 10 more
      INFO 10/17/11 5:41 PM:liquibase: Reading from `liquibasechangelog`
      INFO 10/17/11 6:17 PM:liquibase: Reading from `liquibasechangelog`
      INFO 10/17/11 6:17 PM:liquibase: Successfully acquired change log lock
      INFO 10/17/11 6:17 PM:liquibase: Reading from `liquibasechangelog`
      WARN - AddConceptMapTypesChangeset.runBatchInsert(147) |2011-10-17 18:17:52,305| Error generated while processsing batch insert
      java.sql.BatchUpdateException: Unknown column 'is_hidden' in 'field list'
      	at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2016)
      	at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1452)
      	at org.openmrs.util.databasechange.AddConceptMapTypesChangeset.runBatchInsert(AddConceptMapTypesChangeset.java:132)
      	at org.openmrs.util.databasechange.AddConceptMapTypesChangeset.execute(AddConceptMapTypesChangeset.java:72)
      	at liquibase.change.custom.CustomChangeWrapper.generateStatements(CustomChangeWrapper.java:110)
      	at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:996)
      	at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
      	at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
      	at org.openmrs.util.DatabaseUpdater$1OpenmrsUpdateVisitor.visit(DatabaseUpdater.java:199)
      	at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
      	at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:224)
      	at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:164)
      	at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:149)
      	at org.openmrs.web.filter.update.UpdateFilter$UpdateFilterCompletion$1.run(UpdateFilter.java:577)
      	at java.lang.Thread.run(Thread.java:680)
      
      

      Looks like this custom changeset is using the is_hidden column before the changeset which renames the badly named column from isHidden to is_hidden

        Gliffy Diagrams

          Attachments

            Attachments-Category-Modification

              Activity

                People

                • Assignee:
                  dkayiwa Daniel Kayiwa
                  Reporter:
                  dkayiwa Daniel Kayiwa
                  Watchers:
                  Ben Wolfe, Daniel Kayiwa, Darius Jazayeri, Wyclif Luyima
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  4 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: