Re: [Dhis2-users] [Dhis2-devs] dhis version 2.25 is released

2016-10-19 Thread Brajesh Murari
thanks Michael On Wed, Oct 19, 2016 at 6:23 PM, Michael Mwebaze wrote: > Hi Brajesh, > > You can get the code on Github, > > https://github.com/dhis2/dhis2-core/ > > You can also get the latest builds and other information from > > http://ci.dhis2.org/job/dhis2-2.25/ > > Regards, > > Michael > >

Re: [Dhis2-users] [Dhis2-devs] dhis version 2.25 is released

2016-10-19 Thread Brajesh Murari
thanks Knut On Thu, Oct 20, 2016 at 11:52 AM, Brajesh Murari wrote: > thanks Michael > > On Wed, Oct 19, 2016 at 6:23 PM, Michael Mwebaze < > michael.mweb...@gmail.com> wrote: > >> Hi Brajesh, >> >> You can get the code on Github, >> >> https://github.com/dhis2/dhis2-core/ >> >> You can also get

Re: [Dhis2-users] [Dhis2-devs] 25 hours in completing Analytic

2016-10-19 Thread Neeraj Gupta
Thank you everyone. I will give try to each options you gave and post the result on the mail. Thanks, Neeraj On Wed, Oct 19, 2016 at 6:46 PM, Calle Hedberg wrote: > Neeraj, > > It's always an element of uncertainty linked to database sizes - ref Sam's > post over. So indicating the number of re

Re: [Dhis2-users] 25 hours in completing Analytic

2016-10-19 Thread Dr. Sunil Gavaskar ParthaSarathy
Dear Sir, I had issues in connecting to PoastgreSQL 9.6 due to HSBC error has that been resolved now. Please let me know. I believe 9.6 can handle parallel queries & will have better handling of vacuum, which might be usesful for large databases as handled by Neeraj. Dr. Sunil Gavaskar Partha

Re: [Dhis2-users] [Dhis2-devs] Link to download Dhis 2.22 rev 22060

2016-10-19 Thread Guy Ekani
Thank you all, Matthieu, i got some trouble with charts on our dashboard : the chart is being properly shown now in the data visualizer app, it is still not being rendered in the dashboards (where we just got the message "No Series items selected"). the following war has solved my problem : https

Re: [Dhis2-users] [Dhis2-devs] Link to download Dhis 2.22 rev 22060

2016-10-19 Thread Matthieu Pinard
Perfect :) Matthieu Pinard DHIS2 Core Team | University of Oslo On 19 October 2016 at 17:25, Guy Ekani wrote: > Thank you all, > > Matthieu, i got some trouble with charts on our dashboard : the chart is > being properly shown now in the data visualizer app, it is still not being > rendered in

Re: [Dhis2-users] [Dhis2-devs] Link to download Dhis 2.22 rev 22060

2016-10-19 Thread Michael Mwebaze
Hi Matthieu, Try the link below: http://ci.dhis2.org/job/dhis2-2.22/ Regards, Michael On 19 October 2016 at 11:04, Matthieu Pinard wrote: > Hi Guy, > > any particular reason fo you to ask for this specific rev rather than the > latest one of 222? > > Cheers, > Matthieu > > Matthieu Pinard >

Re: [Dhis2-users] [Dhis2-devs] Link to download Dhis 2.22 rev 22060

2016-10-19 Thread Matthieu Pinard
Hi Guy, any particular reason fo you to ask for this specific rev rather than the latest one of 222? Cheers, Matthieu Matthieu Pinard DHIS2 Core Team | University of Oslo On 19 October 2016 at 16:12, Guy Ekani wrote: > Hello Team, > > Please could someone can share the link for downloading Dh

[Dhis2-users] Link to download Dhis 2.22 rev 22060

2016-10-19 Thread Guy Ekani
Hello Team, Please could someone can share the link for downloading Dhis 2.22 rev 22060 Sincerely, -- = EKANI Guy ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe :

Re: [Dhis2-users] [Dhis2-devs] 25 hours in completing Analytic

2016-10-19 Thread Calle Hedberg
Neeraj, It's always an element of uncertainty linked to database sizes - ref Sam's post over. So indicating the number of records you have in the datavalue table & key meta-data tables would be useful + indicating whether you are running other instances on the same server. Some comments - I've bee

Re: [Dhis2-users] 25 hours in completing Analytic

