Currently, I use DHIS2 version 2.31.7. I am trying to migrate version 2.31.7 to 2.32 latest. But I am facing the error. Therefore, need community team to help. here if my log file with error. Please help!
ERROR: cannot drop column coordinates of table organisationunit because other objects depend on it
Detail: view _view_a depends on column coordinates of table organisationunit
view _view_test2 depends on column coordinates of table organisationunit
Currently, I was able to migrate from DHIS2 version 2.31.7 to 2.32.8. I am continuing migration step by step. If I found issue, I will let you know seeking your help.
Hi @LCaynar,
Please check if you can see the organisation unit using the api URL: [your-instance-domain]/api/organisationUnits?fields=id,name
For example in play we would use, https://play.dhis2.org/2.36.4/api/organisationUnits?fields=id,name
Could you please take a screenshot of what you see? It says that the id is Tbong Khmum but that’s supposed to be the name not the id so this could be a bug.
Thanks @LCaynar! I see from the Catalina log that there are errors with Tomcat reading/accessing the conf and war files, so would you please make sure you review the authorities given to Tomcat on your Windows?
I found some errors and here are some possible solutions I found from community posts:
The system cannot find the path specified.
It might help to increase the java heap space to (-Xms4096m -Xmx4096m). change to java.exe -Xms4096M -Xmx4096M¡± (source)
deployWAR Error
Please check the dhis.conf file and see if the connection.url is correct (then probably restart)
Could not drop view: _view_test3
Did you drop all the materialized SQL views before migration (as mentioned in the docs)? For some reasons this _view_test3 table is causing errors so you might need to drop it manually. drop table _view_test3 cascade
I hope that these will solve the issue; however, if the issue is not solved, please include Java version, Java heap size, Tomcat version, Postgresql version, and the OS you are using. Also include what the connection.url is in your dhis.conf file.