Re: [Dhis2-users] Analytics schedule

[Edward Robinson]

Jus to mention that the way we'll tackle this is to run analytics earlier on 
the tracker instance via the API and turn off the scheduled analytics run.
Regards
Ed

From: Dhis2-users 
 On 
Behalf Of Edward Robinson
Sent: Monday, 05 November 2018 11:39 AM
To: dhis2-users 
Subject: [Dhis2-users] Analytics schedule

Is there a way to have analytics run at a time of my choice?  We have two DHIS2 
servers - a tracker for certain programs (TB, etc.) and an aggregate instance 
that encompasses aggregate data for all national programs.  We transfer data 
daily from certain program indicators on the tracker instance to data elements 
on the aggregate instance but would like all data captured that day on the 
tracker instance to be available on the aggregate instance following analytics. 
 As I understand it, we need to transfer the data using the API after analytics 
runs on the tracker instance, though it will only be available on the aggregate 
instance a day later since analytics will have run already when the data is 
transferred, effectively meaning data will be available 2 days later.

Is there a good approach to solving this?  Some thoughts I've had include 
forcing analytics an hour earlier by setting the server time back and then 
forward again in a cron job.  Has anyone tried this?
___
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

[Dhis2-users] Ad blockers and DHIS2

[Edward Robinson]

Just a heads up to any users of uBlock Origin or other ad blockers, the "Easy 
List privacy" list by includes a blacklist entry for analytics.json as can be 
seen here:
https://easylist.to/easylist/easyprivacy.txt
This is included in uBlock Origin and may be included in others (Adblock, 
etc.).  If you have strange behaviour such as analytics not displaying (graphs, 
pivot tables, etc.), check to see if the workstation has an adblocker or other 
script blocker installed and whitelist your DHIS2 installation URL or turn the 
adblocker off for that URL.

Regards
Ed

___
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

Re: [Dhis2-users] Import/Export data between similar but distinct systems

[Edward Robinson]

I’ll share the code and details with the group as soon as we are at release 1.0 
which I anticipate in the next few weeks.  Our approach is to have something 
that’s easy for a sysadmin to insert new mappings from one side to the other 
using a GUI.
Regards
Ed

From: Isaiah Nyabuto <isaiahnyab...@gmail.com>
Sent: Thursday, 05 April 2018 12:14 PM
To: Edward Robinson <erobin...@projectbalance.com>
Cc: Martin Van Aken <mar...@joyouscoding.com>; dhis2-users 
<dhis2-users@lists.launchpad.net>
Subject: Re: [Dhis2-users] Import/Export data between similar but distinct 
systems

Hi Martin,

Yes, basically the Idea would be to extract metadata/data from one instance 
(source), do some transformations and load into the other instance 
(destination). You can extract and load the metadata/data directly using the 
dhis2 import/export App or work extensively using dhis2 APIs. There are various 
ETL tools that can be used in the process,  I prefer using R.
The following guide can walk you through the whole process. 
http://rstudio-pubs-static.s3.amazonaws.com/139589_a81125b491094fe3b5e79e3bcea0a56b.html

@Edward, I would like to see what you guys are working on ☺

Thank you





On Wed, Apr 4, 2018 at 4:28 PM, Edward Robinson 
<erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>> wrote:
We’re currently working on something for this – a desktop app that runs on 
Windows / Mac / Linux that allows you to specify some parameters to ‘map’ from 
one side to the other and a shell app that runs on a Linux box and reads the 
config file created by the desktop app once a day to transfer data from the one 
to the other using the API.  We specifically need to transfer aggregate program 
indicator values from one side to data elements on the other.
Things to think about:

  *   You need to map Organisational units on both sides
  *   You need to specify the from element + category option combo / indicator 
and the to element + category option combo on the other side
  *   You need to specify the period type and optionally a start / end date so 
that the system knows what periods to target.
The system is still in development but will effectively enable incremental 
updates by recording periods already taken care of for each source / 
destination / ou.
I’ll keep you posted, at this stage we’re not 100% sure when it will be 
complete, but it should be in the next few weeks.
Ed

From: Dhis2-users 
<dhis2-users-bounces+erobinson=projectbalance@lists.launchpad.net<mailto:projectbalance@lists.launchpad.net>>
 On Behalf Of Martin Van Aken
Sent: Tuesday, 09 January 2018 8:56 PM
To: dhis2-users 
<dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net>>
Subject: [Dhis2-users] Import/Export data between similar but distinct systems

Hello DHIS2 community,
We need to make frequent import/export between two different DHIS2 systems. 
While they are similar and the format "fits", we know some differences, mainly:

- The org units concerned exist on both sides but with different ids
- Same for the data elements
- In some situation, the export value may be an indicator, to be imported in a 
data element

I can imagine making the export in CSV, then having a "matching sheet" in XLS 
with the link between OU in the source system and OU in the destination system.

Is someone doing those kind of operations? What's your typical flow/way of 
working?
I think I remember Lars presenting some feature helping with this on one of the 
last DHIS2 releases, but I'm not sure.

Martin
--
Martin Van Aken - Freelance Enthusiast Developer

Mobile : +32 486 899 652

Follow me on Twitter : @martinvanaken<http://twitter.com/martinvanaken>
Call me on Skype : vanakenm
Hang out with me : mar...@joyouscoding.com<mailto:mar...@joyouscoding.com>
Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken
Company website : www.joyouscoding.com<http://www.joyouscoding.com/>

___
Mailing list: https://launchpad.net/~dhis2-users
Post to : 
dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp



--

Isaiah Nyabuto
+254 729 572 616
Bsc. Health Records Management & Informatics, JKUAT.
___
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

Re: [Dhis2-users] Import/Export data between similar but distinct systems

[Edward Robinson]

We’re currently working on something for this – a desktop app that runs on 
Windows / Mac / Linux that allows you to specify some parameters to ‘map’ from 
one side to the other and a shell app that runs on a Linux box and reads the 
config file created by the desktop app once a day to transfer data from the one 
to the other using the API.  We specifically need to transfer aggregate program 
indicator values from one side to data elements on the other.
Things to think about:

  *   You need to map Organisational units on both sides
  *   You need to specify the from element + category option combo / indicator 
and the to element + category option combo on the other side
  *   You need to specify the period type and optionally a start / end date so 
that the system knows what periods to target.
The system is still in development but will effectively enable incremental 
updates by recording periods already taken care of for each source / 
destination / ou.
I’ll keep you posted, at this stage we’re not 100% sure when it will be 
complete, but it should be in the next few weeks.
Ed

From: Dhis2-users 
 On 
Behalf Of Martin Van Aken
Sent: Tuesday, 09 January 2018 8:56 PM
To: dhis2-users 
Subject: [Dhis2-users] Import/Export data between similar but distinct systems

Hello DHIS2 community,
We need to make frequent import/export between two different DHIS2 systems. 
While they are similar and the format "fits", we know some differences, mainly:

- The org units concerned exist on both sides but with different ids
- Same for the data elements
- In some situation, the export value may be an indicator, to be imported in a 
data element

I can imagine making the export in CSV, then having a "matching sheet" in XLS 
with the link between OU in the source system and OU in the destination system.

Is someone doing those kind of operations? What's your typical flow/way of 
working?
I think I remember Lars presenting some feature helping with this on one of the 
last DHIS2 releases, but I'm not sure.

Martin
--
Martin Van Aken - Freelance Enthusiast Developer

Mobile : +32 486 899 652

Follow me on Twitter : @martinvanaken
Call me on Skype : vanakenm
Hang out with me : mar...@joyouscoding.com
Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken
Company website : www.joyouscoding.com
___
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

Re: [Dhis2-users] Indicator based on previous year's output

[Edward Robinson]

Thanks Jim, I’ll look into predictors and see if they’re able to meet my 
specific need.  I suspect they might be ideal for setting the targets, though 
we will likely set an annual target once a year and average that for quarterly 
targets – maybe once a year create quarterly target indicators based on the 
annual target elements / 4.  I’ll put something more comprehensive together for 
a Jira ticket to explain exactly what we’re doing – I suspect it will be very 
useful for the whole community.
Regards
Ed

From: Jim Grace <j...@dhis2.org>
Sent: Wednesday, 28 March 2018 10:23 PM
To: Tlohang <moekets...@yahoo.com>
Cc: Edward Robinson <erobin...@projectbalance.com>; DHIS Users 
<dhis2-users@lists.launchpad.net>
Subject: Re: [Dhis2-users] Indicator based on previous year's output

Hi Edward,

1. You might consider using predictors. Define additional data elements (with 
disaggregations if you like) for your targets. Use predictors to populate those 
data elements in the new period based on values from the old period(s). You can 
use a predictor formula to sum past data, and even add 5% if you like. Then you 
will have predicted (target) data in the same period to compare with your 
results in that period. For details see 
https://docs.dhis2.org/master/en/user/html/manage_predictor.html

2. We are considering possible future enhancements to analytics expressions 
including things like pulling data from past periods into an indicator. If this 
would be more useful to you than using predictors, please write up a DHIS2 Jira 
ticket that describes your use case (the kinds of things you've said in this 
email thread would be just fine), and reference the Epic at 
https://jira.dhis2.org/browse/DHIS2-3187 (or let me know and I will reference 
it -- I'm not sure what privilege is required for this.)

Cheers,
Jim


On Wed, Mar 28, 2018 at 4:05 PM, Tlohang 
<moekets...@yahoo.com<mailto:moekets...@yahoo.com>> wrote:
Hi Edward

I see that I was on a different page altogether.
Well, I think your situation can still be addressed within DHIS 2 but you may 
have to do some java scripts to manage the data that has to be retrieved from 
the previous periods. We've done something close to this with one of our 
programmes.

Regards,

Tlohang

On 28 Mar 2018 19:53, Edward Robinson 
<erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>> wrote:

Thanks Tlohang, yes, I’m aware that we can produce a cumulative number of x 
over a period, but I need to then use those numbers to compare data from 
another period as covered in my last mail, hence I assumed I may be able to 
achieve it using an indicator.  Sorry that I was a bit brief in my initial mail,

Regards

Ed



From: Tlohang <moekets...@yahoo.com<mailto:moekets...@yahoo.com>>
Sent: Wednesday, 28 March 2018 7:18 PM
To: Edward Robinson 
<erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>>
Cc: DHIS Users 
<dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net>>
Subject: Re: [Dhis2-users] Indicator based on previous year's output



Hi Edward



You probably don't need an indicator for that. The knows how to analyse that 
data element in that cumulative manner once you choose that period during 
analysis.



I hope this helps.



Regards,

Tlohang



On 28 Mar 2018 17:34, Edward Robinson 
<erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>> wrote:

What’s the best approach to creating an indicator that’s based on a cumulative 
total of a data element captured monthly, for a set timeframe?



E.g. I have an indicator called “Number of patients” captured monthly.

I need an indicator that will give me the total number of patients for the set 
period October 2016 – September 2017.



Thanks in advance!




___
Mailing list: https://launchpad.net/~dhis2-users
Post to : 
dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp



--
Jim Grace
Core developer, DHIS 2
HISP US Inc.
http://www.dhis2.org<https://www.dhis2.org/>
___
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

Re: [Dhis2-users] Indicator based on previous year's output

[Edward Robinson]

Thanks Tlohang, yes, I’m aware that we can produce a cumulative number of x 
over a period, but I need to then use those numbers to compare data from 
another period as covered in my last mail, hence I assumed I may be able to 
achieve it using an indicator.  Sorry that I was a bit brief in my initial mail,
Regards
Ed

From: Tlohang <moekets...@yahoo.com>
Sent: Wednesday, 28 March 2018 7:18 PM
To: Edward Robinson <erobin...@projectbalance.com>
Cc: DHIS Users <dhis2-users@lists.launchpad.net>
Subject: Re: [Dhis2-users] Indicator based on previous year's output

Hi Edward

You probably don't need an indicator for that. The knows how to analyse that 
data element in that cumulative manner once you choose that period during 
analysis.

I hope this helps.

Regards,
Tlohang

On 28 Mar 2018 17:34, Edward Robinson 
<erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>> wrote:

What’s the best approach to creating an indicator that’s based on a cumulative 
total of a data element captured monthly, for a set timeframe?



E.g. I have an indicator called “Number of patients” captured monthly.

I need an indicator that will give me the total number of patients for the set 
period October 2016 – September 2017.



Thanks in advance!

___
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

Re: [Dhis2-users] Indicator based on previous year's output

[Edward Robinson]

I am beginning to think what I'm trying to achieve is not possible within DHIS2 
without using the API and creating custom reports, please correct me if I'm 
wrong.

  1.  I want a cumulative quarterly target for certain data elements.  I want 
to base the target on the previous year's performance (per OU).  In the example 
below, the values there are based on the previous year's actual values 
(possibly + 5% or another suitable figure):

[cid:image002.jpg@01D3C6CE.12ACE640]



  1.  I want to compare the cumulative target values for the above period with 
the cumulative actual values for the same period...

[cid:image004.jpg@01D3C6CE.12ACE640]



...to produce the final output showing the percentage of target achieved for 
the cumulative number of visits:

[cid:image006.jpg@01D3C6CE.12ACE640]

I am thinking that for 1) we may need to create a new data element and record 
the cumulative values manually (or import).  For the final result, I'm not 
sure, given that we're expecting a comparison of cumulative figures, how doable 
it is without a custom report and the API.  Any insight would be appreciated.
Thanks,
Ed

From: Dhis2-users 
<dhis2-users-bounces+erobinson=projectbalance@lists.launchpad.net> On 
Behalf Of Edward Robinson
Sent: Wednesday, 28 March 2018 5:35 PM
To: DHIS Users <dhis2-users@lists.launchpad.net>
Subject: [Dhis2-users] Indicator based on previous year's output

What's the best approach to creating an indicator that's based on a cumulative 
total of a data element captured monthly, for a set timeframe?

E.g. I have an indicator called "Number of patients" captured monthly.
I need an indicator that will give me the total number of patients for the set 
period October 2016 - September 2017.

Thanks in advance!
___
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

[Dhis2-users] Indicator based on previous year's output

[Edward Robinson]

What's the best approach to creating an indicator that's based on a cumulative 
total of a data element captured monthly, for a set timeframe?

E.g. I have an indicator called "Number of patients" captured monthly.
I need an indicator that will give me the total number of patients for the set 
period October 2016 - September 2017.

Thanks in advance!
___
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

[Dhis2-users] Organisational unit by level via API

[Edward Robinson]

Is there a nice clean way of displaying organisational units by level using the 
API?
Thanks in advance!
___
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

Re: [Dhis2-users] HOW TO CREATE PROGRAM INDICATOR IN DHIS2 2.27 TO 2.28

[Edward Robinson]

Hi Stanley, have you looked at this?
https://docs.dhis2.org/2.27/en/user/html/configure_program_indicator.html#create_program_indicator
In version 2.27 and above It’s moved to Maintenance -> Indicator -> Program 
Indicator
Regards
Ed

From: Dhis2-users 
[mailto:dhis2-users-bounces+erobinson=projectbalance@lists.launchpad.net] 
On Behalf Of Stanley Kalyati
Sent: Tuesday, 20 February 2018 11:32 AM
To: DHIS Users ; DHIS 2 Developers list 

Subject: [Dhis2-users] HOW TO CREATE PROGRAM INDICATOR IN DHIS2 2.27 TO 2.28

Dear All,

Initially i was using dhis2 2.26 build revision  aaae441 and when creating a 
program indicator,thats the page i would come and i would easily do it.Now in 
2.27 version,everything seems different.Anyone with any documentation please 
share or advise.This is urgent.

[Inline image 1]
___
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

[Dhis2-users] Program Indicator values / Indicator values with API

[Edward Robinson]

