Upgrade 2.0.4 to 2.4

I am working on a system which was originally set up with version 2.0.4 and wish to install the latest (2.4) .
Is there anything that needs to be done to upgrade the data for the new version? Will this be handled somehow?

Thanks,
Mark

···


Mark Spohr, MD

I am working on a system which was originally set up with version 2.0.4 and wish to install the latest (2.4) .
Is there anything that needs to be done to upgrade the data for the new version? Will this be handled somehow?

Hm…there are quite a few changes between the two. I guess the best approach depends a bit on what exactly is in the current system, e.g. are there many custom data entry forms?

First of all, you could just do a dump and make a copy of the database (MySql or Postgres?), and run it with the latest and see what may be missing.

Another approach could be to try a DXF export and import into an empty 2.4 database (the structure will be generated if you link 2.4 to a completely empty database). However, not everything is included in DXF, so some additional manual adjustments are likely necessary.

Knut

···

On Mon, Oct 10, 2011 at 10:02 PM, Mark Spohr mhspohr@gmail.com wrote:

Thanks,
Mark


Mark Spohr, MD


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

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

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

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


Knut Staring

Informatics, U. of Oslo

http://hisp.uio.no

+4791880522

Hi Mark,

This upgrade is a difficult one as there have been many major changes to the database model since 2.0.4.

If this 2.0.4 database uses data element categories (other than the default), then it might require quite a lot of manual database fixing to get it over to the latest version.

You can always try to start up 2.4 with your database (take a backup first), and see what happens (I guess this has failed already since you post this question here…).

Pay attention to the tomcat log during the startup routines.

If it fails you can post the error messages here, or it might be better you just send me your database and I can give it a try.

Ola

···

Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link

On 10 October 2011 22:02, Mark Spohr mhspohr@gmail.com wrote:

I am working on a system which was originally set up with version 2.0.4 and wish to install the latest (2.4) .
Is there anything that needs to be done to upgrade the data for the new version? Will this be handled somehow?

Thanks,
Mark


Mark Spohr, MD


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

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

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

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

Hi Knut,
Thanks for the information. The system was set up with Postgres. It only has one custom data entry form now. It was set up with facilities and provinces but not much else. However, a year’s worth of historical data was imported into the system from another database and some work remains to clean up that import.

Is there some documentation of the changes to the DB across versions?
I think the DXF export/import process would probably be best.

On a related note, most systems seem to use MySQL or Postgres but the H2 database seems quite capable and has good performance at the scale we anticipate (328 facilities monthly reporting) so any caveats if we decide to stay with H2?

All the best,
Mark

···

On Mon, Oct 10, 2011 at 1:14 PM, Knut Staring knutst@gmail.com wrote:

On Mon, Oct 10, 2011 at 10:02 PM, Mark Spohr mhspohr@gmail.com wrote:

I am working on a system which was originally set up with version 2.0.4 and wish to install the latest (2.4) .
Is there anything that needs to be done to upgrade the data for the new version? Will this be handled somehow?

Hm…there are quite a few changes between the two. I guess the best approach depends a bit on what exactly is in the current system, e.g. are there many custom data entry forms?

First of all, you could just do a dump and make a copy of the database (MySql or Postgres?), and run it with the latest and see what may be missing.

Another approach could be to try a DXF export and import into an empty 2.4 database (the structure will be generated if you link 2.4 to a completely empty database). However, not everything is included in DXF, so some additional manual adjustments are likely necessary.

Knut

Thanks,
Mark


Mark Spohr, MD


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

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

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

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

Knut Staring

Informatics, U. of Oslo

http://hisp.uio.no

+4791880522


Mark Spohr, MD

Hi Mark,

As Ola says, the use of dimensional breakdown (age, sex etc) will proabably also be a determinant of how easy this will be. Unfortunately, the changes have not been consistently documented in one place but typically spread over each release, but if your data is somewhat complex and the methods outlined don’t work out of the box, I would go for Ola’s offer to take a look, as he really is our resident expert.

