dhis2-devs team mailing list archive

[Pamod Amarakoon <pamodm@xxxxxxxxx>]

Thank you Morten.

On Thu, Aug 25, 2016 at 12:50 PM, Morten Olav Hansen <morten@xxxxxxxxx>
wrote:

> Give our servers about 1 hour, and you can download the fix for 2.23, 2.24
> and trunk
>
> --
> Morten Olav Hansen
> Senior Engineer, DHIS 2
> University of Oslo
> http://www.dhis2.org
>
> On Thu, Aug 25, 2016 at 2:02 PM, Morten Olav Hansen <morten@xxxxxxxxx>
> wrote:
>
>> Looking into it now Pamod, sorry for the delay.. I have recreated the bug
>> locally and working on a fix
>>
>> --
>> Morten Olav Hansen
>> Senior Engineer, DHIS 2
>> University of Oslo
>> http://www.dhis2.org
>>
>> On Wed, Aug 24, 2016 at 12:33 PM, Pamod Amarakoon <pamodm@xxxxxxxxx>
>> wrote:
>>
>>> Hi Morten,
>>>
>>> Just wondering whether this has been fixed.
>>>
>>> Thank you
>>>
>>> On Wed, Aug 17, 2016 at 7:24 PM, Pamod Amarakoon <pamodm@xxxxxxxxx>
>>> wrote:
>>>
>>>> Thank you Morten.
>>>>
>>>> On Wed, Aug 17, 2016 at 7:10 PM, Morten Olav Hansen <morten@xxxxxxxxx>
>>>> wrote:
>>>>
>>>>> Seems like a bug yes, I will look into it
>>>>>
>>>>> --
>>>>> Morten Olav Hansen
>>>>> Senior Engineer, DHIS 2
>>>>> University of Oslo
>>>>> http://www.dhis2.org
>>>>>
>>>>> On Mon, Aug 15, 2016 at 10:34 AM, chathura widanage <
>>>>> chathurawidanage@xxxxxxxxx> wrote:
>>>>>
>>>>>> Hi all,
>>>>>>
>>>>>> I am using below API call to query all the TEIs which are accessible
>>>>>> by the current user.
>>>>>>
>>>>>> /api/trackedEntityInstances/query.json?ouMode=ACCESSIBLE&att
>>>>>> ribute=izuwkaOUgFg&attribute=C8DBAo2wEYN&attribute=BZEpuufLy
>>>>>> DE&attribute=WqdldQpOIxm
>>>>>>
>>>>>> In our setup,  we have 5 orgUnitLevels and above query works fine for
>>>>>> superuser who has just one orgUnit assigned which is of level 1.
>>>>>>
>>>>>> There are other users who has multiple level 4 and 5 orgUnits
>>>>>> assigned. Above API call fails for those users giving a 500 error code.
>>>>>> Basically this doesn't work for any user who has multiple orgUnits.
>>>>>>
>>>>>> The cause for the issue seems to be a SQL syntax error.
>>>>>>
>>>>>> Please find the link to the stack trace below.
>>>>>>
>>>>>> https://dl.dropboxusercontent.com/u/81780569/stack.txt
>>>>>>
>>>>>> The issue was visible in DHIS2 v2.23 and v2.24.
>>>>>>
>>>>>> Have I done something wrong in the above API call or is this a bug in
>>>>>> the DHIS2. Is there any walk around for this issue?
>>>>>>
>>>>>> Thanks
>>>>>> --
>>>>>> Best Regards,
>>>>>>
>>>>>> *Chathura Widanage,*
>>>>>> Undergraduate,
>>>>>> Department of Computer Science and Engineering,
>>>>>> University of Moratuwa,
>>>>>> Sri Lanka
>>>>>>
>>>>>> <https://www.linkedin.com/profile/public-profile-settings?trk=prof-edit-edit-public_profile>
>>>>>>   <http://facebook.com/chathura.widanage>
>>>>>> <https://plus.google.com/u/0/109418781686423002025>
>>>>>> <https://github.com/chathurawidanage>
>>>>>>
>>>>>> _______________________________________________
>>>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>>
>>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> Regards,
>>>> Pamod Amarakoon
>>>>
>>>> Confidentiality Notice: the information contained in this email and any
>>>> attachments may be legally privileged and confidential. If you are not an
>>>> intended recipient, you are hereby notified that any dissemination,
>>>> distribution, or copying of this e-mail is strictly prohibited. If you have
>>>> received this e-mail in error, please notify the sender and permanently
>>>> delete the e-mail and any attachments immediately. You should not retain,
>>>> copy or use this e-mail or any attachments for any purpose, nor disclose
>>>> all or any part of the contents to any other person.
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>> --
>>> Regards,
>>> Pamod Amarakoon
>>>
>>> Confidentiality Notice: the information contained in this email and any
>>> attachments may be legally privileged and confidential. If you are not an
>>> intended recipient, you are hereby notified that any dissemination,
>>> distribution, or copying of this e-mail is strictly prohibited. If you have
>>> received this e-mail in error, please notify the sender and permanently
>>> delete the e-mail and any attachments immediately. You should not retain,
>>> copy or use this e-mail or any attachments for any purpose, nor disclose
>>> all or any part of the contents to any other person.
>>>
>>>
>>>
>>>
>>
>


-- 
Regards,
Pamod Amarakoon

Confidentiality Notice: the information contained in this email and any
attachments may be legally privileged and confidential. If you are not an
intended recipient, you are hereby notified that any dissemination,
distribution, or copying of this e-mail is strictly prohibited. If you have
received this e-mail in error, please notify the sender and permanently
delete the e-mail and any attachments immediately. You should not retain,
copy or use this e-mail or any attachments for any purpose, nor disclose
all or any part of the contents to any other person.