[Dhis2-devs] Using form name in Dashboard/Pivot/Visualizer

[Nayeem Al Mifthah]

Dear All
Is it possible to show data element "form name" in
dashboard/pivot/visualizer?

I can show, name or short name.


*Nayeem Al Mifthah*
*Consultant for HSS, Health MIS, M&E*
Email: n.mift...@gmail.com
Cell:+8801914030574
Skype: nayeem.a.m
___
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] Using form name in Dashboard/Pivot/Visualizer

[Lars Helge Øverland]

Hi Nayeem,

that is not possible per now, and we are not planning to change this. The
reason is that the form name is intended for use only within forms, whereas
we encourage the use of clear and self-descriptive names/short names for
use in output apps.

best regards,

Lars


On Sun, Oct 9, 2016 at 10:42 AM, Nayeem Al Mifthah 
wrote:

> Dear All
> Is it possible to show data element "form name" in
> dashboard/pivot/visualizer?
>
> I can show, name or short name.
>
>
> *Nayeem Al Mifthah*
> *Consultant for HSS, Health MIS, M&E*
> 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
>
>


-- 
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] custom form in Tracker Capture

[channara rin]

Dear alex,
thank you alot :-)
But could you give example one attribute for me? i don't know how to use
that script...

On Thu, Oct 6, 2016 at 5:36 PM, Alex Tumwesigye 
wrote:

> Dear Channara,
>
> Use angular $watch to watch the models changes.
>
>
> Attribute model is $scope.selectedTei.uid
> event model is $scope.currentEvent.uid
>
> For Jquery,
> use $(selectedTei.uid).val("Your value").trigger('input');
>
> For angular,
> This $scope.selectedTei.uid will pick your value, however, you will need
> $watch to watch for changes.
>
>  Note uid is the dhis2 11 character identifier.
>
> Alex
>
> On Thu, Oct 6, 2016 at 12:47 PM, channara rin 
> wrote:
>
>> Dear all,
>> do you know any jquery script for tracker capture custom form to catch
>> require attributes fields and unique attribute field?
>>
>> for example, when i edit client's profile in tracker capture. if i do
>> some things wrong format of attribute fields, when i click update/save. i
>> didn't see any popup message what i did wrong. but when i look console. i
>> saw error of jax to use "PUT" on 404 message.
>>
>> thank you
>> channara
>>
>> ___
>> 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
>>
>>
>
>
> --
> 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-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] custom form in Tracker Capture

[shyam tayal]

hello , i am new here, Want to contribure .Confused where to start ? any
directions?
Any help will be appreciated .

On Sun, Oct 9, 2016 at 6:53 PM, channara rin  wrote:

> Dear alex,
> thank you alot :-)
> But could you give example one attribute for me? i don't know how to use
> that script...
>
> On Thu, Oct 6, 2016 at 5:36 PM, Alex Tumwesigye 
> wrote:
>
>> Dear Channara,
>>
>> Use angular $watch to watch the models changes.
>>
>>
>> Attribute model is $scope.selectedTei.uid
>> event model is $scope.currentEvent.uid
>>
>> For Jquery,
>> use $(selectedTei.uid).val("Your value").trigger('input');
>>
>> For angular,
>> This $scope.selectedTei.uid will pick your value, however, you will need
>> $watch to watch for changes.
>>
>>  Note uid is the dhis2 11 character identifier.
>>
>> Alex
>>
>> On Thu, Oct 6, 2016 at 12:47 PM, channara rin 
>> wrote:
>>
>>> Dear all,
>>> do you know any jquery script for tracker capture custom form to catch
>>> require attributes fields and unique attribute field?
>>>
>>> for example, when i edit client's profile in tracker capture. if i do
>>> some things wrong format of attribute fields, when i click update/save. i
>>> didn't see any popup message what i did wrong. but when i look console. i
>>> saw error of jax to use "PUT" on 404 message.
>>>
>>> thank you
>>> channara
>>>
>>> ___
>>> 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
>>>
>>>
>>
>>
>> --
>> 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-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Best Regards
Shyam Tayal
Department of Computer Science
Shri Mata Vaishnodevi University
Jammu & Kashmir
___
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] [API Tests] Data Administration - Option Set