2016-10-19 Thread arvind chikne
Dear Uwe, Thanks for your valuable suggestion, we will try with PostgreSQL 9.5 and let you know the progress. On Wed, Oct 19, 2016 at 2:01 PM, Uwe Wahser wrote: > Hi Neeraj, > > not sure about the relevance of this detail: when I upgraded from 9.4 to > 9.5 I > found out that there was a postg

Re: [Dhis2-users] [Dhis2-devs] dhis version 2.25 is released

2016-10-19 Thread Michael Mwebaze
Hi Brajesh, You can get the code on Github, https://github.com/dhis2/dhis2-core/ You can also get the latest builds and other information from http://ci.dhis2.org/job/dhis2-2.25/ Regards, Michael On 19 October 2016 at 01:05, Brajesh Murari wrote: > Hello Devs, > > I have one question in my

Re: [Dhis2-users] [Dhis2-devs] 25 hours in completing Analytic

2016-10-19 Thread Sam Johnson
One other point to mention: if you do try runing VACUUM FULL, you should do it before running the analytics (ie on your initial 100Gb database, not the 500Gb database you end up with after running the analytics), as my guess is that the DHIS2 analytics tables are dropped and re-created anyway, s

Re: [Dhis2-users] [Dhis2-devs] 25 hours in completing Analytic

2016-10-19 Thread Sam Johnson
Hi Neeraj, Using VACUUM and ANALYZE Like Brajesh, my background is MySQL, and one database admin task that is often overlooked in MySQL is OPTIMIZE TABLEs. This reclaims unused space (we’ve had 100Gb databases files drop to half their size) and refreshes index statistics (if the shape of your

[Dhis2-users] Issue with data monitoring

2016-10-19 Thread Sakibou ALASSANI
Hi all I face a issue related to data monitoring. as described this message: Monitoring process failed, please check the logs. Time: 2016-10-14T00:00:00.717Z. System: Staging Message: null Cause: And that is errors in the log: * INFO  2016-10-14 00:00:00,002 Starting scheduled monitoring task (

Re: [Dhis2-users] 25 hours in completing Analytic

2016-10-19 Thread Uwe Wahser
Hi Neeraj, not sure about the relevance of this detail: when I upgraded from 9.4 to 9.5 I found out that there was a postgres parameter (wal_buffers) removed from the current DHIS2 implementer's guide (relating to 9.5), which was still in there up to 2.24 (relating to 9.4). Also I had the feeling

Re: [Dhis2-users] 25 hours in completing Analytic

2016-10-19 Thread Neeraj Gupta
Thanks Knut and Brajesh, Lars we are using 12 Core CPu with SSD and having 48GB RAM but using Postgres 9.4. We will try with Postgres 9.5 now and let you know the results. Do you recommend anything else other than this? Thanks, Neeraj On Wed, Oct 19, 2016 at 12:35 PM, Knut Staring wrote: > Ju

Re: [Dhis2-users] [Dhis2-devs] 25 hours in completing Analytic

2016-10-19 Thread Brajesh Murari
Dear Neeraj, The physical database size doesn't matter much, even the number of records don't matter. In my experience the biggest problem that one can going to run in to is not size, but the number of queries you can handle at a time instance specially during analytic functionality execution. Mos

Re: [Dhis2-users] 25 hours in completing Analytic

2016-10-19 Thread Lars Helge Øverland
Hi Neeraj, what usually helps to improve runtime is: - ssd () - number of CPUs - On Wed, Oct 19, 2016 at 7:13 AM, Neeraj Gupta wrote: > Dear team, > > In one of the Indian state we are using DHIS 2.23 and the database size is > going around 100 GB and once we run analytic it reaches to 500

Re: [Dhis2-users] 25 hours in completing Analytic

2016-10-19 Thread Neeraj Gupta
Thanks Lars, we will give this a try and let you know. How much time do you expect to run for 100 GB database in ideal conditions? Thanks, Neeraj On Wed, Oct 19, 2016 at 12:28 PM, Lars Helge Øverland wrote: > > Hi Neeraj, > > what usually helps to improve runtime is to improve/increase: > > - s

Re: [Dhis2-users] 25 hours in completing Analytic

2016-10-19 Thread Knut Staring
Just a heads-up that there seems to be a JDBC issue with Postgres 9.6, so perhaps you should try upgrading to 9.5 first. On Wed, Oct 19, 2016 at 8:58 AM, Lars Helge Øverland wrote: > > Hi Neeraj, > > what usually helps to improve runtime is to improve/increase: > > - ssd (read and write speed) >