Launch of the splash screen
Selecting components to install. Select Restore Existing UgandaEMR database if you have any data backed up from any older version of UgandaEMR
Determining Installation directory
Confirm start menu item
Install Java Runtime
8.Install Tomcat This is a silent process in the background
11.UgandaEMR Installation completed
Incase the screen below appears,
To fix this:
Go to the start menu
Select UgandaEMR and select Connect Database Path and let it run and correct the path
3. Restart your computer 4. Start UgandaEMR using the Desktop shortcut
An error similar to the one below is shown in the log files:
WARN - ModuleFactory.startModuleInternal(788) |2018-03-22 16:58:39,213| Error while trying to start module: metadatamappingorg.openmrs.module.ModuleException: Unable to update data model using liquibase.xml. Module: Metadata Mappingat org.openmrs.module.ModuleFactory.runLiquibase(ModuleFactory.java:1034)at org.openmrs.module.ModuleFactory.startModuleInternal(ModuleFactory.java:728)at org.openmrs.api.context.Daemon$1.run(Daemon.java:74)Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase.xml::metadatamapping-2016-02-07-1310-b-mysql::kosmik:Reason: liquibase.exception.DatabaseException: Error executing SQL create index metadatamapping_idx_mdtm_mdclass on metadatamapping_metadata_term_mapping(metadata_class(255)): Duplicate key name 'metadatamapping_idx_mdtm_mdclass':Caused By: Error executing SQL create index metadatamapping_idx_mdtm_mdclass on metadatamapping_metadata_term_mapping(metadata_class(255)): Duplicate key name 'metadatamapping_idx_mdtm_mdclass':Caused By: Duplicate key name 'metadatamapping_idx_mdtm_mdclass'
Fix: Run the following SQL statement on the openmrs database then restart your computer
DROP index metadatamapping_idx_mdtm_mdclass ON metadatamapping_metadata_term_mapping;
During the upgrade process, a configuration file is copied which may cause the system to crash due to a conflict in the sizes of the MySQL log files before upgrade and after upgrade. The steps below are to remove the log files causing the conflict
Open Services console and stop the UgandaEMR MySQL service
Using windows explorer navigate to the MySQL folder, either C:\Program Files\MySQL\Data or C:\Program Files\MySQL 5.5\Data
Delete the files named idblog
Restart your computer
The connection error should be resolved.
There are two issues that have been identified that cause this:
The maximum packet size for the MySQL server is too small so needs to be increased to 16M
The serialized column where the Excel template is stored does not allow the special characters to be saved.
The fix is therefore a 2 step process:
Increase the maximum packet size for the MySQL server:
Open Notepad as an administrator - this is because the configuration file being edited in located in the C:\Program Files folder which has restrictions on who can edit the files.
Open the file my.cnf (or my in case Windows Explorer is configured to hide the extensions for files)
Search for the variable max_allowed_packet and change is value to 16M
If the variable does not exists add it following the steps below:
Search for the section [mysqld]
Save the file
Restart your computer
Run the following on the command prompt
mysql -u openmrs -p -e "SHOW GLOBAL VARIABLES LIKE 'max_allowed_packet'" which will show 16777216 which means the variable has been changed
Fix the character set of the serialized column by running the following SQL statement on the openmrs database:
ALTER TABLE `serialized_object` MODIFY `serialized_data` MEDIUMTEXT CHARACTER SET utf8 NOT NULL;
Restart your computer
This issue has been identified to be caused by the Improper un-installation process of UgandaEMR.
This is normally done by deleting of the the UgandaEMR Folder in the C:\Program Files folder which is not recommended.
The recommended un-installation process can be found here.
To fix this issue.
Uninstall the UgandaEMR you have just installed in the recommended way
Open the command prompt as an Administrator by searching Command prompt in the windows task bar , and then press Ctrl+Shift+Enter
On your command prompt, type "sc delete UgandaEMRTomcat " without quotes and press enter.
If it shows no error, restart your computer and install UgandaEMR freshly as recommended here.