Re: [Dhis2-devs] [Dhis2-users] Lock Data set in advance

[Nayeem Al Mifthah]

Dear Jim
Thank you very much.

It will be very helpful.

On 27 Jan 2017 05:22, "Jim Grace"  wrote:

> Hi Nayeem,
>
> Thank you for asking again.
>
> This is now implemented in the latest builds of versions 2.24 and
> following. Negative expiry days are accepted, and the data set is locked
> before the end of the period. With a large enough negative expiry day
> count, the data set can be locked as far ahead as you like, even before the
> start of the period. As you said, this can be useful for entering future
> data such as for planning, forecasting, or targets.
>
> Cheers,
> Jim
>
>
> On Mon, Jan 23, 2017 at 1:20 AM, Nayeem Al Mifthah 
> wrote:
>
>> Hi Jim
>> Is there any plan to allow dataset lock in advance according to my
>> previous mail and discussion.
>>
>> *Nayeem Al Mifthah*
>> *Consultant for HSS, Health MIS, M*
>> Email: n.mift...@gmail.com
>> Cell:+8801914030574 <+880%201914-030574>
>> Skype: nayeem.a.m
>>
>> On Mon, Dec 5, 2016 at 2:53 PM, Nayeem Al Mifthah 
>> wrote:
>>
>>> Dear Developers
>>> Is there any plan to incorporate data lock in advance as we are using
>>> data set for planning and need to lock before implementation start.
>>>
>>> *Nayeem Al Mifthah*
>>> *Consultant for HSS, Health MIS, M*
>>> Email: n.mift...@gmail.com
>>> Cell:+8801914030574 <01914-030574>
>>> Skype: nayeem.a.m
>>>
>>> On Wed, Sep 28, 2016 at 5:24 PM, Jim Grace  wrote:
>>>
 Agreed, it would be good if negative values were accepted and
 processed. This could be useful for one of our other implementations as
 well, that I'm working on.

 Meanwhile, another possibility is to use data approvals to lock out
 data entry for the future period. It would involve taking action every time
 you want the future data locked, but it would do that. See
 http://dhis2.github.io/dhis2-docs/master/en/user/html/da
 ta_approvals.html.


 On Wed, Sep 28, 2016 at 2:12 AM, Nayeem Al Mifthah  wrote:

> Dear All
> We are using DHIS2 for planning purposes. For this organizations are
> input plan in advance. We want to lock the dataset in advance.
>
>
> Like now we want to lock the next quarter planning data entry before
> 15 days from starting of next quarter. But data lock is not taking 
> negative
> (-) value in dataset design.
>
>
> *Nayeem Al Mifthah*
> *Consultant for HSS, Health MIS, M*
> Email: n.mift...@gmail.com
> Cell:+8801914030574
> Skype: nayeem.a.m
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@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 

>>>
>>>
>>
>
>
> --
> Jim Grace
> Core developer, DHIS 2
> HISP US Inc.
> http://www.dhis2.org 
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] Lock Data set in advance

[Jim Grace]

Hi Nayeem,

Thank you for asking again.

This is now implemented in the latest builds of versions 2.24 and
following. Negative expiry days are accepted, and the data set is locked
before the end of the period. With a large enough negative expiry day
count, the data set can be locked as far ahead as you like, even before the
start of the period. As you said, this can be useful for entering future
data such as for planning, forecasting, or targets.

Cheers,
Jim


On Mon, Jan 23, 2017 at 1:20 AM, Nayeem Al Mifthah 
wrote:

> Hi Jim
> Is there any plan to allow dataset lock in advance according to my
> previous mail and discussion.
>
> *Nayeem Al Mifthah*
> *Consultant for HSS, Health MIS, M*
> Email: n.mift...@gmail.com
> Cell:+8801914030574 <+880%201914-030574>
> Skype: nayeem.a.m
>
> On Mon, Dec 5, 2016 at 2:53 PM, Nayeem Al Mifthah 
> wrote:
>
>> Dear Developers
>> Is there any plan to incorporate data lock in advance as we are using
>> data set for planning and need to lock before implementation start.
>>
>> *Nayeem Al Mifthah*
>> *Consultant for HSS, Health MIS, M*
>> Email: n.mift...@gmail.com
>> Cell:+8801914030574 <01914-030574>
>> Skype: nayeem.a.m
>>
>> On Wed, Sep 28, 2016 at 5:24 PM, Jim Grace  wrote:
>>
>>> Agreed, it would be good if negative values were accepted and processed.
>>> This could be useful for one of our other implementations as well, that I'm
>>> working on.
>>>
>>> Meanwhile, another possibility is to use data approvals to lock out data
>>> entry for the future period. It would involve taking action every time you
>>> want the future data locked, but it would do that. See
>>> http://dhis2.github.io/dhis2-docs/master/en/user/html/da
>>> ta_approvals.html.
>>>
>>>
>>> On Wed, Sep 28, 2016 at 2:12 AM, Nayeem Al Mifthah 
>>> wrote:
>>>
 Dear All
 We are using DHIS2 for planning purposes. For this organizations are
 input plan in advance. We want to lock the dataset in advance.


 Like now we want to lock the next quarter planning data entry before 15
 days from starting of next quarter. But data lock is not taking negative
 (-) value in dataset design.


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

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


-- 
Jim Grace
Core developer, DHIS 2
HISP US Inc.
http://www.dhis2.org 
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] PostgreSQL-9.5 failed to boot-up at restart of Linux server

[gerald thomas]

Thanks to everyone for your support and help during the process though
we are experience what looks to be like bugs but that will be save for
another ticket while we verify and test all the various scenarios
within 2.25.

Once again thanks.