Is there any way to view program indicator values or indicator values using the 
API, or is this something I'd have to have my app calculate dynamically based 
on the variables?
Thanks!
Ed

___
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

Re: [Dhis2-users] Android applications security risk

[Edward Robinson]

Thanks Marta, I appreciate the feedback and will look into those links.
Regards
Ed

-Original Message-
From: Marta Vila [mailto:martav...@gmail.com] 
Sent: Wednesday, 21 February 2018 11:23 AM
To: Edward Robinson <erobin...@projectbalance.com>
Cc: Ignacio Foche <nacho.fo...@gmail.com>; dhis2-users 
<dhis2-users@lists.launchpad.net>
Subject: Re: [Dhis2-users] Android applications security risk

Hi Ed,

those request were actually pretty popular when we had the community feedback 
and they are being included in the new App. Unfortunately they will not be 
present in the current Apps.

These are a fre Jira issues about improving security that you might want to 
follow  up:

- Do not delete data when user logs out
https://jira.dhis2.org/browse/ANDROAPP-582
- Lock app to prevent unauthorised access
https://jira.dhis2.org/browse/ANDROAPP-590
- Block after Multiple access Failure https://jira.dhis2.org/browse/ANDROAPP-616
- Access auditing  https://jira.dhis2.org/browse/ANDROAPP-610
- Encrypt data base  https://jira.dhis2.org/browse/ANDROAPP-588

Best,
Marta


