dhis2-users team mailing list archive

[Alex Tumwesigye <atumwesigye@xxxxxxxxx>]

Dear Liem,

I have encountered such scenarios before. You may need to optimize your
database.
Go to postgresql conf and optimize it as per guidelines in
https://www.dhis2.org/doc/snapshot/en/implementer/html/ch08s02.html#d5e469

It seems your queries are taking long to get processed. Increasing buffers
may assist.

Alex




On Thu, Apr 23, 2015 at 5:07 AM, Liem Le Duy <liem.leduy@xxxxxxxxxxxxxx>
wrote:

> Thank you for your kindness, Thuy!. I am happy and will remember that
>
> @Alex, I tried your option with Serra Leon database, at the first time it
> more quicker and can do some actions. However, after several actions, may
> be 2-3, I just navigated to dashboard, messages then moved to profile, the
> response become slowly as so far. Seem the system hang up
>
> And the Tomcat still take a lot of PC time about more 80% although my
> Tomcat is fresh with only DHIS2 web
>
> Best regards
>
> On Wed, Apr 22, 2015 at 5:19 PM, Thuy Nguyen <thuy.hispvietnam@xxxxxxxxx>
> wrote:
>
>> I am happy that you can run the DHIS in your computer now. I am Thuy from
>> HISP Vietnam. If you need more support in learning DHIS 2 function and
>> build database in it. I will be happy to help you.
>> Vào 22-04-2015 17:05, "Michael Mwebaze" <michael.mwebaze@xxxxxxxxx> đã
>> viết:
>>
>> Hi Liem,
>>>
>>> I am glad I was of help.
>>>
>>> Cheers
>>>
>>> On 22 April 2015 at 06:01, Liem Le Duy <liem.leduy@xxxxxxxxxxxxxx>
>>> wrote:
>>>
>>>> Hi Michael & Alex,
>>>>
>>>> It's MAGIC!, the DHIS2 support to generate new database from hql schema?
>>>>
>>>> I tried with new database and it run more faster, some actions can be
>>>> tested as first time I see
>>>>
>>>> I also will try the option as Alex suggested by tomorrow and report
>>>> you. I have to leave now
>>>>
>>>> I am very appreciated to your help!
>>>>
>>>> Thank you all a lot!
>>>> Best regards
>>>> Liem
>>>>
>>>>
>>>>
>>>>
>>>> On Wed, Apr 22, 2015 at 4:47 PM, Alex Tumwesigye <atumwesigye@xxxxxxxxx
>>>> > wrote:
>>>>
>>>>> Hi Liem,
>>>>>
>>>>> Please try this tomcat setting.
>>>>>
>>>>> JAVA_OPTS="-Xmx2000m -XX:MaxPermSize=800m"
>>>>>
>>>>> Alex
>>>>>
>>>>> On Wed, Apr 22, 2015 at 12:45 PM, Liem Le Duy <
>>>>> liem.leduy@xxxxxxxxxxxxxx> wrote:
>>>>>
>>>>>> Hi Nieker,
>>>>>>
>>>>>> Could you please create another thread for your issue? :)
>>>>>>
>>>>>> Thank you
>>>>>> Liem
>>>>>>
>>>>>> On Wed, Apr 22, 2015 at 4:41 PM, Alex Tumwesigye <
>>>>>> atumwesigye@xxxxxxxxx> wrote:
>>>>>>
>>>>>>> Dear Niekerk,
>>>>>>>
>>>>>>> Please visit https://www.dhis2.org/downloads for DHIS2 software.
>>>>>>> For documentation, please visit https://www.dhis2.org/documentation
>>>>>>>
>>>>>>>
>>>>>>> Alex
>>>>>>>
>>>>>>> On Wed, Apr 22, 2015 at 12:36 PM, Niekerk, AK, Mnr <
>>>>>>> akniekerk@xxxxxxxxx> <akniekerk@xxxxxxxxx> wrote:
>>>>>>>
>>>>>>>>  Good Day All,
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> I am new to the forum and I have identified that DHIS2 is a tool
>>>>>>>> that could be used to monitor patient outcome indicators but I have no idea
>>>>>>>> how to go about requesting access to it. I know where to download the tool
>>>>>>>> and the resource documents but creating or requesting access is what I seem
>>>>>>>> to be having difficulty with.
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> Is anyone able to direct/assist me?
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> Kind Regards,
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> *Ashley Niekerk*
>>>>>>>>
>>>>>>>> Programme Data Manager
>>>>>>>>
>>>>>>>> *South to South Program for Comprehensive Family HIV Care &
>>>>>>>> Treatment *
>>>>>>>>
>>>>>>>> Department of Paediatrics and Child Health, Faculty of Medicine and
>>>>>>>> Health Sciences, Stellenbosch University | 3rd Floor, Teaching Block,
>>>>>>>> Tygerberg Campus , Francie van Zyl Drive, Tygerberg 7505 | Tel +27
>>>>>>>> 021 938 9972 | Fax +27  021 938 9972 |
>>>>>>>>
>>>>>>>> Toll free 0800 050 050 | Email: akniekerk@xxxxxxxxx |
>>>>>>>> www.sun.ac.za/southtosouth
>>>>>>>>
>>>>>>>> [image: cid:image002.jpg@01CE98CD.649BE8E0]
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> *From:* Dhis2-users [mailto:dhis2-users-bounces+akniekerk=
>>>>>>>> sun.ac.za@xxxxxxxxxxxxxxxxxxx] *On Behalf Of *Liem Le Duy
>>>>>>>> *Sent:* 22 April 2015 11:34 AM
>>>>>>>> *To:* Michael Mwebaze
>>>>>>>> *Cc:* dhis2-users
>>>>>>>> *Subject:* Re: [Dhis2-users] Please help me for a blank run-able
>>>>>>>> DHIS2 database
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> Hi Michael,
>>>>>>>>
>>>>>>>> I downloaded version 2.18 from this site
>>>>>>>> https://www.dhis2.org/downloads. I just a newbie in this domain
>>>>>>>> for 2 days and don't know where is better resource
>>>>>>>>
>>>>>>>> Best
>>>>>>>>
>>>>>>>> Liem
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> On Wed, Apr 22, 2015 at 4:29 PM, Michael Mwebaze <
>>>>>>>> michael.mwebaze@xxxxxxxxx> wrote:
>>>>>>>>
>>>>>>>>   Liem,
>>>>>>>>
>>>>>>>> are you using the war downloaded from the dhis portal? I remember
>>>>>>>> having issues with it so I had to checkout the source code and do a fresh
>>>>>>>> maven build and was then able to deploy it. I am hoping you don't have to
>>>>>>>> go that far.
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> Regards,
>>>>>>>>
>>>>>>>> Michael
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> On 22 April 2015 at 05:23, Liem Le Duy <liem.leduy@xxxxxxxxxxxxxx>
>>>>>>>> wrote:
>>>>>>>>
>>>>>>>>    Hi Michael,
>>>>>>>>
>>>>>>>> Thank for your response
>>>>>>>>
>>>>>>>> Here below is my pc information
>>>>>>>>
>>>>>>>> RAM: 8gb
>>>>>>>> JAVA_OPTS='-Xmx1024m -Xms1024m -XX:PermSize=512m
>>>>>>>> -XX:MaxPermSize=1024m'
>>>>>>>>
>>>>>>>> TOMCAT: 8.0.21
>>>>>>>>
>>>>>>>> Java 7
>>>>>>>>
>>>>>>>> DHIS 2.18
>>>>>>>>
>>>>>>>> Psql 9.4
>>>>>>>>
>>>>>>>> If you want I will start TeamViewer so you can remote access
>>>>>>>>
>>>>>>>> Thank you a lot
>>>>>>>>
>>>>>>>> Liem
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> On Wed, Apr 22, 2015 at 4:18 PM, Michael Mwebaze <
>>>>>>>> michael.mwebaze@xxxxxxxxx> wrote:
>>>>>>>>
>>>>>>>>    Hi Liem,
>>>>>>>>
>>>>>>>> How much RAM does your system have? My laptop has 4GB of RAM and I
>>>>>>>> am able to run the DHIS2 (with Sierra Leone DB) without any problem with
>>>>>>>> the following settings:
>>>>>>>>
>>>>>>>> JAVA_OPTS  -Xmx512m -XX:MaxPermSize=256m
>>>>>>>>
>>>>>>>> Tomcat : 8.0.15
>>>>>>>>
>>>>>>>> Java 7
>>>>>>>>
>>>>>>>> DHIS 2.18
>>>>>>>>
>>>>>>>> Psql 9.3
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> What version of the DHIS2 have you deployed?
>>>>>>>>
>>>>>>>> Regards,
>>>>>>>>
>>>>>>>> Michael
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> On 22 April 2015 at 04:59, Liem Le Duy <liem.leduy@xxxxxxxxxxxxxx>
>>>>>>>> wrote:
>>>>>>>>
>>>>>>>>  Hi everyone,
>>>>>>>>
>>>>>>>>   1. Using command-line to start Tomcat to see error, I can not
>>>>>>>> see any error thrown out on screen. But I see into the log file, there is a
>>>>>>>> message "No Spring WebApplicationInitializer types detected on classpath"
>>>>>>>>
>>>>>>>> 2. To change JAVA_OPTS
>>>>>>>>
>>>>>>>> I already try some values, you can see some values in the SEV image
>>>>>>>> below that start by REM. But performance still slow
>>>>>>>>
>>>>>>>> 3. In the performance image, I captured the %CPU that Tomcat
>>>>>>>> process take (at the first line)
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> Please correct me if any my mistake of configuration
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> On Wed, Apr 22, 2015 at 3:44 PM, Liem Le Duy <
>>>>>>>> liem.leduy@xxxxxxxxxxxxxx> wrote:
>>>>>>>>
>>>>>>>>   It's very slow on my pc now, I will try to follow all your
>>>>>>>> suggest and report later
>>>>>>>>
>>>>>>>> thank you all a lot
>>>>>>>>
>>>>>>>> Best
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> On Wed, Apr 22, 2015 at 3:24 PM, John Lewis <
>>>>>>>> johnlewis.hisp@xxxxxxxxx> wrote:
>>>>>>>>
>>>>>>>>  Hi Liem,
>>>>>>>>
>>>>>>>> you need to set memory for tomcat.
>>>>>>>>
>>>>>>>> JAVA_OPTS="-Xmx1024m -Xms1024m -XX:PermSize=512m
>>>>>>>> -XX:MaxPermSize=1024m"
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> On Wed, Apr 22, 2015 at 3:19 PM, Liem Le Duy <
>>>>>>>> liem.leduy@xxxxxxxxxxxxxx> wrote:
>>>>>>>>
>>>>>>>>    Hi Michael,
>>>>>>>>
>>>>>>>> Yes, correctly, I have checked the Tomcat process always take more
>>>>>>>> than 80% CPU
>>>>>>>>
>>>>>>>> I will try to start manually to see what happened
>>>>>>>>
>>>>>>>> Thank you a lot
>>>>>>>>
>>>>>>>> Liem
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> On Wed, Apr 22, 2015 at 3:09 PM, Michael Mwebaze <
>>>>>>>> michael.mwebaze@xxxxxxxxx> wrote:
>>>>>>>>
>>>>>>>>   Hi Liem,
>>>>>>>>
>>>>>>>> if you deployed the war into tomcat, you might also want to
>>>>>>>> increase the memory allocation to your tomcat. This will help
>>>>>>>> significantly. Also if possible, start Tomcat from the command line so you
>>>>>>>> are able to see if any exceptions are being thrown so you can troubleshoot.
>>>>>>>> I hope this helps.
>>>>>>>>
>>>>>>>> Regards,
>>>>>>>>
>>>>>>>> Michael
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> On 22 April 2015 at 04:03, John Lewis <johnlewis.hisp@xxxxxxxxx>
>>>>>>>> wrote:
>>>>>>>>
>>>>>>>>  Hi Liem,
>>>>>>>>
>>>>>>>> How have you installed dhis2 using dhis2 live or individual
>>>>>>>> component.
>>>>>>>>
>>>>>>>> you can create a database (empty) and use that database name in
>>>>>>>> hibernate.properties file.
>>>>>>>>
>>>>>>>> is it h2 database or postgres.
>>>>>>>>
>>>>>>>> John
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> On Wed, Apr 22, 2015 at 3:00 PM, Liem Le Duy <
>>>>>>>> liem.leduy@xxxxxxxxxxxxxx> wrote:
>>>>>>>>
>>>>>>>>       Dear,
>>>>>>>>
>>>>>>>> My name is Liem, I am from Viet Nam. I am newbie in DHIS2
>>>>>>>>
>>>>>>>> I already installed DHIS2 on my pc with Serra Leon data example,
>>>>>>>> the web site work but the performance is trouble. I can only log-in, any
>>>>>>>> action after log-in successful take long time, I did some actions such as
>>>>>>>> "kick profile button".. then waited but the browser always in progress of
>>>>>>>> connecting and return nothing for us
>>>>>>>>
>>>>>>>> I worry about of Serra Leon example data is huge, so that it cause
>>>>>>>> performance
>>>>>>>>
>>>>>>>> Actually I hope to have a blank database version that come up with
>>>>>>>> a lit bit data such as user, role,..but can be run-able however with more
>>>>>>>> than 320 tables I still not clarified on so I dont know what first point to
>>>>>>>> start to have it
>>>>>>>>
>>>>>>>> So I think to you!, I will be very appreciated if you can send me a
>>>>>>>> blank run-able data or suggest me some clues so I can easy to create it
>>>>>>>>
>>>>>>>> Thank you so much, for reading & understand my condition
>>>>>>>>
>>>>>>>> I am looking forward to your response
>>>>>>>>
>>>>>>>> Best regards
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> _______________________________________________
>>>>>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>>>>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>>>>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> _______________________________________________
>>>>>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>>>>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>>>>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> _______________________________________________
>>>>>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>>>>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>>>>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> Alex Tumwesigye
>>>>>>>
>>>>>>> Technical Advisor - DHIS2 (Consultant),
>>>>>>> Ministry of Health/AFENET
>>>>>>> Kampala
>>>>>>> Uganda
>>>>>>>
>>>>>>> IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya
>>>>>>>
>>>>>>> IT Specialist (Servers, Networks and Security, Health Information
>>>>>>> Systems - DHIS2 ) & Solar Consultant
>>>>>>>
>>>>>>> +256 774149 775, + 256 759 800161
>>>>>>>
>>>>>>> "I don't want to be anything other than what I have been - one tree
>>>>>>> hill "
>>>>>>>
>>>>>>> _______________________________________________
>>>>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>>>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>>>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Alex Tumwesigye
>>>>>
>>>>> Technical Advisor - DHIS2 (Consultant),
>>>>> Ministry of Health/AFENET
>>>>> Kampala
>>>>> Uganda
>>>>>
>>>>> IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya
>>>>>
>>>>> IT Specialist (Servers, Networks and Security, Health Information
>>>>> Systems - DHIS2 ) & Solar Consultant
>>>>>
>>>>> +256 774149 775, + 256 759 800161
>>>>>
>>>>> "I don't want to be anything other than what I have been - one tree
>>>>> hill "
>>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>>>
>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET
Kampala
Uganda

IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya

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

+256 774149 775, + 256 759 800161

"I don't want to be anything other than what I have been - one tree hill "