On 1/26/17, Calle Hedberg  wrote:
> Hi
>
> Gerald managed to get it all up and working again this afternoon +
> restoring the dump file (onto 9.5.5). So all good now  :-)
>
> Analytics run time dropped from 56 minutes to 17 minutes, which is
> equivalent to the time it takes on my laptop, so the upgrade was overdue...
>
> Regards
> Calle
>
> On 26 January 2017 at 12:46, Bob Jolliffe  wrote:
>
>> Sounds like now you are really "waist deep in the big muddy".  You have
>> already had to scrap and reinstall your postgres and it looks like your
>> dhis2-tools package is also somehow missing or damaged.
>>
>> You have your backups.  scrap the machine and rebuild.  Follow
>> instruction
>> from https://github.com/dhis2/dhis2-tools.
>>
>> On 26 January 2017 at 10:30, gerald thomas  wrote:
>>
>>> Yes Bob,
>>> But i now i am having a major issue because i can't find the
>>> dhis2-startup, dhis2-stop or dhis2-status but the profile of the
>>> instance is available.
>>>
>>>
>>>
>>> On 1/26/17, Bob Jolliffe  wrote:
>>> > what works?  you removed it and started again?
>>> >
>>> > On 26 January 2017 at 10:14, gerald thomas 
>>> wrote:
>>> >
>>> >> Bob,
>>> >> Thanks it is works
>>> >>
>>> >>
>>> >> On 1/26/17, Bob Jolliffe  wrote:
>>> >> > Gerald it sounds like it has got into a bit of a mess and maybe you
>>> >> > risk
>>> >> > just making it worse.  It is really not supposed to be this hard,
>>> >> > but
>>> >> > tit
>>> >> > is next to impossible at a distance to figure out what might have
>>> gone
>>> >> > wrong.
>>> >> >
>>> >> > Given that you are not dependent on migrating the cluster, but that
>>> you
>>> >> are
>>> >> > simply going to restore your dbs, I would advise that you just try
>>> and
>>> >> get
>>> >> > rid of the current non-working postgres installation completely and
>>> >> install
>>> >> > it again.
>>> >> >
>>> >> > sudo apt-get purge postgresql ... etc  (check under /etc and
>>> >> > /var/lib
>>> >> that
>>> >> > all traces have truly gone)
>>> >> >
>>> >> > On 26 January 2017 at 08:42, gerald thomas 
>>> >> wrote:
>>> >> >
>>> >> >> Mutali,
>>> >> >> I think there was an issue where i have postgresql and
>>> postgresql-9.5
>>> >> >> inside /etc/init.d. But when this command: sudo update-rc.d
>>> >> >> postgresql-9.5 enable
>>> >> >>
>>> >> >> I am getting this message "update-rc.d: warning:
>>> >> >> /etc/init.d/postgresql-9.5 missing LSB information"
>>> >> >> >
>>> >> >>
>>> >> >> On 1/26/17, J. Paul Mutali  wrote:
>>> >> >> > Hi Gerald,
>>> >> >> >
>>> >> >> >  you can use this command: sudo update-rc.d postgresql enable
>>> >> >> >
>>> >> >> > Hope it will work for you.
>>> >> >> >
>>> >> >> > ---
>>> >> >> >
>>> >> >> > JP Mutali
>>> >> >> >
>>> >> >> > Kigali - Rwanda
>>> >> >> >
>>> >> >> > On Thu, Jan 26, 2017 at 8:52 AM, gerald thomas
>>> >> >> > >> >> >
>>> >> >> > wrote:
>>> >> >> >
>>> >> >> >> There were some issues with the migration so I had to purge the
>>> 9.3
>>> >> >> >> and
>>> >> >> >> do
>>> >> >> >> a fresh installation of 9.5 and restore my backup. But if the
>>> >> >> >> server
>>> >> >> >> reboot
>>> >> >> >> I will have to manually do:
>>> >> >> >> pg_ctlcluster 9.5 main start
>>> >> >> >>
>>> >> >> >>
>>> >> >> >>
>>> >> >> >>
>>> >> >> >>
>>> >> >> >> On Jan 26, 2017 5:59 AM, "Uwe Wahser"  wrote:
>>> >> >> >>
>>> >> >> >> Hi Gerald,
>>> >> >> >>
>>> >> >> >> we did the upgrade while upgrading to Ubuntu 16.04 and
>>> >> >> >> everything
>>> >> >> >> starts
>>> >> >> >> normally. But you have to manually migrate your 9.3 databases
>>> into
>>> >> the
>>> >> >> >> 9.5
>>> >> >> >> format - did you do that?
>>> >> >> >>
>>> >> >> >> These were the bash commands I recorded back then (at your own
>>> >> >> >> risk,
>>> >> >> >> no
>>> >> >> >> guarantee - do backups and all that first)
>>> >> >> >>
>>> >> >> >> ~/tomcat-dhis/bin/shutdown.sh
>>> >> >> >> sudo pg_dropcluster 9.5 main --stop
>>> >> >> >> sudo pg_upgradecluster 9.3 main
>>> >> >> >> pg_lsclusters
>>> >> >> >> sudo pg_dropcluster 9.3 main
>>> >> >> >>
>>> >> >> >> Hope that helps,
>>> >> >> >>
>>> >> >> >> Uwe
>>> >> >> >>
>>> >> >> >> ---
>>> >> >> >>
>>> >> >> >> > gerald thomas  hat am 26. Januar 2017
>>> um
>>> >> >> >> > 01:38
>>> >> >> >> geschrieben:
>>> >> >> >> >
>>> >> >> >> >
>>> >> >> >> > Dear All,
>>> >> >> >> > We are upgrading DHIS2 server database (PostgreSQL from
>>> >> >> >> > 9.3.15
>>> to
>>> >> >> >> > 9.5.5) and it had been successfully done but the Postgres
>>> >> >> >> > does
>>> >> >> >> > not
>>> >> >> 

Re: [Dhis2-devs] [Dhis2-users] PostgreSQL-9.5 failed to boot-up at restart of Linux server

[Calle Hedberg]

Hi

Gerald managed to get it all up and working again this afternoon +
restoring the dump file (onto 9.5.5). So all good now  :-)

Analytics run time dropped from 56 minutes to 17 minutes, which is
equivalent to the time it takes on my laptop, so the upgrade was overdue...

Regards
Calle

On 26 January 2017 at 12:46, Bob Jolliffe  wrote:

> Sounds like now you are really "waist deep in the big muddy".  You have
> already had to scrap and reinstall your postgres and it looks like your
> dhis2-tools package is also somehow missing or damaged.
>
> You have your backups.  scrap the machine and rebuild.  Follow instruction
> from https://github.com/dhis2/dhis2-tools.
>
> On 26 January 2017 at 10:30, gerald thomas  wrote:
>
>> Yes Bob,
>> But i now i am having a major issue because i can't find the
>> dhis2-startup, dhis2-stop or dhis2-status but the profile of the
>> instance is available.
>>
>>
>>
>> On 1/26/17, Bob Jolliffe  wrote:
>> > what works?  you removed it and started again?
>> >
>> > On 26 January 2017 at 10:14, gerald thomas 
>> wrote:
>> >
>> >> Bob,
>> >> Thanks it is works
>> >>
>> >>
>> >> On 1/26/17, Bob Jolliffe  wrote:
>> >> > Gerald it sounds like it has got into a bit of a mess and maybe you
>> >> > risk
>> >> > just making it worse.  It is really not supposed to be this hard, but
>> >> > tit
>> >> > is next to impossible at a distance to figure out what might have
>> gone
>> >> > wrong.
>> >> >
>> >> > Given that you are not dependent on migrating the cluster, but that
>> you
>> >> are
>> >> > simply going to restore your dbs, I would advise that you just try
>> and
>> >> get
>> >> > rid of the current non-working postgres installation completely and
>> >> install
>> >> > it again.
>> >> >
>> >> > sudo apt-get purge postgresql ... etc  (check under /etc and /var/lib
>> >> that
>> >> > all traces have truly gone)
>> >> >
>> >> > On 26 January 2017 at 08:42, gerald thomas 
>> >> wrote:
>> >> >
>> >> >> Mutali,
>> >> >> I think there was an issue where i have postgresql and
>> postgresql-9.5
>> >> >> inside /etc/init.d. But when this command: sudo update-rc.d
>> >> >> postgresql-9.5 enable
>> >> >>
>> >> >> I am getting this message "update-rc.d: warning:
>> >> >> /etc/init.d/postgresql-9.5 missing LSB information"
>> >> >> >
>> >> >>
>> >> >> On 1/26/17, J. Paul Mutali  wrote:
>> >> >> > Hi Gerald,
>> >> >> >
>> >> >> >  you can use this command: sudo update-rc.d postgresql enable
>> >> >> >
>> >> >> > Hope it will work for you.
>> >> >> >
>> >> >> > ---
>> >> >> >
>> >> >> > JP Mutali
>> >> >> >
>> >> >> > Kigali - Rwanda
>> >> >> >
>> >> >> > On Thu, Jan 26, 2017 at 8:52 AM, gerald thomas
>> >> >> > > >> >
>> >> >> > wrote:
>> >> >> >
>> >> >> >> There were some issues with the migration so I had to purge the
>> 9.3
>> >> >> >> and
>> >> >> >> do
>> >> >> >> a fresh installation of 9.5 and restore my backup. But if the
>> >> >> >> server
>> >> >> >> reboot
>> >> >> >> I will have to manually do:
>> >> >> >> pg_ctlcluster 9.5 main start
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >> >> On Jan 26, 2017 5:59 AM, "Uwe Wahser"  wrote:
>> >> >> >>
>> >> >> >> Hi Gerald,
>> >> >> >>
>> >> >> >> we did the upgrade while upgrading to Ubuntu 16.04 and everything
>> >> >> >> starts
>> >> >> >> normally. But you have to manually migrate your 9.3 databases
>> into
>> >> the
>> >> >> >> 9.5
>> >> >> >> format - did you do that?
>> >> >> >>
>> >> >> >> These were the bash commands I recorded back then (at your own
>> >> >> >> risk,
>> >> >> >> no
>> >> >> >> guarantee - do backups and all that first)
>> >> >> >>
>> >> >> >> ~/tomcat-dhis/bin/shutdown.sh
>> >> >> >> sudo pg_dropcluster 9.5 main --stop
>> >> >> >> sudo pg_upgradecluster 9.3 main
>> >> >> >> pg_lsclusters
>> >> >> >> sudo pg_dropcluster 9.3 main
>> >> >> >>
>> >> >> >> Hope that helps,
>> >> >> >>
>> >> >> >> Uwe
>> >> >> >>
>> >> >> >> ---
>> >> >> >>
>> >> >> >> > gerald thomas  hat am 26. Januar 2017
>> um
>> >> >> >> > 01:38
>> >> >> >> geschrieben:
>> >> >> >> >
>> >> >> >> >
>> >> >> >> > Dear All,
>> >> >> >> > We are upgrading DHIS2 server database (PostgreSQL from 9.3.15
>> to
>> >> >> >> > 9.5.5) and it had been successfully done but the Postgres does
>> >> >> >> > not
>> >> >> >> > automatically start after boot-up. I am using: (pg_ctlcluster
>> 9.5
>> >> >> >> > main
>> >> >> >> > start) to start my database but i want it start automatically.
>> >> >> >> >
>> >> >> >> > Please can someone help me?
>> >> >> >> >
>> >> >> >> > --
>> >> >> >> > Regards,
>> >> >> >> >
>> >> >> >> > Gerald
>> >> >> >> >
>> >> >> >> > ___
>> >> >> >> > Mailing list: https://launchpad.net/~dhis2-users
>> >> >> >> > Post to : dhis2-us...@lists.launchpad.net
>> >> 