On 19/02/2018, Edward Robinson <erobin...@projectbalance.com> wrote:
> Thanks Ignacio, hopefully it will be implemented soon.  I don’t think 
> it’s unexpected in some communities for people using the app to be 
> sharing their device with other friends / family if it’s a personal 
> device.  I’m not familiar with the technical side of the application, 
> do you know if the data on the device is encrypted at rest?
> Regards
> Ed
>
> From: Ignacio Foche [mailto:nacho.fo...@gmail.com]
> Sent: Monday, 19 February 2018 3:36 AM
> To: Edward Robinson <erobin...@projectbalance.com>
> Cc: dhis2-users <dhis2-users@lists.launchpad.net>
> Subject: Re: [Dhis2-users] Android applications security risk
>
> Hi Ed,
>
> In the Current DHIS2 Apps there's no way to ask for the password in a 
> per-session basis (nothing like a sign-out + sign-in without DB wipe). 
> As far as I know, there are plans for this on the new app (at least 
> we've already provided such a function in the new SDK) but regarding 
> the new app roadmap I'm not the appropriate person to talk, so I leave 
> Marta to complete my answer.
>
> In the meanwhile, I would suggest protecting your device with a PIN, 
> so only the authorized person can unblock the device.
>
> I hope it helps.
>
> Best regards
>
> Le ven. 16 févr. 2018 à 19:18, Edward Robinson 
> <erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>> a 
> écrit
> :
> Is there any way to sign out of the Android application?  We’re 
> wanting to use it to track highly sensitive patient level data in the 
> field but can’t find a sign out option in the application.  I’m 
> concerned that if a field worker loses a phone this is a serious 
> security risk.  Am I missing something, or is there no way to sign out 
> of the application without wiping the local data?  Is this a feature still 
> planned for future?
>
> Regards
> Ed
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to :
> dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net
> > Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
> --
> Ignacio Foche Pérez
>
___
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

Re: [Dhis2-users] Android applications security risk

[Edward Robinson]

Thanks Ignacio, hopefully it will be implemented soon.  I don’t think it’s 
unexpected in some communities for people using the app to be sharing their 
device with other friends / family if it’s a personal device.  I’m not familiar 
with the technical side of the application, do you know if the data on the 
device is encrypted at rest?
Regards
Ed

From: Ignacio Foche [mailto:nacho.fo...@gmail.com]
Sent: Monday, 19 February 2018 3:36 AM
To: Edward Robinson <erobin...@projectbalance.com>
Cc: dhis2-users <dhis2-users@lists.launchpad.net>
Subject: Re: [Dhis2-users] Android applications security risk

Hi Ed,

In the Current DHIS2 Apps there's no way to ask for the password in a 
per-session basis (nothing like a sign-out + sign-in without DB wipe). As far 
as I know, there are plans for this on the new app (at least we've already 
provided such a function in the new SDK) but regarding the new app roadmap I'm 
not the appropriate person to talk, so I leave Marta to complete my answer.

In the meanwhile, I would suggest protecting your device with a PIN, so only 
the authorized person can unblock the device.

I hope it helps.

Best regards

Le ven. 16 févr. 2018 à 19:18, Edward Robinson 
<erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>> a écrit :
Is there any way to sign out of the Android application?  We’re wanting to use 
it to track highly sensitive patient level data in the field but can’t find a 
sign out option in the application.  I’m concerned that if a field worker loses 
a phone this is a serious security risk.  Am I missing something, or is there 
no way to sign out of the application without wiping the local data?  Is this a 
feature still planned for future?

Regards
Ed
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : 
dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp
--
Ignacio Foche Pérez
___
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

Re: [Dhis2-users] Tracker capture app for Android - OUs not showing up

[Edward Robinson]

Thanks Ignacio, I’ve just checked and I agree with what you’ve posted,
Regards
Ed

From: Ignacio Foche [mailto:nacho.fo...@gmail.com]
Sent: Monday, 19 February 2018 3:56 AM
To: Edward Robinson <erobin...@projectbalance.com>
Cc: Mike Johnson <mjohn...@pih.org>; dhis2-users 
<dhis2-users@lists.launchpad.net>
Subject: Re: [Dhis2-users] Tracker capture app for Android - OUs not showing up

Hi Ed,

You're correct. Current Apps only let you enter data for directly assigned OUs. 
I've created a Jira issue asking for this improvement as I couldn't find yours 
(https://jira.dhis2.org/browse/ACA-327). Please, feel free to add or correct 
any information written on the issue.

Thanks

Best regards

Le ven. 16 févr. 2018 à 20:31, Edward Robinson 
<erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>> a écrit :
Thanks Mike, that confirms my suspicions.  I’ll create a Jira ticket to suggest 
consistency with the OU selection behaviour.
Cheers
Ed

From: Mike Johnson [mailto:mjohn...@pih.org<mailto:mjohn...@pih.org>]
Sent: Friday, 16 February 2018 2:01 PM
To: Edward Robinson 
<erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>>; 
dhis2-users 
<dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net>>
Subject: RE: Tracker capture app for Android - OUs not showing up

Hi Ed,

I can’t speak to the Tracker data capture, but I had a similar problem in the 
Android Data Capture app for aggregate data. I ended up creating users who were 
assigned to organizations only at the level of data collection: so in this 
case, the particular hospital wards that they were working. It was possible to 
collect data for multiple locations, as long as those locations were 
individually specified for each user individually. The permissions didn’t 
filter down to lower orgUnit levels the way that they do in the web data entry 
forms.

Hope this helps!

Mike

From: Dhis2-users 
[mailto:dhis2-users-bounces+mjohnson=pih@lists.launchpad.net] On Behalf Of 
Edward Robinson
Sent: Friday, February 16, 2018 12:35 PM
To: dhis2-users 
<dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net>>
Subject: [Dhis2-users] Tracker capture app for Android - OUs not showing up

We’re trying to use the Android tracker capture app for our version 2.28 
Tracker program but only get the very top level OU available when we attempt to 
capture data.  Is there something we’ve forgotten?
Regards
Ed
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : 
dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp
--
Ignacio Foche Pérez
___
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

Re: [Dhis2-users] Tracker capture app for Android - OUs not showing up

[Edward Robinson]

Thanks Mike, that confirms my suspicions.  I'll create a Jira ticket to suggest 
consistency with the OU selection behaviour.
Cheers
Ed

From: Mike Johnson [mailto:mjohn...@pih.org]
Sent: Friday, 16 February 2018 2:01 PM
To: Edward Robinson <erobin...@projectbalance.com>; dhis2-users 
<dhis2-users@lists.launchpad.net>
Subject: RE: Tracker capture app for Android - OUs not showing up

Hi Ed,

I can't speak to the Tracker data capture, but I had a similar problem in the 
Android Data Capture app for aggregate data. I ended up creating users who were 
assigned to organizations only at the level of data collection: so in this 
case, the particular hospital wards that they were working. It was possible to 
collect data for multiple locations, as long as those locations were 
individually specified for each user individually. The permissions didn't 
filter down to lower orgUnit levels the way that they do in the web data entry 
forms.

Hope this helps!

Mike

From: Dhis2-users 
[mailto:dhis2-users-bounces+mjohnson=pih@lists.launchpad.net] On Behalf Of 
Edward Robinson
Sent: Friday, February 16, 2018 12:35 PM
To: dhis2-users 
<dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net>>
Subject: [Dhis2-users] Tracker capture app for Android - OUs not showing up

We're trying to use the Android tracker capture app for our version 2.28 
Tracker program but only get the very top level OU available when we attempt to 
capture data.  Is there something we've forgotten?
Regards
Ed
___
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

[Dhis2-users] Android applications security risk

[Edward Robinson]

Is there any way to sign out of the Android application?  We're wanting to use 
it to track highly sensitive patient level data in the field but can't find a 
sign out option in the application.  I'm concerned that if a field worker loses 
a phone this is a serious security risk.  Am I missing something, or is there 
no way to sign out of the application without wiping the local data?  Is this a 
feature still planned for future?

Regards
Ed
___
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

Re: [Dhis2-users] Tracker capture app for Android - OUs not showing up

[Edward Robinson]

Oh wow, looks like you may be right.  We made an assumption that by selecting 
the top level while everything is collapsed, that all children would be 
available to the user.
Does this mean that if I want some users to be able to enter data at facility 
level, I have to expand every province, district, subdistrict etc. and select 
each of the 800 facilities one by one?   Is there no way to assign all OUs to a 
user quickly?  This appears to be in contrast to the standard data set capture 
in DHIS2 where child OUs are selected automatically by selecting the collapsed 
top level if I'm not mistaken.

Regards
Ed


From: Dhis2-users 
[mailto:dhis2-users-bounces+erobinson=projectbalance@lists.launchpad.net] 
On Behalf Of Edward Robinson
Sent: Friday, 16 February 2018 12:35 PM
To: dhis2-users <dhis2-users@lists.launchpad.net>
Subject: [Dhis2-users] Tracker capture app for Android - OUs not showing up

We're trying to use the Android tracker capture app for our version 2.28 
Tracker program but only get the very top level OU available when we attempt to 
capture data.  Is there something we've forgotten?
Regards
Ed
___
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

[Dhis2-users] Custom forms - disable / enable sections

[Edward Robinson]

Is it possible to hide or show certain sections (tabs) of custom forms by 
facility based on some facility property?  We are trying to avoid having 
multiple forms for various services and present them on a single page with 
multiple tabs if possible, but we want to be able to hide tabs that are 
irrelevant for certain facilities.
Thanks in advance for any ideas!
___
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

[Dhis2-users] Organisational Unit subsets

[Edward Robinson]

What is the best way to approach cascading category option combinations?
Facilities are assigned to organizational groups (there are 5 levels).  Clients 
visit the facilities from their various locations and we need to collect those 
locations but only up to level 3 in the OU hierarchy.  What is the best way to 
approach this?

Regards
Ed

___
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

Re: [Dhis2-users] Tracker programs and unique IDs

[Edward Robinson]

Thanks for the feedback Prosper, I’ll take a look at the Jira issue.
@Thierry Octave<mailto:thierry_oct...@dai.com>

Regards
Ed

From: Prosper BT [mailto:ptb3...@gmail.com]
Sent: Friday, 17 November 2017 10:47 AM
To: Stanley Kalyati <skaly...@gmail.com>
Cc: Edward Robinson <erobin...@projectbalance.com>; dhis2-users 
<dhis2-users@lists.launchpad.net>; Stian Sandvold <st...@dhis2.org>; Calle 
Hedberg <ca...@hisp.org>
Subject: Re: [Dhis2-users] Tracker programs and unique IDs

Dear Edward and Stanley

Currently we have attribute Unique Identifiers with just simply random 
generated number that could be set to be unique within Orgunits or entire 
system. This is being expanded to address your need to customize to the use 
cases pattern; check jira issue 
(DHIS2-434<https://jira.dhis2.org/browse/DHIS2-434>) in progress for 2.29.
Please review the suggestions and add your comments.

Again you can use program rules (Assign) to construct the ID you are 
describing; combination of names, age, place birth . if they are corrected 
as attributes. The only challenge now will be that the generated code will not 
be enforced for uniqueness.

Regards





Prosper Behumbiize, MPH
DHIS2 Implementation| HISP Uganda
pros...@hispuganda.org<mailto:ptb3...@gmail.com> | 
pros...@dhis2.org<mailto:pros...@dhis2.org> | Skype: prospertb

On Thu, Nov 16, 2017 at 1:04 PM, Stanley Kalyati 
<skaly...@gmail.com<mailto:skaly...@gmail.com>> wrote:
I would surely want to learn this too.

Cheers!

On Tue, Nov 14, 2017 at 8:09 PM, Edward Robinson 
<erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>> wrote:
What strategies have others used to ensure that tracked entities have unique 
IDs in the absence of an existing unique identifier?

For people, we’re considering a combination of name, date of birth (or 
estimated date of birth), parent’s names, place of birth, etc.
We’re also considering a soundex like search feature to find people (since 
names and places could be misspelled).

The thing I’m not sure of is what is the best strategy to have the system 
auto-generate this ID in the absence of a national ID number?  i.e. The system 
requires minimum information and generates the ID based on the entered data.
Does this have to be implemented using a custom form for data entry with API 
interface for POST/GET?

Thanks!
Ed

___
Mailing list: https://launchpad.net/~dhis2-users
Post to : 
dhis2-users@lists.launchpad.net<mailto: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<mailto: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

[Dhis2-users] Tracker programs and unique IDs

[Edward Robinson]

What strategies have others used to ensure that tracked entities have unique 
IDs in the absence of an existing unique identifier?

For people, we're considering a combination of name, date of birth (or 
estimated date of birth), parent's names, place of birth, etc.
We're also considering a soundex like search feature to find people (since 
names and places could be misspelled).

The thing I'm not sure of is what is the best strategy to have the system 
auto-generate this ID in the absence of a national ID number?  i.e. The system 
requires minimum information and generates the ID based on the entered data.
Does this have to be implemented using a custom form for data entry with API 
interface for POST/GET?

Thanks!
Ed
___
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

Re: [Dhis2-users] DHIS2.ORG is down

[Edward Robinson]

I can confirm this on my end too.
Ed

From: Dhis2-users 
[mailto:dhis2-users-bounces+erobinson=projectbalance@lists.launchpad.net] 
On Behalf Of Barnabas Akumba
Sent: Monday, 13 November 2017 10:23 AM
To: dhis2-devs ; dhis2-users 
; DHIS2 system administrators 

Subject: [Dhis2-users] DHIS2.ORG is down

Hello All,

I've been trying to download files on the dhis2.org site but 
encounter "502 Bad Gateway".


Regards


--

Barnabas AKUMBA

Mobile: +2348036195778
Skype: barnabas.akumba
___
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

Re: [Dhis2-users] [WISCENTDs] User role > Authorities

[Edward Robinson]

Given the sheer number of authorities, I think this kind of documentation would 
be super helpful.  I’d love to know if something like this exists.
Ed

From: Dhis2-users 
[mailto:dhis2-users-bounces+erobinson=projectbalance@lists.launchpad.net] 
On Behalf Of GROUT, Lise
Sent: Wednesday, 08 November 2017 10:39 AM
To: Dhis2 Users 
Cc: RAMON JOSE JIMENEZ POMARETA 
Subject: [Dhis2-users] [WISCENTDs] User role > Authorities

Dear all,

Is there a place where we could find clear description of each authorities 
available to create user roles?

Best
lise

Dr. Lise Grout
Epidemiologist

World Health Organization
Department of Neglected Tropical Diseases (HTM/NTD/IDM)
Innovative and Intensified Disease Management Unit
20, Avenue Appia; CH-1211 Geneva 27
Tel. +41 22 791 2341
Mobile +41 79 290 68 61
Skype: tigrouveto
http://www.who.int/neglected_diseases

___
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

Re: [Dhis2-users] Unable to view Data values in Data Entry screen

[Edward Robinson]

Glad I could help, thanks for the feedback.
I wish mine were as simple, though I’m nearly there sorting through many years 
of data.  Hopefully I’ll have this issue resolved by Wednesday.
Ed

From: Sunakshi Chagti [mailto:sunakshicha...@gmail.com]
Sent: Monday, 06 November 2017 2:17 PM
To: Edward Robinson <erobin...@projectbalance.com>
Cc: dhis2-d...@lists.launchpad.net; dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Unable to view Data values in Data Entry screen

Thanks Edward

I am getting the error and this is related to category option combo. After 
importing the meta data, category option combination id are used as default in 
data entry screen. I am re-assigning the data elements to category option 
combination. Then they show the data values to data entry screen. Now it is 
working fine.


Regards,
Sunakshi
Junior Software Developer
HISP INDIA


On Mon, Nov 6, 2017 at 2:09 PM, Edward Robinson 
<erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>> wrote:
I have been dealing with a similar issue after upgrade from 2.16

When the data is upgraded to 2.20 some of the category option combination codes 
are changed on the data entry form.  There are a number of category option 
combinations named ‘default’ and the system assigned a different ‘default’ 
category option combination to certain (but not all) fields.
As a result, if you edit the form layout, ‘[ undefined ]’ appears in many data 
entry fields.  Re-assigning the data elements to these fields revealed the new 
category option combination the form was using and I have had to update all 
existing data in the datavalues table to use the new category option 
combination that the form is using to allow existing data to be shown on the 
form and allow analytics to pick it up.

In your case it might be a similar issue but it sounds like it’s more form 
related than data value table related since the data appears in your reports 
but not on the form.

Can you confirm that the correct data elements appear in the various fields by 
editing a data entry form?

From: Dhis2-users 
[mailto:dhis2-users-bounces+erobinson<mailto:dhis2-users-bounces%2Berobinson>=projectbalance@lists.launchpad.net<mailto:projectbalance@lists.launchpad.net>]
 On Behalf Of Sunakshi Chagti
Sent: Friday, 03 November 2017 6:48 AM
To: dhis2-d...@lists.launchpad.net<mailto:dhis2-d...@lists.launchpad.net>; 
dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net>
Subject: [Dhis2-users] Unable to view Data values in Data Entry screen

Hi All,

I am using a 2.25 instance.I am trying to import Data values through 
Import-Export App. Data value are imported and it is present in Data set report 
as well as in Sql view. But it was not present in Data Entry screen. I also 
trying that on 2.26 and 2.27 as well but same issue occurred there.


Regards,
Sunakshi
Junior Software Developer
HISP INDIA



[https://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif]<https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=webmail>

Virus-free. 
www.avast.com<https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=webmail>


___
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

Re: [Dhis2-users] Unable to view Data values in Data Entry screen

[Edward Robinson]

I have been dealing with a similar issue after upgrade from 2.16

When the data is upgraded to 2.20 some of the category option combination codes 
are changed on the data entry form.  There are a number of category option 
combinations named ‘default’ and the system assigned a different ‘default’ 
category option combination to certain (but not all) fields.
As a result, if you edit the form layout, ‘[ undefined ]’ appears in many data 
entry fields.  Re-assigning the data elements to these fields revealed the new 
category option combination the form was using and I have had to update all 
existing data in the datavalues table to use the new category option 
combination that the form is using to allow existing data to be shown on the 
form and allow analytics to pick it up.

In your case it might be a similar issue but it sounds like it’s more form 
related than data value table related since the data appears in your reports 
but not on the form.

Can you confirm that the correct data elements appear in the various fields by 
editing a data entry form?

From: Dhis2-users 
[mailto:dhis2-users-bounces+erobinson=projectbalance@lists.launchpad.net] 
On Behalf Of Sunakshi Chagti
Sent: Friday, 03 November 2017 6:48 AM
To: dhis2-d...@lists.launchpad.net; dhis2-users@lists.launchpad.net
Subject: [Dhis2-users] Unable to view Data values in Data Entry screen

Hi All,

I am using a 2.25 instance.I am trying to import Data values through 
Import-Export App. Data value are imported and it is present in Data set report 
as well as in Sql view. But it was not present in Data Entry screen. I also 
trying that on 2.26 and 2.27 as well but same issue occurred there.


Regards,
Sunakshi
Junior Software Developer
HISP INDIA

___
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

Re: [Dhis2-users] Data integrity question

[Edward Robinson]

Great, thanks for the explanation.  I’ll submit the docs pull request / Jira 
today.
Regards
Ed

From: Jason Pickering [mailto:jason.p.picker...@gmail.com]
Sent: Wednesday, 25 October 2017 10:26 AM
To: Edward Robinson <erobin...@projectbalance.com>
Cc: Nayeem Al Mifthah <n.mift...@gmail.com>; Lars Helge Øverland 
<l...@dhis2.org>; DHIS 2 Users list <dhis2-users@lists.launchpad.net>
Subject: Re: [Dhis2-users] Data integrity question

Hi Ed,

I think it is a "bug" in the documentation. The explanation as it stands is 
unclear and seems to be misleading.

This integrity check simply looks (or should based on its description) for data 
elements which are not part of any groups. This is not intrinsically a problem, 
but can present issues if people want to filter data elements in the pivot 
tables, it can be come confusing.

Please feel free to submit a pull request to the docs, or create a JIRA ticket 
and we will try and fix it as soon as we can.

Regards
Jason




On Wed, Oct 25, 2017 at 9:37 AM, Edward Robinson 
<erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>> wrote:
Thanks Nayeem,

Lars and team, could you weigh in on this?
Thank you
Ed


From: Nayeem Al Mifthah [mailto:n.mift...@gmail.com<mailto:n.mift...@gmail.com>]
Sent: Tuesday, 24 October 2017 7:14 PM

To: Edward Robinson 
<erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>>
Cc: DHIS 2 Users list 
<dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net>>
Subject: Re: [Dhis2-users] Data integrity question

I see, the explanation is bit confusing. I have used same data element in 
several groups from 2.3 to 2.27 and never faced any problem in analytics.

Nayeem Al Mifthah
Consultant for HSS, Health MIS, M
Email: n.mift...@gmail.com<mailto:n.mift...@gmail.com>
Cell:+8801914030574<tel:+880%201914-030574>
Skype: nayeem.a.m

On Tue, Oct 24, 2017 at 7:58 PM, Edward Robinson 
<erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>> wrote:
Apologies, I mean since 2.20 and possibly before…
Regards
Ed

From: Edward Robinson
Sent: Tuesday, 24 October 2017 3:55 PM
To: 'Nayeem Al Mifthah' <n.mift...@gmail.com<mailto:n.mift...@gmail.com>>
Cc: DHIS 2 Users list 
<dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net>>
Subject: RE: [Dhis2-users] Data integrity question

Thanks for the feedback Nayeem, are you saying that the manual is incorrect 
(it’s been like that since 2.16 and possibly before)?  Or are you saying it’s 
possible despite it creating issues (as mentioned in the manual)?
Regards
Ed

From: Nayeem Al Mifthah [mailto:n.mift...@gmail.com<mailto:n.mift...@gmail.com>]
Sent: Tuesday, 24 October 2017 3:46 PM
To: Edward Robinson 
<erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>>
Cc: DHIS 2 Users list 
<dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net>>
Subject: Re: [Dhis2-users] Data integrity question

A data element can be assigned to multiple data element groups.

On 24 Oct 2017 4:24 pm, "Edward Robinson" 
<erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>> wrote:
From the manual: 
https://docs.dhis2.org/2.26/en/user/html/dataAdmin_dataIntegrity.html
19.1.2. Data elements without groups
Some Data Elements have been allocated to several Data Element Groups. This is 
currently not allowed, because it will result in duplication of linked data 
records in the analytics record sets that provide aggregated data. Go to 
Maintenance -> Data Element Groups to review each Data Element identified and 
remove the incorrect Group allocations.
Is that a typo?
Is “Data elements without groups” not for data elements that have not been 
assigned to a group instead of data elements that have been assigned to more 
than one group?
Looking at the data set on my side, the elements that appear in that list don’t 
appear to be assigned to any groups.

Could someone clarify?
Thanks,
Ed

___
Mailing list: https://launchpad.net/~dhis2-users
Post to : 
dhis2-users@lists.launchpad.net<mailto: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<mailto:dhis2-users@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp



--
Jason P. Pickering
email: jason.p.picker...@gmail.com<mailto:jason.p.picker...@gmail.com>
tel:+46764147049
___
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

Re: [Dhis2-users] Data integrity question

[Edward Robinson]

Thanks Nayeem,

Lars and team, could you weigh in on this?
Thank you
Ed


From: Nayeem Al Mifthah [mailto:n.mift...@gmail.com]
Sent: Tuesday, 24 October 2017 7:14 PM
To: Edward Robinson <erobin...@projectbalance.com>
Cc: DHIS 2 Users list <dhis2-users@lists.launchpad.net>
Subject: Re: [Dhis2-users] Data integrity question

I see, the explanation is bit confusing. I have used same data element in 
several groups from 2.3 to 2.27 and never faced any problem in analytics.

Nayeem Al Mifthah
Consultant for HSS, Health MIS, M
Email: n.mift...@gmail.com<mailto:n.mift...@gmail.com>
Cell:+8801914030574
Skype: nayeem.a.m

On Tue, Oct 24, 2017 at 7:58 PM, Edward Robinson 
<erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>> wrote:
Apologies, I mean since 2.20 and possibly before…
Regards
Ed

From: Edward Robinson
Sent: Tuesday, 24 October 2017 3:55 PM
To: 'Nayeem Al Mifthah' <n.mift...@gmail.com<mailto:n.mift...@gmail.com>>
Cc: DHIS 2 Users list 
<dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net>>
Subject: RE: [Dhis2-users] Data integrity question

Thanks for the feedback Nayeem, are you saying that the manual is incorrect 
(it’s been like that since 2.16 and possibly before)?  Or are you saying it’s 
possible despite it creating issues (as mentioned in the manual)?
Regards
Ed

From: Nayeem Al Mifthah [mailto:n.mift...@gmail.com<mailto:n.mift...@gmail.com>]
Sent: Tuesday, 24 October 2017 3:46 PM
To: Edward Robinson 
<erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>>
Cc: DHIS 2 Users list 
<dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net>>
Subject: Re: [Dhis2-users] Data integrity question

A data element can be assigned to multiple data element groups.

On 24 Oct 2017 4:24 pm, "Edward Robinson" 
<erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>> wrote:
From the manual: 
https://docs.dhis2.org/2.26/en/user/html/dataAdmin_dataIntegrity.html
19.1.2. Data elements without groups
Some Data Elements have been allocated to several Data Element Groups. This is 
currently not allowed, because it will result in duplication of linked data 
records in the analytics record sets that provide aggregated data. Go to 
Maintenance -> Data Element Groups to review each Data Element identified and 
remove the incorrect Group allocations.
Is that a typo?
Is “Data elements without groups” not for data elements that have not been 
assigned to a group instead of data elements that have been assigned to more 
than one group?
Looking at the data set on my side, the elements that appear in that list don’t 
appear to be assigned to any groups.

Could someone clarify?
Thanks,
Ed

___
Mailing list: https://launchpad.net/~dhis2-users
Post to : 
dhis2-users@lists.launchpad.net<mailto: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

Re: [Dhis2-users] Data integrity question

[Edward Robinson]

Apologies, I mean since 2.20 and possibly before…
Regards
Ed

From: Edward Robinson
Sent: Tuesday, 24 October 2017 3:55 PM
To: 'Nayeem Al Mifthah' <n.mift...@gmail.com>
Cc: DHIS 2 Users list <dhis2-users@lists.launchpad.net>
Subject: RE: [Dhis2-users] Data integrity question

Thanks for the feedback Nayeem, are you saying that the manual is incorrect 
(it’s been like that since 2.16 and possibly before)?  Or are you saying it’s 
possible despite it creating issues (as mentioned in the manual)?
Regards
Ed

From: Nayeem Al Mifthah [mailto:n.mift...@gmail.com]
Sent: Tuesday, 24 October 2017 3:46 PM
To: Edward Robinson <erobin...@projectbalance.com>
Cc: DHIS 2 Users list <dhis2-users@lists.launchpad.net>
Subject: Re: [Dhis2-users] Data integrity question

A data element can be assigned to multiple data element groups.

On 24 Oct 2017 4:24 pm, "Edward Robinson" 
<erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>> wrote:
From the manual: 
https://docs.dhis2.org/2.26/en/user/html/dataAdmin_dataIntegrity.html
19.1.2. Data elements without groups
Some Data Elements have been allocated to several Data Element Groups. This is 
currently not allowed, because it will result in duplication of linked data 
records in the analytics record sets that provide aggregated data. Go to 
Maintenance -> Data Element Groups to review each Data Element identified and 
remove the incorrect Group allocations.
Is that a typo?
Is “Data elements without groups” not for data elements that have not been 
assigned to a group instead of data elements that have been assigned to more 
than one group?
Looking at the data set on my side, the elements that appear in that list don’t 
appear to be assigned to any groups.

Could someone clarify?
Thanks,
Ed

___
Mailing list: https://launchpad.net/~dhis2-users
Post to : 
dhis2-users@lists.launchpad.net<mailto: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

[Dhis2-users] Data integrity question

[Edward Robinson]

>From the manual: 
>https://docs.dhis2.org/2.26/en/user/html/dataAdmin_dataIntegrity.html
19.1.2. Data elements without groups
Some Data Elements have been allocated to several Data Element Groups. This is 
currently not allowed, because it will result in duplication of linked data 
records in the analytics record sets that provide aggregated data. Go to 
Maintenance -> Data Element Groups to review each Data Element identified and 
remove the incorrect Group allocations.
Is that a typo?
Is "Data elements without groups" not for data elements that have not been 
assigned to a group instead of data elements that have been assigned to more 
than one group?
Looking at the data set on my side, the elements that appear in that list don't 
appear to be assigned to any groups.

Could someone clarify?
Thanks,
Ed
___
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

[Dhis2-users] Tracker and integration with an aggregate level national system

[Edward Robinson]

I have a few questions regarding setting up multiple tracker programs when an 
existing national system is implemented.
What is the general consensus with setting up tracker programs in a national 
level environment - is it preferable to set them up on separate instances?
What about aggregation of data - is it relatively straight forward to aggregate 
the data from the tracker instance to the national aggregated instance?
Would we need to configure the process ourselves as an export/import or is this 
something that can be achieved within DHIS2 automatically?

Thanks!
___
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

Re: [Dhis2-users] Issue with empty analytics for certain data elements after upgrade to 2.26

[Edward Robinson]

Hi Alex, thanks for the response.  I had cleared analytics (data administration 
-> maintenance) and re-generated analytics (reports->analytics->start export).
Unfortunately the results are no different.
I assume the default behaviour of generating analytics tables takes care of the 
resource tables as well.
Regards
Ed

From: Alex Tumwesigye [mailto:atumwesi...@gmail.com]
Sent: Tuesday, 17 October 2017 7:30 AM
To: Edward Robinson <erobin...@projectbalance.com>
Cc: DHIS 2 Users list <dhis2-users@lists.launchpad.net>
Subject: Re: [Dhis2-users] Issue with empty analytics for certain data elements 
after upgrade to 2.26

Hi Robinson,

From data administration,go maintainance and clear analytics. Then re-run after 
running the resource tables. I might help.

Alex

On Monday, October 16, 2017, Edward Robinson 
<erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>> wrote:
Just bumping this in case anyone has insight.
After closer inspection, it seems there are approximately 426 of 674 data 
elements not being included in the analytics table after an apparently 
successful analytics run.  The data appears in the data tables and in the UI 
via the forms and looks fine but does not end up in the Analytics tables.  My 
next step is to begin with the 2.16 version DB and upgrade step at a time, run 
analytics and check the output until I find out which step the issue first 
shows up at.

Regards
Ed


From: Dhis2-users 
[mailto:dhis2-users-bounces+erobinson<javascript:_e(%7B%7D,'cvml','dhis2-users-bounces%2Berobinson');>=projectbalance@lists.launchpad.net<javascript:_e(%7B%7D,'cvml','projectbalance....@lists.launchpad.net');>]
 On Behalf Of Edward Robinson
Sent: Friday, 13 October 2017 2:17 PM
To: DHIS 2 Users list 
<dhis2-users@lists.launchpad.net<javascript:_e(%7B%7D,'cvml','dhis2-users@lists.launchpad.net');>>
Subject: [Dhis2-users] Issue with empty analytics for certain data elements 
after upgrade to 2.26

As mentioned a few times in this forum, we recently upgraded a national level 
installation from 2.16 to 2.26 and have had a few minor issues that we have 
managed to resolve easily.  One issue that I’m struggling a little with is 
certain data elements are no longer being aggregated and included in the 
analytics table.  A look at the analytics log doesn’t appear to yield any 
clues.  It appears the issue is with a particular group of elements – all Lab 
tests (though there are over 1000 elements in total so I haven’t confirmed all).
The element structure seems good.  There are no aggregation levels selected at 
the bottom of the element config page – this is as it was prior to the upgrade 
and other elements with the same configuration are working, so I assume this 
isn’t related to the issue.
I’m about to do some low level comparisons at the table level to see if there’s 
anything obviously amiss though as you probably know, this could be difficult 
given structural changes at the table level.

I have two main questions

  1.  Is there something obvious I am missing and should be checking first
  2.  For general troubleshooting, what would others suggest?

Thanks!



--
Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET  | HISP Uganda
Kampala
Uganda
+256 774149 775, + 256 759 800161
Skype ID: talexie

IT Consultant (Servers, Networks and Security, Health Information Systems - 
DHIS2, Disease Outbreak & Surveillance Systems) & Solar Consultant

"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@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Issue with empty analytics for certain data elements after upgrade to 2.26

[Edward Robinson]

Just bumping this in case anyone has insight.
After closer inspection, it seems there are approximately 426 of 674 data 
elements not being included in the analytics table after an apparently 
successful analytics run.  The data appears in the data tables and in the UI 
via the forms and looks fine but does not end up in the Analytics tables.  My 
next step is to begin with the 2.16 version DB and upgrade step at a time, run 
analytics and check the output until I find out which step the issue first 
shows up at.

Regards
Ed


From: Dhis2-users 
[mailto:dhis2-users-bounces+erobinson=projectbalance@lists.launchpad.net] 
On Behalf Of Edward Robinson
Sent: Friday, 13 October 2017 2:17 PM
To: DHIS 2 Users list <dhis2-users@lists.launchpad.net>
Subject: [Dhis2-users] Issue with empty analytics for certain data elements 
after upgrade to 2.26

As mentioned a few times in this forum, we recently upgraded a national level 
installation from 2.16 to 2.26 and have had a few minor issues that we have 
managed to resolve easily.  One issue that I'm struggling a little with is 
certain data elements are no longer being aggregated and included in the 
analytics table.  A look at the analytics log doesn't appear to yield any 
clues.  It appears the issue is with a particular group of elements - all Lab 
tests (though there are over 1000 elements in total so I haven't confirmed all).
The element structure seems good.  There are no aggregation levels selected at 
the bottom of the element config page - this is as it was prior to the upgrade 
and other elements with the same configuration are working, so I assume this 
isn't related to the issue.
I'm about to do some low level comparisons at the table level to see if there's 
anything obviously amiss though as you probably know, this could be difficult 
given structural changes at the table level.

I have two main questions

  1.  Is there something obvious I am missing and should be checking first
  2.  For general troubleshooting, what would others suggest?

Thanks!

___
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

[Dhis2-users] Issue with empty analytics for certain data elements after upgrade to 2.26

[Edward Robinson]

As mentioned a few times in this forum, we recently upgraded a national level 
installation from 2.16 to 2.26 and have had a few minor issues that we have 
managed to resolve easily.  One issue that I'm struggling a little with is 
certain data elements are no longer being aggregated and included in the 
analytics table.  A look at the analytics log doesn't appear to yield any 
clues.  It appears the issue is with a particular group of elements - all Lab 
tests (though there are over 1000 elements in total so I haven't confirmed all).
The element structure seems good.  There are no aggregation levels selected at 
the bottom of the element config page - this is as it was prior to the upgrade 
and other elements with the same configuration are working, so I assume this 
isn't related to the issue.
I'm about to do some low level comparisons at the table level to see if there's 
anything obviously amiss though as you probably know, this could be difficult 
given structural changes at the table level.

I have two main questions

  1.  Is there something obvious I am missing and should be checking first
  2.  For general troubleshooting, what would others suggest?

Thanks!

___
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

Re: [Dhis2-users] Standard approach for recording age at the time of diagnosis when date of birth is unknown

[Edward Robinson]

That’s neat, nice.

From: Abyot Asalefew Gizaw [mailto:ab...@dhis2.org]
Sent: Wednesday, 11 October 2017 3:02 PM
To: TIMIMI, Hazim Bakir <timi...@who.int>
Cc: Edward Robinson <erobin...@projectbalance.com>; 
dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Standard approach for recording age at the time of 
diagnosis when date of birth is unknown

Hi,

We don't capture the additional data if DOB is approximated or not...

Otherwise, we have a value type called AGE, then during data entry a special 
input field is rendered, see below

[Inline image 1]

Users are free to fill any or combination of these and behind the scene the 
system calculates/updates each field and in the end DOB is saved.

--
Abyot A. Gizaw.
Senior Engineer, DHIS2
University of Oslo
http://www.dhis2.org

On Wed, Oct 11, 2017 at 2:21 PM, TIMIMI, Hazim Bakir 
<timi...@who.int<mailto:timi...@who.int>> wrote:
Hi Ed,

Thanks very much, that makes sense. I also came across this yesterday which 
seems similar to what you have done in the past (see under "Collection and 
usage attributes"): http://meteor.aihw.gov.au/content/index.phtml/itemId/287007

Cheers,
Hazim

-Original Message-
From: Edward Robinson 
[mailto:erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>]
Sent: 11 October 2017 13:40
To: TIMIMI, Hazim Bakir; 
dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net>
Subject: RE: [Dhis2-users] Standard approach for recording age at the time of 
diagnosis when date of birth is unknown

What we've done in the past with other systems is have a field for estimated 
age at time of registration - only completed if the DOB is not known.  DOB is 
then auto-populated based on the entered age, and an additional YES/NO field is 
updated to note that the DOB is estimated and not exact.
Ed

-Original Message-
From: Dhis2-users 
[mailto:dhis2-users-bounces+erobinson<mailto:dhis2-users-bounces%2Berobinson>=projectbalance@lists.launchpad.net<mailto:projectbalance@lists.launchpad.net>]
 On Behalf Of TIMIMI, Hazim Bakir
Sent: Tuesday, 10 October 2017 5:01 PM
To: dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net>
Subject: [Dhis2-users] Standard approach for recording age at the time of 
diagnosis when date of birth is unknown

Is there a standard approach commonly in use to handle ages when the exact date 
of birth of a patient is unknown? I can think of two ways -- either using a 
surrogate (approximate) date of birth that tallies with a person's reported 
age, or have an extra data element for age at time of diagnosis to be used only 
if date of birth is unknown. Obviously, if date of birth is known then age is 
calculated automatically.

I would like to know what people have been using and have seen to be working in 
practice (and not necessarily just in DHIS2).

Thanks!

Hazim
…..
Hazim Timimi
Data Manager, Tuberculosis Monitoring and Evaluation, World Health 
Organization, Geneva, Switzerland Tel : +41 22 791 
3468<tel:%2B41%2022%20791%203468>



___
Mailing list: https://launchpad.net/~dhis2-users
Post to : 
dhis2-users@lists.launchpad.net<mailto: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<mailto: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

Re: [Dhis2-users] Standard approach for recording age at the time of diagnosis when date of birth is unknown

[Edward Robinson]

What we've done in the past with other systems is have a field for estimated 
age at time of registration - only completed if the DOB is not known.  DOB is 
then auto-populated based on the entered age, and an additional YES/NO field is 
updated to note that the DOB is estimated and not exact.
Ed

-Original Message-
From: Dhis2-users 
[mailto:dhis2-users-bounces+erobinson=projectbalance@lists.launchpad.net] 
On Behalf Of TIMIMI, Hazim Bakir
Sent: Tuesday, 10 October 2017 5:01 PM
To: dhis2-users@lists.launchpad.net
Subject: [Dhis2-users] Standard approach for recording age at the time of 
diagnosis when date of birth is unknown

Is there a standard approach commonly in use to handle ages when the exact date 
of birth of a patient is unknown? I can think of two ways -- either using a 
surrogate (approximate) date of birth that tallies with a person's reported 
age, or have an extra data element for age at time of diagnosis to be used only 
if date of birth is unknown. Obviously, if date of birth is known then age is 
calculated automatically.

I would like to know what people have been using and have seen to be working in 
practice (and not necessarily just in DHIS2).

Thanks!

Hazim
…..
Hazim Timimi
Data Manager, Tuberculosis Monitoring and Evaluation, World Health 
Organization, Geneva, Switzerland Tel : +41 22 791 3468



___
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

Re: [Dhis2-users] Ambiguity in upgrade instructions

[Edward Robinson]

Just to confirm that this is the case – in fact, dhis.conf appears to not be 
supported in 2.22 at all.  I was unable to deploy without hibernate.properties 
up to 2.25 where dhis.conf is required.
It might be worth removing the reference here: https://www.dhis2.org/222-upgrade

Regards
Ed

From: Knut Staring [mailto:knu...@gmail.com]
Sent: Thursday, 14 September 2017 2:18 PM
To: Edward Robinson <erobin...@projectbalance.com>
Cc: DHIS 2 Users list <dhis2-users@lists.launchpad.net>
Subject: Re: [Dhis2-users] Ambiguity in upgrade instructions

I think  hibernate.properties works up to and including 2.24. But better to 
just change to dhis.conf.

Knut

On Thu, Sep 14, 2017 at 6:42 PM, Edward Robinson 
<erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>> wrote:
In the 2.22 upgrade instructions it says:
“The DHIS 2 configuration file is now called dhis.conf and has a range of new 
and renamed properties. The hibernate.properties configuration file is 
deprecated. Consult the installation guide for details.”

In 2.25 it says:
“- The system will no longer look for a configuration file called 
hibernate.properties. Instead use dhis.conf as filename. The configuration 
properties in dhis.conf are different from hibernate.properties - read the 
database configuration documentation.”

Does this mean that up to 2.25, hibernate.properties will still work, or has it 
been deprecated since 2.22?

Also in 2.22 instructions:
“A configuration property encryption.password must be set in case you would 
like to take advantage of the new attribute value encryption feature. This 
value should be a random string of at least 24 characters. You also need to 
install the "Java Cryptography Extension (JCE)" on your server in order to 
encrypt information. Consult the encryption installation guide for details.”

We were using this in 2.16 – has something changed that it’s mentioned in the 
2.22 upgrade instructions?

Thanks!
Ed


___
Mailing list: https://launchpad.net/~dhis2-users
Post to : 
dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp



--
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org
___
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

Re: [Dhis2-users] See dashboards assigned to users using psql

[Edward Robinson]

Update for anyone else requiring this, this will get the name of all dashboards 
assigned to a particular user (specified by username):

SELECT dashboard.name as Dashboard FROM dashboard where dashboard.dashboardid 
in (
SELECT dashboardid from dashboardusergroupaccesses where 
dashboardusergroupaccesses.usergroupaccessid in (
SELECT usergroupaccessid FROM usergroupaccess where usergroupaccess.usergroupid 
in (
SELECT usergroup.usergroupid from usergroup where usergroup.usergroupid in (
SELECT usergroupmembers.usergroupid from usergroupmembers where 
usergroupmembers.userid = (
SELECT  userid from users where username = 'username')
UNION
SELECT dashboard.name FROM dashboard where dashboard.dashboardid in (
SELECT dashboardid FROM dashboarduseraccesses where 
dashboarduseraccesses.useraccessid in (
SELECT useraccessid FROM useraccess where  useraccess.userid in (
SELECT userid FROM users WHERE username = 'username')));

Sometimes you can't easily get this information from a user, or perhaps you 
have an issue with an account that needs to be recreated as I did.
Ed

From: Dhis2-users 
[mailto:dhis2-users-bounces+erobinson=projectbalance@lists.launchpad.net] 
On Behalf Of Edward Robinson
Sent: Monday, 02 October 2017 2:20 PM
To: DHIS 2 Users list <dhis2-users@lists.launchpad.net>
Subject: [Dhis2-users] See dashboards assigned to users using psql

Is there a simple way to see the dashboards assigned to or shared with a 
particular user in the database tables?  Which tables should I be investigating?
Thanks!

___
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

Re: [Dhis2-users] No dashboards visible to new user

[Edward Robinson]

This problem has been resolved.  It seems the user was in fact not part of the 
group, but was assigned a role with an identical name - obviously not the same 
thing.
Thanks!

From: Dhis2-users 
[mailto:dhis2-users-bounces+erobinson=projectbalance@lists.launchpad.net] 
On Behalf Of Edward Robinson
Sent: Monday, 02 October 2017 3:45 PM
To: DHIS 2 Users list <dhis2-users@lists.launchpad.net>
Subject: [Dhis2-users] No dashboards visible to new user

On the system I have just upgraded from 2.16 to 2.26, I have a newly created 
user who belongs to a group that has two dashboards assigned to it.  The newly 
created user does not see those dashboards (read only access) - is there 
something I'm forgetting or missing here?  Any idea how I can get those 
dashboard to show again?
Regards
Ed

___
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

[Dhis2-users] No dashboards visible to new user

[Edward Robinson]

On the system I have just upgraded from 2.16 to 2.26, I have a newly created 
user who belongs to a group that has two dashboards assigned to it.  The newly 
created user does not see those dashboards (read only access) - is there 
something I'm forgetting or missing here?  Any idea how I can get those 
dashboard to show again?
Regards
Ed

___
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

[Dhis2-users] See dashboards assigned to users using psql

[Edward Robinson]

Is there a simple way to see the dashboards assigned to or shared with a 
particular user in the database tables?  Which tables should I be investigating?
Thanks!

___
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

[Dhis2-users] Analytics logs

[Edward Robinson]

Where can I see a log file detailing the analytics table generation?  Looking 
at scheduling section of data administration, it's clear that they haven't run 
for some time but I'd like to see a log to determine why.
Thanks!
Ed

___
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

[Dhis2-users] Ambiguity in upgrade instructions

[Edward Robinson]

In the 2.22 upgrade instructions it says:
"The DHIS 2 configuration file is now called dhis.conf and has a range of new 
and renamed properties. The hibernate.properties configuration file is 
deprecated. Consult the installation guide for details."

In 2.25 it says:
"- The system will no longer look for a configuration file called 
hibernate.properties. Instead use dhis.conf as filename. The configuration 
properties in dhis.conf are different from hibernate.properties - read the 
database configuration documentation."

Does this mean that up to 2.25, hibernate.properties will still work, or has it 
been deprecated since 2.22?

Also in 2.22 instructions:
"A configuration property encryption.password must be set in case you would 
like to take advantage of the new attribute value encryption feature. This 
value should be a random string of at least 24 characters. You also need to 
install the "Java Cryptography Extension (JCE)" on your server in order to 
encrypt information. Consult the encryption installation guide for details."

We were using this in 2.16 - has something changed that it's mentioned in the 
2.22 upgrade instructions?

Thanks!
Ed

___
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

[Dhis2-users] Tomcat 8.5

[Edward Robinson]

Is there any reason I shouldn't use Tomcat 8.x with DHIS 2.26 or higher DHIS2?
I see even the 2.27 setup instructions specify Tomcat 7.
Thanks
Ed

___
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

Re: [Dhis2-users] Online Academies

[Edward Robinson]

Thanks again, Knut, this is very promising!  Is there a schedule of when new 
courses are planned?
I’m curious about the requirement for a clear start / end date for online 
self-paced training.  It would be great if anyone could join at any time 
(within reason) and perhaps write an exam at a set point in time, though I may 
be misunderstanding the purpose (e.g. if they include real-time coaching).
Regards
Ed

From: Knut Staring [mailto:knu...@gmail.com]
Sent: Wednesday, 30 August 2017 9:55 PM
To: Edward Robinson <erobin...@projectbalance.com>
Cc: DHIS 2 Users list <dhis2-users@lists.launchpad.net>
Subject: Re: [Dhis2-users] Online Academies

Hi Ed,

Are you familiar with this?
https://academy.dhis2.org/courses/HISP/DHIS2_Level1/2015_Q1/about

Regards,
Knut

On Wed, Aug 30, 2017 at 5:20 PM, Edward Robinson 
<erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>> wrote:
Are there any DHIS2 MOOCs available or in planning?  One of the issues I know a 
lot of partners are having is finding the budget to send staff to attend 
academies in person.  Not as much the cost of the academy itself but the travel 
and the frequency – it’s very hard to plan a project around that sort of 
schedule and staff turnover / training new staff can be a real challenge.
A distance learning system would be fantastic, particularly if official 
certification can be issued on completion.  Even if staff can be sent to a 
regional centre to write an exam after self study (such as Unisa do in South 
Africa), it would be a major cost saving and allow projects to have more staff 
certified – something I believe would benefit the community immensely.

Ed

____
Edward Robinson
Technical Director
Project Balance
www.projectbalance.com<http://www.projectbalance.com/>
tel. +27 74 587 6667<tel:+27%2074%20587%206667>

[PB Logo]<http://www.projectbalance.com/>


___
Mailing list: https://launchpad.net/~dhis2-users
Post to : 
dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp



--
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org
___
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

Re: [Dhis2-users] Database being cleared after Tomcat shutdown

[Edward Robinson]

Hi, I am working with 2.16 and am in the process of upgrading but will not be 
doing that on the live servers – I need to get this working offline on 2.16 
before performing the upgrade.
Regards
Ed

From: Em Le Hong [mailto:em.hispviet...@gmail.com]
Sent: Thursday, 31 August 2017 3:42 PM
To: Edward Robinson <erobin...@projectbalance.com>
Cc: DHIS 2 Users list <dhis2-users@lists.launchpad.net>
Subject: Re: [Dhis2-users] Database being cleared after Tomcat shutdown

Hi again,

If you upgrade from 2.16 to 2.22 or above 2.22, you have to change the 
configuration file from hibernate.properties to dhis.conf. Otherwise, it can't 
connect to the correct database.

Read here to check how to create dhis.conf file.

https://docs.dhis2.org/2.22/en/implementer/html/ch08s03.html#d5e500

On Thu, Aug 31, 2017 at 8:29 PM, Em Le Hong 
<em.hispviet...@gmail.com<mailto:em.hispviet...@gmail.com>> wrote:
Hi,

Which version are you working on? for the recent new version, DHIS2 no longer 
use hibernate.properties file.

Read the upgrade note here:
https://www.dhis2.org/222-upgrade

On Thu, Aug 31, 2017 at 6:32 PM, Edward Robinson 
<erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>> wrote:
I know this is not an uncommon issue and I recall it relates to a configuration 
problem if I’m not mistaken, but for the life of me I cannot fathom why two 
machines I am working with seem to exhibit this behaviour consistently.  I have 
a couple of Windows test servers set up to facilitate an offline upgrade from 
2.16 but I’m unable to resolve this on these two machines.  I’ve seen this on 
Linux as well so assume it’s not OS related.

In a nutshell, the system appears to start up fine, I am able to login and 
access the system, create data elements, create users, etc. but when Tomcat is 
shut down, the database is cleared except for the aggregate tables (all other 
tables are dropped):
[cid:image001.jpg@01D32298.C3F1E660]

When Tomcat is started again, obviously the data is no longer there.  As long 
as it’s running, all appears well in the tables:
[cid:image003.jpg@01D32298.C3F1E660]

I have attached a copy of the logs as well as my hibernate.properties file 
(dummy password) and my system variables.  I’ve also attached a screenshot of 
the ‘about DHIS2’ page for reference.

As far as I can see, the only issues / errors on startup include:
A bunch of ERROR for database constraint drop scripts on startup – because the 
database does not yet exist – I assume these are benign.
Some WARN messages:
   “[127.0.0.1]:5701 [dev] [3.2.1] No join method is enabled! 
Starting standalone. (HazelcastInstanceImpl.java [localhost-startStop-1])”
   “RP discovery / realm validation disabled;  (RealmVerifier.java 
[localhost-startStop-1])”
   “Did not find any ViewResolvers to delegate to; please configure 
them using the 'viewResolvers' property on the ContentNegotiatingViewResolver 
(ContentNegotiatingViewResolver.java [localhost-startStop-1])”

Any idea what could be causing this?

___
Mailing list: https://launchpad.net/~dhis2-users
Post to : 
dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp



--
Em Le Hong
DHIS2 Implementation| HISP Vietnam
em.hispviet...@gmail.com<mailto:em.hispviet...@gmail.com> | Skype: 
em.hispviet...@gmail.com<mailto:em.hispviet...@gmail.com>

[https://drive.google.com/uc?id=0B-tlJrv190f5dmR1Y0t2NERvcVU=download]






--
Em Le Hong
DHIS2 Implementation| HISP Vietnam
em.hispviet...@gmail.com<mailto:em.hispviet...@gmail.com> | Skype: 
em.hispviet...@gmail.com<mailto:em.hispviet...@gmail.com>

[https://drive.google.com/uc?id=0B-tlJrv190f5dmR1Y0t2NERvcVU=download]



___
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

Re: [Dhis2-users] Online Academies

[Edward Robinson]

Excellent, thanks for this Knut, I’ll take a look,
Cheers
Ed

From: Knut Staring [mailto:knu...@gmail.com]
Sent: Wednesday, 30 August 2017 9:55 PM
To: Edward Robinson <erobin...@projectbalance.com>
Cc: DHIS 2 Users list <dhis2-users@lists.launchpad.net>
Subject: Re: [Dhis2-users] Online Academies

Hi Ed,

Are you familiar with this?
https://academy.dhis2.org/courses/HISP/DHIS2_Level1/2015_Q1/about

Regards,
Knut

On Wed, Aug 30, 2017 at 5:20 PM, Edward Robinson 
<erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>> wrote:
Are there any DHIS2 MOOCs available or in planning?  One of the issues I know a 
lot of partners are having is finding the budget to send staff to attend 
academies in person.  Not as much the cost of the academy itself but the travel 
and the frequency – it’s very hard to plan a project around that sort of 
schedule and staff turnover / training new staff can be a real challenge.
A distance learning system would be fantastic, particularly if official 
certification can be issued on completion.  Even if staff can be sent to a 
regional centre to write an exam after self study (such as Unisa do in South 
Africa), it would be a major cost saving and allow projects to have more staff 
certified – something I believe would benefit the community immensely.

Ed

____
Edward Robinson
Technical Director
Project Balance
www.projectbalance.com<http://www.projectbalance.com/>
tel. +27 74 587 6667<tel:+27%2074%20587%206667>

[PB Logo]<http://www.projectbalance.com/>


___
Mailing list: https://launchpad.net/~dhis2-users
Post to : 
dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp



--
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org
___
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

[Dhis2-users] Online Academies

[Edward Robinson]

Are there any DHIS2 MOOCs available or in planning?  One of the issues I know a 
lot of partners are having is finding the budget to send staff to attend 
academies in person.  Not as much the cost of the academy itself but the travel 
and the frequency - it's very hard to plan a project around that sort of 
schedule and staff turnover / training new staff can be a real challenge.
A distance learning system would be fantastic, particularly if official 
certification can be issued on completion.  Even if staff can be sent to a 
regional centre to write an exam after self study (such as Unisa do in South 
Africa), it would be a major cost saving and allow projects to have more staff 
certified - something I believe would benefit the community immensely.

Ed


Edward Robinson
Technical Director
Project Balance
www.projectbalance.com<http://www.projectbalance.com/>
tel. +27 74 587 6667

[PB Logo]<http://www.projectbalance.com/>

___
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

Re: [Dhis2-users] OAuth & Single-Sign-on / CAS with DHIS2

[Edward Robinson]

This is old (2014) but still an interesting slide deck on OpenID Connect
http://wiki.openid.net/w/file/fetch/80030063/OpenID_Connect_Overview_May_5_2014.pdf

Ed

From: Dhis2-users 
[mailto:dhis2-users-bounces+erobinson=projectbalance@lists.launchpad.net] 
On Behalf Of Edward Robinson
Sent: Monday, 07 August 2017 3:53 PM
To: Jason Phillips <ja...@hisp.org>; Morten Olav Hansen <mor...@dhis2.org>
Cc: DHIS 2 Users list <dhis2-users@lists.launchpad.net>
Subject: Re: [Dhis2-users] OAuth & Single-Sign-on / CAS with DHIS2

Just adding my 5c – OpenID has been superseded by OpenID 
connect<https://openid.net/connect/faq/>
These may be interesting reading too:
http://lightstep.com/blog/everything-I-wish-I-knew-about-enterprise-sso/
https://developers.google.com/identity/protocols/OpenIDConnect


Cheers
Ed

From: Dhis2-users 
[mailto:dhis2-users-bounces+erobinson=projectbalance@lists.launchpad.net] 
On Behalf Of Jason Phillips
Sent: Monday, 07 August 2017 11:57 AM
To: Morten Olav Hansen <mor...@dhis2.org>
Cc: DHIS 2 Users list <dhis2-users@lists.launchpad.net>
Subject: Re: [Dhis2-users] OAuth & Single-Sign-on / CAS with DHIS2

Hi Morten,

Thanks for your reply.

We did consider LDAP – and it’s certainly still on the table – but were 
definitely, based on your response, heading in the wrong direction; I have been 
investigating a number of OpenID server entities instead, so I am grateful for 
your advice.
We’ll experiment with LDAP instead, and see where we wind up!  One day soon, we 
hope to begin documenting and sharing with the community all our “solutions”, 
so will eventually revert with our end-game…

Kind Regards,
Jason Phillips
[hisp]
Information Systems / Infrastructure
Health Information Systems Program

This message and any attachments are subject to a disclaimer published at 
http://www.hisp.org/policies.html#comms_disclaimer.  Please read the disclaimer 
before opening any attachment or taking any other action in terms of this 
electronic transmission.  If you cannot access the disclaimer, kindly send an 
email to disclai...@hisp.org<mailto:disclai...@hisp.org> and a copy will be 
provided to you. By replying to this e-mail or opening any attachment you agree 
to be bound by the provisions of the disclaimer.


From: Morten Olav Hansen [mailto:mor...@dhis2.org<mailto:mor...@dhis2.org>]
Sent: Sunday, 06 August 2017 7:49 PM
To: Jason Phillips <ja...@hisp.org<mailto:ja...@hisp.org>>
Cc: DHIS 2 Users list 
<dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net>>
Subject: Re: [Dhis2-users] OAuth & Single-Sign-on / CAS with DHIS2

Hi Jason

Have you considered using LDAP? we have had support for that a few releases. 
OpenID is basically deprecated, and I suggest not going that route. OAuth2 does 
not itself contain any authentication protocols (we are using basic or form 
based to get the bearer token).

We have a issue for adding OpenID connect support (OpenID 2 + OAuth2) but 
that's not something that is coming soon.

--
Morten Olav Hansen
Senior Engineer, DHIS 2
University of Oslo
http://www.dhis2.org

On Fri, Aug 4, 2017 at 10:38 AM, Jason Phillips 
<ja...@hisp.org<mailto:ja...@hisp.org>> wrote:
Greetings, community!

HISP SA is looking at ways to implement a single-sign-on solution within our 
hosted DHIS2 instances, potentially using OAuth and a self-hosted central 
OpenID/OpenAuth server entity (or even a dhis2 instance?) for authentication.
Has anyone got any experience with implementing such a solution, and/or any 
advice about what the best practice could/would be to do so?
The aim would be to try and get all dhis2 instances to share a single user’s 
password across the board, and ideally be able to revoke, manage and control 
access to all instances in a single location.

Any advice, comments, suggestions or guidance would be most welcome.

Kind Regards,
Jason Phillips
[hisp]
Information Systems / Infrastructure
Health Information Systems Program

eMail:   ja...@hisp.org<mailto:ja...@hisp.org>
Tel/Fax:+27 21 712 0170<tel:+27%2021%20712%200170>
Cell: +27 72 973 7250<tel:+27%2072%20973%207250>
Skype: jason.n.phillips
This message and any attachments are subject to a disclaimer published at 
http://www.hisp.org/policies.html#comms_disclaimer.  Please read the disclaimer 
before opening any attachment or taking any other action in terms of this 
electronic transmission.  If you cannot access the disclaimer, kindly send an 
email to disclai...@hisp.org<mailto:disclai...@hisp.org> and a copy will be 
provided to you. By replying to this e-mail or opening any attachment you agree 
to be bound by the provisions of the disclaimer.

[cid:image002.jpg@01D2F4CE.CFC9B9B0]
See the conference website<https://www.ehealthalive.org/> for more

Re: [Dhis2-users] OAuth & Single-Sign-on / CAS with DHIS2

[Edward Robinson]

Just adding my 5c – OpenID has been superseded by OpenID 
connect
These may be interesting reading too:
http://lightstep.com/blog/everything-I-wish-I-knew-about-enterprise-sso/
https://developers.google.com/identity/protocols/OpenIDConnect


Cheers
Ed

From: Dhis2-users 
[mailto:dhis2-users-bounces+erobinson=projectbalance@lists.launchpad.net] 
On Behalf Of Jason Phillips
Sent: Monday, 07 August 2017 11:57 AM
To: Morten Olav Hansen 
Cc: DHIS 2 Users list 
Subject: Re: [Dhis2-users] OAuth & Single-Sign-on / CAS with DHIS2

Hi Morten,

Thanks for your reply.

We did consider LDAP – and it’s certainly still on the table – but were 
definitely, based on your response, heading in the wrong direction; I have been 
investigating a number of OpenID server entities instead, so I am grateful for 
your advice.
We’ll experiment with LDAP instead, and see where we wind up!  One day soon, we 
hope to begin documenting and sharing with the community all our “solutions”, 
so will eventually revert with our end-game…

Kind Regards,
Jason Phillips
[hisp]
Information Systems / Infrastructure
Health Information Systems Program

This message and any attachments are subject to a disclaimer published at 
http://www.hisp.org/policies.html#comms_disclaimer.  Please read the disclaimer 
before opening any attachment or taking any other action in terms of this 
electronic transmission.  If you cannot access the disclaimer, kindly send an 
email to disclai...@hisp.org and a copy will be 
provided to you. By replying to this e-mail or opening any attachment you agree 
to be bound by the provisions of the disclaimer.


From: Morten Olav Hansen [mailto:mor...@dhis2.org]
Sent: Sunday, 06 August 2017 7:49 PM
To: Jason Phillips >
Cc: DHIS 2 Users list 
>
Subject: Re: [Dhis2-users] OAuth & Single-Sign-on / CAS with DHIS2

Hi Jason

Have you considered using LDAP? we have had support for that a few releases. 
OpenID is basically deprecated, and I suggest not going that route. OAuth2 does 
not itself contain any authentication protocols (we are using basic or form 
based to get the bearer token).

We have a issue for adding OpenID connect support (OpenID 2 + OAuth2) but 
that's not something that is coming soon.

--
Morten Olav Hansen
Senior Engineer, DHIS 2
University of Oslo
http://www.dhis2.org

On Fri, Aug 4, 2017 at 10:38 AM, Jason Phillips 
> wrote:
Greetings, community!

HISP SA is looking at ways to implement a single-sign-on solution within our 
hosted DHIS2 instances, potentially using OAuth and a self-hosted central 
OpenID/OpenAuth server entity (or even a dhis2 instance?) for authentication.
Has anyone got any experience with implementing such a solution, and/or any 
advice about what the best practice could/would be to do so?
The aim would be to try and get all dhis2 instances to share a single user’s 
password across the board, and ideally be able to revoke, manage and control 
access to all instances in a single location.

Any advice, comments, suggestions or guidance would be most welcome.

Kind Regards,
Jason Phillips
[hisp]
Information Systems / Infrastructure
Health Information Systems Program

eMail:   ja...@hisp.org
Tel/Fax:+27 21 712 0170
Cell: +27 72 973 7250
Skype: jason.n.phillips
This message and any attachments are subject to a disclaimer published at 
http://www.hisp.org/policies.html#comms_disclaimer.  Please read the disclaimer 
before opening any attachment or taking any other action in terms of this 
electronic transmission.  If you cannot access the disclaimer, kindly send an 
email to disclai...@hisp.org and a copy will be 
provided to you. By replying to this e-mail or opening any attachment you agree 
to be bound by the provisions of the disclaimer.

[cid:image002.jpg@01D2F4CE.CFC9B9B0]
See the conference website for more information!




This message and any attachments are subject to a disclaimer published at 
http://www.hisp.org/policies.html#comms_disclaimer.  Please read the disclaimer 
before opening any attachment or taking any other action in terms of this 
electronic transmission.  If you cannot access the disclaimer, kindly send an 
email to disclai...@hisp.org and a copy will be 
provided to you. By replying to this e-mail or opening any attachment you agree 
to be bound by the provisions of the disclaimer.

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

Re: [Dhis2-users] Upgrading from 2.16

[Edward Robinson]

You are a lifesaver, thank you!
I would love to buy you that beer / coffee – direct mail sent! 
Cheers!
Ed

From: Em Le Hong [mailto:em.hispviet...@gmail.com]
Sent: Monday, 07 August 2017 8:59 AM
To: Edward Robinson <erobin...@projectbalance.com>
Cc: dhis2-users <dhis2-users@lists.launchpad.net>
Subject: Re: [Dhis2-users] Upgrading from 2.16

Hi,

If you still need the old war files from 2.17 to 2.20, you can get it from the 
link below:

https://drive.google.com/drive/folders/0B-tlJrv190f5Nm9PakE1b2JqTms?usp=sharing

On Thu, Aug 3, 2017 at 7:10 PM, Edward Robinson 
<erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>> wrote:
Excellent, that’s a great help,  Thank you!
If nobody gets back to me on the .wars for 2.17->2.21 then I’ll indeed setup 
the environment and compile though I’d like to avoid that route for time sake.
There’s a coffee or couple of beers (in mBTC) for anyone who can source those 
.wars 

Thanks!

From: Em Le Hong 
[mailto:em.hispviet...@gmail.com<mailto:em.hispviet...@gmail.com>]
Sent: Thursday, 03 August 2017 1:51 PM
To: Edward Robinson 
<erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>>
Cc: dhis2-users 
<dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net>>
Subject: Re: [Dhis2-users] Upgrading from 2.16

You can read the upgrade notes from the links below:

https://www.dhis2.org/217-upgrade
https://www.dhis2.org/218-upgrade
https://www.dhis2.org/219-upgrade
...

On Thu, Aug 3, 2017 at 6:48 PM, Em Le Hong 
<em.hispviet...@gmail.com<mailto:em.hispviet...@gmail.com>> wrote:
Hi,

Someone was asking similar question recently, I think you can check out the old 
code and build it yourself.

https://code.launchpad.net/dhis2

On Thu, Aug 3, 2017 at 6:43 PM, Edward Robinson 
<erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>> wrote:
I need to upgrade two reasonably large 2.16 instances to at least 2.26 and am 
needing the following:

  *   All .war files from 2.17 up (at least those required for the upgrade)
  *   Instructions specific to each incremental upgrade until 2.26 (if there 
are specific tasks to perform such as running SQL scripts, etc.)

Does this information / these files exist somewhere on the web?
I have googled but can’t find a .war for anything lower than 2.22 in the 
regular places at this point (e.g. 
https://www.dhis2.org/download/releases/2.17/dhis.war)
Can I skip some versions in this incremental update?

Thanks all!

___
Mailing list: https://launchpad.net/~dhis2-users
Post to : 
dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp



--
Em Le Hong
DHIS2 Implementation| HISP Vietnam
em.hispviet...@gmail.com<mailto:em.hispviet...@gmail.com> | Skype: 
em.hispviet...@gmail.com<mailto:em.hispviet...@gmail.com>

[https://drive.google.com/uc?id=0B-tlJrv190f5dmR1Y0t2NERvcVU=download]






--
Em Le Hong
DHIS2 Implementation| HISP Vietnam
em.hispviet...@gmail.com<mailto:em.hispviet...@gmail.com> | Skype: 
em.hispviet...@gmail.com<mailto:em.hispviet...@gmail.com>

[https://drive.google.com/uc?id=0B-tlJrv190f5dmR1Y0t2NERvcVU=download]






--
Em Le Hong
DHIS2 Implementation| HISP Vietnam
em.hispviet...@gmail.com<mailto:em.hispviet...@gmail.com> | Skype: 
em.hispviet...@gmail.com<mailto:em.hispviet...@gmail.com>

[https://drive.google.com/uc?id=0B-tlJrv190f5dmR1Y0t2NERvcVU=download]



___
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

Re: [Dhis2-users] Upgrading from 2.16

[Edward Robinson]

Excellent, that’s a great help,  Thank you!
If nobody gets back to me on the .wars for 2.17->2.21 then I’ll indeed setup 
the environment and compile though I’d like to avoid that route for time sake.
There’s a coffee or couple of beers (in mBTC) for anyone who can source those 
.wars 

Thanks!

From: Em Le Hong [mailto:em.hispviet...@gmail.com]
Sent: Thursday, 03 August 2017 1:51 PM
To: Edward Robinson <erobin...@projectbalance.com>
Cc: dhis2-users <dhis2-users@lists.launchpad.net>
Subject: Re: [Dhis2-users] Upgrading from 2.16

You can read the upgrade notes from the links below:

https://www.dhis2.org/217-upgrade
https://www.dhis2.org/218-upgrade
https://www.dhis2.org/219-upgrade
...

On Thu, Aug 3, 2017 at 6:48 PM, Em Le Hong 
<em.hispviet...@gmail.com<mailto:em.hispviet...@gmail.com>> wrote:
Hi,

Someone was asking similar question recently, I think you can check out the old 
code and build it yourself.

https://code.launchpad.net/dhis2

On Thu, Aug 3, 2017 at 6:43 PM, Edward Robinson 
<erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>> wrote:
I need to upgrade two reasonably large 2.16 instances to at least 2.26 and am 
needing the following:

  *   All .war files from 2.17 up (at least those required for the upgrade)
  *   Instructions specific to each incremental upgrade until 2.26 (if there 
are specific tasks to perform such as running SQL scripts, etc.)

Does this information / these files exist somewhere on the web?
I have googled but can’t find a .war for anything lower than 2.22 in the 
regular places at this point (e.g. 
https://www.dhis2.org/download/releases/2.17/dhis.war)
Can I skip some versions in this incremental update?

Thanks all!

___
Mailing list: https://launchpad.net/~dhis2-users
Post to : 
dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp



--
Em Le Hong
DHIS2 Implementation| HISP Vietnam
em.hispviet...@gmail.com<mailto:em.hispviet...@gmail.com> | Skype: 
em.hispviet...@gmail.com<mailto:em.hispviet...@gmail.com>

[https://drive.google.com/uc?id=0B-tlJrv190f5dmR1Y0t2NERvcVU=download]






--
Em Le Hong
DHIS2 Implementation| HISP Vietnam
em.hispviet...@gmail.com<mailto:em.hispviet...@gmail.com> | Skype: 
em.hispviet...@gmail.com<mailto:em.hispviet...@gmail.com>

[https://drive.google.com/uc?id=0B-tlJrv190f5dmR1Y0t2NERvcVU=download]



___
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

[Dhis2-users] User rights

[Edward Robinson]

Is there a document that comprehensively describes all the 'Authorities' that 
can be assigned under user roles?
E.g. if one wanted to allow a role to create and populate their own dashboards 
but not public dashboards, what are the appropriate authorities to assign?

Regards
Ed

___
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

Re: [Dhis2-users] Hazelcast instance not active

[Edward Robinson]

For reference, this is my setup according to the 'about DHIS2' page:
[cid:image001.jpg@01D30798.6AB24DD0]

From: Dhis2-users 
[mailto:dhis2-users-bounces+erobinson=projectbalance@lists.launchpad.net] 
On Behalf Of Edward Robinson
Sent: Friday, 28 July 2017 11:48 AM
To: dhis2-users <dhis2-users@lists.launchpad.net>
Subject: [Dhis2-users] Hazelcast instance not active

For the past two days I've woken up to this after logging in to DHIS2 (2.16) on 
Windows:
HTTP Status 500 - Hazelcast instance is not active!
I'm not sure what's causing it and I need to investigate the logs but I 
wondered if anything obvious comes to mind from the user group - has anyone 
else experienced this and what should I look out for?
I'll reboot the server (sorts it out) and continue with some urgent work then 
investigate what may be causing this.

Thanks!

Ed

___
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

[Dhis2-users] Hazelcast instance not active

[Edward Robinson]

For the past two days I've woken up to this after logging in to DHIS2 (2.16) on 
Windows:
HTTP Status 500 - Hazelcast instance is not active!
I'm not sure what's causing it and I need to investigate the logs but I 
wondered if anything obvious comes to mind from the user group - has anyone 
else experienced this and what should I look out for?
I'll reboot the server (sorts it out) and continue with some urgent work then 
investigate what may be causing this.

Thanks!

Ed

___
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

[Dhis2-users] JRE_HOME vs JAVA_HOME

[Edward Robinson]

I assume the JAVA_HOME variable mentioned in most install guides specifically 
refers to the Tomcat requirement as opposed to a DHIS2 requirement.
I ask since I imagine JRE is good enough and the JAVA_HOME variable should be 
substituted for JRE_HOME in cases without JDK.
I just want to make sure JAVA_HOME will not be missed by DHIS itself if I have 
specified JRE_HOME.

Thanks!
Ed
___
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

Re: [Dhis2-users] Quick way to edit users per role?

[Edward Robinson]

Perfect!  That will do it, thanks a ton!

From: Knut Staring [mailto:knu...@gmail.com]
Sent: Wednesday, 19 July 2017 5:56 PM
To: Edward Robinson <erobin...@projectbalance.com>
Cc: dhis2-users <dhis2-users@lists.launchpad.net>
Subject: Re: [Dhis2-users] Quick way to edit users per role?

You can for example do things like this:
https://play.dhis2.org/demo/api/27/userCredentials.json?fields=username,userRoles[name]<https://play.dhis2.org/demo/api/27/userCredentials.json?fields=username,userRoles%5bname%5d>

On Wed, Jul 19, 2017 at 11:35 PM, Edward Robinson 
<erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>> wrote:
Thanks Knut, I’ll play around with the API and report back if I get what I need.
Ed

From: Knut Staring [mailto:knu...@gmail.com<mailto:knu...@gmail.com>]
Sent: Wednesday, 19 July 2017 5:16 PM
To: Edward Robinson 
<erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>>
Cc: dhis2-users 
<dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net>>
Subject: Re: [Dhis2-users] Quick way to edit users per role?

Probably not exactly what you are looking for, but I think you could script 
around this endpoint:

https://docs.dhis2.org/master/en/developer/html/webapi_users.html#webapi_users_credentials_query

Knut

On Wed, Jul 19, 2017 at 7:42 PM, Edward Robinson 
<erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>> wrote:
Is there a quick way to see all users assigned to a role and add / remove, or 
do I have to go through each user in the system to confirm their roles?
Ta!
Ed


___
Mailing list: https://launchpad.net/~dhis2-users
Post to : 
dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp



--
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522<tel:+47%20918%2080%20522>
Skype: knutstar
http://dhis2.org



--
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522<tel:+47%20918%2080%20522>
Skype: knutstar
http://dhis2.org
___
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

Re: [Dhis2-users] Linode.com - anyone using them for hosting?

[Edward Robinson]

Excellent, thank you Peter and J. Paul, appreciate the feedback.
Ed

From: Peter D Lubambi [mailto:pluba...@gmail.com]
Sent: Wednesday, 19 July 2017 10:36 AM
To: Edward Robinson <erobin...@projectbalance.com>
Cc: dhis2-users <dhis2-users@lists.launchpad.net>
Subject: Re: [Dhis2-users] Linode.com - anyone using them for hosting?

Hi Edward,
I have been using  Linode hosting various systems including DHI2 for more than 
2 years now, my experience has been great.
I like their payment flexibility and up-time is 99% for this time.
Regards,

Peter Dotto Lubambi,
Skype: plubambi
Mobile: +255 786 087 087

On Wed, Jul 19, 2017 at 5:23 PM, Edward Robinson 
<erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>> wrote:
I’m considering linode.com<http://linode.com> for a DHIS2 server deployment.  
Has anyone used them and what has your experience been?  The pricing is 
compelling.  My experience has mostly been with Amazon AWS, Rackspace, IBM 
Softlayer and MS Azure.  I have also used BAOSystems for DHIS2 specific hosting 
on certain projects.

The Linode 32Gb RAM / 60Gb RAM servers looks like a great option for my needs – 
the 24Gb, 8 Core, 384Gb storage looks even better.  Thoughts?

Ed

___
Mailing list: https://launchpad.net/~dhis2-users
Post to : 
dhis2-users@lists.launchpad.net<mailto: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

[Dhis2-users] Linode.com - anyone using them for hosting?

[Edward Robinson]

I'm considering linode.com for a DHIS2 server deployment.  Has anyone used them 
and what has your experience been?  The pricing is compelling.  My experience 
has mostly been with Amazon AWS, Rackspace, IBM Softlayer and MS Azure.  I have 
also used BAOSystems for DHIS2 specific hosting on certain projects.

The Linode 32Gb RAM / 60Gb RAM servers looks like a great option for my needs - 
the 24Gb, 8 Core, 384Gb storage looks even better.  Thoughts?

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

Re: [Dhis2-users] Major speed issue with pg_restore

[Edward Robinson]

Agree, the system has two independent disks, I hadn’t set up any mirroring or 
striping – I had basically just setup the OS in both cases and performed OS 
updates.  Pretty much a vanilla config on both.  My experience is that if the 
SATA channel drivers aren’t properly loaded, the disks will work in legacy mode 
which slows things down considerably since no interrupts are used.  In the old 
days with the IDE channel, it was interrupt 14 and 15 for channel 1 and 2 but 
that’s no longer the case with SATA.  To be honest I haven’t come across this 
before in Linux since most good distros have all the software required to run 
all but the newest hardware and given that these machines are a few years old, 
I would assume they are supported (but I imagine this may be something worth 
troubleshooting).  Ultimately I do think online hosting for this project will 
probably be the best given the difficulty supporting any hardware in this 
location so we are exploring those options.

Some things I hadn’t tried yet:
https://serverfault.com/questions/790723/postgres-9-5-restoring-dumps-is-very-very-slow
“




It does not seem to be a PG problem. More likely it's a language or locale 
problem with PG on Ubuntu 16.04, because installing huge indexed tables with 
foreign languages and therefore with many utf-8 chars cause the problem. Do we 
miss a language package? On another server with Ubuntu 14.04 everything works 
fine.

“

It’s not this, since I had dumped using the default copy method:
http://manpages.ubuntu.com/manpages/xenial/man1/pg_dump.1.html

“--column-inserts
   --attribute-inserts
   Dump data as INSERT commands with explicit column names (INSERT
   INTO table (column, ...) VALUES ...). This will make restoration
   very slow; it is mainly useful for making dumps that can be loaded
   into non-PostgreSQL databases. However, since this option generates
   a separate command for each row, an error in reloading a row causes
   only that row to be lost rather than the entire table contents.

--inserts

   Dump data as INSERT commands (rather than COPY). This will make

   restoration very slow; it is mainly useful for making dumps that

   can be loaded into non-PostgreSQL databases. However, since this

   option generates a separate command for each row, an error in

   reloading a row causes only that row to be lost rather than the

   entire table contents. Note that the restore might fail altogether

   if you have rearranged column order. The --column-inserts option is

   safe against column order changes, though even slower.
“

___
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

Re: [Dhis2-users] DHIS2 Windows server

[Edward Robinson]

Thanks for the quick follow up Arvind, appreciate it!

From: arvind chikne [mailto:arvind.chi...@gmail.com]
Sent: Wednesday, 19 July 2017 1:02 AM
To: Edward Robinson <erobin...@projectbalance.com>
Cc: dhis2-users <dhis2-users@lists.launchpad.net>
Subject: Re: [Dhis2-users] DHIS2 Windows server

Hi Edward,

As per my experience with windows server, you should split your ram as follow

1) O/S = 2 GB
2) Postgres 9.5 = 8 GB
3) JAVA_OPTS = 4 GB (min 1024M - max 4096M)
4) Keep remain 2 GB for windows buffer


As far as concern about the environment variables you must assign the following 
variables in windows

1) JAVA_HOME=
2) CATALINA_HOME =
3) JAVA_OPTS =
4) DHIS2_HOME=
4) Postgres bin directory location in PATH Variable with separation of ";"

These all above variables will show in about DHIS2 page, if its configured 
correctly.


On Wed, Jul 19, 2017 at 12:58 AM, Edward Robinson 
<erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>> wrote:
I have a server with 16Gb RAM running Windows Server 2012 R2 and (currently) 
DHIS 2.16.  Given that it is mostly dedicated to DHIS2, what would you suggest 
is the best way to split the RAM between Java/Tomcat and Postgres for optimal 
DHIS2 performance?

Also, should I see anything under the ‘about DHIS2 page’ on a Windows server?  
Mine currently displays:

Current user:
admin
Version:
2.16
Build revision:
Build date:
2015-02-12 02:06
User agent:
Mozilla/5.0 (Windows NT 10.0; WOW64; rv:54.0) Gecko/20100101 Firefox/54.0
Server date:
2017-07-16 20:41
Environment variable:
DHIS2_HOME
External configuration directory:
Database type:
Database name:
Database user:
Java Opts:
Java temporary directory:
Java version:
Java vendor:
OS name:
OS architecture:
OS version:
Server memory:
CPU cores:

___
Mailing list: https://launchpad.net/~dhis2-users
Post to : 
dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp



--
Thanks & Regards
Arvind rao chikne
9818979986
Think Green!!! Please consider your environmental responsibility before 
printing this e-mail

___
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

[Dhis2-users] DHIS2 Windows server

[Edward Robinson]

I have a server with 16Gb RAM running Windows Server 2012 R2 and (currently) 
DHIS 2.16.  Given that it is mostly dedicated to DHIS2, what would you suggest 
is the best way to split the RAM between Java/Tomcat and Postgres for optimal 
DHIS2 performance?

Also, should I see anything under the 'about DHIS2 page' on a Windows server?  
Mine currently displays:

Current user:
admin
Version:
2.16
Build revision:
Build date:
2015-02-12 02:06
User agent:
Mozilla/5.0 (Windows NT 10.0; WOW64; rv:54.0) Gecko/20100101 Firefox/54.0
Server date:
2017-07-16 20:41
Environment variable:
DHIS2_HOME
External configuration directory:
Database type:
Database name:
Database user:
Java Opts:
Java temporary directory:
Java version:
Java vendor:
OS name:
OS architecture:
OS version:
Server memory:
CPU cores:
___
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

Re: [Dhis2-users] Major speed issue with pg_restore

[Edward Robinson]

Maybe, but 2 days vs 50 minutes is a pretty big difference…

From: Bob Jolliffe [mailto:bobjolli...@gmail.com]
Sent: Monday, 17 July 2017 2:33 PM
To: Edward Robinson <erobin...@projectbalance.com>
Cc: Lars Helge Øverland <l...@dhis2.org>; dhis2-users 
<dhis2-users@lists.launchpad.net>
Subject: Re: [Dhis2-users] Major speed issue with pg_restore

It is unlikely (though not impossible) that the problem is ubuntu specific.  It 
could be your windows for example, is making better use of the disk.

I think I see you had 2 sata disks which would probably work best in a raid 0 
setup.  Perhaps windows has arranged them thus.  Maybe also some other tweaks 
to get the best out of the filesystem.  Good luck.

On 17 July 2017 at 17:19, Edward Robinson 
<erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>> wrote:
That is useful info for the forum for sure and I fully agree, thanks Lars!
Ultimately the server supports Linux – it’s just certified for different 
sistros.  Also, I noticed a number of Ubuntu 16.04 users complaining of the 
same speed issue, so while Ubuntu will probably remain my go-to distro, in the 
case of these servers, I’m probably better off getting Suse or one of the other 
supported distros on before I take any more troubleshooting steps.  For now 
it’s running fine and the future direction may be different – including cloud 
hosting to avoid this kind of hassle.
Thanks everyone for the support,
Cheers
Ed


From: Lars Helge Øverland [mailto:l...@dhis2.org<mailto:l...@dhis2.org>]
Sent: Monday, 17 July 2017 8:41 AM
To: Edward Robinson 
<erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>>
Cc: Bob Jolliffe <bobjolli...@gmail.com<mailto:bobjolli...@gmail.com>>; 
dhis2-users 
<dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net>>
Subject: Re: [Dhis2-users] Major speed issue with pg_restore

Hi Edward,

this is besides the main point but make sure you create pg dumps without the 
analytics tables, and instead let DHIS 2 re-generate the analytics tables 
(which is faster as indexing is run in parallel).

pg_dump -T analytics*

regards,

Lars

On Sun, Jul 16, 2017 at 10:43 PM, Edward Robinson 
<erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>> wrote:
Hi Bob, apologies, it’s running on this hardware:
http://www.dell.com/support/home/ht/en/htbsdt1/product-support/servicetag/d2fvfx1/configuration
A bit dated, but definitely not a hardware error given the speedy / successful 
restore on Windows.
Regards
Ed

From: Bob Jolliffe [mailto:bobjolli...@gmail.com<mailto:bobjolli...@gmail.com>]
Sent: Saturday, 15 July 2017 3:02 PM
To: Edward Robinson 
<erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>>
Cc: Knut Staring <knu...@gmail.com<mailto:knu...@gmail.com>>; dhis2-users 
<dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net>>; 
Hannan Khan <hann...@gmail.com<mailto:hann...@gmail.com>>
Subject: RE: [Dhis2-users] Major speed issue with pg_restore

Ed you never answered my earlier question about the hardware you were running 
on?

On 15 Jul 2017 6:40 p.m., "Edward Robinson" 
<erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>> wrote:
Sorry for this slow response, time has not been on my side 
Also, thanks Bob, Knut and Hannan for your responses.

So to fill everyone in, I went through postgres.conf with a fine toothed comb.  
@ Bob, Shared buffers were set to 3200 though I'd set them to 1600 for the 
restore as per this article's suggestions:
http://www.databasesoup.com/2014/09/settings-for-fast-pgrestore.html
Overall I'm convinced the PGSQL environment had nothing to do with the issue... 
what I had suspect is that the combination of Ubuntu 16.04 and our hardware was 
not a good match.  I suspect the SATA channel in particular was the bottleneck.
To prove a point (I have two identical machines), I loaded Win Server 2012 R2 
and and installed PGSQL 9.5.5 on the box and, without so much as tweaking a 
single file, I restored the dump within 50 minutes.  We're likely upgrading the 
platform soon so I'm not going to break my back troubleshooting what is likely 
an issue that won't be there in 6 months time.  Dell didn't include Debian or 
Ubuntu on their list of supported OS for the hardware combination, though I 
have no reason to believe it couldn't work with a little effort and a bit of 
old school compiling, I just don't have the luxury of time to fiddle.  It 
worked well with 12.04 out of the box.
I just thought I'd post this in case anyone else was having similar trouble - 
if you've double checked the configs, it's quite possibly a lower level issue.
Cheers!
Ed

___
Mailing list: https://launchpad.net/~dhis2-users
Post to : 
dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.

Re: [Dhis2-users] Major speed issue with pg_restore

[Edward Robinson]

That is useful info for the forum for sure and I fully agree, thanks Lars!
Ultimately the server supports Linux – it’s just certified for different 
sistros.  Also, I noticed a number of Ubuntu 16.04 users complaining of the 
same speed issue, so while Ubuntu will probably remain my go-to distro, in the 
case of these servers, I’m probably better off getting Suse or one of the other 
supported distros on before I take any more troubleshooting steps.  For now 
it’s running fine and the future direction may be different – including cloud 
hosting to avoid this kind of hassle.
Thanks everyone for the support,
Cheers
Ed


From: Lars Helge Øverland [mailto:l...@dhis2.org]
Sent: Monday, 17 July 2017 8:41 AM
To: Edward Robinson <erobin...@projectbalance.com>
Cc: Bob Jolliffe <bobjolli...@gmail.com>; dhis2-users 
<dhis2-users@lists.launchpad.net>
Subject: Re: [Dhis2-users] Major speed issue with pg_restore

Hi Edward,

this is besides the main point but make sure you create pg dumps without the 
analytics tables, and instead let DHIS 2 re-generate the analytics tables 
(which is faster as indexing is run in parallel).

pg_dump -T analytics*

regards,

Lars

On Sun, Jul 16, 2017 at 10:43 PM, Edward Robinson 
<erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>> wrote:
Hi Bob, apologies, it’s running on this hardware:
http://www.dell.com/support/home/ht/en/htbsdt1/product-support/servicetag/d2fvfx1/configuration
A bit dated, but definitely not a hardware error given the speedy / successful 
restore on Windows.
Regards
Ed

From: Bob Jolliffe [mailto:bobjolli...@gmail.com<mailto:bobjolli...@gmail.com>]
Sent: Saturday, 15 July 2017 3:02 PM
To: Edward Robinson 
<erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>>
Cc: Knut Staring <knu...@gmail.com<mailto:knu...@gmail.com>>; dhis2-users 
<dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net>>; 
Hannan Khan <hann...@gmail.com<mailto:hann...@gmail.com>>
Subject: RE: [Dhis2-users] Major speed issue with pg_restore

Ed you never answered my earlier question about the hardware you were running 
on?

On 15 Jul 2017 6:40 p.m., "Edward Robinson" 
<erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>> wrote:
Sorry for this slow response, time has not been on my side 
Also, thanks Bob, Knut and Hannan for your responses.

So to fill everyone in, I went through postgres.conf with a fine toothed comb.  
@ Bob, Shared buffers were set to 3200 though I'd set them to 1600 for the 
restore as per this article's suggestions:
http://www.databasesoup.com/2014/09/settings-for-fast-pgrestore.html
Overall I'm convinced the PGSQL environment had nothing to do with the issue... 
what I had suspect is that the combination of Ubuntu 16.04 and our hardware was 
not a good match.  I suspect the SATA channel in particular was the bottleneck.
To prove a point (I have two identical machines), I loaded Win Server 2012 R2 
and and installed PGSQL 9.5.5 on the box and, without so much as tweaking a 
single file, I restored the dump within 50 minutes.  We're likely upgrading the 
platform soon so I'm not going to break my back troubleshooting what is likely 
an issue that won't be there in 6 months time.  Dell didn't include Debian or 
Ubuntu on their list of supported OS for the hardware combination, though I 
have no reason to believe it couldn't work with a little effort and a bit of 
old school compiling, I just don't have the luxury of time to fiddle.  It 
worked well with 12.04 out of the box.
I just thought I'd post this in case anyone else was having similar trouble - 
if you've double checked the configs, it's quite possibly a lower level issue.
Cheers!
Ed

___
Mailing list: https://launchpad.net/~dhis2-users
Post to : 
dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp



--
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
l...@dhis2.org<mailto:l...@dhis2.org>
http://www.dhis2.org<https://www.dhis2.org/>

___
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

Re: [Dhis2-users] Database version - how to tell

[Edward Robinson]

An update on this, it turns out the encryption.password setting in the 
hibernate.properties file was overwritten with an incorrect value.  Fortunately 
someone on the team recalled what it was previously as the file had not been 
backed up along with the database.  That accounts for the 
org.jasypt.exceptions. EncryptionOperationNotPossibleException error.  I am now 
able to get the system up and access the UI.  Lesson, always backup 
hibernate.properties along with the database!
I am still getting some errors and warnings, they may be benign, but if anyone 
has insight into them, I would appreciate it greatly, particularly the errors:

* WARN  2017-07-16 19:05:27,445 [127.0.0.1]:5701 [dev] [3.2.1] No join method 
is enabled! Starting standalone. (HazelcastInstanceImpl.java 
[localhost-startStop-1])
* ERROR 2017-07-16 19:05:45,648 HHH000388: Unsuccessful: alter table 
programstage add constraint fk_programstage_dataentryform foreign key 
(dataentryformid) references dataentryform (SchemaUpdate.java 
[localhost-startStop-1])
* ERROR 2017-07-16 19:05:45,649 ERROR: constraint 
"fk_programstage_dataentryform" for relation "programstage" already exists 
(SchemaUpdate.java [localhost-startStop-1])
* WARN  2017-07-16 19:06:37,114 RP discovery / realm validation disabled;  
(RealmVerifier.java [localhost-startStop-1])
* WARN  2017-07-16 19:07:16,113 Did not find any ViewResolvers to delegate to; 
please configure them using the 'viewResolvers' property on the 
ContentNegotiatingViewResolver (ContentNegotiatingViewResolver.java 
[localhost-startStop-1])
* WARN  2017-07-16 19:07:26,335 Did not find any ViewResolvers to delegate to; 
please configure them using the 'viewResolvers' property on the 
ContentNegotiatingViewResolver (ContentNegotiatingViewResolver.java 
[localhost-startStop-1])
* WARN  2017-07-16 19:07:29,027 Ignoring action package with no actions: 
struts-default (DefaultModuleManager.java [http-bio-8080-exec-7])
* WARN  2017-07-16 19:07:29,028 Ignoring action package with no actions: 
spring-default (DefaultModuleManager.java [http-bio-8080-exec-7])
* WARN  2017-07-16 19:07:29,028 Ignoring action package with no actions: 
dhis-web-commons (DefaultModuleManager.java [http-bio-8080-exec-7])
* WARN  2017-07-16 19:07:29,030 Ignoring action package with no actions: 
dhis-web-ohie (DefaultModuleManager.java [http-bio-8080-exec-7])
* WARN  2017-07-16 19:07:29,030 Ignoring action package with no actions: 
dhis-web-portal (DefaultModuleManager.java [http-bio-8080-exec-7])

Cheers,
Ed
___
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

[Dhis2-users] Database version - how to tell

[Edward Robinson]

Hi all, is there a way to tell what version the database is?  I'm attempting to 
get an instance going that was running previously.  I was told it was 2.16.  
Tomcat is having trouble firing up using the 2.16 .war and I notice an error in 
the stdout log that seems to indicate the app wants to make changes to the DB 
structure which makes me suspect the DB is possibly not 2.16:

* ERROR 2017-07-16 16:55:02,744 HHH000388: Unsuccessful: alter table 
programstage add constraint fk_programstage_dataentryform foreign key 
(dataentryformid) references dataentryform (SchemaUpdate.java 
[localhost-startStop-1])
* ERROR 2017-07-16 16:55:02,746 ERROR: constraint 
"fk_programstage_dataentryform" for relation "programstage" already exists 
(SchemaUpdate.java [localhost-startStop-1])

I'm also getting these in the log:
* ERROR 2017-07-16 16:56:18,693 
org.jasypt.exceptions.EncryptionOperationNotPossibleException
   at 
org.jasypt.encryption.pbe.StandardPBEByteEncryptor.decrypt(StandardPBEByteEncryptor.java:1055)
   at 
org.jasypt.encryption.pbe.StandardPBEStringEncryptor.decrypt(StandardPBEStringEncryptor.java:725)
   at 
org.jasypt.encryption.pbe.PooledPBEStringEncryptor.decrypt(PooledPBEStringEncryptor.java:498)
   at 
org.jasypt.hibernate4.type.AbstractEncryptedAsStringType.nullSafeGet(AbstractEncryptedAsStringType.java:143)
   at org.hibernate.type.CustomType.nullSafeGet(CustomType.java:127)
   at org.hibernate.type.AbstractType.hydrate(AbstractType.java:106)
   at 
org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2903)
   at 
org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1668)
   at 
org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1600)
   at org.hibernate.loader.Loader.getRow(Loader.java:1500)
   at 
org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:712)
   at org.hibernate.loader.Loader.processResultSet(Loader.java:940)
   at org.hibernate.loader.Loader.doQuery(Loader.java:910)
   at 
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:341)
   at org.hibernate.loader.Loader.doList(Loader.java:2516)
   at 
org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2361)
   at org.hibernate.loader.Loader.list(Loader.java:2324)
   at 
org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:490)
   at 
org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:355)
   at 
org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:195)
   at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1268)
   at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101)
   at 
