Re: [Dhis2-devs] [Dhis2-users] DHIS2 Network Out

2016-09-13 Thread Alex Tumwesigye
Dear Raminosoa,

I faced a similar problem sometime a year ago.
This problem is attributed to SQL queries that take long to finish.
Consider installing pgtop
You may need to increase your shared_buffers a bit and effective_cache_size
or connections parameters until you get the best optimal settings. You can
also allocate more memory (-Xmx7500m) to tomcat process if you have more.
Note that if you increase your postgres connections, pay attention to
memory settings you set as you can easily run out of memory too.

Alex


On Mon, Sep 12, 2016 at 6:13 PM, Raminosoa Rabemanantsoa, Tantely <
tramino...@mikolo.org> wrote:

> Hi Halvdan,
>
> We have already restarted the server and it has solved temporarily the
> problem. We are going to try the command you mentioned and see what is
> happening. Thank you.
>
> Regards,
>
> Tantely.
>
> Le 12 sept. 2016 5:55 PM, "Halvdan Hoem Grelland"  a
> écrit :
>
>> You should probably look into what specific processes on the server are
>> hogging the CPU. Try using 'htop' from the console (or similar). The logs
>> you've provided unfortunately do not provide any useful information.
>>
>> Also, does a simple server reboot solve the issue? If so, does it
>> re-occur?
>>
>> On Mon, Sep 12, 2016 at 4:37 PM, Raminosoa Rabemanantsoa, Tantely <
>> tramino...@mikolo.org> wrote:
>>
>>> Hi All,
>>>
>>> We are using DHIS2 2.19 and it was working really fine for several
>>> months.
>>> We have followed the HISP recommendations for the JVM parameters and the
>>> PostgreSQL memory tunning. We noticed few days ago a slow access to our
>>> DHIS2 server on Amazon from web version as well as from data capture.
>>> When
>>> checking the status, the server CPU is constantly running at 100%. We
>>> would
>>> like to have your advice on the possible sources of the errors. I note
>>> that
>>> Amazon has upgraded the Linux system to a newer version (2016.03). Does
>>> this change have impact on the installation of Tomact and postgreSQL? I
>>> am
>>> attaching the DHIS2 log file which is containing several errors.
>>>
>>> We are stuck, your help are welcome!
>>>
>>> Regards,
>>>
>>> Tantely.
>>>
>>> --
>>> *This message and its attachments are confidential and solely for the
>>> intended recipients. If received in error, please delete them and notify
>>> the sender via reply e-mail immediately.*
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-us...@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>> Halvdan Hoem Grelland
>> Software developer, DHIS 2
>> University of Oslo
>> http://www.dhis2.org 
>>
>>
> *This message and its attachments are confidential and solely for the
> intended recipients. If received in error, please delete them and notify
> the sender via reply e-mail immediately.*
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET  | HISP Uganda
Kampala
Uganda
+256 774149 775, + 256 759 800161
Skype ID: talexie

IT Consultant (Servers, Networks and Security, Health Information Systems -
DHIS2, Disease Outbreak & Surveillance Systems) & Solar Consultant


"I don't want to be anything other than what I have been - one tree hill "
___
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] [Dhis2-users] DHIS2 Network Out

2016-09-13 Thread Raminosoa Rabemanantsoa, Tantely
Dear Alex,

Thank you for your suggestions. We are tuning the memories for JWM and
postgreSQL right now and get back to you after.

Regards,

Tantely.

On Tue, Sep 13, 2016 at 11:01 AM, Alex Tumwesigye 
wrote:

> Dear Raminosoa,
>
> I faced a similar problem sometime a year ago.
> This problem is attributed to SQL queries that take long to finish.
> Consider installing pgtop
> You may need to increase your shared_buffers a bit and
> effective_cache_size  or connections parameters until you get the best
> optimal settings. You can also allocate more memory (-Xmx7500m) to tomcat
> process if you have more.
> Note that if you increase your postgres connections, pay attention to
> memory settings you set as you can easily run out of memory too.
>
> Alex
>
>
> On Mon, Sep 12, 2016 at 6:13 PM, Raminosoa Rabemanantsoa, Tantely <
> tramino...@mikolo.org> wrote:
>
>> Hi Halvdan,
>>
>> We have already restarted the server and it has solved temporarily the
>> problem. We are going to try the command you mentioned and see what is
>> happening. Thank you.
>>
>> Regards,
>>
>> Tantely.
>>
>> Le 12 sept. 2016 5:55 PM, "Halvdan Hoem Grelland"  a
>> écrit :
>>
>>> You should probably look into what specific processes on the server are
>>> hogging the CPU. Try using 'htop' from the console (or similar). The logs
>>> you've provided unfortunately do not provide any useful information.
>>>
>>> Also, does a simple server reboot solve the issue? If so, does it
>>> re-occur?
>>>
>>> On Mon, Sep 12, 2016 at 4:37 PM, Raminosoa Rabemanantsoa, Tantely <
>>> tramino...@mikolo.org> wrote:
>>>
 Hi All,

 We are using DHIS2 2.19 and it was working really fine for several
 months.
 We have followed the HISP recommendations for the JVM parameters and the
 PostgreSQL memory tunning. We noticed few days ago a slow access to our
 DHIS2 server on Amazon from web version as well as from data capture.
 When
 checking the status, the server CPU is constantly running at 100%. We
 would
 like to have your advice on the possible sources of the errors. I note
 that
 Amazon has upgraded the Linux system to a newer version (2016.03). Does
 this change have impact on the installation of Tomact and postgreSQL? I
 am
 attaching the DHIS2 log file which is containing several errors.

 We are stuck, your help are welcome!

 Regards,

 Tantely.

 --
 *This message and its attachments are confidential and solely for the
 intended recipients. If received in error, please delete them and notify
 the sender via reply e-mail immediately.*

 ___
 Mailing list: https://launchpad.net/~dhis2-users
 Post to : dhis2-us...@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-users
 More help   : https://help.launchpad.net/ListHelp


>>>
>>>
>>> --
>>> Halvdan Hoem Grelland
>>> Software developer, DHIS 2
>>> University of Oslo
>>> http://www.dhis2.org 
>>>
>>>
>> *This message and its attachments are confidential and solely for the
>> intended recipients. If received in error, please delete them and notify
>> the sender via reply e-mail immediately.*
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Alex Tumwesigye
>
> Technical Advisor - DHIS2 (Consultant),
> Ministry of Health/AFENET  | HISP Uganda
> Kampala
> Uganda
> +256 774149 775, + 256 759 800161
> Skype ID: talexie
>
> IT Consultant (Servers, Networks and Security, Health Information Systems
> - DHIS2, Disease Outbreak & Surveillance Systems) & Solar Consultant
>
>
> "I don't want to be anything other than what I have been - one tree hill "
>

-- 
*This message and its attachments are confidential and solely for the 
intended recipients. If received in error, please delete them and notify 
the sender via reply e-mail immediately.*
___
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] Event analytics include unenrolled TEIs

2016-09-13 Thread chathura widanage
Thanks Jan.

On Tue, Sep 13, 2016 at 1:53 PM, Jan Henrik Øverland  wrote:

> And here: https://blueprints.launchpad.net/dhis2/+spec/
> event-analytics-event-status-filter
>
> On 13 September 2016 at 10:18, Jan Henrik Øverland  wrote:
>
>> Not possible at the moment, but we will consider a filter to allow for
>> this.
>>
>> Blueprint here: https://blueprints.launchpad.net/dhis2/+spec/event-
>> analytics-program-status-filter
>>
>> Jan
>>
>> On 9 September 2016 at 12:58, chathura widanage <
>> chathurawidan...@gmail.com> wrote:
>>
>>> ​Hi devs,
>>>
>>> api/analytics/events/query/MmGml1Gyb7K?dimension=l0WWFNEMoQZ
>>> :EQ:1&startDate=1992-08-16&endDate=2016-12-12&dimension=ou:GYBZ1og9bk7
>>>
>>> I am calling above api end point to get some analytics about a program.
>>> But it consider unenrolled TEIs for the generation of results. It gives the
>>> same result unless I completely delete the TEI. Is there any parameter that
>>> can be set i n order to eliminate the unenrolled TEIs from the results?
>>>
>>> Thanks in advance.
>>>
>>> Regards,
>>>
>>> ​
>>> Chathura Widanage
>>> Undergraduate,
>>> Department of Computer Science and Engineering,
>>> University of Moratuwa,
>>> Sri Lanka
>>>
>>> ___
>>> 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
>>>
>>>
>>
>>
>> --
>> Jan Henrik Øverland
>> Software developer, DHIS 2
>> University of Oslo
>> http://www.dhis2.org 
>>
>
>
>
> --
> Jan Henrik Øverland
> Software developer, DHIS 2
> University of Oslo
> http://www.dhis2.org 
>



-- 
Best Regards,

*Chathura Widanage,*
Undergraduate,
Department of Computer Science and Engineering,
University of Moratuwa,
Sri Lanka

  


___
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] Flag available in DHIS2 dropdown - Equatorial Guinea

2016-09-13 Thread Sergio Valenzuela
Hello devs,

Would it be possible to incluide the Equatorial Guinea Flag to the latest
build of 2.24 version?

Regards!