Re: [Dhis2-devs] [Dhis2-users] Organisational Units Names

[Barnabas Akumba]

Hello Lars,

Could you please confirm that the link below will get the latest release:

https://www.dhis2.org/download/releases/2.24/dhis.war

Regards.

On Thu, Jan 26, 2017 at 4:14 PM, Lars Helge Øverland  wrote:

> Hi Barnabas,
>
> yes it should be okay now. Can you download the latest 2.24 and try again?
>
> On Thu, Jan 26, 2017 at 2:12 PM, Barnabas Akumba 
> wrote:
>
>> Hello Lars,
>>
>> Any update on this? Have realised that the issue is with both the GIS and
>> Visualiser App.
>>
>> Regards
>>
>> On Mon, Jan 23, 2017 at 8:14 PM, Lars Helge Øverland 
>> wrote:
>>
>>> I suspect this is a bug related to GIS and the API syntax for renaming
>>> properties. Will get back soon.
>>>
>>> Lars
>>>
>>>
>>> On Mon, Jan 23, 2017 at 9:01 AM, Barnabas Akumba 
>>> wrote:
>>>
 Hello Lars,

 I've cleared the Server cache and browser cache as recommended but no
 luck.

 Regards


 On Mon, Jan 23, 2017 at 8:39 AM, Lars Helge Øverland 
 wrote:

> Hi Barnabas,
>
> you might need to clear the server side nginx cache, then restart
> nginx. Did you install your DHIS 2 instance using the "server tools"? On
> linux you can do this with:
>
>
> sudo rm /var/cache/nginx -rf
> sudo service nginx restart
>
>
>
> Then clear your browser cache again.
>
> regards,
>
> Lars
>
>
>
>
> On Mon, Jan 23, 2017 at 8:33 AM, Morten Olav Hansen 
> wrote:
>
>> Ok, so at least the org units themselves have proper names. Maybe Jan
>> has an idea of why its not working?
>>
>> --
>> Morten Olav Hansen
>> Senior Engineer, DHIS 2
>> University of Oslo
>> http://www.dhis2.org
>>
>> On Mon, Jan 23, 2017 at 2:26 PM, Barnabas Akumba <
>> akumbaba...@gmail.com> wrote:
>>
>>> Hello Morten,
>>>
>>> Please find attached output from the api query.
>>>
>>> Regards
>>>
>>> On Mon, Jan 23, 2017 at 8:20 AM, Morten Olav Hansen <
>>> mor...@dhis2.org> wrote:
>>>
 Hi

 Could you please also try /api/organisationUnits.json and
 see if they have proper names there?

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

 On Mon, Jan 23, 2017 at 2:04 PM, Knut Staring 
 wrote:

> You should probably refresh or do something until you see some red
> error messages... The network tab may also be of interest
>
> On Jan 23, 2017 1:59 PM, "Barnabas Akumba" 
> wrote:
>
>> Hello Knut,
>>
>> Please find attached.
>>
>> Regards
>>
>> On Mon, Jan 23, 2017 at 7:55 AM, Knut Staring 
>> wrote:
>>
>>> You still have not provided us with a screenshot of your chrome
>>> browser console.
>>>
>>> On Mon, Jan 23, 2017 at 1:53 PM, Barnabas Akumba <
>>> akumbaba...@gmail.com> wrote:
>>>
 Hello Prosper,

 The only script specified in the upgrade instruction is "Run
 the database SQL upgrade script
 
  once
 before updating the WAR file. It only applies if you have set up 
 program
 rules for your system.". This is to be done during the upgrade 
 from 2.22 to
 2.23. But as you can see it is optional as we don't have program 
 rules on
 our system.

 Regards

 On Mon, Jan 23, 2017 at 5:36 AM, Prosper BT 
 wrote:

> Hi Barnaba,
>
> Am not a server guy but hope you run the required scripts as
> guided in the upgrade package.
>
> Sometimes I ask the server guys to clear nginx cache
>
> Regards
>
> Prosper Behumbiize, MPH
> DHIS2 Implementation| HISP Uganda
> +256 752 751 776 | +256 776 139 139
> pros...@hispuganda.org  | pros...@dhis2.org
>  | Skype: prospertb
>
> On Sat, Jan 21, 2017 at 2:16 PM, Barnabas Akumba <
> akumbaba...@gmail.com> wrote:
>
>> Here attached output from Log file.
>>
>> Regards
>>
>> On Sat, Jan 21, 2017 at 11:48 AM, Knut Staring <
>> knu...@gmail.com> wrote:
>>
>>> RIght. Any errors in your Chrome browser console? Or in your

Re: [Dhis2-devs] Error in 2.25 displaying graphs and tables when an organisationUnitGroupSet is defined as filter

[Alejandro]

Hi,

We found out that the error was due to some organisationUnitGroups being
part of more than one organisationUnitGroupSet. In those cases, if you list
the organisationUnitGroups with an API call you get multiples instances for
those organisationUnitGroups (one per orgUnitGroupSet they belong to). And
in the end, this is the cause of inconsistencies with standard DHIS2
modules such as the one described above. We solved it by duplicating the
orgUnitGroups so they belong only to one orgUnitGroupSet.