org.hisp.dhis.hibernate.HibernateGenericStore.getAll(HibernateGenericStore.java:345)
   at 
org.hisp.dhis.configuration.DefaultConfigurationService.getConfiguration(DefaultConfigurationService.java:70)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown 
Source)
   at java.lang.reflect.Method.invoke(Unknown Source)
   at 
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
   at 
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
   at 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
   at 
org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
   at 
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
   at 
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
   at 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   at 
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
   at com.sun.proxy.$Proxy30.getConfiguration(Unknown Source)
   at 
org.hisp.dhis.startup.ConfigurationPopulator.execute(ConfigurationPopulator.java:48)
   at 
org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:115)
   at 
org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:85)
   at 

Re: [Dhis2-users] Major speed issue with pg_restore

[Edward Robinson]

Hi Bob, apologies, it’s running on this hardware:
http://www.dell.com/support/home/ht/en/htbsdt1/product-support/servicetag/d2fvfx1/configuration
A bit dated, but definitely not a hardware error given the speedy / successful 
restore on Windows.
Regards
Ed

From: Bob Jolliffe [mailto:bobjolli...@gmail.com]
Sent: Saturday, 15 July 2017 3:02 PM
To: Edward Robinson <erobin...@projectbalance.com>
Cc: Knut Staring <knu...@gmail.com>; dhis2-users 
<dhis2-users@lists.launchpad.net>; Hannan Khan <hann...@gmail.com>
Subject: RE: [Dhis2-users] Major speed issue with pg_restore