As for H2, I suppose I would be a bit reluctant to use it for a central server (though not sure it couldn’t work even for that). In your setup, do you have a number of local/offline installations? If so, I think H2 could be a very good choice. I suppose the only things that go against it is that the DHIS2 community has not tested it as extensively as the other two (thus we would welcome your experiences) and that there are somewhat less 3rd party tools available to work with it, but it should be possible to use e.g. the Postgres ODBC driver, which opens up a large range of possibilities: http://www.h2database.com/html/advanced.html#odbc_driver

Knut

···

On Mon, Oct 10, 2011 at 10:39 PM, Mark Spohr mhspohr@gmail.com wrote:

Hi Knut,
Thanks for the information. The system was set up with Postgres. It only has one custom data entry form now. It was set up with facilities and provinces but not much else. However, a year’s worth of historical data was imported into the system from another database and some work remains to clean up that import.

Is there some documentation of the changes to the DB across versions?
I think the DXF export/import process would probably be best.

On a related note, most systems seem to use MySQL or Postgres but the H2 database seems quite capable and has good performance at the scale we anticipate (328 facilities monthly reporting) so any caveats if we decide to stay with H2?

All the best,
Mark

On Mon, Oct 10, 2011 at 1:14 PM, Knut Staring knutst@gmail.com wrote:

On Mon, Oct 10, 2011 at 10:02 PM, Mark Spohr mhspohr@gmail.com wrote:

I am working on a system which was originally set up with version 2.0.4 and wish to install the latest (2.4) .
Is there anything that needs to be done to upgrade the data for the new version? Will this be handled somehow?

Hm…there are quite a few changes between the two. I guess the best approach depends a bit on what exactly is in the current system, e.g. are there many custom data entry forms?

First of all, you could just do a dump and make a copy of the database (MySql or Postgres?), and run it with the latest and see what may be missing.

Another approach could be to try a DXF export and import into an empty 2.4 database (the structure will be generated if you link 2.4 to a completely empty database). However, not everything is included in DXF, so some additional manual adjustments are likely necessary.

Knut

Thanks,
Mark


Mark Spohr, MD


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

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

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

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

Knut Staring

Informatics, U. of Oslo

http://hisp.uio.no

+4791880522


Mark Spohr, MD


Knut Staring

Informatics, U. of Oslo

http://hisp.uio.no

+4791880522

Thanks for this information. Since this is not yet in production, it looks like it might be better to piece together an upgrade by importing various data sets and patching things up as I go along.

There will be a number of disconnected sites which would be good candidates for H2 at least at the start. Planned connectivity improvements will hopefully eliminate these in a year or two.

Do most DHIS sites stay on the same version as originally installed (and thereby forgo all of your fantastic updates)?

I was hoping to have online access to the system by now but it looks like I will have to wait until I go back in a few weeks to get this sorted out.

Regards,
Mark

···

On Mon, Oct 10, 2011 at 1:16 PM, Ola Hodne Titlestad olati@ifi.uio.no wrote:

Hi Mark,

This upgrade is a difficult one as there have been many major changes to the database model since 2.0.4.

If this 2.0.4 database uses data element categories (other than the default), then it might require quite a lot of manual database fixing to get it over to the latest version.

You can always try to start up 2.4 with your database (take a backup first), and see what happens (I guess this has failed already since you post this question here…).

Pay attention to the tomcat log during the startup routines.

If it fails you can post the error messages here, or it might be better you just send me your database and I can give it a try.

Ola



Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link

On 10 October 2011 22:02, Mark Spohr mhspohr@gmail.com wrote:

I am working on a system which was originally set up with version 2.0.4 and wish to install the latest (2.4) .
Is there anything that needs to be done to upgrade the data for the new version? Will this be handled somehow?

Thanks,
Mark


Mark Spohr, MD


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

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

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

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


Mark Spohr, MD

Hi Ola,
I would like to impose upon you to take a look at our database.
This was originally set up under 2.0.4 and we would like to run it under
the latest 2.5
The database as is does run under 2.5 but it crashes at odd times (mostly
when doing maintenance and reports). Data entry seems to work well.
I'd appreciate it if you could take a look at this and see what would be
involved to update it to 2.5. It's a fairly simple installation with only
one data entry form and not much in the way of reports. It includes some
historical data from 2008 and 2009.
This is a Postgres pg_dump file.

Thanks very much,
Mark

···

On Mon, Oct 10, 2011 at 1:16 PM, Ola Hodne Titlestad <olati@ifi.uio.no>wrote:

