Re: [Dhis2-users] Customising timely submissions to a specific time

2018-06-11 Thread Jasper Timm
Thanks Calle.

Issue created: https://jira.dhis2.org/browse/DHIS2-3992

On Sat, Jun 9, 2018 at 12:28 PM Calle Hedberg  wrote:

> Jasper,
>
> I did make a note about it - will try to follow it up when in Oslo during
> the next two weeks (this weeks I'm on leave with my family in Norway)
>
> And yes, please add an improvement JIRA issue for it.
>
> Regards
> Calle
>
> *Carl-Anders (Calle) Hedberg*
> HISP
>
> Strategic Advisor & Technical Specialist
>
> Health Information Systems Programme – South Africa
>
> Tel/fax:  +27 (0)21 685 6472 <+27%2021%20685%206472>
>
> Cell:+27 (0)82 853 5352
>
> Iridium SatPhone: +8816-315-19119 <+881%206%20315%2019119> (usually OFF)
>
> E-mail1: ca...@hisp.org
>
> E-mail2: calle.hedb...@gmail.com
>
> E-mail3: chedb...@telkomsa.net
>
> Skype:  calle_hedberg
>
> On 7 June 2018 at 19:31, Jasper Timm 
> wrote:
>
>> Surprised there wasn't any discussion on this.
>>
>> Calle, I know you spoke about it with Les recently. This seems like a
>> sensible feature to add don't you agree?
>>
>> There's certainly a need for it in Sierra Leone and the MoH in Liberia
>> asked for the same thing as well.
>>
>> Maybe I should just put a JIRA feature request for it in?
>>
>> On Fri, Jun 1, 2018 at 4:11 PM Jasper Timm 
>> wrote:
>>
>>> Hi there DHIS2 folks,
>>>
>>> At the moment there is a field within aggregate dataSets for "days after
>>> period to qualify for timely submissions".
>>>
>>> Is there any plan to make this a little more customisable, so that we
>>> could for instance list a specific time as well? i.e. Monday at 12pm.
>>>
>>> We're currently using custom external scripts to calculate our own
>>> 'timely' values because this isn't possible, but it would be great to use
>>> the built in Reporting Rate Summary.
>>>
>>> Thanks,
>>>
>>> - Jasper
>>> --
>>>
>>> Jasper Timm
>>>
>>> Lead Software Developer
>>>
>>> <http://www.ehealthafrica.org/>
>>>
>>> eHealth Africa
>>> 4A Renner Drive
>>> Off Wilkinson Road (behind Monoprix Supermarket)
>>> Freetown, Sierra Leone
>>>
>>> mobile +232 99891119 <+232%2099%20891119>
>>>
>>> --
>>>
>>> <https://web.facebook.com/EHealthAfrica>
>>> <https://twitter.com/eHealth_africa>
>>> <https://www.linkedin.com/company/1449060/>
>>> <https://www.instagram.com/ehealthafrica/>
>>> <https://www.youtube.com/channel/UCcgM_HhTcg5M9Ji3Of6QmUg>
>>>
>> --
>>
>> Jasper Timm
>>
>> Lead Software Developer
>>
>> <http://www.ehealthafrica.org/>
>>
>> eHealth Africa
>> 4A Renner Drive
>> Off Wilkinson Road (behind Monoprix Supermarket)
>> Freetown, Sierra Leone
>>
>> mobile +232 99891119 <+232%2099%20891119>
>>
>> --
>>
>> <https://web.facebook.com/EHealthAfrica>
>> <https://twitter.com/eHealth_africa>
>> <https://www.linkedin.com/company/1449060/>
>> <https://www.instagram.com/ehealthafrica/>
>> <https://www.youtube.com/channel/UCcgM_HhTcg5M9Ji3Of6QmUg>
>>
>
>
> *This message and any attachments are subject to a disclaimer published at
> http://www.hisp.org/policies.html#comms_disclaimer
> <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.*
>
-- 

Jasper Timm

Lead Software Developer

<http://www.ehealthafrica.org/>

eHealth Africa
4A Renner Drive
Off Wilkinson Road (behind Monoprix Supermarket)
Freetown, Sierra Leone

mobile +232 99891119

--

<https://web.facebook.com/EHealthAfrica>
<https://twitter.com/eHealth_africa>
<https://www.linkedin.com/company/1449060/>
<https://www.instagram.com/ehealthafrica/>
<https://www.youtube.com/channel/UCcgM_HhTcg5M9Ji3Of6QmUg>
___
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] Customising timely submissions to a specific time