Ed you never answered my earlier question about the hardware you were running 
on?

On 15 Jul 2017 6:40 p.m., "Edward Robinson" 
<erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>> wrote:
Sorry for this slow response, time has not been on my side 
Also, thanks Bob, Knut and Hannan for your responses.

So to fill everyone in, I went through postgres.conf with a fine toothed comb.  
@ Bob, Shared buffers were set to 3200 though I'd set them to 1600 for the 
restore as per this article's suggestions:
http://www.databasesoup.com/2014/09/settings-for-fast-pgrestore.html
Overall I'm convinced the PGSQL environment had nothing to do with the issue... 
what I had suspect is that the combination of Ubuntu 16.04 and our hardware was 
not a good match.  I suspect the SATA channel in particular was the bottleneck.
To prove a point (I have two identical machines), I loaded Win Server 2012 R2 
and and installed PGSQL 9.5.5 on the box and, without so much as tweaking a 
single file, I restored the dump within 50 minutes.  We're likely upgrading the 
platform soon so I'm not going to break my back troubleshooting what is likely 
an issue that won't be there in 6 months time.  Dell didn't include Debian or 
Ubuntu on their list of supported OS for the hardware combination, though I 
have no reason to believe it couldn't work with a little effort and a bit of 
old school compiling, I just don't have the luxury of time to fiddle.  It 
worked well with 12.04 out of the box.
I just thought I'd post this in case anyone else was having similar trouble - 
if you've double checked the configs, it's quite possibly a lower level issue.
Cheers!
Ed
___
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