This happened to us before with categoryOptionGroups and
categoryOptionGroupSets and we solved it in the same way. But it took us
some time to match both issues.

Just in case you face the same issue!

One question, is this the expected behaviour?

Cheers!
Alejandro

On Thu, Jan 26, 2017 at 10:01 AM, Alejandro  wrote:

> Hi all!
>
> After upgrading from 2.21 to 2.25 we have found the following error:
>
> [image: Inline image 1]
>
> Code: 500
> Status: Internal Server Error
> Not a valid dimension: BtFXTpKRl6n
>
> This uid, BtFXTpKRl6n, is an organisationUnitGroupSet that, in the Layout
> of a graph/table, is placed in the filter section.
>
> The tricky thing is that the behaviour is not always the same. Sometimes
> we can open those tables and graphs and sometimes not. In particular once
> we get the error, if we perform the Maintenance Task Clear application
> cache, it works again. But suddenly, after some time, we start getting the
> same error again in the same table/graph or in others with the only thing
> in common that they have this organisationUnitGroupSet as a filter.
>
> We are looking into it right now but if any of you have faced a similar
> problem or have an idea on what it could be, thank you for sharing!
>
> Cheers!
> Alejandro
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] Organisational Units Names

[Barnabas Akumba]

Thanks Lars. Will do that after COB. Will revert once I'm done.

Regards

On Thu, Jan 26, 2017 at 4:14 PM, Lars Helge Øverland  wrote:

> Hi Barnabas,
>
> yes it should be okay now. Can you download the latest 2.24 and try again?
>
> On Thu, Jan 26, 2017 at 2:12 PM, Barnabas Akumba 
> wrote:
>
>> Hello Lars,
>>
>> Any update on this? Have realised that the issue is with both the GIS and
>> Visualiser App.
>>
>> Regards
>>
>> On Mon, Jan 23, 2017 at 8:14 PM, Lars Helge Øverland 
>> wrote:
>>
>>> I suspect this is a bug related to GIS and the API syntax for renaming
>>> properties. Will get back soon.
>>>
>>> Lars
>>>
>>>
>>> On Mon, Jan 23, 2017 at 9:01 AM, Barnabas Akumba 
>>> wrote:
>>>
 Hello Lars,

 I've cleared the Server cache and browser cache as recommended but no
 luck.

 Regards


 On Mon, Jan 23, 2017 at 8:39 AM, Lars Helge Øverland 
 wrote:

> Hi Barnabas,
>
> you might need to clear the server side nginx cache, then restart
> nginx. Did you install your DHIS 2 instance using the "server tools"? On
> linux you can do this with:
>
>
> sudo rm /var/cache/nginx -rf
> sudo service nginx restart
>
>
>
> Then clear your browser cache again.
>
> regards,
>
> Lars
>
>
>
>
> On Mon, Jan 23, 2017 at 8:33 AM, Morten Olav Hansen 
> wrote:
>
>> Ok, so at least the org units themselves have proper names. Maybe Jan
>> has an idea of why its not working?
>>
>> --
>> Morten Olav Hansen
>> Senior Engineer, DHIS 2
>> University of Oslo
>> http://www.dhis2.org
>>
>> On Mon, Jan 23, 2017 at 2:26 PM, Barnabas Akumba <
>> akumbaba...@gmail.com> wrote:
>>
>>> Hello Morten,
>>>
>>> Please find attached output from the api query.
>>>
>>> Regards
>>>
>>> On Mon, Jan 23, 2017 at 8:20 AM, Morten Olav Hansen <
>>> mor...@dhis2.org> wrote:
>>>
 Hi

 Could you please also try /api/organisationUnits.json and
 see if they have proper names there?

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

 On Mon, Jan 23, 2017 at 2:04 PM, Knut Staring 
 wrote:

> You should probably refresh or do something until you see some red
> error messages... The network tab may also be of interest
>
> On Jan 23, 2017 1:59 PM, "Barnabas Akumba" 
> wrote:
>
>> Hello Knut,
>>
>> Please find attached.
>>
>> Regards
>>
>> On Mon, Jan 23, 2017 at 7:55 AM, Knut Staring 
>> wrote:
>>
>>> You still have not provided us with a screenshot of your chrome
>>> browser console.
>>>
>>> On Mon, Jan 23, 2017 at 1:53 PM, Barnabas Akumba <
>>> akumbaba...@gmail.com> wrote:
>>>
 Hello Prosper,

 The only script specified in the upgrade instruction is "Run
 the database SQL upgrade script
 
  once
 before updating the WAR file. It only applies if you have set up 
 program
 rules for your system.". This is to be done during the upgrade 
 from 2.22 to
 2.23. But as you can see it is optional as we don't have program 
 rules on
 our system.

 Regards

 On Mon, Jan 23, 2017 at 5:36 AM, Prosper BT 
 wrote:

> Hi Barnaba,
>
> Am not a server guy but hope you run the required scripts as
> guided in the upgrade package.
>
> Sometimes I ask the server guys to clear nginx cache
>
> Regards
>
> Prosper Behumbiize, MPH
> DHIS2 Implementation| HISP Uganda
> +256 752 751 776 | +256 776 139 139
> pros...@hispuganda.org  | pros...@dhis2.org
>  | Skype: prospertb
>
> On Sat, Jan 21, 2017 at 2:16 PM, Barnabas Akumba <
> akumbaba...@gmail.com> wrote:
>
>> Here attached output from Log file.
>>
>> Regards
>>
>> On Sat, Jan 21, 2017 at 11:48 AM, Knut Staring <
>> knu...@gmail.com> wrote:
>>
>>> RIght. Any errors in your Chrome browser console? Or in your
>>> Tomcat server log?
>>>
>>> On Sat, Jan 21, 

Re: [Dhis2-devs] [Dhis2-users] Organisational Units Names

[Lars Helge Øverland]

Hi Barnabas,

yes it should be okay now. Can you download the latest 2.24 and try again?

On Thu, Jan 26, 2017 at 2:12 PM, Barnabas Akumba 
wrote:

> Hello Lars,
>
> Any update on this? Have realised that the issue is with both the GIS and
> Visualiser App.
>
> Regards
>
> On Mon, Jan 23, 2017 at 8:14 PM, Lars Helge Øverland 
> wrote:
>
>> I suspect this is a bug related to GIS and the API syntax for renaming
>> properties. Will get back soon.
>>
>> Lars
>>
>>
>> On Mon, Jan 23, 2017 at 9:01 AM, Barnabas Akumba 
>> wrote:
>>
>>> Hello Lars,
>>>
>>> I've cleared the Server cache and browser cache as recommended but no
>>> luck.
>>>
>>> Regards
>>>
>>>
>>> On Mon, Jan 23, 2017 at 8:39 AM, Lars Helge Øverland 
>>> wrote:
>>>
 Hi Barnabas,

 you might need to clear the server side nginx cache, then restart
 nginx. Did you install your DHIS 2 instance using the "server tools"? On
 linux you can do this with:


 sudo rm /var/cache/nginx -rf
 sudo service nginx restart



 Then clear your browser cache again.

 regards,

 Lars




 On Mon, Jan 23, 2017 at 8:33 AM, Morten Olav Hansen 
 wrote:

