Thanks, will try and make a simple article explaining how to do upgrades. I cannot get the data(report), run the analytic function and data mart functionality. how long does it usually takes, seems like it has been processing for the last 1.5 hrs? Yes there is much data in system!
Moemedi Ntunyane Co-founder KeyInConsulting From: [email protected] Date: Fri, 22 Aug 2014 16:22:02 +0200 Subject: Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15 To: [email protected] CC: [email protected]; [email protected] Excellent! Since other people also seem to have similar problems, we would really appreciate it if you could share a short write-up of your experience. Thanks, Knut On Fri, Aug 22, 2014 at 1:51 PM, Moemedi Ntunyane <[email protected]> wrote: Thanks a lot...I managed by including latitude column orgnunit table. Moemedi Ntunyane Co-founder KeyInConsulting From: [email protected] Date: Fri, 22 Aug 2014 11:53:31 +0200 Subject: Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15 To: [email protected] CC: [email protected]; [email protected] 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 <[email protected]> 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: [email protected] Date: Fri, 22 Aug 2014 15:08:26 +0700 Subject: Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15 To: [email protected] CC: [email protected]; [email protected] 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 <[email protected]> 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: [email protected] To: [email protected] CC: [email protected]; [email protected] Maybe try going to 2.10 first On Aug 21, 2014 5:36 PM, "Moemedi Ntunyane" <[email protected]> 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: [email protected] Date: Thu, 21 Aug 2014 12:45:19 +0200 Subject: Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15 To: [email protected] CC: [email protected]; [email protected] 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 <[email protected]> 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: [email protected] To: [email protected] CC: [email protected]; [email protected]; [email protected] 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 <[email protected]> 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: [email protected] Date: Wed, 20 Aug 2014 15:47:02 +0100 CC: [email protected]; [email protected]; [email protected] To: [email protected] 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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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: [email protected] To: [email protected] CC: [email protected] 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: [email protected] Date: Tue, 19 Aug 2014 10:40:56 -0400 CC: [email protected] To: [email protected] 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 <[email protected]> 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 : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp _______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] 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 : [email protected] 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 : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp _______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp _______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] 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 : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp -- Knut StaringDept. of Informatics, University of Oslo+4791880522 http://dhis2.org -- Knut StaringDept. of Informatics, University of Oslo+4791880522http://dhis2.org
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