[Paulo Grácio]

Hi devs,

should it be possible to update existent Option Set type from 'INTEGER' to
‘TEXT'?

Test Case:
https://github.com/dhis2/api-tests/blob/master/modules/data-admin/optionSet.js#L77
Failing Job: https://travis-ci.org/dhis2/api-tests/jobs/166211140

BR,
Paulo Grácio
___
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] Cannot create new program stage reminder template

[Sam Johnson]

Hi all,

Still banging my head against the wall with this one.  Is there any schema 
documentation available for DHIS2?

Cheers, Sam.


From: Dhis2-devs 
 on behalf of 
Sam Johnson 
Date: Friday, 7 October 2016 at 15:11
To: DHIS2 Developers 
Subject: Re: [Dhis2-devs] Cannot create new program stage reminder template

Hi all,

Am still struggling with this missing UID bug on my own instance.  Does anyone 
know the name of the table into which these ProgramStage reminder templates are 
persisted?  (Is there any schema documentation available for DHIS2?)

Cheers, Sam.


From: Dhis2-devs 
 on behalf of 
Sam Johnson 
Date: Thursday, 6 October 2016 at 13:48
To: Lars Helge Øverland , Knut Staring 
Cc: DHIS2 Developers 
Subject: Re: [Dhis2-devs] Cannot create new program stage reminder template

Hi Knut and Lars,

Many thanks for such a prompt response.

Knut, thanks for the reminder about the upgrade notes; apologies, I should have 
been clearer: I did actually follow these upgrade instructions, noting the one 
SQL script (which I didn’t bother running, as at the time I hadn’t created any 
program rule variables, and was only using programs-with-registration anyway).  
But I was wondering if any further scripts were required for the updates that 
have been done to 2.24, since I started with a very early release of 2.24?

Lars, I’ve unfortunately developed a proof-of-concept which I need to 
demonstrate in the next day or two, and I’m guessing that 2.25 isn’t yet stable 
enough for a client-facing demo?  (I’d need to be sure that all aspects of a 
complex Tracker program would run smoothly!)

In the meantime, do you have any idea why I’m getting this UID error?  What 
seems to be missing from that failed row?

Cheers, Sam.


From: Lars Helge Øverland 
Date: Thursday, 6 October 2016 at 12:47
To: Sam Johnson 
Cc: DHIS2 Developers 
Subject: Re: [Dhis2-devs] Cannot create new program stage reminder template

Hi Sam,

okay. You would probably like to know that for 2.25, the "reminder message 
template" functionality has been replaced by a new version referred to as 
"program notifications" and "program stage notifications". This is a better 
implementation of the notifications system and is mostly equivalent in terms of 
features.

https://www.dhis2.org/225-upgrade

Are you able to upgrade to 2.25 snapshot?

best regards,

Lars





On Thu, Oct 6, 2016 at 1:26 PM, Sam Johnson 
mailto:samuel.john...@qebo.co.uk>> wrote:
Hi all,

I’m using a 2.24 instance which I’ve just updated to 704143a, and am attempting 
to create reminder templates on a repeatable program stage.  I can successfully 
use the front end to create this reminder on one of the program stages on 
play.dhis2.org/demo, but when I attempt it in my 
own instance, I get the ‘An exception occurred’ page, with the following log 
entries:
Caused by: org.postgresql.util.PSQLException: ERROR: null value in column "uid" 
violates not-null constraint
Detail: Failing row contains (1190, null, null, null, null, ANCReminder, -1, 
This is a reminder that you are due to come to the clinic for a ..., null, 1, 
2, 1, null, null, null).

Why would my instance not be populating this uid column?  (I’ve tested this 
same reminder on other program stages and on the program itself, and all 
attempts at saving return the same error.)

A couple of notes:

• My instance was originally installed as 2.21, and upgraded to 2.22, 
2.23 and then 2.24.