> Ok, so at least the org units themselves have proper names. Maybe Jan
> has an idea of why its not working?
>
> --
> Morten Olav Hansen
> Senior Engineer, DHIS 2
> University of Oslo
> http://www.dhis2.org
>
> On Mon, Jan 23, 2017 at 2:26 PM, Barnabas Akumba <
> akumbaba...@gmail.com> wrote:
>
>> Hello Morten,
>>
>> Please find attached output from the api query.
>>
>> Regards
>>
>> On Mon, Jan 23, 2017 at 8:20 AM, Morten Olav Hansen > > wrote:
>>
>>> Hi
>>>
>>> Could you please also try /api/organisationUnits.json and
>>> see if they have proper names there?
>>>
>>> --
>>> Morten Olav Hansen
>>> Senior Engineer, DHIS 2
>>> University of Oslo
>>> http://www.dhis2.org
>>>
>>> On Mon, Jan 23, 2017 at 2:04 PM, Knut Staring 
>>> wrote:
>>>
 You should probably refresh or do something until you see some red
 error messages... The network tab may also be of interest

 On Jan 23, 2017 1:59 PM, "Barnabas Akumba" 
 wrote:

> Hello Knut,
>
> Please find attached.
>
> Regards
>
> On Mon, Jan 23, 2017 at 7:55 AM, Knut Staring 
> wrote:
>
>> You still have not provided us with a screenshot of your chrome
>> browser console.
>>
>> On Mon, Jan 23, 2017 at 1:53 PM, Barnabas Akumba <
>> akumbaba...@gmail.com> wrote:
>>
>>> Hello Prosper,
>>>
>>> The only script specified in the upgrade instruction is "Run
>>> the database SQL upgrade script
>>> 
>>>  once
>>> before updating the WAR file. It only applies if you have set up 
>>> program
>>> rules for your system.". This is to be done during the upgrade from 
>>> 2.22 to
>>> 2.23. But as you can see it is optional as we don't have program 
>>> rules on
>>> our system.
>>>
>>> Regards
>>>
>>> On Mon, Jan 23, 2017 at 5:36 AM, Prosper BT 
>>> wrote:
>>>
 Hi Barnaba,

 Am not a server guy but hope you run the required scripts as
 guided in the upgrade package.

 Sometimes I ask the server guys to clear nginx cache

 Regards

 Prosper Behumbiize, MPH
 DHIS2 Implementation| HISP Uganda
 +256 752 751 776 | +256 776 139 139
 pros...@hispuganda.org  | pros...@dhis2.org
  | Skype: prospertb

 On Sat, Jan 21, 2017 at 2:16 PM, Barnabas Akumba <
 akumbaba...@gmail.com> wrote:

> Here attached output from Log file.
>
> Regards
>
> On Sat, Jan 21, 2017 at 11:48 AM, Knut Staring <
> knu...@gmail.com> wrote:
>
>> RIght. Any errors in your Chrome browser console? Or in your
>> Tomcat server log?
>>
>> On Sat, Jan 21, 2017 at 10:52 AM, Barnabas Akumba <
>> akumbaba...@gmail.com> wrote:
>>
>>> Hello Knut,
>>>
>>> Yes. I've tried clearing the browser cache and also using
>>> another browser plus chrome incognito mode but still get same 
>>> result.

[Dhis2-devs] Problem with Filtered Dimension in Data Visualization in DHIS2 2.25

[Carlos Nyembwe]

Dear Dev,
We need assistance removing, from graphs, the list of items in the filtered
dimension that appears at the top of the graph. Below, is a graph that
shows the number of births assisted by trained health personnel by
trimester for the whole ASSP project. When creating the graph, we selected
all the health zones but then used “Organization Units” as the filtered
dimension (see screenshot of layout). All the health zones appear on the
top of the bars of the graph. We DON’T want to see them listed though. In
previous versions we did not have this problem.

[image: Inline image 1]

Could you fix it?
-- 
*Carlos Nyembwe*
*I'm just a Computer Scientist*

*Skype: carloscnk1*
*Cell: (+243)813166381*
*Find me in: | Google Plus  |
**Linkedin
 | Facebook
 | Twitter
 |*
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] updating display names independently from name

[Lars Helge Øverland]

You will have to ensure a fresh download of metadata from the server for
this to take effect.

On Thu, Jan 26, 2017 at 2:06 PM, Lars Helge Øverland  wrote:

> Great point. The android data capture app uses another API endpoint where
> the form name was not properly handling translations. I have made a fix now
> to (to the DHIS 2 server application) in 2.25 and 2.24.
>
> Builds ready in 15 min. Let me know if it works.
>
> Lars
>
>
>
>
>
> On Thu, Jan 26, 2017 at 1:35 PM, Blake Hansen 
> wrote:
>
>> Thank you Lars!
>>
>> That is curious then, because our data elements are already translated,
>> the users language is set to the locale the translations exist for and yet
>> in the android data capture app the only language displayed is english. Is
>> there a setting that needs to be changed somewhere on the app or the server
>> to ensure the android data capture app UI uses the *display** property
>> value?
>>
>>
>> --
>>
>>
>>
>>
>> *Blake Hansen*
>> Projects Implementation Manager, BAO Systems
>> +1 202-536-1541 | bhan...@baosystems.com | http://www.baosystems.com |
>> Skype: blake.a.hansen |  2900 K Street, Suite 404, Washington D.C. 20007
>>
>> On 26 Jan 2017, at 12:16, Lars Helge Øverland  wrote:
>>
>> Hi Blake,
>>
>> the displayName is not a persisted property of the data model. This
>> property gets populated based on the translations available for the object
>> for the currently selected locale.
>>
>> Example from the demo:
>>
>> https://play.dhis2.org/demo/api/dataElements/FTRrcoaog83?fie
>> lds=id,name,code,translations
>>
>> This dataelement has 8 translations available, including one for the
>> french locale for the name property.
>>
>> When you have set the db locale for your user to french, the system will
>> render that french translation ("Accute French") as the *displayName*
>> property value.
>>
>> The idea is that all clients should use the displayName (or display***)
>> property for their UIs. This is a transient field which is populated by
>> DHIS 2.
>>
>> To store translations in DHIS 2 for a specific locale, you can POST the
>> translation part of the object itself in the same format as it is rendered
>> (see URL example above). Docs here
>> 
>> .
>>
>> This can of course also be done through the maintenance app UI.
>>
>>
>> best regards,
>>
>> Lars
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> On Thu, Jan 26, 2017 at 11:20 AM, Blake Hansen 
>> wrote:
>>
>>> Dear Devs,
>>>
>>> I have been trying to change the display names (displayName,
>>> displayFormName etc…) of some data elements so that they are different to
>>> the name, displayName etc… I have a use case where data entry on computer
>>> will be in one language but on the android data capture app will be
>>> another. In previous threads it was mentioned that from 2.24 the android
>>> app will read the displayX property for what it displays.
>>>
>>> My question: *Is it possible to change the displayFormName
>>> independently of the formName?* If so, how please? So far I have used
>>> xml updates and partial payload updates but to no avail. However simply
>>> changing the form name does the trick (which I don’t want to do.)
>>>
>>> Many thanks,
>>> Blake
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to : dhis2-devs@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>> Lars Helge Øverland
>> Lead developer, DHIS 2
>> University of Oslo
>> Skype: larshelgeoverland
>> l...@dhis2.org
>> http://www.dhis2.org 
>>
>>
>>
>
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> l...@dhis2.org
> http://www.dhis2.org 
>
>


