Loading data from EMR using DWAPI

Checks to perform when you encounter this error;

• DWAPI configurations
• Confirm if all tables have been created in DWAPI database; if incomplete, use below scripts to recreate DWAPI tables;

1. Log into mysql by typing mysql -uroot -p
   

2. Enter the correct  MySQL password
   

3. Drop dwapi database using script below;
   

4.  drop database dwapi;
   

5. Verify server on dwapi dashboard and save
   

• Open terminal and run scripts below;

1. sudo docker stop dwapi
   

2. sudo docker start -i dwapi 
   

3. sudo docker restart dwapi
   

• Reload the page on the browser and click “Verify database” and save

NB: Verify that the DWAPI version is compatible with the KenyaEMR version you are currently using.