Re: [Dhis2-users] Upgrading from 2.16

[Edward Robinson]

Some excellent tips, thank you Elmarie.
Regards
Ed

From: Elmarie Claasen [mailto:elma...@hisp.org]
Sent: Sunday, 16 July 2017 3:00 PM
To: Edward Robinson <erobin...@projectbalance.com>
Cc: DHIS 2 Users list <dhis2-users@lists.launchpad.net>
Subject: Re: [Dhis2-users] Upgrading from 2.16

Hi Edward,

Wow this is quite far back. We upgrading some instances from 2.20 now and 
everything is going fine, provided that you drop SQL views before the upgrade. 
SQL views often hold table updates effected through war upgrades. From 2.23 to 
2.23 you need to read about changes required to sms config if used.

Read the upgrade documentation for each version, some has scripts which you 
must run, others execute an upgrade routine with first startup of the war file.

We have find issues when not upgrading incrementally and also starting up the 
server after each upgrade, so this is recommended. You may find it difficult to 
find the link to older war files but check the URL for download of newer 
versions and just change the version number in the war accordingly.

I would take care if any of the implementations are tracker because tracker got 
a major overhaul since then including changes in tables. You will find apps 
like individual records etc chenging to tracker and event capture.

Through learning some hard lessons we usually upgrade on a test instance first 
and test all existing functionality properly. Also had some issues with table 
or column updates so we download a Sierra Leone database of the same version 
and compare the tables and columns in that instance vs ours with a SQL view.

