Hi dev,
I’m upgrading from version 2.35 to the latest, 2.39 and i am having the following errors
– This script will remove all tables related to Chart and ReportTable.
– Those entities are being entirely removed from the codebase.
– Some statistics data needs are being move into visualization.
– Drop ReportTable and Chart columns from dashboarditem table.
ALTER TABLE dashboarditem
DROP COLUMN IF EXISTS chartid
at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.handleException(DefaultSqlScriptExecutor.java:275) ~[flyway-core-9.3.0.jar:?]
at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.executeStatement(DefaultSqlScriptExecutor.java:222) ~[flyway-core-9.3.0.jar:?]
at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.execute(DefaultSqlScriptExecutor.java:126) ~[flyway-core-9.3.0.jar:?]
and dhis2 will not start.
I tried to execute the following queries…
ALTER TABLE dashboarditem
DROP COLUMN IF EXISTS chartid CASCADE;
ALTER TABLE dashboarditem
DROP COLUMN IF EXISTS reporttable cascade;
delete from flyway_schema_history where flyway_schema_history.success = false;
DROP TABLE IF EXISTS reporttable CASCADE;
And the dhis2 started but the dashboard are blanks and showing no data. Please what can be done?