Please help me for a blank run-able DHIS2 database

Hi Alex,

I already followed that this my morning but still problem. The attachment here is my configuration file

It run fine in 30 minutes practicing continuously then the new problem relating to database connection performance issue I already sent in another mail thread. Please have a look on it and help me so

Thank you

postgresql.conf (21.4 KB)

···

On Thu, Apr 23, 2015 at 3:29 PM, Alex Tumwesigye atumwesigye@gmail.com wrote:

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@pkgdvietuc.com 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


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

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 "

On Wed, Apr 22, 2015 at 5:19 PM, Thuy Nguyen thuy.hispvietnam@gmail.com 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@gmail.com đã viết:

Hi Liem,

I am glad I was of help.

Cheers


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

On 22 April 2015 at 06:01, Liem Le Duy liem.leduy@pkgdvietuc.com 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


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

On Wed, Apr 22, 2015 at 4:47 PM, Alex Tumwesigye atumwesigye@gmail.com 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@pkgdvietuc.com wrote:

Hi Nieker,

Could you please create another thread for your issue? :slight_smile:

Thank you

Liem


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 "

On Wed, Apr 22, 2015 at 4:41 PM, Alex Tumwesigye atumwesigye@gmail.com wrote:

Dear Niekerk,

Please visit https://www.dhis2.org/downloads for DHIS2 software.

For documentation, please visit https://www.dhis2.org/documentation

Alex


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

On Wed, Apr 22, 2015 at 12:36 PM, Niekerk, AK, Mnr akniekerk@sun.ac.za akniekerk@sun.ac.za 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@sun.ac.za
| www.sun.ac.za/southtosouth

From: Dhis2-users [mailto:dhis2-users-bounces+akniekerk=sun.ac.za@lists.launchpad.net] 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@gmail.com 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@pkgdvietuc.com 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@gmail.com 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@pkgdvietuc.com 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”
  1. 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

  1. 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@pkgdvietuc.com 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@gmail.com 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@pkgdvietuc.com 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@gmail.com 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@gmail.com 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@pkgdvietuc.com 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

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 "

Hi Liem,

Try adjusting the effective_cache_size and shared buffers and see.

Alex

image

···

On Thu, Apr 23, 2015 at 12:06 PM, Liem Le Duy liem.leduy@pkgdvietuc.com wrote:

Hi Alex,

I already followed that this my morning but still problem. The attachment here is my configuration file

It run fine in 30 minutes practicing continuously then the new problem relating to database connection performance issue I already sent in another mail thread. Please have a look on it and help me so

Thank you

On Thu, Apr 23, 2015 at 3:29 PM, Alex Tumwesigye atumwesigye@gmail.com wrote:

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@pkgdvietuc.com 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


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

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 "

On Wed, Apr 22, 2015 at 5:19 PM, Thuy Nguyen thuy.hispvietnam@gmail.com 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@gmail.com đã viết:

Hi Liem,

I am glad I was of help.

Cheers


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

On 22 April 2015 at 06:01, Liem Le Duy liem.leduy@pkgdvietuc.com 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


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

On Wed, Apr 22, 2015 at 4:47 PM, Alex Tumwesigye atumwesigye@gmail.com 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@pkgdvietuc.com wrote:

Hi Nieker,

Could you please create another thread for your issue? :slight_smile:

Thank you

Liem


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 "

On Wed, Apr 22, 2015 at 4:41 PM, Alex Tumwesigye atumwesigye@gmail.com wrote:

Dear Niekerk,

Please visit https://www.dhis2.org/downloads for DHIS2 software.

For documentation, please visit https://www.dhis2.org/documentation

Alex


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

On Wed, Apr 22, 2015 at 12:36 PM, Niekerk, AK, Mnr akniekerk@sun.ac.za akniekerk@sun.ac.za 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@sun.ac.za
| www.sun.ac.za/southtosouth

From: Dhis2-users [mailto:dhis2-users-bounces+akniekerk=sun.ac.za@lists.launchpad.net] 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@gmail.com 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@pkgdvietuc.com 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@gmail.com 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@pkgdvietuc.com 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”
  1. 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

  1. 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@pkgdvietuc.com 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@gmail.com 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@pkgdvietuc.com 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@gmail.com 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@gmail.com 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@pkgdvietuc.com 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

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 "

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 "