Hi Developers, where can I get the upgrade scripts from the very lowest dhis 2.0.6 so that i do incremental
Moemedi Ntunyane
Co-founder KeyInConsulting
Hello Moemedi,
The upgrades should happen automatically except for 2.13->2.14 and 2.14->2.15 Those scripts can be found here
https://www.dhis2.org/downloads
2.13->2.14 http://www.dhis2.org/download/resources/sql/convert-fixed-attributes-to-dynamic.sql
2.14->2.15 http://www.dhis2.org/download/resources/sql/rename-patient-to-trackedentity.sql
Thanks,
Dan
Dan Cocos
BAO Systemswww.baosystems.com
T: +1 202-352-2671 | skype: dancocos
···
On Aug 19, 2014, at 6:40 AM, Moemedi Ntunyane moemedi.ntunyane@hotmail.com wrote:
Hi Developers, where can I get the upgrade scripts from the very lowest dhis 2.0.6 so that i do incremental
Moemedi Ntunyane
Co-founder KeyInConsulting
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
Hi Dan
Thanks a lot.
Regards,
Moemedi Ntunyane
Co-founder KeyInConsulting
Hi All
I am upgrading DHIS 2.0.5 using postgreSQL DB, is there a shortcut other than using incremental way like 2.0.5, 2.0.6 ......to 2.15. Directly executing scripts from http://www.dhis2.org/download/resources/sql/convert-fixed-attributes-to-dynamic.sql gives errors like column does not exist.
Moemedi Ntunyane
Co-founder KeyInConsulting
Hi Moemedi,
Not sure, but I think you could try upgrading directly from 2.0.5 to 2.13 first, and then run the first script. Then 2.14, then script, then 2.15.
If things don’t work, you should provide the actual error messages.
···
On Tue, Aug 19, 2014 at 6:17 PM, Moemedi Ntunyane moemedi.ntunyane@hotmail.com wrote:
Hi All
I am upgrading DHIS 2.0.5 using postgreSQL DB, is there a shortcut other than using incremental way like 2.0.5, 2.0.6 …to 2.15. Directly executing scripts from http://www.dhis2.org/download/resources/sql/convert-fixed-attributes-to-dynamic.sql gives errors like column does not exist.
Moemedi Ntunyane
Co-founder KeyInConsulting
From: moemedi.ntunyane@hotmail.com
To: dan@dancocos.comCC: dhis2-devs@lists.launchpad.net
Subject: RE: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15
Date: Tue, 19 Aug 2014 16:47:46 +0200
Hi Dan
Thanks a lot.
Regards,
***Moemedi Ntunyane
Co-founder KeyInConsulting***
Subject: Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15
From: dan@dancocos.comDate: Tue, 19 Aug 2014 10:40:56 -0400
CC: dhis2-devs@lists.launchpad.net
To: moemedi.ntunyane@hotmail.comHello Moemedi,
The upgrades should happen automatically except for 2.13->2.14 and 2.14->2.15 Those scripts can be found here
2.13->2.14 http://www.dhis2.org/download/resources/sql/convert-fixed-attributes-to-dynamic.sql
2.14->2.15 http://www.dhis2.org/download/resources/sql/rename-patient-to-trackedentity.sql
Thanks,
Dan
Dan Cocos
BAO Systemswww.baosystems.com
T: +1 202-352-2671 | skype: dancocos
On Aug 19, 2014, at 6:40 AM, Moemedi Ntunyane moemedi.ntunyane@hotmail.com wrote:
Hi Developers, where can I get the upgrade scripts from the very lowest dhis 2.0.6 so that i do incremental
***Moemedi Ntunyane
Co-founder KeyInConsulting***
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devsMore help : https://help.launchpad.net/ListHelp
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
–
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522
The question of upgrading from very old dhis2 versions came up recently in another post.
It emerged then that we don’t seem to have a historical archive (museum!) of war artefacts going back beyond 2.10 on http://apps.dhis2.org/ci. We do have the source code tagged back as far as 2.4. Has anybody kept hold of these historic build or should we consider rebuilding and making available? Who would volunteer to do that?
···
On 19 August 2014 22:59, Knut Staring knutst@gmail.com wrote:
Hi Moemedi,
Not sure, but I think you could try upgrading directly from 2.0.5 to 2.13 first, and then run the first script. Then 2.14, then script, then 2.15.
If things don’t work, you should provide the actual error messages.
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
On Tue, Aug 19, 2014 at 6:17 PM, Moemedi Ntunyane moemedi.ntunyane@hotmail.com wrote:
Hi All
I am upgrading DHIS 2.0.5 using postgreSQL DB, is there a shortcut other than using incremental way like 2.0.5, 2.0.6 …to 2.15. Directly executing scripts from http://www.dhis2.org/download/resources/sql/convert-fixed-attributes-to-dynamic.sql gives errors like column does not exist.
Moemedi Ntunyane
Co-founder KeyInConsulting
From: moemedi.ntunyane@hotmail.com
To: dan@dancocos.comCC: dhis2-devs@lists.launchpad.net
Subject: RE: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15
Date: Tue, 19 Aug 2014 16:47:46 +0200
Hi Dan
Thanks a lot.
Regards,
***Moemedi Ntunyane
Co-founder KeyInConsulting***
Subject: Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15
From: dan@dancocos.comDate: Tue, 19 Aug 2014 10:40:56 -0400
CC: dhis2-devs@lists.launchpad.net
To: moemedi.ntunyane@hotmail.comHello Moemedi,
The upgrades should happen automatically except for 2.13->2.14 and 2.14->2.15 Those scripts can be found here
2.13->2.14 http://www.dhis2.org/download/resources/sql/convert-fixed-attributes-to-dynamic.sql
2.14->2.15 http://www.dhis2.org/download/resources/sql/rename-patient-to-trackedentity.sql
Thanks,
Dan
Dan Cocos
BAO Systemswww.baosystems.com
T: +1 202-352-2671 | skype: dancocos
On Aug 19, 2014, at 6:40 AM, Moemedi Ntunyane moemedi.ntunyane@hotmail.com wrote:
Hi Developers, where can I get the upgrade scripts from the very lowest dhis 2.0.6 so that i do incremental
***Moemedi Ntunyane
Co-founder KeyInConsulting***
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devsMore help : https://help.launchpad.net/ListHelp
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
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522
–
I thought Dan’s point was that it would not be necessary to go through every version?
But if it’s necessary, maybe it would suffice to describe in simple steps how to build old versions.
···
On Wed, Aug 20, 2014 at 12:15 PM, Bob Jolliffe bobjolliffe@gmail.com wrote:
The question of upgrading from very old dhis2 versions came up recently in another post.
It emerged then that we don’t seem to have a historical archive (museum!) of war artefacts going back beyond 2.10 on http://apps.dhis2.org/ci. We do have the source code tagged back as far as 2.4. Has anybody kept hold of these historic build or should we consider rebuilding and making available? Who would volunteer to do that?
–
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522
On 19 August 2014 22:59, Knut Staring knutst@gmail.com wrote:
Hi Moemedi,
Not sure, but I think you could try upgrading directly from 2.0.5 to 2.13 first, and then run the first script. Then 2.14, then script, then 2.15.
If things don’t work, you should provide the actual error messages.
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
On Tue, Aug 19, 2014 at 6:17 PM, Moemedi Ntunyane moemedi.ntunyane@hotmail.com wrote:
Hi All
I am upgrading DHIS 2.0.5 using postgreSQL DB, is there a shortcut other than using incremental way like 2.0.5, 2.0.6 …to 2.15. Directly executing scripts from http://www.dhis2.org/download/resources/sql/convert-fixed-attributes-to-dynamic.sql gives errors like column does not exist.
Moemedi Ntunyane
Co-founder KeyInConsulting
From: moemedi.ntunyane@hotmail.com
To: dan@dancocos.comCC: dhis2-devs@lists.launchpad.net
Subject: RE: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15
Date: Tue, 19 Aug 2014 16:47:46 +0200
Hi Dan
Thanks a lot.
Regards,
***Moemedi Ntunyane
Co-founder KeyInConsulting***
Subject: Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15
From: dan@dancocos.comDate: Tue, 19 Aug 2014 10:40:56 -0400
CC: dhis2-devs@lists.launchpad.net
To: moemedi.ntunyane@hotmail.comHello Moemedi,
The upgrades should happen automatically except for 2.13->2.14 and 2.14->2.15 Those scripts can be found here
2.13->2.14 http://www.dhis2.org/download/resources/sql/convert-fixed-attributes-to-dynamic.sql
2.14->2.15 http://www.dhis2.org/download/resources/sql/rename-patient-to-trackedentity.sql
Thanks,
Dan
Dan Cocos
BAO Systemswww.baosystems.com
T: +1 202-352-2671 | skype: dancocos
On Aug 19, 2014, at 6:40 AM, Moemedi Ntunyane moemedi.ntunyane@hotmail.com wrote:
Hi Developers, where can I get the upgrade scripts from the very lowest dhis 2.0.6 so that i do incremental
***Moemedi Ntunyane
Co-founder KeyInConsulting***
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devsMore help : https://help.launchpad.net/ListHelp
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
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522
–
Yes in theory they “should”. Though there was much which changed between 2.05 and 2.10. All of the table altering stuff from earlier versions should be accumulated in newer versions but I recall that sometimes things did not go smoothely with major jumps in versions. I guess the simple fact is that incremental upgrades tend to get tested pretty heavily. Jumping versions becomes more of a leap of faith 
But I do agree, if someone can verify that 2.05 to 2.10 works fine, then it would be good to hear.
I suspect the bigger problems will arise because the metadata integrity control on earlier versions was a good bit looser, so there will be hiccups caused by inconsistencies in categoryoptions, groupsets etc due to “broken” metadata in old databases. Certainly before attempting such an upgrade I would consider trying to repair as much of these as possible, though again without tools it is not always really easy.
Of course the most important thing is to make sure you do all of these experiments in the full knowledge that you have a complete, verified/restored backup copy of the source database.
Meanwhile I guess the answer to my earlier question is that nobody has setup a dhis war museum.
Regards
Bob
···
On 20 August 2014 11:25, Knut Staring knutst@gmail.com wrote:
I thought Dan’s point was that it would not be necessary to go through every version?
But if it’s necessary, maybe it would suffice to describe in simple steps how to build old versions.
On Wed, Aug 20, 2014 at 12:15 PM, Bob Jolliffe bobjolliffe@gmail.com wrote:
The question of upgrading from very old dhis2 versions came up recently in another post.
It emerged then that we don’t seem to have a historical archive (museum!) of war artefacts going back beyond 2.10 on http://apps.dhis2.org/ci. We do have the source code tagged back as far as 2.4. Has anybody kept hold of these historic build or should we consider rebuilding and making available? Who would volunteer to do that?
–
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522
On 19 August 2014 22:59, Knut Staring knutst@gmail.com wrote:
Hi Moemedi,
Not sure, but I think you could try upgrading directly from 2.0.5 to 2.13 first, and then run the first script. Then 2.14, then script, then 2.15.
If things don’t work, you should provide the actual error messages.
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
On Tue, Aug 19, 2014 at 6:17 PM, Moemedi Ntunyane moemedi.ntunyane@hotmail.com wrote:
Hi All
I am upgrading DHIS 2.0.5 using postgreSQL DB, is there a shortcut other than using incremental way like 2.0.5, 2.0.6 …to 2.15. Directly executing scripts from http://www.dhis2.org/download/resources/sql/convert-fixed-attributes-to-dynamic.sql gives errors like column does not exist.
Moemedi Ntunyane
Co-founder KeyInConsulting
From: moemedi.ntunyane@hotmail.com
To: dan@dancocos.comCC: dhis2-devs@lists.launchpad.net
Subject: RE: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15
Date: Tue, 19 Aug 2014 16:47:46 +0200
Hi Dan
Thanks a lot.
Regards,
***Moemedi Ntunyane
Co-founder KeyInConsulting***
Subject: Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15
From: dan@dancocos.comDate: Tue, 19 Aug 2014 10:40:56 -0400
CC: dhis2-devs@lists.launchpad.net
To: moemedi.ntunyane@hotmail.comHello Moemedi,
The upgrades should happen automatically except for 2.13->2.14 and 2.14->2.15 Those scripts can be found here
2.13->2.14 http://www.dhis2.org/download/resources/sql/convert-fixed-attributes-to-dynamic.sql
2.14->2.15 http://www.dhis2.org/download/resources/sql/rename-patient-to-trackedentity.sql
Thanks,
Dan
Dan Cocos
BAO Systemswww.baosystems.com
T: +1 202-352-2671 | skype: dancocos
On Aug 19, 2014, at 6:40 AM, Moemedi Ntunyane moemedi.ntunyane@hotmail.com wrote:
Hi Developers, where can I get the upgrade scripts from the very lowest dhis 2.0.6 so that i do incremental
***Moemedi Ntunyane
Co-founder KeyInConsulting***
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devsMore help : https://help.launchpad.net/ListHelp
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
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522
–
Hi,
I posted a similar requirement a few months back. From my experience 2.0 to 2.10 worked fine.
Regards,
Busoye
···
On 20 August 2014 11:25, Knut Staring knutst@gmail.com wrote:
I thought Dan’s point was that it would not be necessary to go through every version?
But if it’s necessary, maybe it would suffice to describe in simple steps how to build old versions.
On Wed, Aug 20, 2014 at 12:15 PM, Bob Jolliffe bobjolliffe@gmail.com wrote:
The question of upgrading from very old dhis2 versions came up recently in another post.
It emerged then that we don’t seem to have a historical archive (museum!) of war artefacts going back beyond 2.10 on http://apps.dhis2.org/ci. We do have the source code tagged back as far as 2.4. Has anybody kept hold of these historic build or should we consider rebuilding and making available? Who would volunteer to do that?
–
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522
On 19 August 2014 22:59, Knut Staring knutst@gmail.com wrote:
Hi Moemedi,
Not sure, but I think you could try upgrading directly from 2.0.5 to 2.13 first, and then run the first script. Then 2.14, then script, then 2.15.
If things don’t work, you should provide the actual error messages.
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
On Tue, Aug 19, 2014 at 6:17 PM, Moemedi Ntunyane moemedi.ntunyane@hotmail.com wrote:
Hi All
I am upgrading DHIS 2.0.5 using postgreSQL DB, is there a shortcut other than using incremental way like 2.0.5, 2.0.6 …to 2.15. Directly executing scripts from http://www.dhis2.org/download/resources/sql/convert-fixed-attributes-to-dynamic.sql gives errors like column does not exist.
Moemedi Ntunyane
Co-founder KeyInConsulting
From: moemedi.ntunyane@hotmail.com
To: dan@dancocos.comCC: dhis2-devs@lists.launchpad.net
Subject: RE: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15
Date: Tue, 19 Aug 2014 16:47:46 +0200
Hi Dan
Thanks a lot.
Regards,
***Moemedi Ntunyane
Co-founder KeyInConsulting***
Subject: Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15
From: dan@dancocos.comDate: Tue, 19 Aug 2014 10:40:56 -0400
CC: dhis2-devs@lists.launchpad.net
To: moemedi.ntunyane@hotmail.comHello Moemedi,
The upgrades should happen automatically except for 2.13->2.14 and 2.14->2.15 Those scripts can be found here
2.13->2.14 http://www.dhis2.org/download/resources/sql/convert-fixed-attributes-to-dynamic.sql
2.14->2.15 http://www.dhis2.org/download/resources/sql/rename-patient-to-trackedentity.sql
Thanks,
Dan
Dan Cocos
BAO Systemswww.baosystems.com
T: +1 202-352-2671 | skype: dancocos
On Aug 19, 2014, at 6:40 AM, Moemedi Ntunyane moemedi.ntunyane@hotmail.com wrote:
Hi Developers, where can I get the upgrade scripts from the very lowest dhis 2.0.6 so that i do incremental
***Moemedi Ntunyane
Co-founder KeyInConsulting***
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devsMore help : https://help.launchpad.net/ListHelp
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
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522
–
Hi Adebusoye
Did you upload run any scripts? just uploaded the war file and restored the old database backup but the problem is everything seems fine but cannot display information related to dataset.
Regards,
Moemedi Ntunyane
Co-founder KeyInConsulting
Hello Moemedi
You only need to run the script when you want to upgrade from 2.13->2.14 OR 2.1->2.15. Run them before you start tomcat.
···
Wilfred F. Senyoni
Computer Science and Engineering Department
College of Information and Communication Technologies
University of Dar es salaam
On Wed, Aug 20, 2014 at 6:14 PM, Moemedi Ntunyane moemedi.ntunyane@hotmail.com wrote:
Hi Adebusoye
Did you upload run any scripts? just uploaded the war file and restored the old database backup but the
problem is everything seems fine but cannot display information related to dataset.
Regards,
Moemedi Ntunyane
Co-founder KeyInConsulting
Subject: Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15
From: busoye@hisp.org
Date: Wed, 20 Aug 2014 15:47:02 +0100CC: knutst@gmail.com; dhis2-devs@lists.launchpad.net; moemedi.ntunyane@hotmail.com
Hi,
I posted a similar requirement a few months back. From my experience 2.0 to 2.10 worked fine.
Regards,
Busoye
On 20 Aug 2014, at 12:12, Bob Jolliffe bobjolliffe@gmail.com wrote:
Yes in theory they “should”. Though there was much which changed between 2.05 and 2.10. All of the table altering stuff from earlier versions should be accumulated in newer versions but I recall that sometimes things did not go smoothely with major jumps in versions. I guess the simple fact is that incremental upgrades tend to get tested pretty heavily. Jumping versions becomes more of a leap of faith
But I do agree, if someone can verify that 2.05 to 2.10 works fine, then it would be good to hear.
I suspect the bigger problems will arise because the metadata integrity control on earlier versions was a good bit looser, so there will be hiccups caused by inconsistencies in categoryoptions, groupsets etc due to “broken” metadata in old databases. Certainly before attempting such an upgrade I would consider trying to repair as much of these as possible, though again without tools it is not always really easy.
Of course the most important thing is to make sure you do all of these experiments in the full knowledge that you have a complete, verified/restored backup copy of the source database.
Meanwhile I guess the answer to my earlier question is that nobody has setup a dhis war museum.
Regards
Bob
On 20 August 2014 11:25, Knut Staring knutst@gmail.com wrote:
I thought Dan’s point was that it would not be necessary to go through every version?
But if it’s necessary, maybe it would suffice to describe in simple steps how to build old versions.
On Wed, Aug 20, 2014 at 12:15 PM, Bob Jolliffe bobjolliffe@gmail.com wrote:
The question of upgrading from very old dhis2 versions came up recently in another post.
It emerged then that we don’t seem to have a historical archive (museum!) of war artefacts going back beyond 2.10 on http://apps.dhis2.org/ci. We do have the source code tagged back as far as 2.4. Has anybody kept hold of these historic build or should we consider rebuilding and making available? Who would volunteer to do that?
On 19 August 2014 22:59, Knut Staring knutst@gmail.com wrote:
Hi Moemedi,
Not sure, but I think you could try upgrading directly from 2.0.5 to 2.13 first, and then run the first script. Then 2.14, then script, then 2.15.
If things don’t work, you should provide the actual error messages.
On Tue, Aug 19, 2014 at 6:17 PM, Moemedi Ntunyane moemedi.ntunyane@hotmail.com wrote:
Hi All
I am upgrading DHIS 2.0.5 using postgreSQL DB, is there a shortcut other than using incremental way like 2.0.5, 2.0.6 …to 2.15. Directly executing scripts from http://www.dhis2.org/download/resources/sql/convert-fixed-attributes-to-dynamic.sql gives errors like column does not exist.
Moemedi Ntunyane
Co-founder KeyInConsulting
From: moemedi.ntunyane@hotmail.com
To: dan@dancocos.comCC: dhis2-devs@lists.launchpad.net
Subject: RE: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15
Date: Tue, 19 Aug 2014 16:47:46 +0200
Hi Dan
Thanks a lot.
Regards,
***Moemedi Ntunyane
Co-founder KeyInConsulting***
Subject: Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15
From: dan@dancocos.comDate: Tue, 19 Aug 2014 10:40:56 -0400
CC: dhis2-devs@lists.launchpad.net
To: moemedi.ntunyane@hotmail.comHello Moemedi,
The upgrades should happen automatically except for 2.13->2.14 and 2.14->2.15 Those scripts can be found here
2.13->2.14 http://www.dhis2.org/download/resources/sql/convert-fixed-attributes-to-dynamic.sql
2.14->2.15 http://www.dhis2.org/download/resources/sql/rename-patient-to-trackedentity.sql
Thanks,
Dan
Dan Cocos
BAO Systemswww.baosystems.com
T: +1 202-352-2671 | skype: dancocos
On Aug 19, 2014, at 6:40 AM, Moemedi Ntunyane moemedi.ntunyane@hotmail.com wrote:
Hi Developers, where can I get the upgrade scripts from the very lowest dhis 2.0.6 so that i do incremental
***Moemedi Ntunyane
Co-founder KeyInConsulting***
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devsMore help : https://help.launchpad.net/ListHelp
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
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522
–
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
–
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.netUnsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
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
Hi, Thanks a lot for information. I did manage to upgrade to 2.10. The datasets are not appearing but the data is available from the database, only displaying is a problem
Moemedi Ntunyane
Co-founder KeyInConsulting
Hi, Thanks a lot for information. I did manage to upgrade to 2.10. The datasets are not appearing but the data is available from the database, only displaying is a problem
Moemedi Ntunyane
Co-founder KeyInConsulting
Please be specific - what is not displaying where? With the newer version, have to go to Reports and run the Analytics before you will see any output in GIS, Pivot tables or charts.
···
On Thu, Aug 21, 2014 at 12:15 PM, Moemedi Ntunyane moemedi.ntunyane@hotmail.com wrote:
Hi, Thanks a lot for information. I did manage to upgrade to 2.10. The datasets are not appearing but the data is available from the database, only displaying is a problem
***Moemedi Ntunyane
Co-founder KeyInConsulting***
Date: Thu, 21 Aug 2014 10:58:06 +0300
Subject: Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15
From: senyoni@gmail.com
To: moemedi.ntunyane@hotmail.com
CC: busoye@hisp.org; bobjolliffe@gmail.com; dhis2-devs@lists.launchpad.netHello Moemedi
You only need to run the script when you want to upgrade from 2.13->2.14 OR 2.1->2.15. Run them before you start tomcat.
Wilfred F. Senyoni
Computer Science and Engineering Department
College of Information and Communication TechnologiesUniversity of Dar es salaam
On Wed, Aug 20, 2014 at 6:14 PM, Moemedi Ntunyane moemedi.ntunyane@hotmail.com wrote:
Hi Adebusoye
Did you upload run any scripts? just uploaded the war file and restored the old database backup but the
problem is everything seems fine but cannot display information related to dataset.
Regards,
Moemedi Ntunyane
Co-founder KeyInConsulting
Subject: Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15
From: busoye@hisp.org
Date: Wed, 20 Aug 2014 15:47:02 +0100CC: knutst@gmail.com; dhis2-devs@lists.launchpad.net; moemedi.ntunyane@hotmail.com
Hi,
I posted a similar requirement a few months back. From my experience 2.0 to 2.10 worked fine.
Regards,
Busoye
On 20 Aug 2014, at 12:12, Bob Jolliffe bobjolliffe@gmail.com wrote:
Yes in theory they “should”. Though there was much which changed between 2.05 and 2.10. All of the table altering stuff from earlier versions should be accumulated in newer versions but I recall that sometimes things did not go smoothely with major jumps in versions. I guess the simple fact is that incremental upgrades tend to get tested pretty heavily. Jumping versions becomes more of a leap of faith
But I do agree, if someone can verify that 2.05 to 2.10 works fine, then it would be good to hear.
I suspect the bigger problems will arise because the metadata integrity control on earlier versions was a good bit looser, so there will be hiccups caused by inconsistencies in categoryoptions, groupsets etc due to “broken” metadata in old databases. Certainly before attempting such an upgrade I would consider trying to repair as much of these as possible, though again without tools it is not always really easy.
Of course the most important thing is to make sure you do all of these experiments in the full knowledge that you have a complete, verified/restored backup copy of the source database.
Meanwhile I guess the answer to my earlier question is that nobody has setup a dhis war museum.
Regards
Bob
On 20 August 2014 11:25, Knut Staring knutst@gmail.com wrote:
I thought Dan’s point was that it would not be necessary to go through every version?
But if it’s necessary, maybe it would suffice to describe in simple steps how to build old versions.
On Wed, Aug 20, 2014 at 12:15 PM, Bob Jolliffe bobjolliffe@gmail.com wrote:
The question of upgrading from very old dhis2 versions came up recently in another post.
It emerged then that we don’t seem to have a historical archive (museum!) of war artefacts going back beyond 2.10 on http://apps.dhis2.org/ci. We do have the source code tagged back as far as 2.4. Has anybody kept hold of these historic build or should we consider rebuilding and making available? Who would volunteer to do that?
On 19 August 2014 22:59, Knut Staring knutst@gmail.com wrote:
Hi Moemedi,
Not sure, but I think you could try upgrading directly from 2.0.5 to 2.13 first, and then run the first script. Then 2.14, then script, then 2.15.
If things don’t work, you should provide the actual error messages.
On Tue, Aug 19, 2014 at 6:17 PM, Moemedi Ntunyane moemedi.ntunyane@hotmail.com wrote:
Hi All
I am upgrading DHIS 2.0.5 using postgreSQL DB, is there a shortcut other than using incremental way like 2.0.5, 2.0.6 …to 2.15. Directly executing scripts from http://www.dhis2.org/download/resources/sql/convert-fixed-attributes-to-dynamic.sql gives errors like column does not exist.
Moemedi Ntunyane
Co-founder KeyInConsulting
From: moemedi.ntunyane@hotmail.com
To: dan@dancocos.comCC: dhis2-devs@lists.launchpad.net
Subject: RE: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15
Date: Tue, 19 Aug 2014 16:47:46 +0200
Hi Dan
Thanks a lot.
Regards,
***Moemedi Ntunyane
Co-founder KeyInConsulting***
Subject: Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15
From: dan@dancocos.comDate: Tue, 19 Aug 2014 10:40:56 -0400
CC: dhis2-devs@lists.launchpad.net
To: moemedi.ntunyane@hotmail.comHello Moemedi,
The upgrades should happen automatically except for 2.13->2.14 and 2.14->2.15 Those scripts can be found here
2.13->2.14 http://www.dhis2.org/download/resources/sql/convert-fixed-attributes-to-dynamic.sql
2.14->2.15 http://www.dhis2.org/download/resources/sql/rename-patient-to-trackedentity.sql
Thanks,
Dan
Dan Cocos
BAO Systemswww.baosystems.com
T: +1 202-352-2671 | skype: dancocos
On Aug 19, 2014, at 6:40 AM, Moemedi Ntunyane moemedi.ntunyane@hotmail.com wrote:
Hi Developers, where can I get the upgrade scripts from the very lowest dhis 2.0.6 so that i do incremental
***Moemedi Ntunyane
Co-founder KeyInConsulting***
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devsMore help : https://help.launchpad.net/ListHelp
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
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522
–
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
–
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.netUnsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
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
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
–
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522
The old datasets and data elements are not displayed on the form. I was upgrading from 2.0.5 to 2.13.
Moemedi Ntunyane
Co-founder KeyInConsulting
Maybe try going to 2.10 first
···
On Aug 21, 2014 5:36 PM, “Moemedi Ntunyane” moemedi.ntunyane@hotmail.com wrote:
The old datasets and data elements are not displayed on the form. I was upgrading from 2.0.5 to 2.13.
***Moemedi Ntunyane
Co-founder KeyInConsulting***
From: knutst@gmail.com
Date: Thu, 21 Aug 2014 12:45:19 +0200Subject: Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15
To: moemedi.ntunyane@hotmail.com
CC: senyoni@gmail.com; dhis2-devs@lists.launchpad.netPlease be specific - what is not displaying where? With the newer version, have to go to Reports and run the Analytics before you will see any output in GIS, Pivot tables or charts.
On Thu, Aug 21, 2014 at 12:15 PM, Moemedi Ntunyane moemedi.ntunyane@hotmail.com wrote:
Hi, Thanks a lot for information. I did manage to upgrade to 2.10. The datasets are not appearing but the data is available from the database, only displaying is a problem
***Moemedi Ntunyane
Co-founder KeyInConsulting***
Date: Thu, 21 Aug 2014 10:58:06 +0300
Subject: Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15
From: senyoni@gmail.com
To: moemedi.ntunyane@hotmail.com
CC: busoye@hisp.org; bobjolliffe@gmail.com; dhis2-devs@lists.launchpad.netHello Moemedi
You only need to run the script when you want to upgrade from 2.13->2.14 OR 2.1->2.15. Run them before you start tomcat.
Wilfred F. Senyoni
Computer Science and Engineering Department
College of Information and Communication TechnologiesUniversity of Dar es salaam
On Wed, Aug 20, 2014 at 6:14 PM, Moemedi Ntunyane moemedi.ntunyane@hotmail.com wrote:
Hi Adebusoye
Did you upload run any scripts? just uploaded the war file and restored the old database backup but the
problem is everything seems fine but cannot display information related to dataset.
Regards,
Moemedi Ntunyane
Co-founder KeyInConsulting
Subject: Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15
From: busoye@hisp.org
Date: Wed, 20 Aug 2014 15:47:02 +0100CC: knutst@gmail.com; dhis2-devs@lists.launchpad.net; moemedi.ntunyane@hotmail.com
Hi,
I posted a similar requirement a few months back. From my experience 2.0 to 2.10 worked fine.
Regards,
Busoye
On 20 Aug 2014, at 12:12, Bob Jolliffe bobjolliffe@gmail.com wrote:
Yes in theory they “should”. Though there was much which changed between 2.05 and 2.10. All of the table altering stuff from earlier versions should be accumulated in newer versions but I recall that sometimes things did not go smoothely with major jumps in versions. I guess the simple fact is that incremental upgrades tend to get tested pretty heavily. Jumping versions becomes more of a leap of faith
But I do agree, if someone can verify that 2.05 to 2.10 works fine, then it would be good to hear.
I suspect the bigger problems will arise because the metadata integrity control on earlier versions was a good bit looser, so there will be hiccups caused by inconsistencies in categoryoptions, groupsets etc due to “broken” metadata in old databases. Certainly before attempting such an upgrade I would consider trying to repair as much of these as possible, though again without tools it is not always really easy.
Of course the most important thing is to make sure you do all of these experiments in the full knowledge that you have a complete, verified/restored backup copy of the source database.
Meanwhile I guess the answer to my earlier question is that nobody has setup a dhis war museum.
Regards
Bob
On 20 August 2014 11:25, Knut Staring knutst@gmail.com wrote:
I thought Dan’s point was that it would not be necessary to go through every version?
But if it’s necessary, maybe it would suffice to describe in simple steps how to build old versions.
On Wed, Aug 20, 2014 at 12:15 PM, Bob Jolliffe bobjolliffe@gmail.com wrote:
The question of upgrading from very old dhis2 versions came up recently in another post.
It emerged then that we don’t seem to have a historical archive (museum!) of war artefacts going back beyond 2.10 on http://apps.dhis2.org/ci. We do have the source code tagged back as far as 2.4. Has anybody kept hold of these historic build or should we consider rebuilding and making available? Who would volunteer to do that?
On 19 August 2014 22:59, Knut Staring knutst@gmail.com wrote:
Hi Moemedi,
Not sure, but I think you could try upgrading directly from 2.0.5 to 2.13 first, and then run the first script. Then 2.14, then script, then 2.15.
If things don’t work, you should provide the actual error messages.
On Tue, Aug 19, 2014 at 6:17 PM, Moemedi Ntunyane moemedi.ntunyane@hotmail.com wrote:
Hi All
I am upgrading DHIS 2.0.5 using postgreSQL DB, is there a shortcut other than using incremental way like 2.0.5, 2.0.6 …to 2.15. Directly executing scripts from http://www.dhis2.org/download/resources/sql/convert-fixed-attributes-to-dynamic.sql gives errors like column does not exist.
Moemedi Ntunyane
Co-founder KeyInConsulting
From: moemedi.ntunyane@hotmail.com
To: dan@dancocos.comCC: dhis2-devs@lists.launchpad.net
Subject: RE: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15
Date: Tue, 19 Aug 2014 16:47:46 +0200
Hi Dan
Thanks a lot.
Regards,
***Moemedi Ntunyane
Co-founder KeyInConsulting***
Subject: Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15
From: dan@dancocos.comDate: Tue, 19 Aug 2014 10:40:56 -0400
CC: dhis2-devs@lists.launchpad.net
To: moemedi.ntunyane@hotmail.comHello Moemedi,
The upgrades should happen automatically except for 2.13->2.14 and 2.14->2.15 Those scripts can be found here
2.13->2.14 http://www.dhis2.org/download/resources/sql/convert-fixed-attributes-to-dynamic.sql
2.14->2.15 http://www.dhis2.org/download/resources/sql/rename-patient-to-trackedentity.sql
Thanks,
Dan
Dan Cocos
BAO Systemswww.baosystems.com
T: +1 202-352-2671 | skype: dancocos
On Aug 19, 2014, at 6:40 AM, Moemedi Ntunyane moemedi.ntunyane@hotmail.com wrote:
Hi Developers, where can I get the upgrade scripts from the very lowest dhis 2.0.6 so that i do incremental
***Moemedi Ntunyane
Co-founder KeyInConsulting***
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devsMore help : https://help.launchpad.net/ListHelp
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
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522
–
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
–
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.netUnsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
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
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
–
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522
Hi these are two errors which I think are blocking datasets from appearingERROR 2014-08-22 09:04:48,993 HHH000388: Unsuccessful: alter table dataset add column mobile boolean not null (SchemaUpdate.java [main])* ERROR 2014-08-22 09:04:48,995 ERROR: column "mobile" contains null values (SchemaUpdate.java [main])
Moemedi Ntunyane
Co-founder KeyInConsulting
If you can access a SQL shell, please try
update dataset set mobile=false where mobile is null;
···
–
Morten
On Fri, Aug 22, 2014 at 2:55 PM, Moemedi Ntunyane moemedi.ntunyane@hotmail.com wrote:
Hi these are two errors which I think are blocking datasets from appearing
ERROR 2014-08-22 09:04:48,993 HHH000388: Unsuccessful: alter table dataset add column mobile boolean not null (SchemaUpdate.java [main])
- ERROR 2014-08-22 09:04:48,995 ERROR: column “mobile” contains null values (SchemaUpdate.java [main])
***Moemedi Ntunyane
Co-founder KeyInConsulting***
Date: Thu, 21 Aug 2014 21:17:32 +0200
Subject: RE: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15
From: knutst@gmail.com
To: moemedi.ntunyane@hotmail.com
CC: senyoni@gmail.com; dhis2-devs@lists.launchpad.netMaybe try going to 2.10 first
On Aug 21, 2014 5:36 PM, “Moemedi Ntunyane” moemedi.ntunyane@hotmail.com wrote:
The old datasets and data elements are not displayed on the form. I was upgrading from 2.0.5 to 2.13.
***Moemedi Ntunyane
Co-founder KeyInConsulting***
From: knutst@gmail.com
Date: Thu, 21 Aug 2014 12:45:19 +0200Subject: Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15
To: moemedi.ntunyane@hotmail.com
CC: senyoni@gmail.com; dhis2-devs@lists.launchpad.netPlease be specific - what is not displaying where? With the newer version, have to go to Reports and run the Analytics before you will see any output in GIS, Pivot tables or charts.
On Thu, Aug 21, 2014 at 12:15 PM, Moemedi Ntunyane moemedi.ntunyane@hotmail.com wrote:
Hi, Thanks a lot for information. I did manage to upgrade to 2.10. The datasets are not appearing but the data is available from the database, only displaying is a problem
***Moemedi Ntunyane
Co-founder KeyInConsulting***
Date: Thu, 21 Aug 2014 10:58:06 +0300
Subject: Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15
From: senyoni@gmail.com
To: moemedi.ntunyane@hotmail.com
CC: busoye@hisp.org; bobjolliffe@gmail.com; dhis2-devs@lists.launchpad.netHello Moemedi
You only need to run the script when you want to upgrade from 2.13->2.14 OR 2.1->2.15. Run them before you start tomcat.
Wilfred F. Senyoni
Computer Science and Engineering Department
College of Information and Communication TechnologiesUniversity of Dar es salaam
On Wed, Aug 20, 2014 at 6:14 PM, Moemedi Ntunyane moemedi.ntunyane@hotmail.com wrote:
Hi Adebusoye
Did you upload run any scripts? just uploaded the war file and restored the old database backup but the
problem is everything seems fine but cannot display information related to dataset.
Regards,
Moemedi Ntunyane
Co-founder KeyInConsulting
Subject: Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15
From: busoye@hisp.org
Date: Wed, 20 Aug 2014 15:47:02 +0100CC: knutst@gmail.com; dhis2-devs@lists.launchpad.net; moemedi.ntunyane@hotmail.com
Hi,
I posted a similar requirement a few months back. From my experience 2.0 to 2.10 worked fine.
Regards,
Busoye
On 20 Aug 2014, at 12:12, Bob Jolliffe bobjolliffe@gmail.com wrote:
Yes in theory they “should”. Though there was much which changed between 2.05 and 2.10. All of the table altering stuff from earlier versions should be accumulated in newer versions but I recall that sometimes things did not go smoothely with major jumps in versions. I guess the simple fact is that incremental upgrades tend to get tested pretty heavily. Jumping versions becomes more of a leap of faith
But I do agree, if someone can verify that 2.05 to 2.10 works fine, then it would be good to hear.
I suspect the bigger problems will arise because the metadata integrity control on earlier versions was a good bit looser, so there will be hiccups caused by inconsistencies in categoryoptions, groupsets etc due to “broken” metadata in old databases. Certainly before attempting such an upgrade I would consider trying to repair as much of these as possible, though again without tools it is not always really easy.
Of course the most important thing is to make sure you do all of these experiments in the full knowledge that you have a complete, verified/restored backup copy of the source database.
Meanwhile I guess the answer to my earlier question is that nobody has setup a dhis war museum.
Regards
Bob
On 20 August 2014 11:25, Knut Staring knutst@gmail.com wrote:
I thought Dan’s point was that it would not be necessary to go through every version?
But if it’s necessary, maybe it would suffice to describe in simple steps how to build old versions.
On Wed, Aug 20, 2014 at 12:15 PM, Bob Jolliffe bobjolliffe@gmail.com wrote:
The question of upgrading from very old dhis2 versions came up recently in another post.
It emerged then that we don’t seem to have a historical archive (museum!) of war artefacts going back beyond 2.10 on http://apps.dhis2.org/ci. We do have the source code tagged back as far as 2.4. Has anybody kept hold of these historic build or should we consider rebuilding and making available? Who would volunteer to do that?
On 19 August 2014 22:59, Knut Staring knutst@gmail.com wrote:
Hi Moemedi,
Not sure, but I think you could try upgrading directly from 2.0.5 to 2.13 first, and then run the first script. Then 2.14, then script, then 2.15.
If things don’t work, you should provide the actual error messages.
On Tue, Aug 19, 2014 at 6:17 PM, Moemedi Ntunyane moemedi.ntunyane@hotmail.com wrote:
Hi All
I am upgrading DHIS 2.0.5 using postgreSQL DB, is there a shortcut other than using incremental way like 2.0.5, 2.0.6 …to 2.15. Directly executing scripts from http://www.dhis2.org/download/resources/sql/convert-fixed-attributes-to-dynamic.sql gives errors like column does not exist.
Moemedi Ntunyane
Co-founder KeyInConsulting
From: moemedi.ntunyane@hotmail.com
To: dan@dancocos.comCC: dhis2-devs@lists.launchpad.net
Subject: RE: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15
Date: Tue, 19 Aug 2014 16:47:46 +0200
Hi Dan
Thanks a lot.
Regards,
***Moemedi Ntunyane
Co-founder KeyInConsulting***
Subject: Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15
From: dan@dancocos.comDate: Tue, 19 Aug 2014 10:40:56 -0400
CC: dhis2-devs@lists.launchpad.net
To: moemedi.ntunyane@hotmail.comHello Moemedi,
The upgrades should happen automatically except for 2.13->2.14 and 2.14->2.15 Those scripts can be found here
2.13->2.14 http://www.dhis2.org/download/resources/sql/convert-fixed-attributes-to-dynamic.sql
2.14->2.15 http://www.dhis2.org/download/resources/sql/rename-patient-to-trackedentity.sql
Thanks,
Dan
Dan Cocos
BAO Systemswww.baosystems.com
T: +1 202-352-2671 | skype: dancocos
On Aug 19, 2014, at 6:40 AM, Moemedi Ntunyane moemedi.ntunyane@hotmail.com wrote:
Hi Developers, where can I get the upgrade scripts from the very lowest dhis 2.0.6 so that i do incremental
***Moemedi Ntunyane
Co-founder KeyInConsulting***
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devsMore help : https://help.launchpad.net/ListHelp
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
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522
–
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
–
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.netUnsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
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
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
–
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522
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
Thanks a lot Morten, datasets are ok and their. I only have problem with editing orgunits. Orgunits are displaying but cannot be edited but cant see any error logs associateed with the problem.
Moemedi Ntunyane
Co-founder KeyInConsulting
In what sense can they not be edited? You click on edit but nothing happens?
You can try clearing your browser cache (CRTL+SHIFT+DELETE in Chrome)
···
On Fri, Aug 22, 2014 at 10:25 AM, Moemedi Ntunyane moemedi.ntunyane@hotmail.com wrote:
Thanks a lot Morten, datasets are ok and their. I only have problem with editing orgunits. Orgunits are displaying but cannot be edited but cant see any error logs associateed with the problem.
Moemedi Ntunyane
Co-founder KeyInConsulting
From: mortenoh@gmail.com
Date: Fri, 22 Aug 2014 15:08:26 +0700Subject: Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15
To: moemedi.ntunyane@hotmail.com
CC: knutst@gmail.com; dhis2-devs@lists.launchpad.net
If you can access a SQL shell, please try
update dataset set mobile=false where mobile is null;
–
Morten
On Fri, Aug 22, 2014 at 2:55 PM, Moemedi Ntunyane moemedi.ntunyane@hotmail.com wrote:
Hi these are two errors which I think are blocking datasets from appearing
ERROR 2014-08-22 09:04:48,993 HHH000388: Unsuccessful: alter table dataset add column mobile boolean not null (SchemaUpdate.java [main])
- ERROR 2014-08-22 09:04:48,995 ERROR: column “mobile” contains null values (SchemaUpdate.java [main])
***Moemedi Ntunyane
Co-founder KeyInConsulting***
Date: Thu, 21 Aug 2014 21:17:32 +0200
Subject: RE: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15
From: knutst@gmail.com
To: moemedi.ntunyane@hotmail.com
CC: senyoni@gmail.com; dhis2-devs@lists.launchpad.netMaybe try going to 2.10 first
On Aug 21, 2014 5:36 PM, “Moemedi Ntunyane” moemedi.ntunyane@hotmail.com wrote:
The old datasets and data elements are not displayed on the form. I was upgrading from 2.0.5 to 2.13.
***Moemedi Ntunyane
Co-founder KeyInConsulting***
From: knutst@gmail.com
Date: Thu, 21 Aug 2014 12:45:19 +0200Subject: Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15
To: moemedi.ntunyane@hotmail.com
CC: senyoni@gmail.com; dhis2-devs@lists.launchpad.netPlease be specific - what is not displaying where? With the newer version, have to go to Reports and run the Analytics before you will see any output in GIS, Pivot tables or charts.
On Thu, Aug 21, 2014 at 12:15 PM, Moemedi Ntunyane moemedi.ntunyane@hotmail.com wrote:
Hi, Thanks a lot for information. I did manage to upgrade to 2.10. The datasets are not appearing but the data is available from the database, only displaying is a problem
***Moemedi Ntunyane
Co-founder KeyInConsulting***
Date: Thu, 21 Aug 2014 10:58:06 +0300
Subject: Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15
From: senyoni@gmail.com
To: moemedi.ntunyane@hotmail.com
CC: busoye@hisp.org; bobjolliffe@gmail.com; dhis2-devs@lists.launchpad.netHello Moemedi
You only need to run the script when you want to upgrade from 2.13->2.14 OR 2.1->2.15. Run them before you start tomcat.
Wilfred F. Senyoni
Computer Science and Engineering Department
College of Information and Communication TechnologiesUniversity of Dar es salaam
On Wed, Aug 20, 2014 at 6:14 PM, Moemedi Ntunyane moemedi.ntunyane@hotmail.com wrote:
Hi Adebusoye
Did you upload run any scripts? just uploaded the war file and restored the old database backup but the
problem is everything seems fine but cannot display information related to dataset.
Regards,
Moemedi Ntunyane
Co-founder KeyInConsulting
Subject: Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15
From: busoye@hisp.org
Date: Wed, 20 Aug 2014 15:47:02 +0100CC: knutst@gmail.com; dhis2-devs@lists.launchpad.net; moemedi.ntunyane@hotmail.com
Hi,
I posted a similar requirement a few months back. From my experience 2.0 to 2.10 worked fine.
Regards,
Busoye
On 20 Aug 2014, at 12:12, Bob Jolliffe bobjolliffe@gmail.com wrote:
Yes in theory they “should”. Though there was much which changed between 2.05 and 2.10. All of the table altering stuff from earlier versions should be accumulated in newer versions but I recall that sometimes things did not go smoothely with major jumps in versions. I guess the simple fact is that incremental upgrades tend to get tested pretty heavily. Jumping versions becomes more of a leap of faith
But I do agree, if someone can verify that 2.05 to 2.10 works fine, then it would be good to hear.
I suspect the bigger problems will arise because the metadata integrity control on earlier versions was a good bit looser, so there will be hiccups caused by inconsistencies in categoryoptions, groupsets etc due to “broken” metadata in old databases. Certainly before attempting such an upgrade I would consider trying to repair as much of these as possible, though again without tools it is not always really easy.
Of course the most important thing is to make sure you do all of these experiments in the full knowledge that you have a complete, verified/restored backup copy of the source database.
Meanwhile I guess the answer to my earlier question is that nobody has setup a dhis war museum.
Regards
Bob
On 20 August 2014 11:25, Knut Staring knutst@gmail.com wrote:
I thought Dan’s point was that it would not be necessary to go through every version?
But if it’s necessary, maybe it would suffice to describe in simple steps how to build old versions.
On Wed, Aug 20, 2014 at 12:15 PM, Bob Jolliffe bobjolliffe@gmail.com wrote:
The question of upgrading from very old dhis2 versions came up recently in another post.
It emerged then that we don’t seem to have a historical archive (museum!) of war artefacts going back beyond 2.10 on http://apps.dhis2.org/ci. We do have the source code tagged back as far as 2.4. Has anybody kept hold of these historic build or should we consider rebuilding and making available? Who would volunteer to do that?
On 19 August 2014 22:59, Knut Staring knutst@gmail.com wrote:
Hi Moemedi,
Not sure, but I think you could try upgrading directly from 2.0.5 to 2.13 first, and then run the first script. Then 2.14, then script, then 2.15.
If things don’t work, you should provide the actual error messages.
On Tue, Aug 19, 2014 at 6:17 PM, Moemedi Ntunyane moemedi.ntunyane@hotmail.com wrote:
Hi All
I am upgrading DHIS 2.0.5 using postgreSQL DB, is there a shortcut other than using incremental way like 2.0.5, 2.0.6 …to 2.15. Directly executing scripts from http://www.dhis2.org/download/resources/sql/convert-fixed-attributes-to-dynamic.sql gives errors like column does not exist.
Moemedi Ntunyane
Co-founder KeyInConsulting
From: moemedi.ntunyane@hotmail.com
To: dan@dancocos.comCC: dhis2-devs@lists.launchpad.net
Subject: RE: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15
Date: Tue, 19 Aug 2014 16:47:46 +0200
Hi Dan
Thanks a lot.
Regards,
***Moemedi Ntunyane
Co-founder KeyInConsulting***
Subject: Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15
From: dan@dancocos.comDate: Tue, 19 Aug 2014 10:40:56 -0400
CC: dhis2-devs@lists.launchpad.net
To: moemedi.ntunyane@hotmail.comHello Moemedi,
The upgrades should happen automatically except for 2.13->2.14 and 2.14->2.15 Those scripts can be found here
2.13->2.14 http://www.dhis2.org/download/resources/sql/convert-fixed-attributes-to-dynamic.sql
2.14->2.15 http://www.dhis2.org/download/resources/sql/rename-patient-to-trackedentity.sql
Thanks,
Dan
Dan Cocos
BAO Systemswww.baosystems.com
T: +1 202-352-2671 | skype: dancocos
On Aug 19, 2014, at 6:40 AM, Moemedi Ntunyane moemedi.ntunyane@hotmail.com wrote:
Hi Developers, where can I get the upgrade scripts from the very lowest dhis 2.0.6 so that i do incremental
***Moemedi Ntunyane
Co-founder KeyInConsulting***
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devsMore help : https://help.launchpad.net/ListHelp
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
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522
–
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
–
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.netUnsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
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
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
–
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522
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
–
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522