• My user has a role with ‘ALL’ and every other authority in it, and 
has all programs assigned to it.

• I’ve done all updates to 2.24 by simply replacing the .war file – 
were any database scripts required for any updates?

Many thanks for any help you can give, as I’m currently stuck and unable to 
create reminders!

Cheers, Sam.


___
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] SQL Views Dependency Issue

[chathura widanage]

Hi,
Any update on this?

Thanks

On Thu, Oct 6, 2016 at 11:27 AM, chathura widanage <
chathurawidan...@gmail.com> wrote:

> Hi Lars,
>
> We have two sets of SQL Views,
>
> -
> dnms nutrition last event (A)
> dnms nutrition psi pi map(B)
>
> Here A depends on B
> ---
> dnms risk last event (C)
> dnms risk psi pi map (D)
>
> Here C depends on D
> ---
>
> Problem is, from above two sets just the first set fails during
> maintenance procedure. Following your directions, I tried changing the
> names of the views to make B and D come Alphabetically before A and C. Then
> second set started to fail during maintenance.  Any reason for this to
> happen?
>
> Thanks,
> Chathura
>
>
>
>
>
> On Tue, Oct 4, 2016 at 3:41 PM, Lars Helge Øverland 
> wrote:
>
>> Hi Chathura,
>>
>> currently the approach to achieve this is to rely on the alphabetical
>> ordering of SQL view names. For the scheduled tasks, the system first drops
>> the SQL views in *reversed* alphabetical order. Finally, the system
>> regenerates the SQL views in alphabetical order.
>>
>> So in your case where A depends on B, you should ensure that that the
>> name of SQL view B comes before the name of SQL view A alphabetically. This
>> way, the system will first drop A, then B, and when it is time to
>> regenerate the views, first generate B, then A, and you should be good.
>>
>> best regards,
>>
>> Lars
>>
>> On Tue, Oct 4, 2016 at 11:10 AM, chathura widanage <
>> chathurawidan...@gmail.com> wrote:
>>
>>> Dear Devs,
>>>
>>> We have two SQLViews created in DHIS2 v2.24 where one view depends on
>>> other one(Say, A depends on B). We have also scheduled an automatic
>>> maintenance event every day at 12.00 a.m. Problem is DHIS2 tries to drop
>>> view B first during this automated procedure and as a result whole
>>> procedure fails including analytics table generation.
>>>
>>> Is there a way to make DHIS2 scheduled event drop A before B in above
>>> case.
>>>
>>> Thanks & Regards,
>>> Chathura Widanage
>>>
>>> ___
>>> 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 
>>
>>
>
>
> --
> Best Regards,
>
> *Chathura Widanage,*
> Undergraduate,
> Department of Computer Science and Engineering,
> University of Moratuwa,
> Sri Lanka
>
> 
>   
> 
> 
>



-- 
Best Regards,

*Chathura Widanage,*
Undergraduate,
Department of Computer Science and Engineering,
University of Moratuwa,
Sri Lanka

  


___
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] [API Tests] Data Administration - Option Set #2

[Paulo Grácio]

Hi devs,

should it be able to update existent Option Set code from 'TEST_OPTION_SET'
to 'TEST_OPTION_SET_NEW'?

Test Case:
https://github.com/dhis2/api-tests/blob/master/modules/data-admin/optionSet.js#L62
Failing Job: https://travis-ci.org/dhis2/api-tests/jobs/166235371
Version: 2.23-20161008

BR,
Paulo Grácio
___
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] [API Tests] Data Administration - Option Set #2

[Paulo Grácio]

Correction:

Version: 2.*24*-20161008

On Sun, Oct 9, 2016 at 7:40 PM Paulo Grácio  wrote:

> Hi devs,
>
> should it be able to update existent Option Set code from
> 'TEST_OPTION_SET' to 'TEST_OPTION_SET_NEW'?
>
> Test Case:
> https://github.com/dhis2/api-tests/blob/master/modules/data-admin/optionSet.js#L62
> Failing Job: https://travis-ci.org/dhis2/api-tests/jobs/166235371
> Version: 2.23-20161008
>
> BR,
> Paulo Grácio
>
___
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] Cannot create new program stage reminder template

