Why are DWAPI not loading C&T? Help with steps to follow to sort up the issue

Viewed 103

Have been trying to load care and treatment dockets without sucess,any time I try to load i encounter an error. Kindly help

Provide more information either by capturing the error and share the screenshot

have shared the screen shot,kindly help

2 Answers
  1. This issue seems the dwapi tables were not created successfully. So first delete the dwapi database in mysql.
    drop schema dwapi

  2. Recreate an empty database called dwapi.
    ** create schema dwapi**

  3. Ensure the DWAPI database user for MySQL i.e
    ** create user 'dwapi'@'%' identified by 'dwapi';**

  4. Ensure the privileges are assigned for dwapi database user:
    GRANT ALL PRIVILEGES ON . TO 'dwapi'@'%' WITH GRANT OPTION;
    FLUSH PRIVILEGES;

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

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

image.png

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