-- 
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
l...@dhis2.org
http://www.dhis2.org 
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] updating display names independently from name

[Lars Helge Øverland]

Great point. The android data capture app uses another API endpoint where
the form name was not properly handling translations. I have made a fix now
to (to the DHIS 2 server application) in 2.25 and 2.24.

Builds ready in 15 min. Let me know if it works.

Lars





On Thu, Jan 26, 2017 at 1:35 PM, Blake Hansen 
wrote:

> Thank you Lars!
>
> That is curious then, because our data elements are already translated,
> the users language is set to the locale the translations exist for and yet
> in the android data capture app the only language displayed is english. Is
> there a setting that needs to be changed somewhere on the app or the server
> to ensure the android data capture app UI uses the *display** property
> value?
>
>
> --
>
>
>
>
> *Blake Hansen*
> Projects Implementation Manager, BAO Systems
> +1 202-536-1541 | bhan...@baosystems.com | http://www.baosystems.com |
> Skype: blake.a.hansen |  2900 K Street, Suite 404, Washington D.C. 20007
>
> On 26 Jan 2017, at 12:16, Lars Helge Øverland  wrote:
>
> Hi Blake,
>
> the displayName is not a persisted property of the data model. This
> property gets populated based on the translations available for the object
> for the currently selected locale.
>
> Example from the demo:
>
> https://play.dhis2.org/demo/api/dataElements/FTRrcoaog83?
> fields=id,name,code,translations
>
> This dataelement has 8 translations available, including one for the
> french locale for the name property.
>
> When you have set the db locale for your user to french, the system will
> render that french translation ("Accute French") as the *displayName*
> property value.
>
> The idea is that all clients should use the displayName (or display***)
> property for their UIs. This is a transient field which is populated by
> DHIS 2.
>
> To store translations in DHIS 2 for a specific locale, you can POST the
> translation part of the object itself in the same format as it is rendered
> (see URL example above). Docs here
> 
> .
>
> This can of course also be done through the maintenance app UI.
>
>
> best regards,
>
> Lars
>
>
>
>
>
>
>
>
>
> On Thu, Jan 26, 2017 at 11:20 AM, Blake Hansen 
> wrote:
>
>> Dear Devs,
>>
>> I have been trying to change the display names (displayName,
>> displayFormName etc…) of some data elements so that they are different to
>> the name, displayName etc… I have a use case where data entry on computer
>> will be in one language but on the android data capture app will be
>> another. In previous threads it was mentioned that from 2.24 the android
>> app will read the displayX property for what it displays.
>>
>> My question: *Is it possible to change the displayFormName independently
>> of the formName?* If so, how please? So far I have used xml updates and
>> partial payload updates but to no avail. However simply changing the form
>> name does the trick (which I don’t want to do.)
>>
>> Many thanks,
>> Blake
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> l...@dhis2.org
> http://www.dhis2.org 
>
>
>


-- 
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
l...@dhis2.org
http://www.dhis2.org 
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] updating display names independently from name

[Blake Hansen]

Thank you Lars! 

That is curious then, because our data elements are already translated, the 
users language is set to the locale the translations exist for and yet in the 
android data capture app the only language displayed is english. Is there a 
setting that needs to be changed somewhere on the app or the server to ensure 
the android data capture app UI uses the display* property value?

 
-- 




Blake Hansen
Projects Implementation Manager, BAO Systems
+1 202-536-1541 | bhan...@baosystems.com  | 
http://www.baosystems.com  |
Skype: blake.a.hansen |  2900 K Street, Suite 404, Washington D.C. 20007

> On 26 Jan 2017, at 12:16, Lars Helge Øverland  wrote:
> 
> Hi Blake,
> 
> the displayName is not a persisted property of the data model. This property 
> gets populated based on the translations available for the object for the 
> currently selected locale.
> 
> Example from the demo:
> 
> https://play.dhis2.org/demo/api/dataElements/FTRrcoaog83?fields=id,name,code,translations
>  
> 
> 
> This dataelement has 8 translations available, including one for the french 
> locale for the name property. 
> 
> When you have set the db locale for your user to french, the system will 
> render that french translation ("Accute French") as the displayName property 
> value.
> 
> The idea is that all clients should use the displayName (or display***) 
> property for their UIs. This is a transient field which is populated by DHIS 
> 2.
> 
> To store translations in DHIS 2 for a specific locale, you can POST the 
> translation part of the object itself in the same format as it is rendered 
> (see URL example above). Docs here 
> .
> 
> This can of course also be done through the maintenance app UI.
> 
> 
> best regards,
> 
> Lars
> 
> 
> 
> 
> 
> 
> 
> 
> 
> On Thu, Jan 26, 2017 at 11:20 AM, Blake Hansen  > wrote:
> Dear Devs,
> 
> I have been trying to change the display names (displayName, displayFormName 
> etc…) of some data elements so that they are different to the name, 
> displayName etc… I have a use case where data entry on computer will be in 
> one language but on the android data capture app will be another. In previous 
> threads it was mentioned that from 2.24 the android app will read the 
> displayX property for what it displays.
> 
> My question: Is it possible to change the displayFormName independently of 
> the formName? If so, how please? So far I have used xml updates and partial 
> payload updates but to no avail. However simply changing the form name does 
> the trick (which I don’t want to do.)
> 
> Many thanks,
> Blake
> 
> ___
> Mailing list: https://launchpad.net/~dhis2-devs 
> 
> Post to : dhis2-devs@lists.launchpad.net 
> 
> Unsubscribe : https://launchpad.net/~dhis2-devs 
> 
> More help   : https://help.launchpad.net/ListHelp 
> 
> 
> 
> 
> 
> -- 
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> l...@dhis2.org 
> http://www.dhis2.org 
> 

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

Re: [Dhis2-devs] [Dhis2-users] PostgreSQL-9.5 failed to boot-up at restart of Linux server

[gerald thomas]

Yes Bob,
But i now i am having a major issue because i can't find the
dhis2-startup, dhis2-stop or dhis2-status but the profile of the
instance is available.



