dhis2-devs team mailing list archive

[Rodolfo Melia <rmelia@xxxxxxxxxxxx>]

Hi I just want to report on the progress of status on this bug. Now the
report runs 'sometimes'. I've made a movie to show the problem in your
Sierra Leone dev server (2.12) - you will see that it works for Apgar Test,
but when you try to use the weight, the loading goes for ever...

http://www.youtube.com/watch?v=WrWtMZyBSv0

The movie also shows the status for our server (2.11): the issue is that
now it loads for Data Elements Date, Value and Text, but as soon as you add
a Yes/No or Yes only field, it loads with no answers... The end of the 2min
video show our Program.

There must be something wrong on the query for the select statement,
specially for the case when you add values that are based in True/False.
Regarding the 'loading...' for ever, I cannot think of a possible
explanation.

R


On Tue, May 14, 2013 at 2:10 PM, Rodolfo Melia <rmelia@xxxxxxxxxxxx> wrote:

> Hi - I just tested on 2.12, Sierra Leone (http://apps.dhis2.org/dev). The
> bug is gone.
> 2.11 at http://apps.dhis2.org/demo doens't yet have the latest release,
> so I cannot test. I will wait for 2.11 to be released, as that's the one
> that we have in our production servers.
>
> R
>
>
> On Tue, May 14, 2013 at 1:53 PM, Thu Tran <1179832@xxxxxxxxxxxxxxxxxx>wrote:
>
>> Dear Rodolfo,
>>
>> I fixed this bug in revision 10823 after James informed with me. Please
>> help me to test it again. If it's still there, please send to me the log
>> file. Thanks so much, Rodolfo.
>>
>>
>> On Tuesday, May 14, 2013, Rodolfo Melia <rmelia@xxxxxxxxxxxx> wrote:
>> > Hi Ola - we have scheduling active for our servers, and I'm assuming
>> that
>> you do for Sierra Leone's dev and demo sites. In any case, I just tried
>> re-generating the resource tables, and I still having the problem - it
>> tries loading for ever.
>> > I only reported this as a bug because I could easily reproduce it on you
>> demo & dev environment. Hopefully is something that can be addressed with
>> a
>> quick fix.
>> > R
>> >
>> > On Tue, May 14, 2013 at 10:01 AM, Ola Hodne Titlestad <olati@xxxxxxxxxx
>> >
>> wrote:
>> >>
>> >> Hi Rodolfo,
>> >>
>> >> Have you generated the resource tables?
>> >>
>> >> Tabular reports depends on the _organisationunitstructure table.
>> >>
>> >> This is generated as part of the nightly scheduled jobs, but if
>> >> scheduling is not started then you need to generate these resource
>> >> tables manually in Maintenance->Data Administration->Resource Tables.
>> >>
>> >> Ola
>> >> -------
>> >>
>> >> ----------------------------------
>> >> Ola Hodne Titlestad (Mr)
>> >> HISP
>> >> Department of Informatics
>> >> University of Oslo
>> >>
>> >> Mobile: +47 48069736
>> >> Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps link
>> >>
>> >>
>> >> On 14 May 2013 10:38, Rodolfo Melia <rmelia@xxxxxxxxxxxx> wrote:
>> >> > By the way, nothing shows on the catalina log, so no log output to
>> >> > add...
>> >> >
>> >> > --
>> >> > You received this bug notification because you are a member of DHIS 2
>> >> > developers, which is subscribed to DHIS.
>> >> > https://bugs.launchpad.net/bugs/1179832
>> >> >
>> >> > Title:
>> >> >   Tabular reporting doesn't load
>> >> >
>> >> > Status in DHIS 2 - District Health Information Software:
>> >> >   New
>> >> >
>> >> > Bug description:
>> >> >   Tabular report doesn't load any results. This applies to all type
>> of
>> >> >   programs (with and without registration). After selecting your
>> >> >   criteria, the 'loading' message appears, but it never displays any
>> >> >   answers. This is occurring in 2.11 and 2.12. I've tested on my own
>> >> >   environments as well as on http://apps.dhis2.org/dev &
>> >> >   http://apps.dhis2.org/demo
>> >> >
>> >> >   On an old 2.11, for which tabular report works, everything loads
>> until
>> >> >   you add a data element of type 'Yes Only' or 'Yes/No'. I believe
>> that
>> >> >   because there are records with Null values, then the whole answer
>> >> >   query gets cancelled, resulting in no records returned.
>> >> >
>> >> >   Let me know if you need further info.
>> >> >
>> >> > To manage notifications about this bug go to:
>> >> > https://bugs.launchpad.net/dhis2/+bug/1179832/+subscriptions
>> >> >
>> >> > _______________________________________________
>> >> > 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
>> >
>> >
>> >
>> > --
>> > Rodolfo Meliá
>> > Principal
>> > rmelia@xxxxxxxxxxxx
>> > www.knowming.com
>> > +1 708 872 7636
>> > +44 777 576 4090
>> > Skype: rod.melia
>> > Twitter: @RodolfoMelia
>> > Note: Please note my new email address, which I will be using for PSI
>> related work: rmelia@xxxxxxxxxxxx
>>
>> --
>> You received this bug notification because you are a member of DHIS 2
>> developers, which is subscribed to DHIS.
>> https://bugs.launchpad.net/bugs/1179832
>>
>> Title:
>>   Tabular reporting doesn't load
>>
>> Status in DHIS 2 - District Health Information Software:
>>   New
>>
>> Bug description:
>>   Tabular report doesn't load any results. This applies to all type of
>>   programs (with and without registration). After selecting your
>>   criteria, the 'loading' message appears, but it never displays any
>>   answers. This is occurring in 2.11 and 2.12. I've tested on my own
>>   environments as well as on http://apps.dhis2.org/dev &
>>   http://apps.dhis2.org/demo
>>
>>   On an old 2.11, for which tabular report works, everything loads until
>>   you add a data element of type 'Yes Only' or 'Yes/No'. I believe that
>>   because there are records with Null values, then the whole answer
>>   query gets cancelled, resulting in no records returned.
>>
>>   Let me know if you need further info.
>>
>> To manage notifications about this bug go to:
>> https://bugs.launchpad.net/dhis2/+bug/1179832/+subscriptions
>>
>> _______________________________________________
>> 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
>>
>
>
>
> --
> *Rodolfo Meliá*
> *Principal*
> rmelia@xxxxxxxxxxxx
> www.knowming.com
> +1 708 872 7636
> +44 777 576 4090
> Skype: rod.melia
> Twitter: @RodolfoMelia <https://twitter.com/RodolfoMelia>
>
> Note: Please note my new email address, which I will be using for PSI
> related work: rmelia@xxxxxxxxxxxx
>


-- 
*Rodolfo Meliá*
*Principal*
rmelia@xxxxxxxxxxxx
www.knowming.com
+1 708 872 7636
+44 777 576 4090
Skype: rod.melia
Twitter: @RodolfoMelia <https://twitter.com/RodolfoMelia>

Note: Please note my new email address, which I will be using for PSI
related work: rmelia@xxxxxxxxxxxx

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1179832

Title:
  Tabular reporting doesn't load

Status in DHIS 2 - District Health Information Software:
  New

Bug description:
  Tabular report doesn't load any results. This applies to all type of
  programs (with and without registration). After selecting your
  criteria, the 'loading' message appears, but it never displays any
  answers. This is occurring in 2.11 and 2.12. I've tested on my own
  environments as well as on http://apps.dhis2.org/dev &
  http://apps.dhis2.org/demo

  On an old 2.11, for which tabular report works, everything loads until
  you add a data element of type 'Yes Only' or 'Yes/No'. I believe that
  because there are records with Null values, then the whole answer
  query gets cancelled, resulting in no records returned.

  Let me know if you need further info.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1179832/+subscriptions