Good luck

Elmarie

On 16 Jul 2017 20:10, "Edward Robinson" 
<erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>> wrote:
I have a couple of 2.16 installations that should probably be brought up to 
date.
What are the major caveats I should be looking out for and what is the latest 
stable DHIS2 version that I should be aiming for?  It’s critical that service 
be maintained for the client, I will run the upgrades on another box and 
validate them before updating live but I wondered if anyone had anything 
specific that comes to mind that I should look out for or be aware prior to 
upgrading.  Do I need to upgrade incrementally?

Thanks in advance!

___
Mailing list: https://launchpad.net/~dhis2-users
Post to : 
dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp


This message and any attachments are subject to a disclaimer published at 
http://www.hisp.org/policies.html#comms_disclaimer.  Please read the disclaimer 
before opening any attachment or taking any other action in terms of this 
electronic transmission.  If you cannot access the disclaimer, kindly send an 
email to disclai...@hisp.org<mailto:disclai...@hisp.org> and a copy will be 
provided to you. By replying to this e-mail or opening any attachment you agree 
to be bound by the provisions of the disclaimer.
___
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

[Dhis2-users] Upgrading from 2.16

[Edward Robinson]

I have a couple of 2.16 installations that should probably be brought up to 
date.
What are the major caveats I should be looking out for and what is the latest 
stable DHIS2 version that I should be aiming for?  It's critical that service 
be maintained for the client, I will run the upgrades on another box and 
validate them before updating live but I wondered if anyone had anything 
specific that comes to mind that I should look out for or be aware prior to 
upgrading.  Do I need to upgrade incrementally?

