UI Framework Error when running reports

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 to sort the error described;
Log in to mysql by typing

1. mysql –uroot –p [ENTER]
   

Enter correct MySQL password and select database by typing

1. use openmrs; [ENTER]
   

Type the following commands as you press [ENTER]

1. call create_etl_tables();
   

2. call sp_first_time_setup();
   

3. grant all privileges on *.* to 'openmrs_user'@'localhost';
   

4. flush privileges;
   

Restart tomcat by typing

1. sudo service tomcat9 restart [ENTER]