[Knut Staring]

I don't think so, unfortunately. Perhaps the programmessage table?

On Sun, Oct 9, 2016 at 6:55 PM, Sam Johnson 
wrote:

> Hi all,
>
>
>
> Still banging my head against the wall with this one.  Is there any schema
> documentation available for DHIS2?
>
>
>
> Cheers, Sam.
>
>
>
>
>
> *From: *Dhis2-devs  launchpad.net> on behalf of Sam Johnson 
> *Date: *Friday, 7 October 2016 at 15:11
> *To: *DHIS2 Developers 
>
> *Subject: *Re: [Dhis2-devs] Cannot create new program stage reminder
> template
>
>
>
> Hi all,
>
>
>
> Am still struggling with this missing UID bug on my own instance.  Does
> anyone know the name of the table into which these ProgramStage reminder
> templates are persisted?  (Is there any schema documentation available for
> DHIS2?)
>
>
>
> Cheers, Sam.
>
>
>
>
>
> *From: *Dhis2-devs  launchpad.net> on behalf of Sam Johnson 
> *Date: *Thursday, 6 October 2016 at 13:48
> *To: *Lars Helge Øverland , Knut Staring  >
> *Cc: *DHIS2 Developers 
> *Subject: *Re: [Dhis2-devs] Cannot create new program stage reminder
> template
>
>
>
> Hi Knut and Lars,
>
>
>
> Many thanks for such a prompt response.
>
>
>
> Knut, thanks for the reminder about the upgrade notes; apologies, I should
> have been clearer: I did actually follow these upgrade instructions, noting
> the one SQL script (which I didn’t bother running, as at the time I hadn’t
> created any program rule variables, and was only using
> programs-with-registration anyway).  But I was wondering if any further
> scripts were required for the *updates* that have been done to 2.24,
> since I started with a very early release of 2.24?
>
>
>
> Lars, I’ve unfortunately developed a proof-of-concept which I need to
> demonstrate in the next day or two, and I’m guessing that 2.25 isn’t yet
> stable enough for a client-facing demo?  (I’d need to be sure that all
> aspects of a complex Tracker program would run smoothly!)
>
>
>
> In the meantime, do you have any idea why I’m getting this UID error?
> What seems to be missing from that failed row?
>
>
>
> Cheers, Sam.
>
>
>
>
>
> *From: *Lars Helge Øverland 
> *Date: *Thursday, 6 October 2016 at 12:47
> *To: *Sam Johnson 
> *Cc: *DHIS2 Developers 
> *Subject: *Re: [Dhis2-devs] Cannot create new program stage reminder
> template
>
>
>
> Hi Sam,
>
>
>
> okay. You would probably like to know that for 2.25, the "reminder message
> template" functionality has been replaced by a new version referred to as
> "program notifications" and "program stage notifications". This is a better
> implementation of the notifications system and is mostly equivalent in
> terms of features.
>
>
>
> https://www.dhis2.org/225-upgrade
>
>
>
> Are you able to upgrade to 2.25 snapshot?
>
>
>
> best regards,
>
>
>
> Lars
>
>
>
>
>
>
>
>
>
>
>
> On Thu, Oct 6, 2016 at 1:26 PM, Sam Johnson 
> wrote:
>
> Hi all,
>
>
>
> I’m using a 2.24 instance which I’ve just updated to 704143a, and am
> attempting to create reminder templates on a repeatable program stage.  I
> can successfully use the front end to create this reminder on one of the
> program stages on play.dhis2.org/demo, but when I attempt it in my own
> instance, I get the ‘An exception occurred’ page, with the following log
> entries:
>
> Caused by: org.postgresql.util.PSQLException: ERROR: null value in column
> "uid" violates not-null constraint
>
> Detail: Failing row contains (1190, null, null, null, null, ANCReminder,
> -1, This is a reminder that you are due to come to the clinic for a ...,
> null, 1, 2, 1, null, null, null).
>
>
>
> Why would my instance not be populating this uid column?  (I’ve tested
> this same reminder on other program stages and on the program itself, and
> all attempts at saving return the same error.)
>
>
>
> A couple of notes:
>
> · My instance was originally installed as 2.21, and upgraded to
> 2.22, 2.23 and then 2.24.
>
> · My user has a role with ‘ALL’ *and* every other authority in
> it, and has all programs assigned to it.
>
> · I’ve done all updates to 2.24 by simply replacing the .war file
> – were any database scripts required for any updates?
>
>
>
> Many thanks for any help you can give, as I’m currently stuck and unable
> to create reminders!
>
>
>
> Cheers, Sam.
>
>
>
>
> ___
> 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
>
>