Thanks in advance!
___
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

Re: [Dhis2-users] Major speed issue with pg_restore

[Edward Robinson]

Sorry for this slow response, time has not been on my side 
Also, thanks Bob, Knut and Hannan for your responses.

So to fill everyone in, I went through postgres.conf with a fine toothed comb.  
@ Bob, Shared buffers were set to 3200 though I'd set them to 1600 for the 
restore as per this article's suggestions:
http://www.databasesoup.com/2014/09/settings-for-fast-pgrestore.html
Overall I'm convinced the PGSQL environment had nothing to do with the issue... 
what I had suspect is that the combination of Ubuntu 16.04 and our hardware was 
not a good match.  I suspect the SATA channel in particular was the bottleneck. 
 
To prove a point (I have two identical machines), I loaded Win Server 2012 R2 
and and installed PGSQL 9.5.5 on the box and, without so much as tweaking a 
single file, I restored the dump within 50 minutes.  We're likely upgrading the 
platform soon so I'm not going to break my back troubleshooting what is likely 
an issue that won't be there in 6 months time.  Dell didn't include Debian or 
Ubuntu on their list of supported OS for the hardware combination, though I 
have no reason to believe it couldn't work with a little effort and a bit of 
old school compiling, I just don't have the luxury of time to fiddle.  It 
worked well with 12.04 out of the box.
I just thought I'd post this in case anyone else was having similar trouble - 
if you've double checked the configs, it's quite possibly a lower level issue.
Cheers!
Ed

___
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

Re: [Dhis2-users] Major speed issue with pg_restore

[Edward Robinson]

Apologies, I meant 650Mb on the compressed.
I'll revert with more details shortly, it looks like a huge factor may be 
autovacuum being on (and possibly logging).  I'm tweaking a little more then 
going to restart it.
Some sort of progress indicator would be nice for restoring large dumps like 
these.
I'll post my postgresql.conf and other details shortly.  Thanks!

-Original Message-
From: Bob Jolliffe [mailto:bobjolli...@gmail.com] 
Sent: Friday, 14 July 2017 8:07 AM
To: Edward Robinson <erobin...@projectbalance.com>
Cc: dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Major speed issue with pg_restore

I am also trying to understand how a plain sql dump is only 7G while the custom 
compressed format is 650G.  But given that is true, why aren't you using the 
plain text dump?

On 14 July 2017 at 13:02, Bob Jolliffe <bobjolli...@gmail.com> wrote:
> Hi Edward
>
> Can you tell us a bit more about the machine.  In particular RAM size 
> and disk type/speed and filesystem type.
>
> Given that you are probably not going to be running anything else on 
> this machine while you are restoring I think you might be able to 
> tweak a bit more aggressively just for this operation.
>
> You don't mention shared_buffers above?  That is a dramatic control 
> lever.  Is that just something you left off your mail?
>
> Bob
>
> On 14 July 2017 at 02:54, Edward Robinson <erobin...@projectbalance.com> 
> wrote:
>> I’ve setup a new Ubuntu 16.04 box with PostgreSQL 9.5.5 and I’m 
>> restoring a fairly large DHIS2 backup but having speed issues.  It’s 
>> a full pg_dump in custom format and about 650Gb compressed (a plain 
>> text dump produces a 7Gb file).  I made sure inserts were turned off, 
>> so that’s not the issue, but so far it’s been running for 33 hours – CPU at 
>> 100% - with no end in sight.
>> This is a backup file that took 30 minutes to generate.
>>
>>
>>
>> If it is running synchronously, I calculated that it’s on around 20 
>> million DB rows of around 170 million after 33 hours!  Surely that’s not 
>> normal.
>>
>> I’ve tweaked PostgreSQL with the following settings:
>>
>>
>>
>> maintenance_work_mem=2GB
>>
>> max_wal_size = 1Gb
>>
>> checkpoint_timeout = 3600
>>
>> checkpoint_completion_target = 0.9
>>
>>
>>
>> Anyway, if anyone has insight or has had a similar experience, or 
>> suggestions, please let me know!
>>
>> I’m testing it on another (Windows) instance to see if there’s 
>> something amiss.
>>
>>
>>
>> Cheers,
>>
>> Ed
>>
>>
>> ___
>> 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

Re: [Dhis2-users] Major speed issue with pg_restore

[Edward Robinson]

Agree, I’m sure it’s a PostgreSQL / Ubuntu 16.04 issue.  I’m posting in as many 
locations as possible.  Seems I’m not alone
https://serverfault.com/questions/790723/postgres-9-5-restoring-dumps-is-very-very-slow
https://www.questarter.com/q/restoring-postgres-dump-is-very-very-slow-using-on-ubuntu-16-04-7_171095.html

Ed

From: Knut Staring [mailto:knu...@gmail.com]
Sent: Thursday, 13 July 2017 9:58 PM
To: Edward Robinson <erobin...@projectbalance.com>
Cc: dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Major speed issue with pg_restore

Perhaps useful to also send this question to a postgres forum?

On Jul 13, 2017 9:55 PM, "Edward Robinson" 
<erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>> wrote:
I’ve setup a new Ubuntu 16.04 box with PostgreSQL 9.5.5 and I’m restoring a 
fairly large DHIS2 backup but having speed issues.  It’s a full pg_dump in 
custom format and about 650Gb compressed (a plain text dump produces a 7Gb 
file).  I made sure inserts were turned off, so that’s not the issue, but so 
far it’s been running for 33 hours – CPU at 100% - with no end in sight.  This 
is a backup file that took 30 minutes to generate.

If it is running synchronously, I calculated that it’s on around 20 million DB 
rows of around 170 million after 33 hours!  Surely that’s not normal.
I’ve tweaked PostgreSQL with the following settings:

maintenance_work_mem=2GB
max_wal_size = 1Gb
checkpoint_timeout = 3600
checkpoint_completion_target = 0.9

Anyway, if anyone has insight or has had a similar experience, or suggestions, 
please let me know!
I’m testing it on another (Windows) instance to see if there’s something amiss.

Cheers,
Ed

___
Mailing list: https://launchpad.net/~dhis2-users
Post to : 
dhis2-users@lists.launchpad.net<mailto: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

[Dhis2-users] Major speed issue with pg_restore

[Edward Robinson]

I've setup a new Ubuntu 16.04 box with PostgreSQL 9.5.5 and I'm restoring a 
fairly large DHIS2 backup but having speed issues.  It's a full pg_dump in 
custom format and about 650Gb compressed (a plain text dump produces a 7Gb 
file).  I made sure inserts were turned off, so that's not the issue, but so 
far it's been running for 33 hours - CPU at 100% - with no end in sight.  This 
is a backup file that took 30 minutes to generate.

If it is running synchronously, I calculated that it's on around 20 million DB 
rows of around 170 million after 33 hours!  Surely that's not normal.
I've tweaked PostgreSQL with the following settings:

maintenance_work_mem=2GB
max_wal_size = 1Gb
checkpoint_timeout = 3600
checkpoint_completion_target = 0.9

Anyway, if anyone has insight or has had a similar experience, or suggestions, 
please let me know!
I'm testing it on another (Windows) instance to see if there's something amiss.

Cheers,
Ed
___
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