application Name: Platform openmrs, openmrs-module-radiology Version Number: 2.0.5
Hi,
I’m a student and I’m working on the integration of openmrs-module-radiology in openmrs on my thesis.
I have built and installed the openmrs-module-radiology as described in the following tutorial: https://github.com/openmrs/openmrs-module-radiology#openmrs-module-radiology.
I’m facing a problem while trying to start the module and I’m getting this error:
WARN - ModuleFactory.startModuleInternal(788) |2017-06-29 12:35:51,070| Error while trying to start module: radiology
org.openmrs.module.ModuleException: Unable to update data model using liquibase.xml. Module: Radiology
at org.openmrs.module.ModuleFactory.runLiquibase(ModuleFactory.java:1034)
at org.openmrs.module.ModuleFactory.startModuleInternal(ModuleFactory.java:728)
at org.openmrs.api.context.Daemon$1.run(Daemon.java:74)
Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase.xml::radiology-4::juanp:
Reason: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE radiology_study
(id
INT AUTO_INCREMENT NOT NULL, uid
VARCHAR(255) NULL, order_id
INT NULL, scheduled_status
INT DEFAULT -1 NULL, performed_status
INT DEFAULT -1 NULL, priority
INT DEFAULT -1 NULL, modality
INT DEFAULT -1 NULL, scheduler_user_id
INT DEFAULT -1 NULL, performing_physician_user_id
INT DEFAULT -1 NULL, reading_physician_user_id
INT DEFAULT -1 NULL, mwl_status
INT DEFAULT -1 NULL, CONSTRAINT PK_RADIOLOGY_STUDY
PRIMARY KEY (id
), UNIQUE (order_id
)): Table ‘radiology_study’ already exists:
Caused By: Error executing SQL CREATE TABLE radiology_study
(id
INT AUTO_INCREMENT NOT NULL, uid
VARCHAR(255) NULL, order_id
INT NULL, scheduled_status
INT DEFAULT -1 NULL, performed_status
INT DEFAULT -1 NULL, priority
INT DEFAULT -1 NULL, modality
INT DEFAULT -1 NULL, scheduler_user_id
INT DEFAULT -1 NULL, performing_physician_user_id
INT DEFAULT -1 NULL, reading_physician_user_id
INT DEFAULT -1 NULL, mwl_status
INT DEFAULT -1 NULL, CONSTRAINT PK_RADIOLOGY_STUDY
PRIMARY KEY (id
), UNIQUE (order_id
)): Table ‘radiology_study’ already exists:
Caused By: Table ‘radiology_study’ already exists
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:189)
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:218)
at org.openmrs.module.ModuleFactory.runLiquibase(ModuleFactory.java:1024)
… 2 more
Caused by: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE radiology_study
(id
INT AUTO_INCREMENT NOT NULL, uid
VARCHAR(255) NULL, order_id
INT NULL, scheduled_status
INT DEFAULT -1 NULL, performed_status
INT DEFAULT -1 NULL, priority
INT DEFAULT -1 NULL, modality
INT DEFAULT -1 NULL, scheduler_user_id
INT DEFAULT -1 NULL, performing_physician_user_id
INT DEFAULT -1 NULL, reading_physician_user_id
INT DEFAULT -1 NULL, mwl_status
INT DEFAULT -1 NULL, CONSTRAINT PK_RADIOLOGY_STUDY
PRIMARY KEY (id
), UNIQUE (order_id
)): Table ‘radiology_study’ already exists
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)
at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
… 7 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table ‘radiology_study’ already exists
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2768)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:949)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:795)
at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
… 11 more
INFO - LoggingAdvice.invoke(115) |2017-06-29 12:35:51,111| In method AlertService.saveAlert. Arguments: Alert=Alert: #null,
INFO - LoggingAdvice.invoke(155) |2017-06-29 12:35:51,113| Exiting method saveAlert
please how to fix that?