2018-06-07 Thread Jasper Timm
Surprised there wasn't any discussion on this.

Calle, I know you spoke about it with Les recently. This seems like a
sensible feature to add don't you agree?

There's certainly a need for it in Sierra Leone and the MoH in Liberia
asked for the same thing as well.

Maybe I should just put a JIRA feature request for it in?

On Fri, Jun 1, 2018 at 4:11 PM Jasper Timm 
wrote:

> Hi there DHIS2 folks,
>
> At the moment there is a field within aggregate dataSets for "days after
> period to qualify for timely submissions".
>
> Is there any plan to make this a little more customisable, so that we
> could for instance list a specific time as well? i.e. Monday at 12pm.
>
> We're currently using custom external scripts to calculate our own
> 'timely' values because this isn't possible, but it would be great to use
> the built in Reporting Rate Summary.
>
> Thanks,
>
> - Jasper
> --
>
> Jasper Timm
>
> Lead Software Developer
>
> <http://www.ehealthafrica.org/>
>
> eHealth Africa
> 4A Renner Drive
> Off Wilkinson Road (behind Monoprix Supermarket)
> Freetown, Sierra Leone
>
> mobile +232 99891119 <+232%2099%20891119>
>
> --
>
> <https://web.facebook.com/EHealthAfrica>
> <https://twitter.com/eHealth_africa>
> <https://www.linkedin.com/company/1449060/>
> <https://www.instagram.com/ehealthafrica/>
> <https://www.youtube.com/channel/UCcgM_HhTcg5M9Ji3Of6QmUg>
>
-- 

Jasper Timm

Lead Software Developer

<http://www.ehealthafrica.org/>

eHealth Africa
4A Renner Drive
Off Wilkinson Road (behind Monoprix Supermarket)
Freetown, Sierra Leone

mobile +232 99891119

--

<https://web.facebook.com/EHealthAfrica>
<https://twitter.com/eHealth_africa>
<https://www.linkedin.com/company/1449060/>
<https://www.instagram.com/ehealthafrica/>
<https://www.youtube.com/channel/UCcgM_HhTcg5M9Ji3Of6QmUg>
___
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] Customising timely submissions to a specific time

2018-06-01 Thread Jasper Timm
Hi there DHIS2 folks,

At the moment there is a field within aggregate dataSets for "days after
period to qualify for timely submissions".

Is there any plan to make this a little more customisable, so that we could
for instance list a specific time as well? i.e. Monday at 12pm.

We're currently using custom external scripts to calculate our own 'timely'
values because this isn't possible, but it would be great to use the built
in Reporting Rate Summary.

Thanks,

- Jasper
-- 

Jasper Timm

Lead Software Developer

<http://www.ehealthafrica.org/>

eHealth Africa
4A Renner Drive
Off Wilkinson Road (behind Monoprix Supermarket)
Freetown, Sierra Leone

mobile +232 99891119

--

<https://web.facebook.com/EHealthAfrica>
<https://twitter.com/eHealth_africa>
<https://www.linkedin.com/company/1449060/>
<https://www.instagram.com/ehealthafrica/>
<https://www.youtube.com/channel/UCcgM_HhTcg5M9Ji3Of6QmUg>
___
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] Cant not create new approval levels in 2.26

2017-11-21 Thread Jasper Timm
Thanks Jim, just confirming for everyone else this is now fixed in 2.26
core as well. I assume someone pushed the fix from somewhere other than
github then.

On Fri, Nov 10, 2017 at 8:37 PM, Jim Grace <j...@dhis2.org> wrote:

> Birk Johansson made the fix, after I determined that the fix needed to be
> done in the front end code. Now that we're migrating the user interface to
> apps, they're in separate repositories. I see the 2.27 fix in the
> settings-app repository at https://github.com/dhis2/settings-app/commit/
> 8747d606029cb510f178cf86005acf33cc9e0a7c. I'm not sure where the 2.26 fix
> is, but I rebuilt the latest 2.26 on my system and it worked. If you have
> further questions about the fix, Birk might be able to shed more light on
> it.
>
> Cheers,
> Jim
>
>
> On Fri, Nov 10, 2017 at 11:58 AM, Jasper Timm <jasper.timm@ehealthnigeria.
> org> wrote:
>
>> Hi Jim,
>>
>> I can't seem to see the commit for this fix in the 2.26 or 2.27 branch on
>> the dhis2-core repo in github.
>>
>> Did you commit somewhere else?
>>
>> Thanks,
>>
>> - Jasper
>>
>> On Mon, Nov 6, 2017 at 11:48 PM, Ibrahim Bayoh <
>> ibrahim.ba...@sl.ehealthafrica.org> wrote:
>>
>>> thanks, Jim. You are a lifesaver. I'll test and get back to you.
>>>
>>> Best,
>>> Bayoh.
>>>
>>> On Mon, Nov 6, 2017 at 8:43 PM Jim Grace <j...@dhis2.org> wrote:
>>>
>>>> It's fixed now in the latest builds of 2.26 and 2.27. Apologies for the
>>>> long delay.
>>>>
>>>> Cheers,
>>>> Jim
>>>>
>>>>
>>>> On Thu, Nov 2, 2017 at 5:30 AM, Ibrahim Bayoh <
>>>> ibrahim.ba...@sl.ehealthafrica.org> wrote:
>>>>
>>>>> Thanks, Jim
>>>>> It seems like this issue has been around for a while. When do you
>>>>> think we'll get a fix for it?
>>>>> Thanks,
>>>>> Bayoh.
>>>>>
>>>>> On Thu, Oct 26, 2017 at 1:27 PM Trøyel Nerbø <troyel.ne...@nrc.no>
>>>>> wrote:
>>>>>
>>>>>> FYI: I also reported this in June. https://jira.dhis2.org/browse/
>>>>>> DHIS2-1831?jql=issuetype%20%3D%20Bug%20AND%20text%20~%20approval
>>>>>>
>>>>>>
>>>>>>
>>>>>> *From:* Dhis2-users [mailto:dhis2-users-bounces+troyel.nerbo=
>>>>>> nrc...@lists.launchpad.net] *On Behalf Of *Jim Grace
>>>>>> *Sent:* torsdag 26. oktober 2017 14.18
>>>>>> *To:* Ibrahim Bayoh <ibrahim.ba...@sl.ehealthafrica.org>
>>>>>> *Cc:* dhis2-users <dhis2-users@lists.launchpad.net>
>>>>>> *Subject:* Re: [Dhis2-users] Cant not create new approval levels in
>>>>>> 2.26
>>>>>>
>>>>>>
>>>>>>
>>>>>> Hi Bayoh,
>>>>>>
>>>>>>
>>>>>>
>>>>>> I have reproduced this problem in 2.26 and 2.27. I have created a
>>>>>> Jira ticket for this at https://jira.dhis2.org/browse/DHIS2-2449.
>>>>>>
>>>>>>
>>>>>>
>>>>>> Apologies for this problem. Thank you for bringing this to our
>>>>>> attention. We will fix it.
>>>>>>
>>>>>>
>>>>>>
>>>>>> Cheers,
>>>>>>
>>>>>> Jim
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> On Thu, Oct 26, 2017 at 7:30 AM, Ibrahim Bayoh <
>>>>>> ibrahim.ba...@sl.ehealthafrica.org> wrote:
>>>>>>
>>>>>> Hi All,
>>>>>>
>>>>>> Am trying to create approval level in 2.26 which failed on saving
>>>>>> level. Console error reveals a "Missing required property 'name' " error.
>>>>>> See screenshots below.
>>>>>>
>>>>>> Thanks,
>>>>>>
>>>>>> Bayoh.
>>>>>>
>>>>>>
>>>>>>
>>>>>> [image: Screen Shot 2017-10-26 at 11.10.35 AM.png]
>>>>>>
>>>>>> [image: Screen Shot 2017-10-26 at 11.26.10 AM.png]
>>>>>>
>>>>>> --
>>>>>>
>>>>>> Ibrahim Bayoh
>>>>>>
>>>>>>
>>>>>&g

[Dhis2-users] Previous releases in playground

2017-11-14 Thread Jasper Timm
Hi there,

It appears the previous releases running at play.dhis2.org have not been
updated.

I assume given the current stable release is 2.28, Release 1 should be 2.27
and Release 2 should be 2.26.

Would someone be able to take care of that?

Thanks,

-- 

*Jasper Timm*