Hi Mark,

This upgrade is a difficult one as there have been many major changes to
the database model since 2.0.4.
If this 2.0.4 database uses data element categories (other than the
default), then it might require quite a lot of manual database fixing to
get it over to the latest version.

You can always try to start up 2.4 with your database (take a backup
first), and see what happens (I guess this has failed already since you
post this question here....).
Pay attention to the tomcat log during the startup routines.

If it fails you can post the error messages here, or it might be better
you just send me your database and I can give it a try.

Ola
------

----------------------------------
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link<http://maps.google.com/maps?f=q&source=s_q&hl=en&geocode=&q=Vetlandsvn.+95B,+0685+Oslo,+Norway>

On 10 October 2011 22:02, Mark Spohr <mhspohr@gmail.com> wrote:

I am working on a system which was originally set up with version 2.0.4
and wish to install the latest (2.4) .
Is there anything that needs to be done to upgrade the data for the new
version? Will this be handled somehow?

Thanks,
Mark

--
Mark Spohr, MD

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp

--
Mark Spohr, MD

Hi Mark,

I got it up an running with the latest 2.5 build.

(can be downloaded here: http://apps.dhis2.org/ci/job/dhis-web-2.5/lastSuccessfulBuild/artifact/dhis-2/dhis-web/dhis-web-portal/target/dhis.war )

Should be the same as on dhis2.org/downloads

It seems to run fine, I have been through data entry, data set reports, data element and orgunit maintenance without any errors so far.

I need some more information about your crashes, so can you please locate the logs under /logs

If they are not too big you could zip them all together and send me.

Ola

···

Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link

On 16 November 2011 06:01, Mark Spohr mhspohr@gmail.com wrote:

Hi Ola,
I would like to impose upon you to take a look at our database.
This was originally set up under 2.0.4 and we would like to run it under the latest 2.5
The database as is does run under 2.5 but it crashes at odd times (mostly when doing maintenance and reports). Data entry seems to work well.

I’d appreciate it if you could take a look at this and see what would be involved to update it to 2.5. It’s a fairly simple installation with only one data entry form and not much in the way of reports. It includes some historical data from 2008 and 2009.

This is a Postgres pg_dump file.

Thanks very much,
Mark

On Mon, Oct 10, 2011 at 1:16 PM, Ola Hodne Titlestad olati@ifi.uio.no wrote:

Hi Mark,

This upgrade is a difficult one as there have been many major changes to the database model since 2.0.4.

If this 2.0.4 database uses data element categories (other than the default), then it might require quite a lot of manual database fixing to get it over to the latest version.

You can always try to start up 2.4 with your database (take a backup first), and see what happens (I guess this has failed already since you post this question here…).

Pay attention to the tomcat log during the startup routines.

If it fails you can post the error messages here, or it might be better you just send me your database and I can give it a try.

Ola



Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link

On 10 October 2011 22:02, Mark Spohr mhspohr@gmail.com wrote:

I am working on a system which was originally set up with version 2.0.4 and wish to install the latest (2.4) .
Is there anything that needs to be done to upgrade the data for the new version? Will this be handled somehow?

Thanks,
Mark


Mark Spohr, MD


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

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

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

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


Mark Spohr, MD

Thanks very much for working on this. Did you need to make changes to the data structure, etc?
We’ll download and install the new war file.

I really appreciate all of your good work.

Regards,
Mark

···

On Wed, Nov 16, 2011 at 12:32 AM, Ola Hodne Titlestad olati@ifi.uio.no wrote:

Hi Mark,

I got it up an running with the latest 2.5 build.

(can be downloaded here: http://apps.dhis2.org/ci/job/dhis-web-2.5/lastSuccessfulBuild/artifact/dhis-2/dhis-web/dhis-web-portal/target/dhis.war )

Should be the same as on dhis2.org/downloads

It seems to run fine, I have been through data entry, data set reports, data element and orgunit maintenance without any errors so far.

I need some more information about your crashes, so can you please locate the logs under /logs

If they are not too big you could zip them all together and send me.

Ola



Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link

On 16 November 2011 06:01, Mark Spohr mhspohr@gmail.com wrote:

Hi Ola,
I would like to impose upon you to take a look at our database.
This was originally set up under 2.0.4 and we would like to run it under the latest 2.5
The database as is does run under 2.5 but it crashes at odd times (mostly when doing maintenance and reports). Data entry seems to work well.

I’d appreciate it if you could take a look at this and see what would be involved to update it to 2.5. It’s a fairly simple installation with only one data entry form and not much in the way of reports. It includes some historical data from 2008 and 2009.

This is a Postgres pg_dump file.

Thanks very much,
Mark

On Mon, Oct 10, 2011 at 1:16 PM, Ola Hodne Titlestad olati@ifi.uio.no wrote:

Hi Mark,

This upgrade is a difficult one as there have been many major changes to the database model since 2.0.4.

If this 2.0.4 database uses data element categories (other than the default), then it might require quite a lot of manual database fixing to get it over to the latest version.

You can always try to start up 2.4 with your database (take a backup first), and see what happens (I guess this has failed already since you post this question here…).

Pay attention to the tomcat log during the startup routines.

If it fails you can post the error messages here, or it might be better you just send me your database and I can give it a try.

Ola



Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link

On 10 October 2011 22:02, Mark Spohr mhspohr@gmail.com wrote:

I am working on a system which was originally set up with version 2.0.4 and wish to install the latest (2.4) .
Is there anything that needs to be done to upgrade the data for the new version? Will this be handled somehow?

Thanks,
Mark


Mark Spohr, MD


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

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

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

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


Mark Spohr, MD


Mark Spohr, MD

Hi Mark,

No, I didn’t change anything. I just started up your database with 2.5 and it worked fine.

If you still get problems, please send us the tomcat logs and we can investigate,

Ola

···

Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link

On 16 November 2011 23:07, Mark Spohr mhspohr@gmail.com wrote:

Thanks very much for working on this. Did you need to make changes to the data structure, etc?
We’ll download and install the new war file.

I really appreciate all of your good work.

Regards,
Mark

On Wed, Nov 16, 2011 at 12:32 AM, Ola Hodne Titlestad olati@ifi.uio.no wrote:

Hi Mark,

I got it up an running with the latest 2.5 build.

(can be downloaded here: http://apps.dhis2.org/ci/job/dhis-web-2.5/lastSuccessfulBuild/artifact/dhis-2/dhis-web/dhis-web-portal/target/dhis.war )

Should be the same as on dhis2.org/downloads

It seems to run fine, I have been through data entry, data set reports, data element and orgunit maintenance without any errors so far.

I need some more information about your crashes, so can you please locate the logs under /logs

If they are not too big you could zip them all together and send me.

Ola



Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link

On 16 November 2011 06:01, Mark Spohr mhspohr@gmail.com wrote:

Hi Ola,
I would like to impose upon you to take a look at our database.
This was originally set up under 2.0.4 and we would like to run it under the latest 2.5
The database as is does run under 2.5 but it crashes at odd times (mostly when doing maintenance and reports). Data entry seems to work well.

I’d appreciate it if you could take a look at this and see what would be involved to update it to 2.5. It’s a fairly simple installation with only one data entry form and not much in the way of reports. It includes some historical data from 2008 and 2009.

This is a Postgres pg_dump file.

Thanks very much,
Mark

On Mon, Oct 10, 2011 at 1:16 PM, Ola Hodne Titlestad olati@ifi.uio.no wrote:

Hi Mark,

This upgrade is a difficult one as there have been many major changes to the database model since 2.0.4.

If this 2.0.4 database uses data element categories (other than the default), then it might require quite a lot of manual database fixing to get it over to the latest version.

You can always try to start up 2.4 with your database (take a backup first), and see what happens (I guess this has failed already since you post this question here…).

Pay attention to the tomcat log during the startup routines.

If it fails you can post the error messages here, or it might be better you just send me your database and I can give it a try.

Ola



Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link

On 10 October 2011 22:02, Mark Spohr mhspohr@gmail.com wrote:

I am working on a system which was originally set up with version 2.0.4 and wish to install the latest (2.4) .
Is there anything that needs to be done to upgrade the data for the new version? Will this be handled somehow?

Thanks,
Mark


Mark Spohr, MD


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

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

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

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


Mark Spohr, MD


Mark Spohr, MD