Upgrade to 2.37 Failed

Support - Assistance technique
4

I’m also getting similar error during upgrade . We are trying to update form 2.36.4 to 2.37

Please note ours is a few years old system got all the upgrades done. 2.36.4 was working smooth. this upgrade of 2.37 failed with below error.

-----------------------------------------------------------
SQL State  : 2BP01
Error Code : 0
Message    : ERROR: cannot drop table reporttable because other objects depend on it
  Detail: constraint fk_dashboarditem_reporttables_reporttableid on table dashboarditem_reporttables depends on table reporttable
  Hint: Use DROP ... CASCADE to drop the dependent objects too.
Location   : org/hisp/dhis/db/migration/2.37/V2_37_17__Remove_Chart_and_ReportTable.sql (/home/dhis2admin/tomcat-dhis/webapps/file:/home/dhis2admin/tomcat-dhis/webapps/ROOT/WEB-INF/lib/dhis-support-db-migration-2.37.0.jar!/org/hisp/dhis/db/migration/2.37/V2_37_17__Remove_Chart_and_ReportTable.sql)
Line       : 36
Statement  : -- Drop all ReportTable tables
DROP TABLE IF EXISTS reporttable```
1 Like