Lead Software Developer

*eHealth Africa*

Mobile +232 99891119 <+23299891119>

www.ehealthafrica.org


<http://www.ehealthafrica.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] Cant not create new approval levels in 2.26

2017-11-10 Thread Jasper Timm
Hi Jim,

I can't seem to see the commit for this fix in the 2.26 or 2.27 branch on
the dhis2-core repo in github.

Did you commit somewhere else?

Thanks,

- Jasper

On Mon, Nov 6, 2017 at 11:48 PM, Ibrahim Bayoh <
ibrahim.ba...@sl.ehealthafrica.org> wrote:

> thanks, Jim. You are a lifesaver. I'll test and get back to you.
>
> Best,
> Bayoh.
>
> On Mon, Nov 6, 2017 at 8:43 PM Jim Grace <j...@dhis2.org> wrote:
>
>> It's fixed now in the latest builds of 2.26 and 2.27. Apologies for the
>> long delay.
>>
>> Cheers,
>> Jim
>>
>>
>> On Thu, Nov 2, 2017 at 5:30 AM, Ibrahim Bayoh <ibrahim.bayoh@sl.
>> ehealthafrica.org> wrote:
>>
>>> Thanks, Jim
>>> It seems like this issue has been around for a while. When do you think
>>> we'll get a fix for it?
>>> Thanks,
>>> Bayoh.
>>>
>>> On Thu, Oct 26, 2017 at 1:27 PM Trøyel Nerbø <troyel.ne...@nrc.no>
>>> wrote:
>>>
>>>> FYI: I also reported this in June. https://jira.dhis2.org/browse/
>>>> DHIS2-1831?jql=issuetype%20%3D%20Bug%20AND%20text%20~%20approval
>>>>
>>>>
>>>>
>>>> *From:* Dhis2-users [mailto:dhis2-users-bounces+troyel.nerbo=
>>>> nrc...@lists.launchpad.net] *On Behalf Of *Jim Grace
>>>> *Sent:* torsdag 26. oktober 2017 14.18
>>>> *To:* Ibrahim Bayoh <ibrahim.ba...@sl.ehealthafrica.org>
>>>> *Cc:* dhis2-users <dhis2-users@lists.launchpad.net>
>>>> *Subject:* Re: [Dhis2-users] Cant not create new approval levels in
>>>> 2.26
>>>>
>>>>
>>>>
>>>> Hi Bayoh,
>>>>
>>>>
>>>>
>>>> I have reproduced this problem in 2.26 and 2.27. I have created a Jira
>>>> ticket for this at https://jira.dhis2.org/browse/DHIS2-2449.
>>>>
>>>>
>>>>
>>>> Apologies for this problem. Thank you for bringing this to our
>>>> attention. We will fix it.
>>>>
>>>>
>>>>
>>>> Cheers,
>>>>
>>>> Jim
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> On Thu, Oct 26, 2017 at 7:30 AM, Ibrahim Bayoh <ibrahim.bayoh@sl.
>>>> ehealthafrica.org> wrote:
>>>>
>>>> Hi All,
>>>>
>>>> Am trying to create approval level in 2.26 which failed on saving
>>>> level. Console error reveals a "Missing required property 'name' " error.
>>>> See screenshots below.
>>>>
>>>> Thanks,
>>>>
>>>> Bayoh.
>>>>
>>>>
>>>>
>>>> [image: Screen Shot 2017-10-26 at 11.10.35 AM.png]
>>>>
>>>> [image: Screen Shot 2017-10-26 at 11.26.10 AM.png]
>>>>
>>>> --
>>>>
>>>> Ibrahim Bayoh
>>>>
>>>>
>>>> ___
>>>> 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
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> --
>>>>
>>>> Jim Grace
>>>>
>>>> Core developer, DHIS 2
>>>>
>>>> HISP US Inc.
>>>>
>>>> http://www.dhis2.org <https://www.dhis2.org/>
>>>>
>>> --
>>> Ibrahim Bayoh
>>>
>>
>>
>>
>> --
>> Jim Grace
>> Core developer, DHIS 2
>> HISP US Inc.
>> http://www.dhis2.org <https://www.dhis2.org/>
>>
> --
> Ibrahim Bayoh
>
> ___
> 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
>
>


-- 

*Jasper Timm*

Lead Software Developer

*eHealth Africa*

