← Back to team overview

dhis2-users team mailing list archive

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

 

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

JPEG image


Follow ups

References