How to solve UI Framework error while running reports in KenyaEMR

A user may encounter a UI Framework error while running reports, this may be caused by lack of privileges to openmrs_user or missing some etl tables.

The following provides step-by-step guide;

• Log in to mysql by typing mysql –uroot –p
• Enter correct MySQL password
• Select database by typing use openmrs;
• Type call create_etl_tables();
• Type call sp_first_time_setup();
• Type grant all privileges on *.* to ‘openmrs_user’@’localhost’;
• Type flush privileges;

Restart tomcat by typing sudo service tomcat9 restart