DHIS Upgrade from 2.23 to 2.25 inconsistencies in the database migration when doing an incremental upgrade vs direct upgrade

Support - Assistance technique
1

Hi DHIS-Devs,

We are planning to upgrade from DHIS 2.23 to 2.25, we have two ways to do the upgrade:

  • Incremental Upgrade from 2.23 → 2.24 → 2.25
  • Direct Upgrade from 2.23 → 2.25

We have noticed some inconsistencies in the database when doing an incremental upgrade vs direct upgrade. Following tables are not getting created when doing a direct upgrade from 2.23 to 2.25 (Apart from this rest other migrations looks good).

  1. maplayertranslations
  2. metadatafiltertranslations
  3. programvalidationtranslations
  4. trackedentityinstanceremindertranslations
    Above missing tables are added in DHIS 2.24 and the code to create these tables is removed in DHIS 2.25. Because of which, these tables are getting created only with an incremental upgrade from 2.24 to 2.25 and not with the direct upgrade from 2.23 to 2.25. Is the intention behind removing the code is to get rid of these tables? But, these tables will be in the system forever if someone is doing an incremental upgrade. So, Is there any plan to use these tables in future or can we ignore this tables?

Thanks,

Jhansi

2

We have also verified if these missing tables exist in the brand new DHIS 2.25 installation and we don’t see them in it either.

Thanks,

Jhansi

···

On 02-May-2017, at 1:00 PM, jhansirk jhansirk@thoughtworks.com wrote:

Hi DHIS-Devs,

We are planning to upgrade from DHIS 2.23 to 2.25, we have two ways to do the upgrade:

  • Incremental Upgrade from 2.23 → 2.24 → 2.25
  • Direct Upgrade from 2.23 → 2.25

We have noticed some inconsistencies in the database when doing an incremental upgrade vs direct upgrade. Following tables are not getting created when doing a direct upgrade from 2.23 to 2.25 (Apart from this rest other migrations looks good).

  1. maplayertranslations
  2. metadatafiltertranslations
  3. programvalidationtranslations
  4. trackedentityinstanceremindertranslations
    Above missing tables are added in DHIS 2.24 and the code to create these tables is removed in DHIS 2.25. Because of which, these tables are getting created only with an incremental upgrade from 2.24 to 2.25 and not with the direct upgrade from 2.23 to 2.25. Is the intention behind removing the code is to get rid of these tables? But, these tables will be in the system forever if someone is doing an incremental upgrade. So, Is there any plan to use these tables in future or can we ignore this tables?

Thanks,

Jhansi

3

Hi,

For upgrading, You have to upgrade as the first way:

  • Incremental Upgrade from 2.23 → 2.24 → 2.25
    And read the Upgrade notes for each version from:

https://www.dhis2.org/downloads

https://www.dhis2.org/224-upgrade

https://www.dhis2.org/225-upgrade

Some versions you need to use upgrade script.

Hope this is helpful for you.

···

On Tue, May 2, 2017 at 3:52 PM, jhansirk jhansirk@thoughtworks.com wrote:

We have also verified if these missing tables exist in the brand new DHIS 2.25 installation and we don’t see them in it either.

Thanks,

Jhansi

On 02-May-2017, at 1:00 PM, jhansirk jhansirk@thoughtworks.com wrote:

Hi DHIS-Devs,

We are planning to upgrade from DHIS 2.23 to 2.25, we have two ways to do the upgrade:

  • Incremental Upgrade from 2.23 → 2.24 → 2.25
  • Direct Upgrade from 2.23 → 2.25

We have noticed some inconsistencies in the database when doing an incremental upgrade vs direct upgrade. Following tables are not getting created when doing a direct upgrade from 2.23 to 2.25 (Apart from this rest other migrations looks good).

  1. maplayertranslations
  2. metadatafiltertranslations
  3. programvalidationtranslations
  4. trackedentityinstanceremindertranslations
    Above missing tables are added in DHIS 2.24 and the code to create these tables is removed in DHIS 2.25. Because of which, these tables are getting created only with an incremental upgrade from 2.24 to 2.25 and not with the direct upgrade from 2.23 to 2.25. Is the intention behind removing the code is to get rid of these tables? But, these tables will be in the system forever if someone is doing an incremental upgrade. So, Is there any plan to use these tables in future or can we ignore this tables?

Thanks,

Jhansi

Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

–

Em Le Hong
DHIS2 Implementation| **HISP Vietnam **

em.hispvietnam@gmail.com | Skype: em.hispvietnam@gmail.com

4

Hi,

For a DHIS2 instance upgrading to 2.25 we can understand why you would first need to upgrade to 2.24 before then upgrading to 2.25. Although if the database migrations are structured correctly then a direct upgrade from 2.23 to 2.25 should be possible as well.

However, the bigger concern here is that the tables in question are missing when you do a brand new installation of DHIS 2.25. This means one of two things:

  • The tables are required in DHIS 2.25 and the database migrations were removed by mistake, in which case there is a bug in DHIS2.
  • The tables are no longer required in DHIS 2.25 but there was no migration added to remove these tables, in which case there are redundant tables that are being left behind in every DHIS2 instance that upgrades from 2.24 to 2.25.
    Can someone please confirm whether these tables were removed deliberately? We need to understand this prior to upgrading to DHIS 2.25.

Cheers,

···

On Tue, May 2, 2017 at 3:16 PM, Em Le Hong em.hispvietnam@gmail.com wrote:

Hi,

For upgrading, You have to upgrade as the first way:

  • Incremental Upgrade from 2.23 → 2.24 → 2.25
    And read the Upgrade notes for each version from:

https://www.dhis2.org/downloads

https://www.dhis2.org/224-upgrade

https://www.dhis2.org/225-upgrade

Some versions you need to use upgrade script.

Hope this is helpful for you.

-doh

On Tue, May 2, 2017 at 3:52 PM, jhansirk jhansirk@thoughtworks.com wrote:

We have also verified if these missing tables exist in the brand new DHIS 2.25 installation and we don’t see them in it either.

Thanks,

Jhansi

On 02-May-2017, at 1:00 PM, jhansirk jhansirk@thoughtworks.com wrote:

Hi DHIS-Devs,

We are planning to upgrade from DHIS 2.23 to 2.25, we have two ways to do the upgrade:

  • Incremental Upgrade from 2.23 → 2.24 → 2.25
  • Direct Upgrade from 2.23 → 2.25

We have noticed some inconsistencies in the database when doing an incremental upgrade vs direct upgrade. Following tables are not getting created when doing a direct upgrade from 2.23 to 2.25 (Apart from this rest other migrations looks good).

  1. maplayertranslations
  2. metadatafiltertranslations
  3. programvalidationtranslations
  4. trackedentityinstanceremindertranslations
    Above missing tables are added in DHIS 2.24 and the code to create these tables is removed in DHIS 2.25. Because of which, these tables are getting created only with an incremental upgrade from 2.24 to 2.25 and not with the direct upgrade from 2.23 to 2.25. Is the intention behind removing the code is to get rid of these tables? But, these tables will be in the system forever if someone is doing an incremental upgrade. So, Is there any plan to use these tables in future or can we ignore this tables?

Thanks,

Jhansi

Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Em Le Hong
DHIS2 Implementation| **HISP Vietnam **

em.hispvietnam@gmail.com | Skype: em.hispvietnam@gmail.com

–