dhis2-devs team mailing list archive

[Morten Olav Hansen <morten@xxxxxxxxx>]

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&
> attribute=izuwkaOUgFg&attribute=C8DBAo2wEYN&attribute=BZEpuufLyDE&
> 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
>
>