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 <pam...@gmail.com> wrote: > Hi Morten, > > Just wondering whether this has been fixed. > > Thank you > > On Wed, Aug 17, 2016 at 7:24 PM, Pamod Amarakoon <pam...@gmail.com> wrote: > >> Thank you Morten. >> >> On Wed, Aug 17, 2016 at 7:10 PM, Morten Olav Hansen <mor...@dhis2.org> >> 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 < >>> chathurawidan...@gmail.com> 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@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 >>> >>> >> >> >> -- >> 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. > > > >
_______________________________________________ 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