[Dhis2-devs] using mydatamart to export data excel format
Hi evryone Mydatamart tool not able to download metadata from dhis instance. All possible options checked!! Just to verify: is this tool available DHIS2.14! that is before implementation of pivot tables!!...Thankz in advbanced!! 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
Re: [Dhis2-devs] using mydatamart to export data excel format
Thanks Bob. We are not stuck, jst needed a simply tool to be used by clients to extract data in form of excel format. And the format should always be the same because it will be used to update data in powerpoint for presentation purposes Moemedi Ntunyane Co-founder KeyInConsulting > Date: Wed, 24 Jun 2015 17:14:03 +0100 > Subject: Re: [Dhis2-devs] using mydatamart to export data excel format > From: bobjolli...@gmail.com > To: moemedi.ntuny...@hotmail.com > CC: dhis2-devs@lists.launchpad.net > > Hi Moemedi > > Nobody has seriously looked at mydatamart now for over two years so it > is hard to tell. It was basically superceded by the introduction of > web pivot tables and the new web api and analytics. > > Is there any reason why you are still stuck on 2.14? > > Bob > > On 24 June 2015 at 16:55, Moemedi Ntunyane > wrote: > > Hi evryone > > > > Mydatamart tool not able to download metadata from dhis instance. All > > possible options checked!! Just to verify: > > is this tool available DHIS2.14! that is before implementation of pivot > > tables!!...Thankz in advbanced!! > > > > > > 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 > > ___ 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
[Dhis2-devs] DHIS upgrade from 2.0.5 to 2.14
Good Day Every one I want to upgrade DHIS 2.0.5 to a new version(2.14) which is more advanced with a lot of improved features. I cannot see a clear manual for doing the upgrade like scripts for all the versions from 2.0.5 to 2.14. How can I upgrade without continuously moving version by version. Thanks for your help in advanced... ___ 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
[Dhis2-devs] upgrade from 2.0.5 to 2.14
Good Day Every one I want to upgrade DHIS 2.0.5 to a new version(2.14) which is more advanced with a lot of improved features. I cannot see a clear manual for doing the upgrade like scripts for all the versions from 2.0.5 to 2.14. How can I upgrade without continously moving version by version. Thanks for your help in advanced... 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
[Dhis2-devs] dhis upgrade from 2.0.5 to 2.15
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
Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15
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: d...@dancocos.com Date: Tue, 19 Aug 2014 10:40:56 -0400 CC: dhis2-devs@lists.launchpad.net To: moemedi.ntuny...@hotmail.com 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.sql2.14->2.15 http://www.dhis2.org/download/resources/sql/rename-patient-to-trackedentity.sql Thanks,Dan Dan Cocos BAO Systems www.baosystems.comT: +1 202-352-2671 | skype: dancocos On Aug 19, 2014, at 6:40 AM, Moemedi Ntunyane 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 ___ 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
Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15
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.ntuny...@hotmail.com To: d...@dancocos.com CC: 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: d...@dancocos.com Date: Tue, 19 Aug 2014 10:40:56 -0400 CC: dhis2-devs@lists.launchpad.net To: moemedi.ntuny...@hotmail.com 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.sql2.14->2.15 http://www.dhis2.org/download/resources/sql/rename-patient-to-trackedentity.sql Thanks,Dan Dan Cocos BAO Systems www.baosystems.comT: +1 202-352-2671 | skype: dancocos On Aug 19, 2014, at 6:40 AM, Moemedi Ntunyane 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 ___ 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
Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15
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: bus...@hisp.org Date: Wed, 20 Aug 2014 15:47:02 +0100 CC: knu...@gmail.com; dhis2-devs@lists.launchpad.net; moemedi.ntuny...@hotmail.com To: bobjolli...@gmail.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 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 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 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 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 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.ntuny...@hotmail.com To: d...@dancocos.com CC: 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: d...@dancocos.com Date: Tue, 19 Aug 2014 10:40:56 -0400 CC: dhis2-devs@lists.launchpad.net To: moemedi.ntuny...@hotmail.com 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 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 ___ Mailing list: https://launchpad.net/~dhis
Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15
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: seny...@gmail.com To: moemedi.ntuny...@hotmail.com CC: bus...@hisp.org; bobjolli...@gmail.com; dhis2-devs@lists.launchpad.net 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 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: bus...@hisp.org Date: Wed, 20 Aug 2014 15:47:02 +0100 CC: knu...@gmail.com; dhis2-devs@lists.launchpad.net; moemedi.ntuny...@hotmail.com To: bobjolli...@gmail.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 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 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 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 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 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.ntuny...@hotmail.com To: d...@dancocos.com CC: 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: d...@dancocos.com Date: Tue, 19 Aug 2014 10:40:56 -0400 CC: dhis2-devs@lists.launchpad.net To: moemedi.ntuny...@hotmail.com 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 htt
Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15
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: seny...@gmail.com To: moemedi.ntuny...@hotmail.com CC: bus...@hisp.org; bobjolli...@gmail.com; dhis2-devs@lists.launchpad.net 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 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: bus...@hisp.org Date: Wed, 20 Aug 2014 15:47:02 +0100 CC: knu...@gmail.com; dhis2-devs@lists.launchpad.net; moemedi.ntuny...@hotmail.com To: bobjolli...@gmail.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 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 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 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 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 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.ntuny...@hotmail.com To: d...@dancocos.com CC: 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: d...@dancocos.com Date: Tue, 19 Aug 2014 10:40:56 -0400 CC: dhis2-devs@lists.launchpad.net To: moemedi.ntuny...@hotmail.com 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 htt
Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15
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: knu...@gmail.com Date: Thu, 21 Aug 2014 12:45:19 +0200 Subject: Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15 To: moemedi.ntuny...@hotmail.com CC: seny...@gmail.com; dhis2-devs@lists.launchpad.net 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 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: seny...@gmail.com To: moemedi.ntuny...@hotmail.com CC: bus...@hisp.org; bobjolli...@gmail.com; dhis2-devs@lists.launchpad.net 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 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: bus...@hisp.org Date: Wed, 20 Aug 2014 15:47:02 +0100 CC: knu...@gmail.com; dhis2-devs@lists.launchpad.net; moemedi.ntuny...@hotmail.com To: bobjolli...@gmail.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 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 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 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 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 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.ntuny...@hotmail.com To: d...@dancocos.com CC: dhis2-devs@lists.launchpad.net Subject: RE: [Dhis2-devs] dhi
Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15
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: knu...@gmail.com To: moemedi.ntuny...@hotmail.com CC: seny...@gmail.com; dhis2-devs@lists.launchpad.net Maybe try going to 2.10 first On Aug 21, 2014 5:36 PM, "Moemedi Ntunyane" 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: knu...@gmail.com Date: Thu, 21 Aug 2014 12:45:19 +0200 Subject: Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15 To: moemedi.ntuny...@hotmail.com CC: seny...@gmail.com; dhis2-devs@lists.launchpad.net 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 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: seny...@gmail.com To: moemedi.ntuny...@hotmail.com CC: bus...@hisp.org; bobjolli...@gmail.com; dhis2-devs@lists.launchpad.net 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 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: bus...@hisp.org Date: Wed, 20 Aug 2014 15:47:02 +0100 CC: knu...@gmail.com; dhis2-devs@lists.launchpad.net; moemedi.ntuny...@hotmail.com To: bobjolli...@gmail.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 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 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 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 wrote: Hi Moemedi,Not sure, but I think you could try upgrading directly from 2.0.5 to 2.13 first, and then run t
Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15
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: morte...@gmail.com Date: Fri, 22 Aug 2014 15:08:26 +0700 Subject: Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15 To: moemedi.ntuny...@hotmail.com CC: knu...@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 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: knu...@gmail.com To: moemedi.ntuny...@hotmail.com CC: seny...@gmail.com; dhis2-devs@lists.launchpad.net Maybe try going to 2.10 first On Aug 21, 2014 5:36 PM, "Moemedi Ntunyane" 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: knu...@gmail.com Date: Thu, 21 Aug 2014 12:45:19 +0200 Subject: Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15 To: moemedi.ntuny...@hotmail.com CC: seny...@gmail.com; dhis2-devs@lists.launchpad.net 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 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: seny...@gmail.com To: moemedi.ntuny...@hotmail.com CC: bus...@hisp.org; bobjolli...@gmail.com; dhis2-devs@lists.launchpad.net 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 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: bus...@hisp.org Date: Wed, 20 Aug 2014 15:47:02 +0100 CC: knu...@gmail.com; dhis2-devs@lists.launchpad.net; moemedi.ntuny...@hotmail.com To: bobjolli...@gmail.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 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 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
Re: [Dhis2-devs] 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: knu...@gmail.com Date: Fri, 22 Aug 2014 11:53:31 +0200 Subject: Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15 To: moemedi.ntuny...@hotmail.com CC: morte...@gmail.com; dhis2-devs@lists.launchpad.net 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 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: morte...@gmail.com Date: Fri, 22 Aug 2014 15:08:26 +0700 Subject: Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15 To: moemedi.ntuny...@hotmail.com CC: knu...@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 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: knu...@gmail.com To: moemedi.ntuny...@hotmail.com CC: seny...@gmail.com; dhis2-devs@lists.launchpad.net Maybe try going to 2.10 first On Aug 21, 2014 5:36 PM, "Moemedi Ntunyane" 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: knu...@gmail.com Date: Thu, 21 Aug 2014 12:45:19 +0200 Subject: Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15 To: moemedi.ntuny...@hotmail.com CC: seny...@gmail.com; dhis2-devs@lists.launchpad.net 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 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: seny...@gmail.com To: moemedi.ntuny...@hotmail.com CC: bus...@hisp.org; bobjolli...@gmail.com; dhis2-devs@lists.launchpad.net 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 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: bus...@hisp.org Date: Wed, 20 Aug 2014 15:47:02 +0100 CC: knu...@gmail.com; dhis2-devs@lists.launchpad.net; moemedi.ntuny...@hotmail.com To: bobjolli...@gmail.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 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 p
Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15
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: knu...@gmail.com Date: Fri, 22 Aug 2014 16:22:02 +0200 Subject: Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15 To: moemedi.ntuny...@hotmail.com CC: morte...@gmail.com; dhis2-devs@lists.launchpad.net 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 wrote: Thanks a lot...I managed by including latitude column orgnunit table. Moemedi Ntunyane Co-founder KeyInConsulting From: knu...@gmail.com Date: Fri, 22 Aug 2014 11:53:31 +0200 Subject: Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15 To: moemedi.ntuny...@hotmail.com CC: morte...@gmail.com; dhis2-devs@lists.launchpad.net 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 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: morte...@gmail.com Date: Fri, 22 Aug 2014 15:08:26 +0700 Subject: Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15 To: moemedi.ntuny...@hotmail.com CC: knu...@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 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: knu...@gmail.com To: moemedi.ntuny...@hotmail.com CC: seny...@gmail.com; dhis2-devs@lists.launchpad.net Maybe try going to 2.10 first On Aug 21, 2014 5:36 PM, "Moemedi Ntunyane" 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: knu...@gmail.com Date: Thu, 21 Aug 2014 12:45:19 +0200 Subject: Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15 To: moemedi.ntuny...@hotmail.com CC: seny...@gmail.com; dhis2-devs@lists.launchpad.net 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 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: seny...@gmail.com To: moemedi.ntuny...@hotmail.com CC: bus...@hisp.org; bobjolli...@gmail.com; dhis2-devs@lists.launchpad.net 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 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: bus...@hisp.org Date: Wed, 20 Aug 2014 15:47:02 +0100 CC: knu...@gmail.com; dhis2-devs@lists.launchpad.net; moemedi.ntuny...@hotmail.com To: bobjolli...@gmail.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 wrote: Yes in theory they "should". Though there was much
[Dhis2-devs] Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics_2009" does not exist
Hi all I am having a problem with generating pivot tables as dat cannot be found and the follwing error appears:Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics_2009" does not exist thnzx in advance 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
Re: [Dhis2-devs] Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics_2009" does not exist
Hi All All data seems to be ok as it is available in data entry screen and only not available in reports Moemedi Ntunyane Co-founder KeyInConsulting From: moemedi.ntuny...@hotmail.com To: dhis2-devs@lists.launchpad.net Subject: Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics_2009" does not exist Date: Thu, 11 Sep 2014 17:34:51 +0200 Hi all I am having a problem with generating pivot tables as dat cannot be found and the follwing error appears:Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics_2009" does not exist thnzx in advance 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
Re: [Dhis2-devs] Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics_2009" does not exist
Hi Lars Will send the copy of the log file as I am not at the station. I generated the analytics tables but the errors shows that the errors analytics tables cannot be created Regards, Moemedi Ntunyane Co-founder KeyInConsulting Date: Thu, 11 Sep 2014 14:19:19 -0400 Subject: Re: [Dhis2-devs] Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics_2009" does not exist From: larshe...@gmail.com To: moemedi.ntuny...@hotmail.com CC: dhis2-devs@lists.launchpad.net Hi Moemedi, did you run the analytics table generation process first? If yes, any exceptions in the tomcat log? Lars On Thu, Sep 11, 2014 at 12:51 PM, Moemedi Ntunyane wrote: Hi All All data seems to be ok as it is available in data entry screen and only not available in reports Moemedi Ntunyane Co-founder KeyInConsulting From: moemedi.ntuny...@hotmail.com To: dhis2-devs@lists.launchpad.net Subject: Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics_2009" does not exist Date: Thu, 11 Sep 2014 17:34:51 +0200 Hi all I am having a problem with generating pivot tables as dat cannot be found and the follwing error appears:Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics_2009" does not exist thnzx in advance 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 ___ 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
Re: [Dhis2-devs] Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics_2009" does not exist
gatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at
org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:95)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: org.postgresql.util.PSQLException: ERROR: relation
"completenesstarget" does not exist
Moemedi Ntunyane
Co-founder KeyInConsulting
From: moemedi.ntuny...@hotmail.com
To: larshe...@gmail.com
CC: dhis2-devs@lists.launchpad.net
Subject: RE: [Dhis2-devs] Caused by: org.postgresql.util.PSQLException: ERROR:
relation "analytics_2009" does not exist
Date: Fri, 12 Sep 2014 09:45:30 +0200
Hi Lars
Will send the copy of the log file as I am not at the station. I generated the
analytics tables but the errors shows that the errors analytics tables cannot
be created
Regards,
Moemedi Ntunyane
Co-founder KeyInConsulting
Date: Thu, 11 Sep 2014 14:19:19 -0400
Subject: Re: [Dhis2-devs] Caused by: org.postgresql.util.PSQLException: ERROR:
relation "analytics_2009" does not exist
From: larshe...@gmail.com
To: moemedi.ntuny...@hotmail.com
CC: dhis2-devs@lists.launchpad.net
Hi Moemedi,
did you run the analytics table generation process first? If yes, any
exceptions in the tomcat log?
Lars
On Thu, Sep 11, 2014 at 12:51 PM, Moemedi Ntunyane
wrote:
Hi All
All data seems to be ok as it is available in data entry screen and only not
available in reports
Moemedi Ntunyane
Co-founder KeyInConsulting
From: moemedi.ntuny...@hotmail.com
To: dhis2-devs@lists.launchpad.net
Subject: Caused by: org.postgresql.util.PSQLException: ERROR: relation
"analytics_2009" does not exist
Date: Thu, 11 Sep 2014 17:34:51 +0200
Hi all
I am having a problem with generating pivot tables as dat cannot be found and
the follwing error appears:Caused by: org.postgresql.util.PSQLException: ERROR:
relation "analytics_2009" does not exist
thnzx in advance
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
___
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
Re: [Dhis2-devs] Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics_2009" does not exist
Hi All
Please help, this error exit and do not know if its a bug or what as tried
running analytics tables for some while...
>From log analysis it seems this is the error:
DataIntegrityViolationException: PreparedStatementCallback; SQL [insert into
_periodstructure values (?,?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR: null value in
column "iso" violates not-null constraint; nested exception is
org.postgresql.util.PSQLException: ERROR: null value in column "iso" violates
not-null constraint
Moemedi Ntunyane
Co-founder KeyInConsulting
From: moemedi.ntuny...@hotmail.com
To: larshe...@gmail.com
CC: dhis2-devs@lists.launchpad.net
Subject: RE: [Dhis2-devs] Caused by: org.postgresql.util.PSQLException: ERROR:
relation "analytics_2009" does not exist
Date: Fri, 12 Sep 2014 10:21:25 +0200
Below is the copy of the error log:
* INFO 2014-09-11 17:18:33,189 Query failed, likely because the requested
analytics table does not exist (JdbcAnalyticsManager.java
[SimpleAsyncTaskExecutor-32])
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL
grammar [select "ds","uidlevel2", count(value) as value from completenesstarget
where "ds" in ('hOoA0bFo96D', 'hWqRDn4VpaF') and "uidlevel2" in ('OxnNb1tfpXB',
'SDB3KHGyjiK', 'VU9xLppiHNF', 'WWQvbVWpnpp', 'XgmvbwoMxuT', 'lTzRY1k8J28',
'o3BMs74aL2D') group by "ds","uidlevel2"]; nested exception is
org.postgresql.util.PSQLException: ERROR: relation "completenesstarget" does
not exist
Position: 53
at
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:237)
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)
at
org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:501)
at
org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(JdbcAnalyticsManager.java:325)
at
org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAnalyticsManager.java:129)
at sun.reflect.GeneratedMethodAccessor482.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at
org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:95)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: org.postgresql.util.PSQLException: ERROR: relation
"completenesstarget" does not exist
Position: 53
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:560)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:283)
at
com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35)
at
org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:441)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
... 13 more
* INFO 2014-09-11 17:18:33,188 Query failed, likely because the requested
analytics table does not exist (JdbcAnalyticsManager.java
[SimpleAsyncTaskExecutor-31])
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL
grammar [select "ds","uidlevel2", count(value) as value from completenesstarget
where "ds" in ('U8NAwVfGzO7', 'VWU7Rtolaec') and "uidlevel2" in ('OxnNb1tfpXB',
'SDB3KHGyjiK', 'VU9xLppiHNF', 'WWQvbVWpnpp', 'XgmvbwoMxuT', 'lTzRY1k8J28',
'o3BMs74aL2D') group by "ds","uidlevel2"]; nested exception is
org.postgresql.util.PSQLException: ERROR: relation "completenesstarget" does
not exist
Position
[Dhis2-devs] periodstructure giving errors...
Hi All I have this problem while generating the resource tables...all other tables are fine except periodstructure... Process failed: PreparedStatementCallback; SQL [insert into _periodstructure values (?,?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR: null value in column "iso" violates not-null constraint; nested exception is org.postgresql.util.PSQLException: ERROR: null value in column "iso" violates not-null constraint Regards, 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
Re: [Dhis2-devs] periodstructure giving errors...
Hi Jason Thanx, I just run the query you gave and no records were available and removed not = year(!=year) and records where available. The date format is available as: 1573;6;"2010-01-01";"2010-01-31" 1589;6;"2010-02-01";"2010-02-28" The error available shows that there is key violation for null values for iso column in the periodstructure table. Moemedi Ntunyane Co-founder KeyInConsulting Date: Mon, 15 Sep 2014 11:46:07 +0200 Subject: Re: [Dhis2-devs] periodstructure giving errors... From: jason.p.picker...@gmail.com To: moemedi.ntuny...@hotmail.com CC: dhis2-devs@lists.launchpad.net Very likely you have an invalid period in the periods table. Can you run this and see what happens? SELECT * FROM period where age(enddate,startdate) != '1 year'::interval and periodtypeid = (SELECT periodtypeid from periodtype where name = 'Yearly'); Also, you should get an error which will help you to decipher which period is not correct , something like Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "in_periodstructure_iso" Detail: Key (iso)=(1995) already exists. Best regards,Jason On Fri, Sep 12, 2014 at 5:03 PM, Moemedi Ntunyane wrote: Hi All I have this problem while generating the resource tables...all other tables are fine except periodstructure... Process failed: PreparedStatementCallback; SQL [insert into _periodstructure values (?,?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR: null value in column "iso" violates not-null constraint; nested exception is org.postgresql.util.PSQLException: ERROR: null value in column "iso" violates not-null constraint Regards, 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 -- Jason P. Pickering email: jason.p.picker...@gmail.com tel:+46764147049 ___ 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
Re: [Dhis2-devs] periodstructure giving errors...
Hi Jason Thnx, I had successfully elimated duplicate records the error still pesistit complaining of ISO column: is this column a date column?? Process failed: PreparedStatementCallback; SQL [insert into _periodstructure values (?,?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR: null value in column "iso" violates not-null constraint; nested exception is org.postgresql.util.PSQLException: ERROR: null value in column "iso" violates not-null constraint. Regards, Moemedi Ntunyane Co-founder KeyInConsulting Date: Mon, 15 Sep 2014 12:22:31 +0200 Subject: Re: [Dhis2-devs] periodstructure giving errors... From: jason.p.picker...@gmail.com To: moemedi.ntuny...@hotmail.com CC: dhis2-devs@lists.launchpad.net So, the period 1589;6;"2010-02-01";"2010-02-28 , points to a yearly period type, which is not a year in duration. You are going to need to get rid of it. You will need to do something like SELECT COUNT(*) FROM datavalue where periodid = 1589; If you have any records with this periodID, you are going to need to resolve these. This period looks to be monthly, so if the data is also monthly, you should be able to reassign it to a monthly period which starts in 2010-02-01 and ends in 2010-02-28, if it is already there. You could try "SELECT * FROM period where startdate = '2010-02-01'::date;" and see if you get multiple periods for Feb 2010. If you have multiple periods for Feb 2010, then you need to do something like UPDATE datavalue set periodid = ? where is the periodid of the "real" Feb 2010 period. Then you should get rid of the bogus Feb 2010 period with DELETE FROM period where periodid = 1589; After that, you should clear your cache from Data administration. Do not try any of this on a production database!!! Regards,Jason On Mon, Sep 15, 2014 at 12:14 PM, Moemedi Ntunyane wrote: Hi Jason Thanx, I just run the query you gave and no records were available and removed not = year(!=year) and records where available. The date format is available as: 1573;6;"2010-01-01";"2010-01-31" 1589;6;"2010-02-01";"2010-02-28" The error available shows that there is key violation for null values for iso column in the periodstructure table. Moemedi Ntunyane Co-founder KeyInConsulting Date: Mon, 15 Sep 2014 11:46:07 +0200 Subject: Re: [Dhis2-devs] periodstructure giving errors... From: jason.p.picker...@gmail.com To: moemedi.ntuny...@hotmail.com CC: dhis2-devs@lists.launchpad.net Very likely you have an invalid period in the periods table. Can you run this and see what happens? SELECT * FROM period where age(enddate,startdate) != '1 year'::interval and periodtypeid = (SELECT periodtypeid from periodtype where name = 'Yearly'); Also, you should get an error which will help you to decipher which period is not correct , something like Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "in_periodstructure_iso" Detail: Key (iso)=(1995) already exists. Best regards,Jason On Fri, Sep 12, 2014 at 5:03 PM, Moemedi Ntunyane wrote: Hi All I have this problem while generating the resource tables...all other tables are fine except periodstructure... Process failed: PreparedStatementCallback; SQL [insert into _periodstructure values (?,?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR: null value in column "iso" violates not-null constraint; nested exception is org.postgresql.util.PSQLException: ERROR: null value in column "iso" violates not-null constraint Regards, 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 -- Jason P. Pickering email: jason.p.picker...@gmail.com tel:+46764147049 -- Jason P. Pickering email: jason.p.picker...@gmail.com tel:+46764147049 ___ 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
Re: [Dhis2-devs] periodstructure giving errors...
Thanks, will eliminate all of them. So far the query returned 5 records. But other records are referenced by foreign keys like: chart_periods;reporttable_periods;completedatasetregistration Moemedi Ntunyane Co-founder KeyInConsulting Date: Mon, 15 Sep 2014 16:01:08 +0200 Subject: Re: [Dhis2-devs] periodstructure giving errors... From: jason.p.picker...@gmail.com To: moemedi.ntuny...@hotmail.com CC: dhis2-devs@lists.launchpad.net I suspect you have more invalid periods then. You should follow the same procedure for other period types, i.e. checking to be sure that all months are one month, all weeks are one week, etc. You may want to try something like SELECT startdate, periodtypeid,COUNT(*) from period GROUP BY startdate,periodtypeid HAVING COUNT(*) > 1 ; and see which periods and period types you have multiple records for. Ideally, this should not happen. Regards,Jason On Mon, Sep 15, 2014 at 3:53 PM, Moemedi Ntunyane wrote: Hi Jason Thnx, I had successfully elimated duplicate records the error still pesistit complaining of ISO column: is this column a date column?? Process failed: PreparedStatementCallback; SQL [insert into _periodstructure values (?,?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR: null value in column "iso" violates not-null constraint; nested exception is org.postgresql.util.PSQLException: ERROR: null value in column "iso" violates not-null constraint. Regards, Moemedi Ntunyane Co-founder KeyInConsulting Date: Mon, 15 Sep 2014 12:22:31 +0200 Subject: Re: [Dhis2-devs] periodstructure giving errors... From: jason.p.picker...@gmail.com To: moemedi.ntuny...@hotmail.com CC: dhis2-devs@lists.launchpad.net So, the period 1589;6;"2010-02-01";"2010-02-28 , points to a yearly period type, which is not a year in duration. You are going to need to get rid of it. You will need to do something like SELECT COUNT(*) FROM datavalue where periodid = 1589; If you have any records with this periodID, you are going to need to resolve these. This period looks to be monthly, so if the data is also monthly, you should be able to reassign it to a monthly period which starts in 2010-02-01 and ends in 2010-02-28, if it is already there. You could try "SELECT * FROM period where startdate = '2010-02-01'::date;" and see if you get multiple periods for Feb 2010. If you have multiple periods for Feb 2010, then you need to do something like UPDATE datavalue set periodid = ? where is the periodid of the "real" Feb 2010 period. Then you should get rid of the bogus Feb 2010 period with DELETE FROM period where periodid = 1589; After that, you should clear your cache from Data administration. Do not try any of this on a production database!!! Regards,Jason On Mon, Sep 15, 2014 at 12:14 PM, Moemedi Ntunyane wrote: Hi Jason Thanx, I just run the query you gave and no records were available and removed not = year(!=year) and records where available. The date format is available as: 1573;6;"2010-01-01";"2010-01-31" 1589;6;"2010-02-01";"2010-02-28" The error available shows that there is key violation for null values for iso column in the periodstructure table. Moemedi Ntunyane Co-founder KeyInConsulting Date: Mon, 15 Sep 2014 11:46:07 +0200 Subject: Re: [Dhis2-devs] periodstructure giving errors... From: jason.p.picker...@gmail.com To: moemedi.ntuny...@hotmail.com CC: dhis2-devs@lists.launchpad.net Very likely you have an invalid period in the periods table. Can you run this and see what happens? SELECT * FROM period where age(enddate,startdate) != '1 year'::interval and periodtypeid = (SELECT periodtypeid from periodtype where name = 'Yearly'); Also, you should get an error which will help you to decipher which period is not correct , something like Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "in_periodstructure_iso" Detail: Key (iso)=(1995) already exists. Best regards,Jason On Fri, Sep 12, 2014 at 5:03 PM, Moemedi Ntunyane wrote: Hi All I have this problem while generating the resource tables...all other tables are fine except periodstructure... Process failed: PreparedStatementCallback; SQL [insert into _periodstructure values (?,?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR: null value in column "iso" violates not-null constraint; nested exception is org.postgresql.util.PSQLException: ERROR: null value in column "iso" violates not-null constraint Regards, 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 -- Jason P. Pickering email: jason.
Re: [Dhis2-devs] periodstructure giving errors...
Hi Lars, I have not done that. Im only capturing statistical data. Regards, Moemedi Ntunyane Co-founder KeyInConsulting Date: Mon, 15 Sep 2014 16:10:13 +0200 Subject: Re: [Dhis2-devs] periodstructure giving errors... From: larshe...@gmail.com To: jason.p.picker...@gmail.com CC: moemedi.ntuny...@hotmail.com; dhis2-devs@lists.launchpad.net Hi Moemedi, may I ask, did you ever run the "aggregation queries" (producing aggregate values from event data) on your database? regards, Lars On Mon, Sep 15, 2014 at 4:01 PM, Jason Pickering wrote: I suspect you have more invalid periods then. You should follow the same procedure for other period types, i.e. checking to be sure that all months are one month, all weeks are one week, etc. You may want to try something like SELECT startdate, periodtypeid,COUNT(*) from period GROUP BY startdate,periodtypeid HAVING COUNT(*) > 1 ; and see which periods and period types you have multiple records for. Ideally, this should not happen. Regards,Jason On Mon, Sep 15, 2014 at 3:53 PM, Moemedi Ntunyane wrote: Hi Jason Thnx, I had successfully elimated duplicate records the error still pesistit complaining of ISO column: is this column a date column?? Process failed: PreparedStatementCallback; SQL [insert into _periodstructure values (?,?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR: null value in column "iso" violates not-null constraint; nested exception is org.postgresql.util.PSQLException: ERROR: null value in column "iso" violates not-null constraint. Regards, Moemedi Ntunyane Co-founder KeyInConsulting Date: Mon, 15 Sep 2014 12:22:31 +0200 Subject: Re: [Dhis2-devs] periodstructure giving errors... From: jason.p.picker...@gmail.com To: moemedi.ntuny...@hotmail.com CC: dhis2-devs@lists.launchpad.net So, the period 1589;6;"2010-02-01";"2010-02-28 , points to a yearly period type, which is not a year in duration. You are going to need to get rid of it. You will need to do something like SELECT COUNT(*) FROM datavalue where periodid = 1589; If you have any records with this periodID, you are going to need to resolve these. This period looks to be monthly, so if the data is also monthly, you should be able to reassign it to a monthly period which starts in 2010-02-01 and ends in 2010-02-28, if it is already there. You could try "SELECT * FROM period where startdate = '2010-02-01'::date;" and see if you get multiple periods for Feb 2010. If you have multiple periods for Feb 2010, then you need to do something like UPDATE datavalue set periodid = ? where is the periodid of the "real" Feb 2010 period. Then you should get rid of the bogus Feb 2010 period with DELETE FROM period where periodid = 1589; After that, you should clear your cache from Data administration. Do not try any of this on a production database!!! Regards,Jason On Mon, Sep 15, 2014 at 12:14 PM, Moemedi Ntunyane wrote: Hi Jason Thanx, I just run the query you gave and no records were available and removed not = year(!=year) and records where available. The date format is available as: 1573;6;"2010-01-01";"2010-01-31" 1589;6;"2010-02-01";"2010-02-28" The error available shows that there is key violation for null values for iso column in the periodstructure table. Moemedi Ntunyane Co-founder KeyInConsulting Date: Mon, 15 Sep 2014 11:46:07 +0200 Subject: Re: [Dhis2-devs] periodstructure giving errors... From: jason.p.picker...@gmail.com To: moemedi.ntuny...@hotmail.com CC: dhis2-devs@lists.launchpad.net Very likely you have an invalid period in the periods table. Can you run this and see what happens? SELECT * FROM period where age(enddate,startdate) != '1 year'::interval and periodtypeid = (SELECT periodtypeid from periodtype where name = 'Yearly'); Also, you should get an error which will help you to decipher which period is not correct , something like Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "in_periodstructure_iso" Detail: Key (iso)=(1995) already exists. Best regards,Jason On Fri, Sep 12, 2014 at 5:03 PM, Moemedi Ntunyane wrote: Hi All I have this problem while generating the resource tables...all other tables are fine except periodstructure... Process failed: PreparedStatementCallback; SQL [insert into _periodstructure values (?,?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR: null value in column "iso" violates not-null constraint; nested exception is org.postgresql.util.PSQLException: ERROR: null value in column "iso" violates not-null constraint Regards, Moemedi Ntunyane Co-founder KeyInConsulting ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscri
Re: [Dhis2-devs] periodstructure giving errors...
I have eliminated all duplicates but this error still persist. Process failed: PreparedStatementCallback; SQL [insert into _periodstructure values (?,?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR: null value in column "iso" violates not-null constraint; nested exception is org.postgresql.util.PSQLException: ERROR: null value in column "iso" violates not-null constraint. Moemedi Ntunyane Co-founder KeyInConsulting From: moemedi.ntuny...@hotmail.com To: larshe...@gmail.com; jason.p.picker...@gmail.com CC: dhis2-devs@lists.launchpad.net Subject: RE: [Dhis2-devs] periodstructure giving errors... Date: Mon, 15 Sep 2014 16:18:14 +0200 Hi Lars, I have not done that. Im only capturing statistical data. Regards, Moemedi Ntunyane Co-founder KeyInConsulting Date: Mon, 15 Sep 2014 16:10:13 +0200 Subject: Re: [Dhis2-devs] periodstructure giving errors... From: larshe...@gmail.com To: jason.p.picker...@gmail.com CC: moemedi.ntuny...@hotmail.com; dhis2-devs@lists.launchpad.net Hi Moemedi, may I ask, did you ever run the "aggregation queries" (producing aggregate values from event data) on your database? regards, Lars On Mon, Sep 15, 2014 at 4:01 PM, Jason Pickering wrote: I suspect you have more invalid periods then. You should follow the same procedure for other period types, i.e. checking to be sure that all months are one month, all weeks are one week, etc. You may want to try something like SELECT startdate, periodtypeid,COUNT(*) from period GROUP BY startdate,periodtypeid HAVING COUNT(*) > 1 ; and see which periods and period types you have multiple records for. Ideally, this should not happen. Regards,Jason On Mon, Sep 15, 2014 at 3:53 PM, Moemedi Ntunyane wrote: Hi Jason Thnx, I had successfully elimated duplicate records the error still pesistit complaining of ISO column: is this column a date column?? Process failed: PreparedStatementCallback; SQL [insert into _periodstructure values (?,?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR: null value in column "iso" violates not-null constraint; nested exception is org.postgresql.util.PSQLException: ERROR: null value in column "iso" violates not-null constraint. Regards, Moemedi Ntunyane Co-founder KeyInConsulting Date: Mon, 15 Sep 2014 12:22:31 +0200 Subject: Re: [Dhis2-devs] periodstructure giving errors... From: jason.p.picker...@gmail.com To: moemedi.ntuny...@hotmail.com CC: dhis2-devs@lists.launchpad.net So, the period 1589;6;"2010-02-01";"2010-02-28 , points to a yearly period type, which is not a year in duration. You are going to need to get rid of it. You will need to do something like SELECT COUNT(*) FROM datavalue where periodid = 1589; If you have any records with this periodID, you are going to need to resolve these. This period looks to be monthly, so if the data is also monthly, you should be able to reassign it to a monthly period which starts in 2010-02-01 and ends in 2010-02-28, if it is already there. You could try "SELECT * FROM period where startdate = '2010-02-01'::date;" and see if you get multiple periods for Feb 2010. If you have multiple periods for Feb 2010, then you need to do something like UPDATE datavalue set periodid = ? where is the periodid of the "real" Feb 2010 period. Then you should get rid of the bogus Feb 2010 period with DELETE FROM period where periodid = 1589; After that, you should clear your cache from Data administration. Do not try any of this on a production database!!! Regards,Jason On Mon, Sep 15, 2014 at 12:14 PM, Moemedi Ntunyane wrote: Hi Jason Thanx, I just run the query you gave and no records were available and removed not = year(!=year) and records where available. The date format is available as: 1573;6;"2010-01-01";"2010-01-31" 1589;6;"2010-02-01";"2010-02-28" The error available shows that there is key violation for null values for iso column in the periodstructure table. Moemedi Ntunyane Co-founder KeyInConsulting Date: Mon, 15 Sep 2014 11:46:07 +0200 Subject: Re: [Dhis2-devs] periodstructure giving errors... From: jason.p.picker...@gmail.com To: moemedi.ntuny...@hotmail.com CC: dhis2-devs@lists.launchpad.net Very likely you have an invalid period in the periods table. Can you run this and see what happens? SELECT * FROM period where age(enddate,startdate) != '1 year'::interval and periodtypeid = (SELECT periodtypeid from periodtype where name = 'Yearly'); Also, you should get an error which will help you to decipher which period is not correct , something like Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "in_periodstructure_iso" Detail: Key (iso)=(1995) already exists. Best regards,Jason On Fri, Sep 12, 2014 at 5:03 PM, Moemedi Ntunyane wrote: Hi All I have this problem while gene
Re: [Dhis2-devs] periodstructure giving errors...
I cleared cache and even restarted my tomcat server Moemedi Ntunyane Co-founder KeyInConsulting Date: Tue, 16 Sep 2014 06:09:43 +0200 Subject: Re: [Dhis2-devs] periodstructure giving errors... From: jason.p.picker...@gmail.com To: moemedi.ntuny...@hotmail.com CC: larshe...@gmail.com; dhis2-devs@lists.launchpad.net Did you clear your server cache and or restart DHIS2? On Tue, Sep 16, 2014 at 5:50 AM, Moemedi Ntunyane wrote: I have eliminated all duplicates but this error still persist. Process failed: PreparedStatementCallback; SQL [insert into _periodstructure values (?,?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR: null value in column "iso" violates not-null constraint; nested exception is org.postgresql.util.PSQLException: ERROR: null value in column "iso" violates not-null constraint. Moemedi Ntunyane Co-founder KeyInConsulting From: moemedi.ntuny...@hotmail.com To: larshe...@gmail.com; jason.p.picker...@gmail.com CC: dhis2-devs@lists.launchpad.net Subject: RE: [Dhis2-devs] periodstructure giving errors... Date: Mon, 15 Sep 2014 16:18:14 +0200 Hi Lars, I have not done that. Im only capturing statistical data. Regards, Moemedi Ntunyane Co-founder KeyInConsulting Date: Mon, 15 Sep 2014 16:10:13 +0200 Subject: Re: [Dhis2-devs] periodstructure giving errors... From: larshe...@gmail.com To: jason.p.picker...@gmail.com CC: moemedi.ntuny...@hotmail.com; dhis2-devs@lists.launchpad.net Hi Moemedi, may I ask, did you ever run the "aggregation queries" (producing aggregate values from event data) on your database? regards, Lars On Mon, Sep 15, 2014 at 4:01 PM, Jason Pickering wrote: I suspect you have more invalid periods then. You should follow the same procedure for other period types, i.e. checking to be sure that all months are one month, all weeks are one week, etc. You may want to try something like SELECT startdate, periodtypeid,COUNT(*) from period GROUP BY startdate,periodtypeid HAVING COUNT(*) > 1 ; and see which periods and period types you have multiple records for. Ideally, this should not happen. Regards,Jason On Mon, Sep 15, 2014 at 3:53 PM, Moemedi Ntunyane wrote: Hi Jason Thnx, I had successfully elimated duplicate records the error still pesistit complaining of ISO column: is this column a date column?? Process failed: PreparedStatementCallback; SQL [insert into _periodstructure values (?,?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR: null value in column "iso" violates not-null constraint; nested exception is org.postgresql.util.PSQLException: ERROR: null value in column "iso" violates not-null constraint. Regards, Moemedi Ntunyane Co-founder KeyInConsulting Date: Mon, 15 Sep 2014 12:22:31 +0200 Subject: Re: [Dhis2-devs] periodstructure giving errors... From: jason.p.picker...@gmail.com To: moemedi.ntuny...@hotmail.com CC: dhis2-devs@lists.launchpad.net So, the period 1589;6;"2010-02-01";"2010-02-28 , points to a yearly period type, which is not a year in duration. You are going to need to get rid of it. You will need to do something like SELECT COUNT(*) FROM datavalue where periodid = 1589; If you have any records with this periodID, you are going to need to resolve these. This period looks to be monthly, so if the data is also monthly, you should be able to reassign it to a monthly period which starts in 2010-02-01 and ends in 2010-02-28, if it is already there. You could try "SELECT * FROM period where startdate = '2010-02-01'::date;" and see if you get multiple periods for Feb 2010. If you have multiple periods for Feb 2010, then you need to do something like UPDATE datavalue set periodid = ? where is the periodid of the "real" Feb 2010 period. Then you should get rid of the bogus Feb 2010 period with DELETE FROM period where periodid = 1589; After that, you should clear your cache from Data administration. Do not try any of this on a production database!!! Regards,Jason On Mon, Sep 15, 2014 at 12:14 PM, Moemedi Ntunyane wrote: Hi Jason Thanx, I just run the query you gave and no records were available and removed not = year(!=year) and records where available. The date format is available as: 1573;6;"2010-01-01";"2010-01-31" 1589;6;"2010-02-01";"2010-02-28" The error available shows that there is key violation for null values for iso column in the periodstructure table. Moemedi Ntunyane Co-founder KeyInConsulting Date: Mon, 15 Sep 2014 11:46:07 +0200 Subject: Re: [Dhis2-devs] periodstructure giving errors... From: jason.p.picker...@gmail.com To: moemedi.ntuny...@hotmail.com CC: dhis2-devs@lists.launchpad.net Very likely you have an invalid period in the periods table. Can you run this and see what happens? SELECT * FROM period where age(enddate,startdate) != '1 year'::interval and periodtypeid = (SELECT periodtypeid from periodtype where name = 'Yearly'); Al
Re: [Dhis2-devs] periodstructure giving errors...
Thanks, I was upgrading from 2.0.5 to 2.14. I can only see this error its not complaining of duplication but null value error: org.postgresql.util.PSQLException: ERROR: null value in column "iso" violates not-null constraint. Moemedi Ntunyane Co-founder KeyInConsulting Date: Tue, 16 Sep 2014 09:18:20 +0200 Subject: Re: [Dhis2-devs] periodstructure giving errors... From: jason.p.picker...@gmail.com To: moemedi.ntuny...@hotmail.com CC: larshe...@gmail.com; dhis2-devs@lists.launchpad.net Yeah, well, I can't offer much more advice other in this case. We had similar problems as I mentioned before with 2.16, but after carefully cleaning up all of the faulty periods, things worked OK. One thing which I would suggest would be to turn on full logging of all postgresql queries, and see exactly where things are failing. You should also see something like Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "in_periodstructure_iso" Detail: Key (iso)=(1995) already exists. in the Tomcat log, which again, gives you a clue about which period may be causing the problem. I know you posted a portion of the log before, but I did not see anything like this in your log. Turning on the postgresql logs may help you to track down which period is causing this error. Maybe one of the developers can add more information? The procedure worked for us, but required a bit of detective work. Regards,Jason On Tue, Sep 16, 2014 at 9:12 AM, Moemedi Ntunyane wrote: I cleared cache and even restarted my tomcat server Moemedi Ntunyane Co-founder KeyInConsulting Date: Tue, 16 Sep 2014 06:09:43 +0200 Subject: Re: [Dhis2-devs] periodstructure giving errors... From: jason.p.picker...@gmail.com To: moemedi.ntuny...@hotmail.com CC: larshe...@gmail.com; dhis2-devs@lists.launchpad.net Did you clear your server cache and or restart DHIS2? On Tue, Sep 16, 2014 at 5:50 AM, Moemedi Ntunyane wrote: I have eliminated all duplicates but this error still persist. Process failed: PreparedStatementCallback; SQL [insert into _periodstructure values (?,?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR: null value in column "iso" violates not-null constraint; nested exception is Moemedi Ntunyane Co-founder KeyInConsulting From: moemedi.ntuny...@hotmail.com To: larshe...@gmail.com; jason.p.picker...@gmail.com CC: dhis2-devs@lists.launchpad.net Subject: RE: [Dhis2-devs] periodstructure giving errors... Date: Mon, 15 Sep 2014 16:18:14 +0200 Hi Lars, I have not done that. Im only capturing statistical data. Regards, Moemedi Ntunyane Co-founder KeyInConsulting Date: Mon, 15 Sep 2014 16:10:13 +0200 Subject: Re: [Dhis2-devs] periodstructure giving errors... From: larshe...@gmail.com To: jason.p.picker...@gmail.com CC: moemedi.ntuny...@hotmail.com; dhis2-devs@lists.launchpad.net Hi Moemedi, may I ask, did you ever run the "aggregation queries" (producing aggregate values from event data) on your database? regards, Lars On Mon, Sep 15, 2014 at 4:01 PM, Jason Pickering wrote: I suspect you have more invalid periods then. You should follow the same procedure for other period types, i.e. checking to be sure that all months are one month, all weeks are one week, etc. You may want to try something like SELECT startdate, periodtypeid,COUNT(*) from period GROUP BY startdate,periodtypeid HAVING COUNT(*) > 1 ; and see which periods and period types you have multiple records for. Ideally, this should not happen. Regards,Jason On Mon, Sep 15, 2014 at 3:53 PM, Moemedi Ntunyane wrote: Hi Jason Thnx, I had successfully elimated duplicate records the error still pesistit complaining of ISO column: is this column a date column?? Process failed: PreparedStatementCallback; SQL [insert into _periodstructure values (?,?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR: null value in column "iso" violates not-null constraint; nested exception is org.postgresql.util.PSQLException: ERROR: null value in column "iso" violates not-null constraint. Regards, Moemedi Ntunyane Co-founder KeyInConsulting Date: Mon, 15 Sep 2014 12:22:31 +0200 Subject: Re: [Dhis2-devs] periodstructure giving errors... From: jason.p.picker...@gmail.com To: moemedi.ntuny...@hotmail.com CC: dhis2-devs@lists.launchpad.net So, the period 1589;6;"2010-02-01";"2010-02-28 , points to a yearly period type, which is not a year in duration. You are going to need to get rid of it. You will need to do something like SELECT COUNT(*) FROM datavalue where periodid = 1589; If you have any records with this periodID, you are going to need to resolve these. This period looks to be monthly, so if the data is also monthly, you should be able to reassign it to a monthly period which starts in 2010-02-01 and ends in 2010-02-28, if it is already there. You could try "SELECT * FROM period where startdate = '2010-02-01'::date;" and see if
Re: [Dhis2-devs] periodstructure giving errors...
Thanks a lot for your assistance, I just used a fresh database and imported meta data and the data itself eventhough other info was missing but managed to fix everything. Now its working ok on my local instance. Moemedi Ntunyane Co-founder KeyInConsulting From: knu...@gmail.com Date: Tue, 16 Sep 2014 09:37:36 +0200 Subject: Re: [Dhis2-devs] periodstructure giving errors... To: moemedi.ntuny...@hotmail.com CC: jason.p.picker...@gmail.com; dhis2-devs@lists.launchpad.net Depending on how much of configuration you have in your database, one option could be to start afresh - doing metadata and data exports, and import to an empty database. You would lose certain things (like users), but also possibly get rid of some issues, rather than operating directly in the database. On Tue, Sep 16, 2014 at 9:27 AM, Moemedi Ntunyane wrote: Thanks, I was upgrading from 2.0.5 to 2.14. I can only see this error its not complaining of duplication but null value error: org.postgresql.util.PSQLException: ERROR: null value in column "iso" violates not-null constraint. Moemedi Ntunyane Co-founder KeyInConsulting Date: Tue, 16 Sep 2014 09:18:20 +0200 Subject: Re: [Dhis2-devs] periodstructure giving errors... From: jason.p.picker...@gmail.com To: moemedi.ntuny...@hotmail.com CC: larshe...@gmail.com; dhis2-devs@lists.launchpad.net Yeah, well, I can't offer much more advice other in this case. We had similar problems as I mentioned before with 2.16, but after carefully cleaning up all of the faulty periods, things worked OK. One thing which I would suggest would be to turn on full logging of all postgresql queries, and see exactly where things are failing. You should also see something like Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "in_periodstructure_iso" Detail: Key (iso)=(1995) already exists. in the Tomcat log, which again, gives you a clue about which period may be causing the problem. I know you posted a portion of the log before, but I did not see anything like this in your log. Turning on the postgresql logs may help you to track down which period is causing this error. Maybe one of the developers can add more information? The procedure worked for us, but required a bit of detective work. Regards,Jason On Tue, Sep 16, 2014 at 9:12 AM, Moemedi Ntunyane wrote: I cleared cache and even restarted my tomcat server Moemedi Ntunyane Co-founder KeyInConsulting Date: Tue, 16 Sep 2014 06:09:43 +0200 Subject: Re: [Dhis2-devs] periodstructure giving errors... From: jason.p.picker...@gmail.com To: moemedi.ntuny...@hotmail.com CC: larshe...@gmail.com; dhis2-devs@lists.launchpad.net Did you clear your server cache and or restart DHIS2? On Tue, Sep 16, 2014 at 5:50 AM, Moemedi Ntunyane wrote: I have eliminated all duplicates but this error still persist. Process failed: PreparedStatementCallback; SQL [insert into _periodstructure values (?,?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR: null value in column "iso" violates not-null constraint; nested exception is Moemedi Ntunyane Co-founder KeyInConsulting From: moemedi.ntuny...@hotmail.com To: larshe...@gmail.com; jason.p.picker...@gmail.com CC: dhis2-devs@lists.launchpad.net Subject: RE: [Dhis2-devs] periodstructure giving errors... Date: Mon, 15 Sep 2014 16:18:14 +0200 Hi Lars, I have not done that. Im only capturing statistical data. Regards, Moemedi Ntunyane Co-founder KeyInConsulting Date: Mon, 15 Sep 2014 16:10:13 +0200 Subject: Re: [Dhis2-devs] periodstructure giving errors... From: larshe...@gmail.com To: jason.p.picker...@gmail.com CC: moemedi.ntuny...@hotmail.com; dhis2-devs@lists.launchpad.net Hi Moemedi, may I ask, did you ever run the "aggregation queries" (producing aggregate values from event data) on your database? regards, Lars On Mon, Sep 15, 2014 at 4:01 PM, Jason Pickering wrote: I suspect you have more invalid periods then. You should follow the same procedure for other period types, i.e. checking to be sure that all months are one month, all weeks are one week, etc. You may want to try something like SELECT startdate, periodtypeid,COUNT(*) from period GROUP BY startdate,periodtypeid HAVING COUNT(*) > 1 ; and see which periods and period types you have multiple records for. Ideally, this should not happen. Regards,Jason On Mon, Sep 15, 2014 at 3:53 PM, Moemedi Ntunyane wrote: Hi Jason Thnx, I had successfully elimated duplicate records the error still pesistit complaining of ISO column: is this column a date column?? Process failed: PreparedStatementCallback; SQL [insert into _periodstructure values (?,?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR: null value in column "iso" violates not-null constraint; nested exception is org.postgresql.util.PSQLException: ERROR: null value in column "iso" violates not-null constraint. Regards, Moemedi Ntunyane Co-founder KeyInConsult
