Trouble Shooting

backupdatabase script has an access denied error

This is because the password for root has changed from a blank password

1.Open the backup database (or backupdatabase.bat) file in Notepad and add the following to the line that starts with @mysqldump

@mysqldump -ppassword

password is the password of the root account, and there is no space after the -p

2.Doubleclick the backupdatabase file

upgradedatabase script has an error - openmrs_backup database not found

This is because the installer did not create the openmrs_backup database. Uninstall UgandaEMR and start again

openmrs_backup database not found

upgradedatabase script error 2003 - Can't connect to MySQL server on local host (10061)

This is because the password for root has changed from a blank password

1.Open the upgradedatabase (or upgradedatabase.bat) file in Notepad and add the following to the line that starts with @mysqldump

@mysql -ppassword password is the password of the root account, and there is no space after the -p

2.Doubleclick the upgradedatabase file

Upgrade failed so need to reset environment

In case your upgrade fails, there is a need to restore the environment so that you can try again.

The steps are as follows:

1. Backup the openmrs database

2. Delete the openmrs and openmrs_backup databases

3. Create a new openmrs and openmrs_backup databases

4. On the openmrs database run the following scripts:

   • new-install.sql - this one creates a blank database for UgandaEMR

   • concept_dictionary script - use the latest version

5. Restart your computer so that UgandaEMR can start

6. Run the upgrade again

Error starting uploaded module

This is usually characterized by a green arrow next to the module name, an error message at the top of the Manage Modules page and a text box in the row of the module name with the words "Error starting! Click here for details" 1.Click the text box to find out the details of why the module did not start:

• If the error is caused by a missing module then upload the module following the steps above

• If the error is caused by a higher version of a module, then upgrade the module to that higher version. Please note that this may cause additional errors in other modules that may be incompatible with the higher version.

• If a lower version of a module is required, then you may need to upload a lower version of the module, though this may cause other modules to fail loading

2.Restart the computer which resets all UgandaEMR services.

UI Framework Error: Null Pointer Exception on Patient Registration

A common cause is blank entries in the address hierarchy during the upgrade process as seen in the link below

1. Click the Administration link in the top menu as below:

   
2. Click the Manage Address Hierarchy link on the administration dashboard

   
3. Delete all the address hierarchy entries in the rectangle which are causing the error one level at a time

   

Address hierarchy is not installed properly with missing entries and unable to delete any levels

This happens in case there is an error when loading the entries for the address hierarchy see screenshot below

partially loaded address hierarchy

The fix is by deleting the current address hierarchy entries, then restarting your computer so that it is loaded properly.

1. Backup your database

2. Run the SQL commands below:

   /!40101 SET @OLD_CHARACTER_SET_CLIENT = @@CHARACTER_SET_CLIENT /; /!40101 SET @OLD_CHARACTER_SET_RESULTS = @@CHARACTER_SET_RESULTS /; /!40101 SET @OLD_COLLATION_CONNECTION = @@COLLATION_CONNECTION /; /!40101 SET NAMES utf8 /; /!40103 SET @OLD_TIME_ZONE = @@TIME_ZONE /; /!40103 SET TIME_ZONE = '+00:00' /; /!40014 SET @OLD_UNIQUE_CHECKS = @@UNIQUE_CHECKS, UNIQUE_CHECKS = 0 /; /!40014 SET @OLD_FOREIGN_KEY_CHECKS = @@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS = 0 /; /!40101 SET @OLD_SQL_MODE = @@SQL_MODE, SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO' /; /!40111 SET @OLD_SQL_NOTES = @@SQL_NOTES, SQL_NOTES = 0 /;

   / The address hierarchy may be installed before so this causes problems - remove instal trail of the address hierarchy / DELETE FROM global_property WHERE property IN ('address.format', 'addresshierarchy.database_version', 'addresshierarchy.mandatory', 'addresshierarchy.started', 'metadatadeploy.bundle.version.org.openmrs.module.aijar.api.deploy.bundle.UgandaAddressMetadataBundle');

   / Drop the address hierarchy tables if necessary / ALTER TABLE address_hierarchy_address_to_entry_map DROP FOREIGN KEY address_id_to_person_address_table; ALTER TABLE address_hierarchy_address_to_entry_map DROP FOREIGN KEY entry_id_to_address_hierarchy_table; ALTER TABLE address_hierarchy_entry DROP FOREIGN KEY level_to_level; ALTER TABLE address_hierarchy_entry DROP FOREIGN KEY parent-to-parent; ALTER TABLE address_hierarchy_level DROP FOREIGN KEY parent_level; DROP TABLE IF EXISTS address_hierarchy_address_to_entry_map; DROP TABLE IF EXISTS address_hierarchy_entry; DROP TABLE IF EXISTS address_hierarchy_level;

   /!40101 SET SQL_MODE = @OLD_SQL_MODE /; /!40014 SET FOREIGN_KEY_CHECKS = @OLD_FOREIGN_KEY_CHECKS /; /!40014 SET UNIQUE_CHECKS = @OLD_UNIQUE_CHECKS /; /!40101 SET CHARACTER_SET_CLIENT = @OLD_CHARACTER_SET_CLIENT /; /!40101 SET CHARACTER_SET_RESULTS = @OLD_CHARACTER_SET_RESULTS /; /!40101 SET COLLATION_CONNECTION = @OLD_COLLATION_CONNECTION /; /!40111 SET SQL_NOTES = @OLD_SQL_NOTES /;

3. Restart your computer

Error starting Data Integrity Module

This error tends to happen from UgandaEMR 1.0.16 that requires this module to be available, which is based on upgrades from old versions of OpenMRS that had the data integrity module installed. The old version of a module left a dataintegrity tables installed, so the new version cannot replace some tables.

The fix involves deleting the dataintegrity_rule table using different tools:

1. Command line

   • Connect to the database using the command

   mysql -u openmrs -p which will request for a password

   • Change to the openmrs database

   use openmrs

   • Delete the dataintegrity tables - not all of these may exist in your installation

   DROP TABLE IF EXISTS dataintegrity_run; DROP TABLE IF EXISTS dataintegrity_result; DROP TABLE IF EXISTS dataintegrity_column; DROP TABLE IF EXISTS dataintegrity_check; DROP TABLE IF EXISTS dataintegrity_integrity_checks; DROP TABLE IF EXISTS dataintegrity_result; DROP TABLE IF EXISTS dataintegrity_rule;

   • Delete previous liquibase change logs for data integrity

   DELETE FROM liquibasechangelog WHERE ID LIKE '%data-integrity%';

   • Restart your computer

2. Heidi SQL

   • Download the upgrade script from https://sourceforge.net/projects/ugandaemr/files/1.0.16/dataintegritymodule_cleanup-1.0.16.sql/download

   • Open a connection to the openmrs database on port 3306

   • Open File -> Load SQL File and load the downloaded file

Mysql cannot start after 2.0 upgrade or installation

1. Go to start menu, search for services.

2. Under Services look for mysql.

3. Stop mysql service

4. Go to C:\ProgramData\MySQL\MySQL Server 5.5\data

5. Delete the following files:

   • ib_logfile0

   • ib_logfile1

6. Restart mysql from services.

Tomcat Failing to start after 2.0 upgrade or installation

1. Go to Menu search for Launch Tomcat Manager and clink on it

2. After check the notification area and right click on tomcat icon
3. Select Configuretion and a popup window will show

4. Go to the Java Tab and select Use default.

5. Incase there are some text in the Java Options:, remove them and click apply

6. Go back to General tab and click start, to start tomcat