← Back to team overview

dhis2-devs team mailing list archive

Re: dhis upgrade from 2.0.5 to 2.15

 

Thanks a lot...I managed by including latitude column orgnunit table.

Moemedi Ntunyane
Co-founder KeyInConsulting


From: knutst@xxxxxxxxx
Date: Fri, 22 Aug 2014 11:53:31 +0200
Subject: Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15
To: moemedi.ntunyane@xxxxxxxxxxx
CC: mortenoh@xxxxxxxxx; dhis2-devs@xxxxxxxxxxxxxxxxxxx

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@xxxxxxxxxxx> 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@xxxxxxxxx
Date: Fri, 22 Aug 2014 15:08:26 +0700
Subject: Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15
To: moemedi.ntunyane@xxxxxxxxxxx


CC: knutst@xxxxxxxxx; dhis2-devs@xxxxxxxxxxxxxxxxxxx



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@xxxxxxxxxxx> wrote:







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


Date: Thu, 21 Aug 2014 21:17:32 +0200
Subject: RE: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15




From: knutst@xxxxxxxxx
To: moemedi.ntunyane@xxxxxxxxxxx
CC: senyoni@xxxxxxxxx; dhis2-devs@xxxxxxxxxxxxxxxxxxx





Maybe try going to 2.10 first
On Aug 21, 2014 5:36 PM, "Moemedi Ntunyane" <moemedi.ntunyane@xxxxxxxxxxx> 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@xxxxxxxxx
Date: Thu, 21 Aug 2014 12:45:19 +0200





Subject: Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15
To: moemedi.ntunyane@xxxxxxxxxxx
CC: senyoni@xxxxxxxxx; dhis2-devs@xxxxxxxxxxxxxxxxxxx






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@xxxxxxxxxxx> 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@xxxxxxxxx
To: moemedi.ntunyane@xxxxxxxxxxx
CC: busoye@xxxxxxxx; bobjolliffe@xxxxxxxxx; dhis2-devs@xxxxxxxxxxxxxxxxxxx








Hello MoemediYou 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@xxxxxxxxxxx> 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@xxxxxxxx
Date: Wed, 20 Aug 2014 15:47:02 +0100

CC: knutst@xxxxxxxxx; dhis2-devs@xxxxxxxxxxxxxxxxxxx; moemedi.ntunyane@xxxxxxxxxxx








To: bobjolliffe@xxxxxxxxx

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@xxxxxxxxx> 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.
RegardsBob

On 20 August 2014 11:25, Knut Staring <knutst@xxxxxxxxx> 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@xxxxxxxxx> 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@xxxxxxxxx> 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@xxxxxxxxxxx> 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@xxxxxxxxxxx
To: dan@xxxxxxxxxxxx














CC: dhis2-devs@xxxxxxxxxxxxxxxxxxx
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@xxxxxxxxxxxx














Date: Tue, 19 Aug 2014 10:40:56 -0400
CC: dhis2-devs@xxxxxxxxxxxxxxxxxxx
To: moemedi.ntunyane@xxxxxxxxxxx















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 Systems
www.baosystems.com













T: +1 202-352-2671 | skype: dancocos






On Aug 19, 2014, at 6:40 AM, Moemedi Ntunyane <moemedi.ntunyane@xxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~dhis2-devs














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






 		 	   		   		 	   		  

_______________________________________________

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




-- 
Knut StaringDept. of Informatics, University of Oslo+4791880522



http://dhis2.org



_______________________________________________

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






-- 
Knut StaringDept. of Informatics, University of Oslo+4791880522
http://dhis2.org




_______________________________________________
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









 		 	   		  

_______________________________________________

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



 		 	   		  

_______________________________________________

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




-- 
Knut StaringDept. of Informatics, University of Oslo+4791880522
http://dhis2.org


 		 	   		  
 		 	   		  

_______________________________________________

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



 		 	   		  


-- 
Knut StaringDept. of Informatics, University of Oslo+4791880522http://dhis2.org

 		 	   		  

Follow ups

References