← Back to team overview

dhis2-users team mailing list archive

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

 

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

JPEG image


Follow ups

References