Issue in upgrade the database from 2.40 to 2.42

[Gassim (AL-Gassim Sharaf Addin)]

Hi,

Thank you for sharing these details and it’s great that you are working on keeping your instance up to date. As there are important changes that you will need to be aware of, before upgrading to version 42, please make sure to go through:

• DHIS2 Version 42 Upgrade Notes: dhis2-releases/releases/2.42/README.md at master · dhis2/dhis2-releases · GitHub
• DHIS2 Version 42 Migration Notes: dhis2-releases/releases/2.42/migration-notes.md at master · dhis2/dhis2-releases · GitHub

Additionally, if you still face these issues, would you kindly check your Catalina.out log and look for the SQL queries that are failing and copy their log.

Furthermore, I know that the error that appeared is related to the DB migration, please make sure that the environment changes are also taken into consideration, and for that please follow the guidelines posted by @tkipkurgat here:

@tkipkurgat

In our standard installation, we use LXD containers, each running its own operating system—typically Ubuntu LTS releases. These container or guest operating systems are immutable, meaning once the OS is set during initial deployment, it cannot be changed later by simply modifying the guest_os=24.04 parameter.

To upgrade to DHIS2 version 42, there are key prerequisites:

1. Tomcat 10
2. Java 17

An implied requirement is Ubuntu 24.04, since Tomcat 10 is only available via apt on this version of Ubuntu.

Summary:

You cannot perform an in-place upgrade from DHIS2 version 2.41 or earlier. Instead, you must provision a new guest environment—either an LXD container or VM—running Ubuntu 24.04, and migrate your instance there.

Thank you!