Error while 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;
• Log into mysql by typing mysql -uroot -p
• Enter the correct MySQL password
• Drop dwapi database using script below;

drop database dwapi;

• Verify server on dwapi dashboard and save

Open terminal and run scripts below;

sudo docker stop dwapi

sudo docker start -i dwapi

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.