On 1/26/17, Bob Jolliffe  wrote:
> what works?  you removed it and started again?
>
> On 26 January 2017 at 10:14, gerald thomas  wrote:
>
>> Bob,
>> Thanks it is works
>>
>>
>> On 1/26/17, Bob Jolliffe  wrote:
>> > Gerald it sounds like it has got into a bit of a mess and maybe you
>> > risk
>> > just making it worse.  It is really not supposed to be this hard, but
>> > tit
>> > is next to impossible at a distance to figure out what might have gone
>> > wrong.
>> >
>> > Given that you are not dependent on migrating the cluster, but that you
>> are
>> > simply going to restore your dbs, I would advise that you just try and
>> get
>> > rid of the current non-working postgres installation completely and
>> install
>> > it again.
>> >
>> > sudo apt-get purge postgresql ... etc  (check under /etc and /var/lib
>> that
>> > all traces have truly gone)
>> >
>> > On 26 January 2017 at 08:42, gerald thomas 
>> wrote:
>> >
>> >> Mutali,
>> >> I think there was an issue where i have postgresql and postgresql-9.5
>> >> inside /etc/init.d. But when this command: sudo update-rc.d
>> >> postgresql-9.5 enable
>> >>
>> >> I am getting this message "update-rc.d: warning:
>> >> /etc/init.d/postgresql-9.5 missing LSB information"
>> >> >
>> >>
>> >> On 1/26/17, J. Paul Mutali  wrote:
>> >> > Hi Gerald,
>> >> >
>> >> >  you can use this command: sudo update-rc.d postgresql enable
>> >> >
>> >> > Hope it will work for you.
>> >> >
>> >> > ---
>> >> >
>> >> > JP Mutali
>> >> >
>> >> > Kigali - Rwanda
>> >> >
>> >> > On Thu, Jan 26, 2017 at 8:52 AM, gerald thomas
>> >> > > >
>> >> > wrote:
>> >> >
>> >> >> There were some issues with the migration so I had to purge the 9.3
>> >> >> and
>> >> >> do
>> >> >> a fresh installation of 9.5 and restore my backup. But if the
>> >> >> server
>> >> >> reboot
>> >> >> I will have to manually do:
>> >> >> pg_ctlcluster 9.5 main start
>> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >> >> On Jan 26, 2017 5:59 AM, "Uwe Wahser"  wrote:
>> >> >>
>> >> >> Hi Gerald,
>> >> >>
>> >> >> we did the upgrade while upgrading to Ubuntu 16.04 and everything
>> >> >> starts
>> >> >> normally. But you have to manually migrate your 9.3 databases into
>> the
>> >> >> 9.5
>> >> >> format - did you do that?
>> >> >>
>> >> >> These were the bash commands I recorded back then (at your own
>> >> >> risk,
>> >> >> no
>> >> >> guarantee - do backups and all that first)
>> >> >>
>> >> >> ~/tomcat-dhis/bin/shutdown.sh
>> >> >> sudo pg_dropcluster 9.5 main --stop
>> >> >> sudo pg_upgradecluster 9.3 main
>> >> >> pg_lsclusters
>> >> >> sudo pg_dropcluster 9.3 main
>> >> >>
>> >> >> Hope that helps,
>> >> >>
>> >> >> Uwe
>> >> >>
>> >> >> ---
>> >> >>
>> >> >> > gerald thomas  hat am 26. Januar 2017 um
>> >> >> > 01:38
>> >> >> geschrieben:
>> >> >> >
>> >> >> >
>> >> >> > Dear All,
>> >> >> > We are upgrading DHIS2 server database (PostgreSQL from 9.3.15 to
>> >> >> > 9.5.5) and it had been successfully done but the Postgres does
>> >> >> > not
>> >> >> > automatically start after boot-up. I am using: (pg_ctlcluster 9.5
>> >> >> > main
>> >> >> > start) to start my database but i want it start automatically.
>> >> >> >
>> >> >> > Please can someone help me?
>> >> >> >
>> >> >> > --
>> >> >> > Regards,
>> >> >> >
>> >> >> > Gerald
>> >> >> >
>> >> >> > ___
>> >> >> > Mailing list: https://launchpad.net/~dhis2-users
>> >> >> > Post to : dhis2-us...@lists.launchpad.net
>> >> >> > Unsubscribe : https://launchpad.net/~dhis2-users
>> >> >> > More help   : https://help.launchpad.net/ListHelp
>> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >> >> ___
>> >> >> Mailing list: https://launchpad.net/~dhis2-devs
>> >> >> Post to : dhis2-devs@lists.launchpad.net
>> >> >> Unsubscribe : https://launchpad.net/~dhis2-devs
>> >> >> More help   : https://help.launchpad.net/ListHelp
>> >> >>
>> >> >>
>> >> >
>> >>
>> >>
>> >> --
>> >> Regards,
>> >>
>> >> Gerald
>> >>
>> >> ___
>> >> Mailing list: https://launchpad.net/~dhis2-users
>> >> Post to : dhis2-us...@lists.launchpad.net
>> >> Unsubscribe : https://launchpad.net/~dhis2-users
>> >> More help   : https://help.launchpad.net/ListHelp
>> >>
>> >
>>
>>
>> --
>> Regards,
>>
>> Gerald
>>
>


-- 
Regards,

Gerald

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

Re: [Dhis2-devs] Errors in JDBC connection

[Bob Jolliffe]

This seems to be a known problem between mysql, java and c3p0 (the database
connection pool).  It seems that mysql resets connections which are not
used for 8 hours (by default).  For some reason these stale connections
then get served up from the connection pool giving rise to this error.

You can kick the problem further down the tracks by increasing the timeout
on the mysql side.  check the documentation for the configuration option.

Or you can make c3p0 more robust, for example by checking connections on
checkout (google 'c3p0 mysql reset' for lots of discussion, tips, advice
etc).  This involves tweaking hibernate settings, possibly inside the war
file.  I haven't tested myself on mysql for a long time.  I think HISP
India folk probably have the best experience of supporting mysql on DHIS2
over the years.

On 25 January 2017 at 07:55, Neeraj Gupta  wrote:

> Dear team,
>
> For one of our client, we are using DHIS2.21 with MySQL 5.6. Application
> server and database server are separate and can talk to each other.
> Since last 3 weeks, they are facing issues and getting the below message
> instead of login screen.
>
> *org.springframework.transaction.CannotCreateTransactionException: Could
> not open Hibernate Session for transaction; nested exception is
> org.hibernate.TransactionException: JDBC begin transaction failed*
>
> After refreshing the page twice or thrice login page gets loaded.
>
> I tried to check the log file and found below errors
>
>- org.hibernate.TransactionException: JDBC begin transaction failed
>- com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:
>Communications link failure
>- java.net.SocketException: Connection reset
>
> Has anyone had any idea about these and how these can be rectified? Any
> help is much appreciated.
>
> --
> Thanks,
> Neeraj Gupta
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] updating display names independently from name

[Blake Hansen]

Dear Devs,

I have been trying to change the display names (displayName, displayFormName 
etc…) of some data elements so that they are different to the name, displayName 
etc… I have a use case where data entry on computer will be in one language but 
on the android data capture app will be another. In previous threads it was 
mentioned that from 2.24 the android app will read the displayX property for 
what it displays.

My question: Is it possible to change the displayFormName independently of the 
formName? If so, how please? So far I have used xml updates and partial payload 
updates but to no avail. However simply changing the form name does the trick 
(which I don’t want to do.)

Many thanks,
Blake___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] PostgreSQL-9.5 failed to boot-up at restart of Linux server

[gerald thomas]

Bob,
Thanks it is works