*Sergio Valenzuela*
Fundación EHAS
Telemedicina para países en desarrollo -* www.ehas.org
*
E.T.S.I. de Telecomunicación A.101-9L. Ciudad Universitaria 30, 28040
Madrid - España
Tlfno. (+34) 91 488 87 41: (+34) 687 67 17 62



2016-08-02 18:21 GMT+02:00 Sergio Valenzuela :

> I have just checked it. Thanks Jason.
>
> Regards.
>
>
> *Sergio Valenzuela*
> Fundación EHAS
> Telemedicina para países en desarrollo -* www.ehas.org
> *
> E.T.S.I. de Telecomunicación A.101-9L. Ciudad Universitaria 30, 28040
> Madrid - España
> Tlfno. (+34) 91 488 87 41: (+34) 687 67 17 62
>
>
>
> 2016-08-02 17:34 GMT+02:00 Jason Pickering :
>
>> OK. Its done in R23593
>>
>> Regards,
>> Jason
>>
>>
>> On Tue, Aug 2, 2016 at 5:24 PM, Sergio Valenzuela <
>> sergio.valenzu...@ehas.org> wrote:
>>
>>> Thanks a lot Jason!
>>>
>>> Regards.
>>>
>>>
>>> *Sergio Valenzuela*
>>> Fundación EHAS
>>> Telemedicina para países en desarrollo -* www.ehas.org
>>> *
>>> E.T.S.I. de Telecomunicación A.101-9L. Ciudad Universitaria 30, 28040
>>> Madrid - España
>>> Tlfno. (+34) 91 488 87 41: (+34) 687 67 17 62
>>>
>>>
>>>
>>> 2016-08-02 17:19 GMT+02:00 Jason Pickering 
>>> :
>>>
 Hi Sergio,
 I will take care of it for you.

 Regards,
 Jason


 On Tue, Aug 2, 2016 at 5:16 PM, Sergio Valenzuela <
 sergio.valenzu...@ehas.org> wrote:

> Hello devs,
>
> Could it be possible to add the flag of Equatorial Guinea as an option
> on the Settings -> Appearance menu?
>
> Best Regards!
>
>
> *Sergio Valenzuela*
> Fundación EHAS
> Telemedicina para países en desarrollo -* www.ehas.org
> *
> E.T.S.I. de Telecomunicación A.101-9L. Ciudad Universitaria 30, 28040
> Madrid - España
> Tlfno. (+34) 91 488 87 41: (+34) 687 67 17 62
>
>
>
> ___
> 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] Flag available in DHIS2 dropdown - Equatorial Guinea

2016-09-13 Thread Jason Pickering
Hi Sergio,
I have added it here

.

Regards,
Jason


On Tue, Sep 13, 2016 at 1:26 PM, Sergio Valenzuela <
sergio.valenzu...@ehas.org> wrote:

> Hello devs,
>
> Would it be possible to incluide the Equatorial Guinea Flag to the latest
> build of 2.24 version?
>
> Regards!
>
>
> *Sergio Valenzuela*
> Fundación EHAS
> Telemedicina para países en desarrollo -* www.ehas.org
> *
> E.T.S.I. de Telecomunicación A.101-9L. Ciudad Universitaria 30, 28040
> Madrid - España
> Tlfno. (+34) 91 488 87 41: (+34) 687 67 17 62
>
>
>
> 2016-08-02 18:21 GMT+02:00 Sergio Valenzuela :
>
>> I have just checked it. Thanks Jason.
>>
>> Regards.
>>
>>
>> *Sergio Valenzuela*
>> Fundación EHAS
>> Telemedicina para países en desarrollo -* www.ehas.org
>> *
>> E.T.S.I. de Telecomunicación A.101-9L. Ciudad Universitaria 30, 28040
>> Madrid - España
>> Tlfno. (+34) 91 488 87 41: (+34) 687 67 17 62
>>
>>
>>
>> 2016-08-02 17:34 GMT+02:00 Jason Pickering :
>>
>>> OK. Its done in R23593
>>>
>>> Regards,
>>> Jason
>>>
>>>
>>> On Tue, Aug 2, 2016 at 5:24 PM, Sergio Valenzuela <
>>> sergio.valenzu...@ehas.org> wrote:
>>>
 Thanks a lot Jason!

 Regards.


 *Sergio Valenzuela*
 Fundación EHAS
 Telemedicina para países en desarrollo -* www.ehas.org
 *
 E.T.S.I. de Telecomunicación A.101-9L. Ciudad Universitaria 30, 28040
 Madrid - España
 Tlfno. (+34) 91 488 87 41: (+34) 687 67 17 62



 2016-08-02 17:19 GMT+02:00 Jason Pickering >>> >:

