dhis2-devs team mailing list archive

[David Siang Fong Oh <doh@xxxxxxxxxxxxxxxx>]

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,

-doh

On Tue, May 2, 2017 at 3:16 PM, Em Le Hong <em.hispvietnam@xxxxxxxxx> 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.
>
> On Tue, May 2, 2017 at 3:52 PM, jhansirk <jhansirk@xxxxxxxxxxxxxxxx>
> 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@xxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> *Em Le Hong*
> DHIS2 Implementation| *HISP Vietnam *
> em.hispvietnam@xxxxxxxxx | *Skype:* em.hispvietnam@xxxxxxxxx
>
>
>
>
>
>