← Back to team overview

dhis2-users team mailing list archive

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

 

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