How to solve ‘Red Ribbon/banner’; System Did not Load Properly when launching KenyaEMR on the browser

When logging into KenyaEMR and you experience a red banner at the top of the screen notifying you to contact the system administrator use the following steps to resolve:

• Open the terminal and log into MySQL (mysql –uroot –p) and enter password.
• Select openmrs as the default database (use openmrs) and run the following:

                 set foreign_key_checks=0;

                            delete from location;

                            delete from location_identifier;

                            set foreign_key_checks=1;

Restart tomcat.