Migration from DHIS2 version 2.31 to 2.32 face erro

Dear Team,

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!

issue.docx (22.4 KB)

Thanks
LCaynar

Hi @LCaynar
I see the error:

 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

Please did you follow the instructions for upgrading (see docs: Upgrading - DHIS2 Documentation )

I think you still have to drop the SQL views before upgrading.

Thanks!

Hi @Gassim,

Thanks you so much!

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.

Best,
LCaynar

1 Like

Hi @Gassim ,

After I successful migrated V 2.31 to 2.32. I lost all data on tracker capture APP. and show error stated below:

In addition, when capture new registration with save and continue button; I got error message stated below:


image

Any guidance to resolve this issue. the data is very important.

Best,
LCaynar

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.

Additionally, please tell me which one works (if any):
https://play.dhis2.org/2.36.4/api/organisationUnits?fields=id,name&filter=name:ilike:tbong
OR
https://play.dhis2.org/2.36.4/api/organisationUnits?fields=id,name&filter=id:ilike:tbong


For the server error, would you please share Catalina log (without any sensitive info)? Thank you!

Hi @Gassim ,

All data were not loaded with error:

http://localhost:8080/DB/api/30/organisationUnits/Kampong%20Cham.json?fields=id,displayName,code,closedDate,openingDate,organisationUnitGroups[id,code,name]

This is link error:

http://localhost:8080/DB/api/30/organisationUnits/Kampong%20Cham.json?fields=id,displayName,code,closedDate,openingDate,organisationUnitGroups[id,code,name]

In addition, based on your link. this one is works: api/organisationUnits?fields=id,name&filter=name:ilike:tbong

Thanks for your help.

Best,
LCaynar

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?

Thanks!

Dear @Gassim ,

I still can’t solve it on the permission of Tomcat. Could you help to guide me to solve this issue.

Thanks,
LCaynar

@LCaynar,

I found some errors and here are some possible solutions I found from community posts:

  1. 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)

  2. deployWAR Error
    Please check the dhis.conf file and see if the connection.url is correct (then probably restart)

  3. 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.

I hope this helps!

Thanks!

@Gassim ,

Thanks you so much for your instruction. I will follow your guidance and any queries I will let you know.

Best,
Aynar

1 Like