# 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

## UgandaEMR login screen not available yet system starts

**Error Messages and Screenshots**\
![Login Error no modules started](https://2263683135-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4YKhNOQtSxoP0vCjuG%2F-M4y-MlFbjPpenC-zM3Y%2F-M4y-ZiQeMy2Nzyj25ma%2Flogin_error_modules_not_started.png?generation=1586957054425479\&alt=media)

When you login the screen may display as below:

![Modules not started errors](https://2263683135-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4YKhNOQtSxoP0vCjuG%2F-M4y-MlFbjPpenC-zM3Y%2F-M4y-ZiSSmX62RTPGPqi%2Fmodule_not_started_error-1.jpg?generation=1586957054513036\&alt=media)

![Modules not started due to cyclic dependencies](https://2263683135-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4YKhNOQtSxoP0vCjuG%2F-M4y-MlFbjPpenC-zM3Y%2F-M4y-ZiUyDvRIR8tPvKY%2Fmodule_not_started_error_2.png?generation=1586957054632811\&alt=media)

**Resolution**

1.  On the Administration page, select the Manage Modules link

    <img src="https://2263683135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M4YKhNOQtSxoP0vCjuG%2Fuploads%2Fgit-blob-6559ac5e0b763c3da3f3b23a2e24f1119264d8c9%2Fmanage_modules_link.png?alt=media" alt="Manage Modules" data-size="original">
2.  Click the Start All button

    <img src="https://2263683135-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4YKhNOQtSxoP0vCjuG%2F-M4y-MlFbjPpenC-zM3Y%2F-M4y-ZiXmBHOgcu86IWV%2Fmodules_start_all.png?generation=1586957054528035&#x26;alt=media" alt="Start All Modules" data-size="original">
3. Restart your computer

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

**Error Messages and Screenshots**

![OpenMRS cannot start - Error creating bean of name "messageSourceServiceTarget"](https://2263683135-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4YKhNOQtSxoP0vCjuG%2F-M4y-MlFbjPpenC-zM3Y%2F-M4y-ZiZ9AdysGLPLnoJ%2Ferror_message_source.jpg?generation=1586957054304955\&alt=media)

**Resolution**

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

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

**Error messages and Screenshots**\
![Error - White Screen during operation](https://2263683135-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4YKhNOQtSxoP0vCjuG%2F-M4y-MlFbjPpenC-zM3Y%2F-M4y-ZiaqX2AFFQYlmob%2Ferror_white_screen.jpeg?generation=1586957054641837\&alt=media)

**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**

![](https://2263683135-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4YKhNOQtSxoP0vCjuG%2F-M4y-MlFbjPpenC-zM3Y%2F-M4y-X6iPLIRBnWi6aGE%2Fcohort-builder.jpeg?generation=1586957044104830\&alt=media) ![](https://2263683135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M4YKhNOQtSxoP0vCjuG%2Fuploads%2Fgit-blob-4d7e9b97e9ed463fc1489c42b8ed38995fe893f2%2Fcohortbuilder-problem%20\(1\).jpeg?alt=media)

### 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.

![](https://2263683135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M4YKhNOQtSxoP0vCjuG%2Fuploads%2Fgit-blob-a866b2776a320507aca4b527152ca5528de71425%2Fprogram-problem%20\(1\).jpeg?alt=media)

### Resolution

1. Download the concept dictionary from the source [https://sourceforge.net/projects/ugandaemr/files/1.0.13/concept\_dictonary\_ref\_1.0.13.sql/download](https://sourceforge.net/projects/ugandaemr/files/1.0.13/concept_dictonary_ref_1.0.13.sql/download)
2. 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
3. Run the concept dictionary downloaded on your database in your command prompt
4.  After the concept dictionary is done, run the following script on the same command prompt

    ```sql
    /*!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 */;
    ```
5. Restart your computer

## Client ART Number not Showing

**Screen Shots Of The Problem**

![](https://github.com/METS-Programme/ugandaemr-usermanual/blob/master/assets/art-number-not-showing.jpeg)

### Resolution

1. 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
2.  Run the following script on your database in your command prompt

    ```sql
    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';
    ```
3. Refresh your computer browser.
