Have been trying to load care and treatment dockets without sucess,any time I try to load i encounter an error. Kindly help
Have been trying to load care and treatment dockets without sucess,any time I try to load i encounter an error. Kindly help
This issue seems the dwapi tables were not created successfully. So first delete the dwapi database in mysql.
drop schema dwapi
Recreate an empty database called dwapi.
** create schema dwapi**
Ensure the DWAPI database user for MySQL i.e
** create user 'dwapi'@'%' identified by 'dwapi';**
Ensure the privileges are assigned for dwapi database user:
GRANT ALL PRIVILEGES ON . TO 'dwapi'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
Restart dwapi and setup the first time setup i.e the dwapi database connection from the url:
** https://localhost:5753/#/emrconfig**
8.Restart dwapi docker:
sudo docker restart dwapi
9.Check the logs to ensure the dwapi tables are created successfully i.e
sudo docker logs -f dwapi
Once all the tables are created and you can see the logs are successfully then you can proceed to the dwapi online url:
https://localhost:5753/#/emrconfig
and
ensure the kenyaEMR protocols under EMR Settings have the correct host and then you can load the database.
Refresh the DWAPI Tables from the EMR then rerun the process. Also check if the version of DWAPI is the latest
Have refreshed,but still getting the same error
Did you check the version number?
version is 3.1.26
Provide more information either by capturing the error and share the screenshot
have shared the screen shot,kindly help