← Back to team overview

dhis2-users team mailing list archive

Re: Please help me for a blank run-able DHIS2 database

 

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

JPEG image


Follow ups

References