Mobile +232 99891119 <+23299891119>

www.ehealthafrica.org


<http://www.ehealthafrica.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] [Dhis2-devs] Error Message on Log

2017-05-29 Thread Jasper Timm
Maybe someone should change the logging level from 'Error' to 'Info' for
the message then?

On Mon, May 29, 2017 at 12:34 PM, gerald thomas 
wrote:

> Noted Lars!!!
>
> Thanks
>
> On 5/29/17, Lars Helge Øverland  wrote:
> > Hi Gerald,
> >
> > this is normal and is an internal system log message related to database
> > connections - nothing to worry about.
> >
> > regards,
> >
> > Lars
> >
> >
> > On Mon, May 29, 2017 at 1:51 PM, gerald thomas 
> > wrote:
> >
> >> Dear All,
> >>
> >> I am having the following errors:
> >>
> >> * ERROR 2017-05-29 00:46:10,458 Initialised statement manager
> >> (StatementInterceptor.java [tomcat-http-191])
> >> * ERROR 2017-05-29 00:46:15,648 Initialised statement manager
> >> (StatementInterceptor.java [tomcat-http-191])
> >> * ERROR 2017-05-29 00:46:42,437 Initialised statement manager
> >> (StatementInterceptor.java [tomcat-http-187])
> >> * ERROR 2017-05-29 00:46:47,430 Initialised statement manager
> >> (StatementInterceptor.java [tomcat-http-152])
> >>
> >> Any idea what is it means?
> >>
> >> --
> >> Regards,
> >>
> >> Gerald
> >>
> >> ___
> >> 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
> >>
> >
> >
> >
> > --
> > Lars Helge Øverland
> > Lead developer, DHIS 2
> > University of Oslo
> > Skype: larshelgeoverland
> > l...@dhis2.org
> > http://www.dhis2.org 
> >
>
>
> --
> Regards,
>
> Gerald
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> 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] SMS Gateway in 2.25

2017-01-30 Thread Jasper Timm
Hi there DHIS2 devs,

We've recently upgraded our DHIS2 instance from 2.22 to 2.25 (incrementally
through 2.23, 2.24 e.t.c. and the SQL upgrade scripts). As part of the
upgrade we were forced to remove our previous SMS gateway configuration and
re-add it after the upgrade to 2.25.

When looking at the SMS gateway configuration screen now though, I fail to
see the section which previously listed the status of the gateway and
allowed one to stop/start/restart e.t.c. Is this a known issue? The same
thing can be seen on the play instance:
https://play.dhis2.org/demo/dhis-web-maintenance-mobile/showSMSConfigureForm.action

As far as I can tell, the SMS gateway is not running on our instance, but I
get no errors in the logs regarding this.

Additionally, when attempting to access the SMS gateway config from the
API, it seems the endpoint listed in the documentation does not exist,
i.e.: /api/sms/gateways is not a valid endpoint. Is this known?

Cheers,

- Jasper
___
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] Compulsory data element not seems to be working

2016-10-27 Thread Jasper Timm
Hey Lars,

Thanks for the quick response!

We're actually running 2.22 here (as is the production Sierra Leone
national instance we're working in co-operation with I believe).

There seems to be some confusion with the functionality of compulsory data
elements though, in this previous thread you seemed to mention it was a
known bug that forms could be completed with blank compulsory data
elements: https://lists.launchpad.net/dhis2-users/msg10726.html

Was that a misunderstanding?

If so, what would you recommend? A data validation rule for each data
element which checks that it is not blank? Can this be done in one rule?

Thanks for your help,

- Jasper

On Thu, Oct 27, 2016 at 1:02 PM, Lars Helge Øverland <l...@dhis2.org> wrote:

> Hi there,
>
> 1)
>
> you are right, this was a bug that was fixed in 2.24. The problem is the
> uniqueness constraint on data element + option combo which simply should
> not be there.
>
> dataelement_operand_unique_key
>
> I have backported the fix to 2.23 as well now.
>
> 2)
>
> Per now, the compulsory elements are only used for reporting rate
> calculations, not to block completion of forms.
>
>
> regards,
>
> Lars
>
>
>
>
>
> On Thu, Oct 27, 2016 at 5:43 AM, Jasper Timm <jasper.timm@ehealthnigeria.
> org> wrote:
>
>> Hi all,
>>
>> Any chance we could get a DHIS2 developer to respond to these issues with
>> compulsory data elements?
>>
>> As I understand then, it seems to be two issues:
>>
>> 1.) Attempting to add data elements as compulsory to *certain* data sets
>> seems to result in a crash related to a uniqueness constraint being
>> violated: "duplicate key value violates unique constraint
>> "dataelement_operand_unique_key" Detail: Key (dataelementid,
>> categoryoptioncomboid)=(1627, 1596) already exists"
>>
>> 2.) When a data element *can* be successfully added to a data set as
>> compulsory, it appears it is not checked at all in the data validation
>> within data entry for the data set.
>>
>> Any help with either issue would be great.
>>
>> Thanks,
>>
>> - Jasper
>>
>> On Fri, Oct 21, 2016 at 10:08 AM, Ibrahim Bayoh <
>> ibrahim.ba...@sl.ehealthafrica.org> wrote:
>>
>>> Hi Lars,
>>> Regarding the Compulsory data element feature, it's still not been
>>> fixed. We've tested on 2.22 and 2.23 with almost the result.
>>>
>>>
>>>- From the 'Data Sets' screen in DHIS2
>>>- Select a Data Set
>>>- Right click it and then 'Edit Compulsory Data Elements'
>>>- Attempt to add one of the Data Elements to the DataSet
>>>- Hit 'Save'.
>>>
>>> The action fails, with a DHIS2 error screen asking you to go back, where
>>> the changes aren't saved.
>>>
>>> See log below.
>>>
>>>
>>>
>>>> From the 'Data Sets' screen in DHIS2, select a Data Set, click it and
>>>> then 'Edit Compulsory Data Elements'. Attempt to add one of these Data
>>>> Elements to the Data Set and hit 'Save'. The action fails, with a
>>>> DHIS2 error screen asking you to go back, where the changes aren't saved.
>>>
>>>
>>>> This appears to happen on both our dev server (2.22) and staging
>>>> (2.21), for all data set and data element combinations.
>>>
>>>
>>>> See log output below:
>>>
>>> `* INFO 2016-10-19 12:54:54,425 'admin' update
>>>> org.hisp.dhis.dataset.DataSet, name: georgeTest, uid: vjAYdNmic8v
>>>> (AuditLogUtil.java [http-apr-8080-exec-7])
>>>
>>> * WARN 2016-10-19 12:54:54,429 SQL Error: 0, SQLState: 23505
>>>> (SqlExceptionHelper.java [http-apr-8080-exec-7])
>>>
>>> * ERROR 2016-10-19 12:54:54,429 ERROR: duplicate key value violates
>>>> unique constraint "dataelement_operand_unique_key"
>>>
>>> Detail: Key (dataelementid, categoryoptioncomboid)=(1627, 1596) already
>>>> exists. (SqlExceptionHelper.java [http-apr-8080-exec-7])
>>>
>>> at org.springframework.orm.hibernate4.HibernateTransactionManag
>>>> er.convertHibernateAccessException(HibernateTransactionManag
>>>> er.java:730)
>>>
>>> at org.springframework.orm.hibernate4.HibernateTransactionManag
>>>> er.doCommit(HibernateTransactionManager.java:592)
>>>
>>> at org.springframework.transaction.support.AbstractPlatformTran
>>>> sactionManager.processCommit(AbstractPlatformTransactionMana
>>>> ger.java:757

Re: [Dhis2-users] Compulsory data element not seems to be working

2016-10-27 Thread Jasper Timm
Hi all,

Any chance we could get a DHIS2 developer to respond to these issues with
compulsory data elements?

As I understand then, it seems to be two issues:

1.) Attempting to add data elements as compulsory to *certain* data sets
seems to result in a crash related to a uniqueness constraint being
violated: "duplicate key value violates unique constraint
"dataelement_operand_unique_key" Detail: Key (dataelementid,
categoryoptioncomboid)=(1627, 1596) already exists"

2.) When a data element *can* be successfully added to a data set as
compulsory, it appears it is not checked at all in the data validation
within data entry for the data set.

Any help with either issue would be great.

Thanks,

- Jasper

On Fri, Oct 21, 2016 at 10:08 AM, Ibrahim Bayoh  wrote:

> Hi Lars,
> Regarding the Compulsory data element feature, it's still not been fixed.
> We've tested on 2.22 and 2.23 with almost the result.
>
>
>- From the 'Data Sets' screen in DHIS2
>- Select a Data Set
>- Right click it and then 'Edit Compulsory Data Elements'
>- Attempt to add one of the Data Elements to the DataSet
>- Hit 'Save'.
>
> The action fails, with a DHIS2 error screen asking you to go back, where
> the changes aren't saved.
>
> See log below.
>
>
>
>> From the 'Data Sets' screen in DHIS2, select a Data Set, click it and
>> then 'Edit Compulsory Data Elements'. Attempt to add one of these Data
>> Elements to the Data Set and hit 'Save'. The action fails, with a DHIS2
>> error screen asking you to go back, where the changes aren't saved.
>
>
>> This appears to happen on both our dev server (2.22) and staging (2.21),
>> for all data set and data element combinations.
>
>
>> See log output below:
>
> `* INFO 2016-10-19 12:54:54,425 'admin' update
>> org.hisp.dhis.dataset.DataSet, name: georgeTest, uid: vjAYdNmic8v
>> (AuditLogUtil.java [http-apr-8080-exec-7])
>
> * WARN 2016-10-19 12:54:54,429 SQL Error: 0, SQLState: 23505
>> (SqlExceptionHelper.java [http-apr-8080-exec-7])
>
> * ERROR 2016-10-19 12:54:54,429 ERROR: duplicate key value violates unique
>> constraint "dataelement_operand_unique_key"
>
> Detail: Key (dataelementid, categoryoptioncomboid)=(1627, 1596) already
>> exists. (SqlExceptionHelper.java [http-apr-8080-exec-7])
>
> at org.springframework.orm.hibernate4.HibernateTransactionManag
>> er.convertHibernateAccessException(HibernateTransactionManager.java:730)
>
> at org.springframework.orm.hibernate4.HibernateTransactionManag
>> er.doCommit(HibernateTransactionManager.java:592)
>
> at org.springframework.transaction.support.AbstractPlatformTran
>> sactionManager.processCommit(AbstractPlatformTransactionManager.java:757)
>
> at org.springframework.transaction.support.AbstractPlatformTran
>> sactionManager.commit(AbstractPlatformTransactionManager.java:726)
>
> at org.springframework.transaction.interceptor.TransactionAspec
>> tSupport.commitTransactionAfterReturning(TransactionAspectSu
>> pport.java:521)
>
> at org.springframework.transaction.interceptor.TransactionAspec
>> tSupport.invokeWithinTransaction(TransactionAspectSupport.java:291)
>
> at org.springframework.transaction.interceptor.TransactionInter
>> ceptor.invoke(TransactionInterceptor.java:96)
>
> at org.springframework.aop.framework.ReflectiveMethodInvocation
>> .proceed(ReflectiveMethodInvocation.java:179)
>
> at org.springframework.aop.interceptor.ExposeInvocationIntercep
>> tor.invoke(ExposeInvocationInterceptor.java:92)
>
> at org.springframework.aop.framework.ReflectiveMethodInvocation
>> .proceed(ReflectiveMethodInvocation.java:179)
>
> at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(
>> JdkDynamicAopProxy.java:207)
>
> at com.sun.proxy.$Proxy99.updateDataSet(Unknown Source)
>
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce
>> ssorImpl.java:62)
>
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe
>> thodAccessorImpl.java:43)
>
> at java.lang.reflect.Method.invoke(Method.java:498)
>
> at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction
>> (DefaultActionInvocation.java:450)
>
> at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction
>> Only(DefaultActionInvocation.java:289)
>
> at com.opensymphony.xwork2.DefaultActionInvocation.invoke(Defau
>> ltActionInvocation.java:252)
>
> at org.hisp.dhis.webportal.interceptor.XWorkPortalUserIntercept
>> or.intercept(XWorkPortalUserInterceptor.java:85)
>
> at com.opensymphony.xwork2.DefaultActionInvocation.invoke(Defau
>> ltActionInvocation.java:246)
>
> at org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterce
>> ptor.intercept(XWorkPortalModuleInterceptor.java:91)
>
> at com.opensymphony.xwork2.DefaultActionInvocation.invoke(Defau
>> ltActionInvocation.java:246)
>
> at org.hisp.dhis.webportal.interceptor.XWorkPortalMenuIntercept
>> or.intercept(XWorkPortalMenuInterceptor.java:94)
>
> at