the tomcat server starts but the migration fails.
Caused by: org.flywaydb.core.api.FlywayException: Validate failed: Detected failed migration to version 2.35.4 (Remove color set)
this is what I suppose the script running
Since some tables were dropped, I deduced it’s the color table causing the issue
I ran manually in psql the following command : drop table if exists color;
The command outputs this :
ERROR: cannot drop table color because other objects depend on it
DETAIL: constraint fk_objecttranslation_colorid on table colortranslations depends on table color
The thing I don’t understand all these tables are empty
dhis2=> select * from colortranslations;
colorid | objecttranslationid
---------+---------------------
(0 rows)
dhis2=> select * from color;
colorid | uid | code | created | lastupdated | lastupdatedby | color | name | translations
---------+-----+------+---------+-------------+---------------+-------+------+--------------
(0 rows)
I assume the migration that drops the table “forgot” about colortranslations