On 1/26/17, Bob Jolliffe  wrote:
> Gerald it sounds like it has got into a bit of a mess and maybe you risk
> just making it worse.  It is really not supposed to be this hard, but tit
> is next to impossible at a distance to figure out what might have gone
> wrong.
>
> Given that you are not dependent on migrating the cluster, but that you are
> simply going to restore your dbs, I would advise that you just try and get
> rid of the current non-working postgres installation completely and install
> it again.
>
> sudo apt-get purge postgresql ... etc  (check under /etc and /var/lib that
> all traces have truly gone)
>
> On 26 January 2017 at 08:42, gerald thomas  wrote:
>
>> Mutali,
>> I think there was an issue where i have postgresql and postgresql-9.5
>> inside /etc/init.d. But when this command: sudo update-rc.d
>> postgresql-9.5 enable
>>
>> I am getting this message "update-rc.d: warning:
>> /etc/init.d/postgresql-9.5 missing LSB information"
>> >
>>
>> On 1/26/17, J. Paul Mutali  wrote:
>> > Hi Gerald,
>> >
>> >  you can use this command: sudo update-rc.d postgresql enable
>> >
>> > Hope it will work for you.
>> >
>> > ---
>> >
>> > JP Mutali
>> >
>> > Kigali - Rwanda
>> >
>> > On Thu, Jan 26, 2017 at 8:52 AM, gerald thomas 
>> > wrote:
>> >
>> >> There were some issues with the migration so I had to purge the 9.3
>> >> and
>> >> do
>> >> a fresh installation of 9.5 and restore my backup. But if the server
>> >> reboot
>> >> I will have to manually do:
>> >> pg_ctlcluster 9.5 main start
>> >>
>> >>
>> >>
>> >>
>> >>
>> >> On Jan 26, 2017 5:59 AM, "Uwe Wahser"  wrote:
>> >>
>> >> Hi Gerald,
>> >>
>> >> we did the upgrade while upgrading to Ubuntu 16.04 and everything
>> >> starts
>> >> normally. But you have to manually migrate your 9.3 databases into the
>> >> 9.5
>> >> format - did you do that?
>> >>
>> >> These were the bash commands I recorded back then (at your own risk,
>> >> no
>> >> guarantee - do backups and all that first)
>> >>
>> >> ~/tomcat-dhis/bin/shutdown.sh
>> >> sudo pg_dropcluster 9.5 main --stop
>> >> sudo pg_upgradecluster 9.3 main
>> >> pg_lsclusters
>> >> sudo pg_dropcluster 9.3 main
>> >>
>> >> Hope that helps,
>> >>
>> >> Uwe
>> >>
>> >> ---
>> >>
>> >> > gerald thomas  hat am 26. Januar 2017 um
>> >> > 01:38
>> >> geschrieben:
>> >> >
>> >> >
>> >> > Dear All,
>> >> > We are upgrading DHIS2 server database (PostgreSQL from 9.3.15 to
>> >> > 9.5.5) and it had been successfully done but the Postgres does not
>> >> > automatically start after boot-up. I am using: (pg_ctlcluster 9.5
>> >> > main
>> >> > start) to start my database but i want it start automatically.
>> >> >
>> >> > Please can someone help me?
>> >> >
>> >> > --
>> >> > Regards,
>> >> >
>> >> > Gerald
>> >> >
>> >> > ___
>> >> > Mailing list: https://launchpad.net/~dhis2-users
>> >> > Post to : dhis2-us...@lists.launchpad.net
>> >> > Unsubscribe : https://launchpad.net/~dhis2-users
>> >> > More help   : https://help.launchpad.net/ListHelp
>> >>
>> >>
>> >>
>> >>
>> >> ___
>> >> Mailing list: https://launchpad.net/~dhis2-devs
>> >> Post to : dhis2-devs@lists.launchpad.net
>> >> Unsubscribe : https://launchpad.net/~dhis2-devs
>> >> More help   : https://help.launchpad.net/ListHelp
>> >>
>> >>
>> >
>>
>>
>> --
>> Regards,
>>
>> Gerald
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>


-- 
Regards,

Gerald

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

Re: [Dhis2-devs] [Dhis2-users] PostgreSQL-9.5 failed to boot-up at restart of Linux server

[Bob Jolliffe]

Gerald it sounds like it has got into a bit of a mess and maybe you risk
just making it worse.  It is really not supposed to be this hard, but tit
is next to impossible at a distance to figure out what might have gone
wrong.

Given that you are not dependent on migrating the cluster, but that you are
simply going to restore your dbs, I would advise that you just try and get
rid of the current non-working postgres installation completely and install
it again.

sudo apt-get purge postgresql ... etc  (check under /etc and /var/lib that
all traces have truly gone)

On 26 January 2017 at 08:42, gerald thomas  wrote:

> Mutali,
> I think there was an issue where i have postgresql and postgresql-9.5
> inside /etc/init.d. But when this command: sudo update-rc.d
> postgresql-9.5 enable
>
> I am getting this message "update-rc.d: warning:
> /etc/init.d/postgresql-9.5 missing LSB information"
> >
>
> On 1/26/17, J. Paul Mutali  wrote:
> > Hi Gerald,
> >
> >  you can use this command: sudo update-rc.d postgresql enable
> >
> > Hope it will work for you.
> >
> > ---
> >
> > JP Mutali
> >
> > Kigali - Rwanda
> >
> > On Thu, Jan 26, 2017 at 8:52 AM, gerald thomas 
> > wrote:
> >
> >> There were some issues with the migration so I had to purge the 9.3 and
> >> do
> >> a fresh installation of 9.5 and restore my backup. But if the server
> >> reboot
> >> I will have to manually do:
> >> pg_ctlcluster 9.5 main start
> >>
> >>
> >>
> >>
> >>
> >> On Jan 26, 2017 5:59 AM, "Uwe Wahser"  wrote:
> >>
> >> Hi Gerald,
> >>
> >> we did the upgrade while upgrading to Ubuntu 16.04 and everything starts
> >> normally. But you have to manually migrate your 9.3 databases into the
> >> 9.5
> >> format - did you do that?
> >>
> >> These were the bash commands I recorded back then (at your own risk, no
> >> guarantee - do backups and all that first)
> >>
> >> ~/tomcat-dhis/bin/shutdown.sh
> >> sudo pg_dropcluster 9.5 main --stop
> >> sudo pg_upgradecluster 9.3 main
> >> pg_lsclusters
> >> sudo pg_dropcluster 9.3 main
> >>
> >> Hope that helps,
> >>
> >> Uwe
> >>
> >> ---
> >>
> >> > gerald thomas  hat am 26. Januar 2017 um 01:38
> >> geschrieben:
> >> >
> >> >
> >> > Dear All,
> >> > We are upgrading DHIS2 server database (PostgreSQL from 9.3.15 to
> >> > 9.5.5) and it had been successfully done but the Postgres does not
> >> > automatically start after boot-up. I am using: (pg_ctlcluster 9.5 main
> >> > start) to start my database but i want it start automatically.
> >> >
> >> > Please can someone help me?
> >> >
> >> > --
> >> > Regards,
> >> >
> >> > Gerald
> >> >
> >> > ___
> >> > Mailing list: https://launchpad.net/~dhis2-users
> >> > Post to : dhis2-us...@lists.launchpad.net
> >> > Unsubscribe : https://launchpad.net/~dhis2-users
> >> > More help   : https://help.launchpad.net/ListHelp
> >>
> >>
> >>
> >>
> >> ___
> >> Mailing list: https://launchpad.net/~dhis2-devs
> >> Post to : dhis2-devs@lists.launchpad.net
> >> Unsubscribe : https://launchpad.net/~dhis2-devs
> >> More help   : https://help.launchpad.net/ListHelp
> >>
> >>
> >
>
>
> --
> Regards,
>
> Gerald
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Error in 2.25 displaying graphs and tables when an organisationUnitGroupSet is defined as filter

[Alejandro]

Hi all!

After upgrading from 2.21 to 2.25 we have found the following error:

[image: Inline image 1]

Code: 500
Status: Internal Server Error
Not a valid dimension: BtFXTpKRl6n

This uid, BtFXTpKRl6n, is an organisationUnitGroupSet that, in the Layout
of a graph/table, is placed in the filter section.

The tricky thing is that the behaviour is not always the same. Sometimes we
can open those tables and graphs and sometimes not. In particular once we
get the error, if we perform the Maintenance Task Clear application cache,
it works again. But suddenly, after some time, we start getting the same
error again in the same table/graph or in others with the only thing in
common that they have this organisationUnitGroupSet as a filter.

We are looking into it right now but if any of you have faced a similar
problem or have an idea on what it could be, thank you for sharing!

Cheers!
Alejandro
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp