By Mistake Legacy UI module and not, its not started


(Riyad Sarker) #1

Hi, My openMrs was running. By mistake I dactived legacy UI module. Now its not started anymore. Just showing :

I copied legacy-ui-1.4.2.omod file into : C:\Windows\System32\config\systemprofile\Application Data\OpenMRS

But still not running.

here is my openmrs log file: https://pastebin.com/wqjVZqXX

tomcat log: https://pastebin.com/96Hkys01

Any suggestion ? I’m in big trouble.


(Daniel Kayiwa) #2

In your database’s global_property table, what is the value of this property? legacyui.started


(Riyad Sarker) #3

I was false, I just change it true.


(Daniel Kayiwa) #4

After changing it to true, restart tomcat and tell us what happens.


(Riyad Sarker) #5

Application started but: Logic module not working:

Reporting module also:


(Daniel Kayiwa) #6

Just get rid of the logic module


(Riyad Sarker) #7

Sorry for late reply. Reporting tool not working: see the screenshot:

openmrs log: https://pastebin.com/iiK25hUT


(Daniel Kayiwa) #8

Which version of the reporting module are you running?

On the reporting_report_design table, do you have a foreign key constraint named? report_definition_id_for_reporting_report_design


(Riyad Sarker) #9

This is the DDL of reporting_repoty_design table :

CREATE TABLE `reporting_report_design` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uuid` char(38) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` varchar(1000) DEFAULT NULL,
  `report_definition_id` int(11) NOT NULL DEFAULT '0',
  `renderer_type` varchar(255) NOT NULL,
  `properties` text,
  `creator` int(11) NOT NULL DEFAULT '0',
  `date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `changed_by` int(11) DEFAULT NULL,
  `date_changed` datetime DEFAULT NULL,
  `retired` tinyint(1) NOT NULL DEFAULT '0',
  `retired_by` int(11) DEFAULT NULL,
  `date_retired` datetime DEFAULT NULL,
  `retire_reason` varchar(255) DEFAULT NULL,
  `report_definition_uuid` char(38) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `report_definition_id for reporting_report_design` (`report_definition_id`),
  KEY `creator for reporting_report_design` (`creator`),
  KEY `changed_by for reporting_report_design` (`changed_by`),
  KEY `retired_by for reporting_report_design` (`retired_by`),
  KEY `report_definition_uuid_for_reporting_report_design` (`report_definition_uuid`),
  CONSTRAINT `changed_by for reporting_report_design` FOREIGN KEY (`changed_by`) REFERENCES `users` (`user_id`),
  CONSTRAINT `creator for reporting_report_design` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`),
  CONSTRAINT `report_definition_id for reporting_report_design` FOREIGN KEY (`report_definition_id`) REFERENCES `serialized_object` (`serialized_object_id`),
  CONSTRAINT `retired_by for reporting_report_design` FOREIGN KEY (`retired_by`) REFERENCES `users` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8

(Daniel Kayiwa) #10

Which version of the reporting module are you running?


(Riyad Sarker) #11

Reporting Module: I tried all version from 0.9.8.1 to 1.15.0 openmrs 2.0.6 please see the screenshot:


(Daniel Kayiwa) #12

Do you have any data in the reporting_report_design table?


(Riyad Sarker) #13

Yes, I’ve data on reporting_report_design table. Please screenshot:

What should I’ve to do now?


(Daniel Kayiwa) #14

Start by removing the foreign key constraint named “report_definition_id_for_reporting_report_design”


(Riyad Sarker) #15

Removed it from DB, but same result. See current foreign keys for this table:

openmrs log: https://pastebin.com/UpjUdtnC


(Daniel Kayiwa) #16

The validation exception that you are getting looks like you are running a lower version of the reporting module.


(Riyad Sarker) #17

reporting module: 1.15

and here is the global property:

What should I do now ?


(Daniel Kayiwa) #18

Go to the “liquibasechangelog” table and delete rows with ID in (reporting_report_design_1, reporting_report_design_4, reporting_report_design_5)

Then try again.


(Riyad Sarker) #19

Did it. Now reporting module start . But its blank.

Tomcat log: https://pastebin.com/65xCnVkn


(Daniel Kayiwa) #20

Restart tomcat.