> Hi Sergio,
> I will take care of it for you.
>
> Regards,
> Jason
>
>
> On Tue, Aug 2, 2016 at 5:16 PM, Sergio Valenzuela <
> sergio.valenzu...@ehas.org> wrote:
>
>> Hello devs,
>>
>> Could it be possible to add the flag of Equatorial Guinea as an
>> option on the Settings -> Appearance menu?
>>
>> Best Regards!
>>
>>
>> *Sergio Valenzuela*
>> Fundación EHAS
>> Telemedicina para países en desarrollo -* www.ehas.org
>> *
>> E.T.S.I. de Telecomunicación A.101-9L. Ciudad Universitaria 30,
>> 28040 Madrid - España
>> Tlfno. (+34) 91 488 87 41: (+34) 687 67 17 62
>>
>>
>>
>> ___
>> 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
>>>
>>
>>
>


-- 
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] Flag available in DHIS2 dropdown - Equatorial Guinea

2016-09-13 Thread Sergio Valenzuela
Thanks a lot Jason.

Regards!


*Sergio Valenzuela*
Fundación EHAS
Telemedicina para países en desarrollo -* www.ehas.org
*
E.T.S.I. de Telecomunicación A.101-9L. Ciudad Universitaria 30, 28040
Madrid - España
Tlfno. (+34) 91 488 87 41: (+34) 687 67 17 62



2016-09-13 13:45 GMT+02:00 Jason Pickering :

> Hi Sergio,
> I have added it here
> 
> .
>
> Regards,
> Jason
>
>
> On Tue, Sep 13, 2016 at 1:26 PM, Sergio Valenzuela <
> sergio.valenzu...@ehas.org> wrote:
>
>> Hello devs,
>>
>> Would it be possible to incluide the Equatorial Guinea Flag to the latest
>> build of 2.24 version?
>>
>> Regards!
>>
>>
>> *Sergio Valenzuela*
>> Fundación EHAS
>> Telemedicina para países en desarrollo -* www.ehas.org
>> *
>> E.T.S.I. de Telecomunicación A.101-9L. Ciudad Universitaria 30, 28040
>> Madrid - España
>> Tlfno. (+34) 91 488 87 41: (+34) 687 67 17 62
>>
>>
>>
>> 2016-08-02 18:21 GMT+02:00 Sergio Valenzuela 
>> :
>>
>>> I have just checked it. Thanks Jason.
>>>
>>> Regards.
>>>
>>>
>>> *Sergio Valenzuela*
>>> Fundación EHAS
>>> Telemedicina para países en desarrollo -* www.ehas.org
>>> *
>>> E.T.S.I. de Telecomunicación A.101-9L. Ciudad Universitaria 30, 28040
>>> Madrid - España
>>> Tlfno. (+34) 91 488 87 41: (+34) 687 67 17 62
>>>
>>>
>>>
>>> 2016-08-02 17:34 GMT+02:00 Jason Pickering 
>>> :
>>>
 OK. Its done in R23593

 Regards,
 Jason


 On Tue, Aug 2, 2016 at 5:24 PM, Sergio Valenzuela <
 sergio.valenzu...@ehas.org> wrote:

> Thanks a lot Jason!
>
> Regards.
>
>
> *Sergio Valenzuela*
> Fundación EHAS
> Telemedicina para países en desarrollo -* www.ehas.org
> *
> E.T.S.I. de Telecomunicación A.101-9L. Ciudad Universitaria 30, 28040
> Madrid - España
> Tlfno. (+34) 91 488 87 41: (+34) 687 67 17 62
>
>
>
> 2016-08-02 17:19 GMT+02:00 Jason Pickering <
> jason.p.picker...@gmail.com>:
>
>> Hi Sergio,
>> I will take care of it for you.
>>
>> Regards,
>> Jason
>>
>>
>> On Tue, Aug 2, 2016 at 5:16 PM, Sergio Valenzuela <
>> sergio.valenzu...@ehas.org> wrote:
>>
>>> Hello devs,
>>>
>>> Could it be possible to add the flag of Equatorial Guinea as an
>>> option on the Settings -> Appearance menu?
>>>
>>> Best Regards!
>>>
>>>
>>> *Sergio Valenzuela*
>>> Fundación EHAS
>>> Telemedicina para países en desarrollo -* www.ehas.org
>>> *
>>> E.T.S.I. de Telecomunicación A.101-9L. Ciudad Universitaria 30,
>>> 28040 Madrid - España
>>> Tlfno. (+34) 91 488 87 41: (+34) 687 67 17 62
>>>
>>>
>>>
>>> ___
>>> 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

>>>
>>>
>>
>
>
> --
> 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