Hi, I get an error installing module Reporting. When I try to upload this module from the application I get this error.
So i Manually placed it in the directory modules and restarted tomcat. I can see the module but i’am not able to start it.
Does anyone know a solution?
INFO - Slf4jLogger.info(42) |2021-04-29T12:50:37,894| CREATE INDEX report_definition_uuid_for_reporting_report_design ON openmrs.reporting_report_design(report_definition_uuid) ERROR - Slf4jLogger.severe(22) |2021-04-29T12:50:37,912| Change Set liquibase.xml::reporting_report_design_5::mseaton failed. Error: Key column ‘report_definition_uuid’ doesn’t exist in table [Failed SQL: (1072) CREATE INDEX report_definition_uuid_for_reporting_report_design ON openmrs.reporting_report_design(report_definition_uuid)] INFO - Slf4jLogger.info(42) |2021-04-29T12:50:37,914| Successfully released change log lock WARN - ModuleFactory.startModuleInternal(788) |2021-04-29T12:50:37,915| Error while trying to start module: reporting org.openmrs.module.ModuleException: Unable to update data model using liquibase.xml. Module: Reporting at org.openmrs.module.ModuleFactory.runLiquibase(ModuleFactory.java:997) ~[openmrs-api-2.4.0.jar:?] at org.openmrs.module.ModuleFactory.startModuleInternal(ModuleFactory.java:728) [openmrs-api-2.4.0.jar:?] at org.openmrs.api.context.Daemon$1.run(Daemon.java:80) [openmrs-api-2.4.0.jar:?] Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase.xml::reporting_report_design_5::mseaton: Reason: liquibase.exception.DatabaseException: Key column ‘report_definition_uuid’ doesn’t exist in table [Failed SQL: (1072) CREATE INDEX report_definition_uuid_for_reporting_report_design ON openmrs.reporting_report_design(report_definition_uuid)] at liquibase.changelog.ChangeSet.execute(ChangeSet.java:659) ~[liquibase-core-3.10.2.jar:?] at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:53) ~[liquibase-core-3.10.2.jar:?] at org.openmrs.util.DatabaseUpdater$OpenmrsUpdateVisitor.visit(DatabaseUpdater.java:850) ~[openmrs-api-2.4.0.jar:?] at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:97) ~[liquibase-core-3.10.2.jar:?] at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:232) ~[openmrs-api-2.4.0.jar:?] at org.openmrs.module.ModuleFactory.runLiquibase(ModuleFactory.java:989) ~[openmrs-api-2.4.0.jar:?] … 2 more Caused by: liquibase.exception.DatabaseException: Key column ‘report_definition_uuid’ doesn’t exist in table [Failed SQL: (1072) CREATE INDEX report_definition_uuid_for_reporting_report_design ON openmrs.reporting_report_design(report_definition_uuid)] at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:430) ~[liquibase-core-3.10.2.jar:?] at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:87) ~[liquibase-core-3.10.2.jar:?] at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:159) ~[liquibase-core-3.10.2.jar:?] at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1276) ~[liquibase-core-3.10.2.jar:?] at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1258) ~[liquibase-core-3.10.2.jar:?] at liquibase.changelog.ChangeSet.execute(ChangeSet.java:622) ~[liquibase-core-3.10.2.jar:?] at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:53) ~[liquibase-core-3.10.2.jar:?] at org.openmrs.util.DatabaseUpdater$OpenmrsUpdateVisitor.visit(DatabaseUpdater.java:850) ~[openmrs-api-2.4.0.jar:?] at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:97) ~[liquibase-core-3.10.2.jar:?] at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:232) ~[openmrs-api-2.4.0.jar:?] at org.openmrs.module.ModuleFactory.runLiquibase(ModuleFactory.java:989) ~[openmrs-api-2.4.0.jar:?] … 2 more Caused by: java.sql.SQLSyntaxErrorException: Key column ‘report_definition_uuid’ doesn’t exist in table at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) ~[mysql-connector-java-8.0.21.jar:8.0.21] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.21.jar:8.0.21] at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.21.jar:8.0.21] at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:764) ~[mysql-connector-java-8.0.21.jar:8.0.21] at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648) ~[mysql-connector-java-8.0.21.jar:8.0.21] at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:426) ~[liquibase-core-3.10.2.jar:?] at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:87) ~[liquibase-core-3.10.2.jar:?] at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:159) ~[liquibase-core-3.10.2.jar:?] at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1276) ~[liquibase-core-3.10.2.jar:?] at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1258) ~[liquibase-core-3.10.2.jar:?] at liquibase.changelog.ChangeSet.execute(ChangeSet.java:622) ~[liquibase-core-3.10.2.jar:?] at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:53) ~[liquibase-core-3.10.2.jar:?] at org.openmrs.util.DatabaseUpdater$OpenmrsUpdateVisitor.visit(DatabaseUpdater.java:850) ~[openmrs-api-2.4.0.jar:?] at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:97) ~[liquibase-core-3.10.2.jar:?] at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:232) ~[openmrs-api-2.4.0.jar:?] at org.openmrs.module.ModuleFactory.runLiquibase(ModuleFactory.java:989) ~[openmrs-api-2.4.0.jar:?] … 2 more