dhis2-devs team mailing list archive

[chathura widanage <chathurawidanage@xxxxxxxxx>]

Hi Morten,

We found a problem in the SQL Views as well. SQLView/{id}/data endpoint is
not working in v2.24 (23583,2016-08-25 07:50) and we can't even define new
SQL views from the Data Administration app.

stack trace :
https://dl.dropboxusercontent.com/u/81780569/sql_stack_trace.txt

Same sql views are working fine in a 2.23 (23041,
​
2016-06-30 20:26) instance.

Thank you.

On Thu, Aug 25, 2016 at 6:10 PM, chathura widanage <
chathurawidanage@xxxxxxxxx> wrote:

> Thank you Morten.
>
> On 25 Aug 2016 13:00, "Pamod Amarakoon" <pamodm@xxxxxxxxx> wrote:
>
>> 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.
>>
>>
>>
>>


-- 
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>