Error Starting KenyaEMR charts Module

[karimkkanji]

The Kenyaemr_etl and kenyaemr_datatools have been dropped and recreated using the following:

call create_etl_tables(); call sp_first_time_setup();

In mysql console and Tomcat restarted but the issue persists.

The following is an error observed in the console:

[ngarivictor]

you could try source a fresh 👇 kenyaemr_etl.zip

[karimkkanji]

Let me try again. Have tried deleting the databases and recreating them but the issue still persists

[karimkkanji]

The ETL Database shared has actually made it worse. Home Page graphs are now not appearing at all

[karimkkanji]

Running the following on MYSQL Shell might do the trick:

DROP DATABASE kenyaemr_etl;
DROP DATABASE kenyaemr_datatools;
USE openmrs;
CALL create_etl_tables();
CALL sp_first_time_setup();

[ngarivictor]

Let me know how it goes.

On Tue, 27 Jul 2021, 19:02 Karim K. Kanji, @.***> wrote:

Running the following on MYSQL Shell might do the trick:

DROP DATABASE kenyaemr_etl;DROP DATABASE kenyaemr_datatools; USE openmrs; CALL create_etl_tables(); CALL sp_first_time_setup();

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/karimkkanji/kenyaemr-plus-issues/issues/3#issuecomment-887636815, or unsubscribe https://github.com/notifications/unsubscribe-auth/ADNRNNYLIL6ZDEORD6E26JTTZ3KBLANCNFSM5AYTDZLA .

[karimkkanji]

@ngarivictor It is a database issue. I have used the current database running in at the facility and it now works well. All modules work well. I had tried with the de-id database and the etl database you shared but that didn't work.

Issue: The openmrs Database might be having a schema issue or LIQUIBASE issue