dhis2-devs team mailing list archive

[Ola Hodne Titlestad <olati@xxxxxxxxxx>]

Anything in the  tomcat log while running analytics that indicates there is
a problem?

Ola
------
22. aug. 2014 17:13 skrev "Moemedi Ntunyane" <moemedi.ntunyane@xxxxxxxxxxx>
følgende:

> 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 NtunyaneCo-founder KeyInConsulting*
>
>
> ------------------------------
> From: knutst@xxxxxxxxx
> Date: Fri, 22 Aug 2014 16:22:02 +0200
> Subject: Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15
> To: moemedi.ntunyane@xxxxxxxxxxx
> CC: mortenoh@xxxxxxxxx; dhis2-devs@xxxxxxxxxxxxxxxxxxx
>
> 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 <
> moemedi.ntunyane@xxxxxxxxxxx> wrote:
>
> 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 NtunyaneCo-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 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@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 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@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 NtunyaneCo-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.
>
> Regards
> Bob
>
>
> 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 NtunyaneCo-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 Staring
> Dept. 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 Staring
> Dept. 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 Staring
> Dept. 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 Staring
> Dept. of Informatics, University of Oslo
> +4791880522
> http://dhis2.org
>
>
>
>
> --
> Knut Staring
> Dept. 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
>
>