Troubleshooting Tips

This section contains tips and tricks to help maintain your installation, as well as a general guide to common problems

My installation cannot start

Restart your computer

Error Messages and Screenshots

When you login the screen may display as below:

Resolution

On the Administration page, select the Manage Modules link
Click the Start All button
Restart your computer

OpenMRS cannot start - Error creating bean with name "messageSourceServiceTarget"

Error Messages and Screenshots

Resolution

Delete the folder C:\Application Data\OpenMRS\lucene
Restart your computer

White screen appears when carrying out administrative tasks like module installation, upgrade

Error messages and Screenshots

Resolution

Restart your computer and repeat the action that caused the error

Cohort Builder does not Allow defining of Columns

Screen Shots Of The Problem

Root Cause

The root cause of this problem is due to the addition of other programs into the UgandaEMR system by an individual( which is prohibited ) that is done by creation of concepts and thereby resulting into concept mismatch with concepts that come with UgandaEMR.

Resolution

Download the concept dictionary from the source https://sourceforge.net/projects/ugandaemr/files/1.0.13/concept_dictonary_ref_1.0.13.sql/download
Open your command Prompt and login to mysql with the following command without quotes "mysql -u openmrs -p" and provide it with the required password
Run the concept dictionary downloaded on your database in your command prompt

After the concept dictionary is done, run the following script on the same command prompt

/*!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 */;

DELETE from patient_program ;
DELETE from program;

/*!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 */;

Restart your computer

Client ART Number not Showing

Screen Shots Of The Problem

Resolution

Open your command Prompt and login to mysql with the following command without quotes "mysql -u openmrs -p" and provide it with the required password

Run the following script on your database in your command prompt

REPLACE INTO metadatamapping_metadata_set_member (metadata_set_member_id, metadata_set_id, metadata_class, metadata_uuid, sort_weight, name, description, creator, date_created, changed_by, date_changed, retired, date_retired, retired_by, retire_reason, uuid)
SELECT 1, 1, 'org.openmrs.PatientIdentifierType', 'e1731641-30ab-102d-86b0-7a5022ba4115',null, null, null, 2, NOW(), null, null, 0, null, null, null,'57c7a9df-193d-4d44-b34a-3156e6204bde';