-- 
Knut Staring
Dept. of Informatics, University of Oslo
Norway: 

Re: [Dhis2-devs] [API Tests] Data Administration - Option Set

[Jason Pickering]

Hi Paulo,

I would expect that this operation should be disallowed by the server. The
reason for this is that once you have established that a given option set
has a type "INTEGER" , you should not be able to change this afterwards to
a different type. It seems the test is correct to me, but from the results
of the test, it seems it is possible to update.

Maybe the developers can comment more?

Regards,
Jason


On Sun, Oct 9, 2016 at 5:58 PM, Paulo Grácio  wrote:

> Hi devs,
>
> should it be possible to update existent Option Set type from 'INTEGER' to
> ‘TEXT'?
>
> Test Case: https://github.com/dhis2/api-tests/blob/master/modules/
> data-admin/optionSet.js#L77
> Failing Job: https://travis-ci.org/dhis2/api-tests/jobs/166211140
>
> BR,
> Paulo Grácio
>
> ___
> 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
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
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] Upgrading DHIS2 from 2.21 to 2.24 and using new exporter/importer

[Aamer Mohammed]

Hi Lars/Morten,

This is reproducible on 2.25 as well. Any updates regarding this issue. Let
us know if any further details are required from our end.


Thanks
Aamer.


On Thu, Oct 6, 2016 at 4:12 PM, Aamer Mohammed 
wrote:

> Hi Lars,
>
> Thanks for the fix (removal of constraint). Yes we are trying to import
> the metadata into a new 2.24 db. The metadata is exported from an instance
> which is upgraded from 2.21 to 2.24.
>
> 1) After your fix, there is no constraint violation error and we are able
> to continue further. But this time we got the below issue in the later part
> of the import.
> ---
> * INFO  2016-10-06 11:46:09,906 (admin) Creating 1003 object(s) of type
> ReportTable (DefaultObjectBundleService.java [qtp923727115-15])
> org.hibernate.TransientObjectException: object references an unsaved
> transient instance - save the transient instance before flushing:
> org.hisp.dhis.dataelement.DataElement
> 
>
> The complete stack trace is also attached. Any suggestions please.
>
>
> Thanks
> Aamer.
>
>
> On Tue, Oct 4, 2016 at 1:23 PM, Lars Helge Øverland 
> wrote:
>
>> Hi Aamer,
>>
>>
>> On Thu, Sep 29, 2016 at 1:31 PM, Aamer Mohammed 
>> wrote:
>>
>>> Hi,
>>>
>>> For continuation of testing, we changed the metadata to ensure that a
>>> Group can be part of only one GroupSet.
>>> 1) We got the below issue.
>>> {"status":"ERROR","stats":{"total":1,"created":0,"updated":0
>>> ,"deleted":0,"ignored":1},"typeReports":[{"klass":"org.hisp.
>>> dhis.indicator.Indicator","stats":{"total":1,"created":0,"up
>>> dated":0,"deleted":0,"ignored":1},"objectReports":[{"klass":
>>> "org.hisp.dhis.indicator.Indicator","index":277,"uid":"oMbEl
>>> S3lhOO","errorReports":[{"message":"Missing required property
>>> `numerator`.","mainKlass":"org.hisp.dhis.indicator.Indicator
>>> ","errorKlass":"java.lang.String","errorCode":"E4000"}]}]}]}
>>>
>>> which means that Numerator is required field for an indicator. This was
>>> not the case in 2.21. This restriction was introduced in some version after
>>> 2.21. However, we modified the metadata for the indicator having this issue
>>> and proceeded further.
>>>
>>>
>> Right, we did make indicator numerator and denominator not-null in the
>> schema. You can say that this is something we should have done from the
>> very start. In 2.24 we tightened up the schema, which is very helpful to
>> avoid problems in the source code, but could require some modifications in
>> existing solutions.
>>
>>
>>
>>
>>> 2) Now we got the below issue.
>>> {"httpStatus":"Internal Server Error","httpStatusCode":500,"s
>>> tatus":"ERROR","message":"ERROR: duplicate key value violates unique
>>> constraint \"dataelement_operand_unique_key\"\n  Detail: Key
>>> (dataelementid, categoryoptioncomboid)=(4497, 3576) already exists."}
>>>
>>> This means that you cannot have duplicate combination of (dataelementid,
>>> categoryoptioncomboid) in dataelementoperand table. This constraint was not
>>> present in 2.21 version.
>>> When we see dataelementoperand table, there are lot of such duplicates.
>>> We would like to understand more around this constraint and why it was
>>> introduced.
>>> *Is there any note which has the details about the constraints being
>>> introduced in a DHIS version?*
>>>
>>
>> This is interesting because i) it has been like this for many years and
>> ii) I agree this constraint should not be there. Not sure why this surfaced
>> now - likely because you have started a new db. I have removed this
>> constraint in master and 2.24 now.
>>
>>
>> best regards,
>>
>> Lars
>>
>>
>>> 3) Also this constraint (dataelement_operand_unique_key) is not present
>>> in the instance which was upgraded from 2.21 to 2.24. But it is present in
>>> the instance which is directly on 2.24. Any thoughts on this. Did the
>>> constraint not get created in upgraded instance because the data was not
>>> abiding to the constraint rules? What happens in a dhis upgrade if there is
>>> any constraint being introduced and existing data does not confirm to the
>>> constraint? Please suggest.
>>>
>>>
>>> Thanks
>>> Aamer.
>>>
>>>
>>> On Sat, Sep 24, 2016 at 5:54 PM, Lars Helge Øverland 
>>> wrote:
>>>
 Hi Aamer,

 the problem here happens because the hibernate mapping between GroupSet
 and Group is one-to-many, ie. a Group can only be part of one GroupSet.

 There is a reason for this, but it is not very good ;) When we store
 favorites with group sets, we need to know which dimension (GroupSet) a
 dimension item (Group) is part of. If the Group is part of many GroupSets,
 we need another link object in between to represent which dimension it is
 part of. This can clearly be done and this is something we plan to fix, but
 it is a bit of work and it requires an upgrade routine to upgrade existing
 databases.

 So I am pretty sure that is why you see these duplicates: You have
 groups which are part of multiple group sets. In these cases, Hib

[Dhis2-devs] [Issue] Unable to create Event Reports and Event Charts

[Archana Chillala]

Hi Team,

We are using DHIS version 2.24 (revision - 704143a6). We are unable to
create Event Charts and Event Reports on their respective apps (Event
Visualiser and Event Reports). After we set the chart/table configuration
and click on 'update', the chart/table does not load at all. Events have
got data and we've exported analytics as well. The same is happening on the
play server as well. Could you please look into the issue and help resolve
it?


*Cheers,*

Archana Chillala
Application Developer
Email archa...@thoughtworks.com
Telephone +91 9100960533 <+91+9100960533>
[image: ThoughtWorks]

___
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] [API Tests] Data Administration - Option Set

[Mark Polak]

Hey Paolo,

We have made this action unavailable in the UI, as like Jason says, this is
generally not something you would want.

I would say the test case is indeed correct. We should enforce the same
logic on the server.

On Mon, Oct 10, 2016 at 6:32 AM, Jason Pickering <
jason.p.picker...@gmail.com> wrote:

> Hi Paulo,
>
> I would expect that this operation should be disallowed by the server. The
> reason for this is that once you have established that a given option set
> has a type "INTEGER" , you should not be able to change this afterwards to
> a different type. It seems the test is correct to me, but from the results
> of the test, it seems it is possible to update.
>
> Maybe the developers can comment more?
>
> Regards,
> Jason
>
>
> On Sun, Oct 9, 2016 at 5:58 PM, Paulo Grácio 
> wrote:
>
>> Hi devs,
>>
>> should it be possible to update existent Option Set type from 'INTEGER'
>> to ‘TEXT'?
>>
>> Test Case: https://github.com/dhis2/api-tests/blob/master/modules/data-
>> admin/optionSet.js#L77
>> Failing Job: https://travis-ci.org/dhis2/api-tests/jobs/166211140
>>
>> BR,
>> Paulo Grácio
>>
>> ___
>> 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
>>
>>
>
>
> --
> Jason P. Pickering
> email: jason.p.picker...@gmail.com
> tel:+46764147049
>
> ___
> 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,


Mark Polak
Software developer, DHIS 2
University of Oslo
http://www.dhis2.org 
m...@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] [Issue] Unable to create Event Reports and Event Charts

[Archana Chillala]

Also, the logs don't show any errors at all.

Archana Chillala
Application Developer
Email archa...@thoughtworks.com
Telephone +91 9100960533 <+91+9100960533>
[image: ThoughtWorks]


On Mon, Oct 10, 2016 at 11:41 AM, Archana Chillala <
archa...@thoughtworks.com> wrote:

> Hi Team,
>
> We are using DHIS version 2.24 (revision - 704143a6). We are unable to
> create Event Charts and Event Reports on their respective apps (Event
> Visualiser and Event Reports). After we set the chart/table configuration
> and click on 'update', the chart/table does not load at all. Events have
> got data and we've exported analytics as well. The same is happening on the
> play server as well. Could you please look into the issue and help resolve
> it?
>
>
> *Cheers,*
>
> Archana Chillala
> Application Developer
> Email archa...@thoughtworks.com
> Telephone +91 9100960533 <+91+9100960533>
> [image: ThoughtWorks]
> 
>
___
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] [API Tests] Data Administration - Option Set

[Paulo Grácio]

Hi Mark,

Ok. I'll keep the test disabled for now and we can enable it again once the
fix is released on the API side.

Thanks,
Paulo

On Mon, Oct 10, 2016 at 8:28 AM Mark Polak  wrote:

> Hey Paolo,
>
> We have made this action unavailable in the UI, as like Jason says, this
> is generally not something you would want.
>
> I would say the test case is indeed correct. We should enforce the same
> logic on the server.
>
> On Mon, Oct 10, 2016 at 6:32 AM, Jason Pickering <
> jason.p.picker...@gmail.com> wrote:
>
> Hi Paulo,
>
> I would expect that this operation should be disallowed by the server. The
> reason for this is that once you have established that a given option set
> has a type "INTEGER" , you should not be able to change this afterwards to
> a different type. It seems the test is correct to me, but from the results
> of the test, it seems it is possible to update.
>
> Maybe the developers can comment more?
>
> Regards,
> Jason
>
>
> On Sun, Oct 9, 2016 at 5:58 PM, Paulo Grácio 
> wrote:
>
> Hi devs,
>
> should it be possible to update existent Option Set type from 'INTEGER' to
> ‘TEXT'?
>
> Test Case:
> https://github.com/dhis2/api-tests/blob/master/modules/data-admin/optionSet.js#L77
> Failing Job: https://travis-ci.org/dhis2/api-tests/jobs/166211140
>
> BR,
> Paulo Grácio
>
> ___
> 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
>
>
>
>
> --
> Jason P. Pickering
> email: jason.p.picker...@gmail.com
> tel:+46764147049
>
> ___
> 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,
>
>
> Mark Polak
> Software developer, DHIS 2
> University of Oslo
> http://www.dhis2.org 
> m...@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