← Back to team overview

dhis2-devs team mailing list archive

Re: Inconsistency in generating analytics

 

The thing I found confusing was that I got the same results also in the
browser on the server, which I did not think had been used to look at pivot
tables at all before. I admit the setting was probably wrong, and the
situation was finally resolved after clearing both browser and server side
caches BUT also manually deleting the analytics tables. So not exactly sure
what the issue was exactly.

But I still find it very confusing that the Analytics generation process
first provides something that looks like (but is not particularly marked
out, e.g. in BOLD or RED or something) as an error message, AND THEN
proceeds to indicate that everything is honkey-dorey....



On Wed, May 28, 2014 at 3:25 PM, Jason Pickering <
jason.p.pickering@xxxxxxxxx> wrote:

> Well, I think that is the isssue. If you regenerate the analytics, and the
> system cache is set to 6 AM, nothing is going to happen, unless you clear
> your browser cache, as the results for the same analytics resource, have
> been cached there, right?
>
>
> On Wed, May 28, 2014 at 3:24 PM, Knut Staring <knutst@xxxxxxxxx> wrote:
>
>> It is set to "Cache until 6 am next morning", which I think is the
>> default.
>>
>> But when I said I cleared the cache, I meant on the server, as
>> in dhis-web-maintenance-dataadmin/showCache.action
>>
>>
>> On Wed, May 28, 2014 at 2:45 PM, Jason Pickering <
>> jason.p.pickering@xxxxxxxxx> wrote:
>>
>>> I mean the system cache settings..
>>>
>>> dhis-web-maintenance-settings/systemGeneralSettings.action
>>>
>>> What is this set to?
>>>
>>> Regards,
>>> Jason
>>>
>>>
>>>
>>> On Wed, May 28, 2014 at 2:37 PM, Knut Staring <knutst@xxxxxxxxx> wrote:
>>>
>>>> Yes I had no event data. But the analytics tables remained the same
>>>> after deleting all data and then clearing cache. Had to delete them
>>>> directly in the db (which admittedly is also how I got rid of all the
>>>> testdata in the first place)
>>>>
>>>> On May 28, 2014 6:59 PM, "Jason Pickering" <jason.p.pickering@xxxxxxxxx>
>>>> wrote:
>>>> >
>>>> > Check the cache settings. That message may not be fatal, and may be
>>>> related to systems which have no event data.
>>>> >
>>>> > Regards,
>>>> > Jason
>>>> >
>>>> >
>>>> >
>>>> > On Wed, May 28, 2014 at 2:21 PM, Knut Staring <knutst@xxxxxxxxx>
>>>> wrote:
>>>> >>
>>>> >> When running the Analytics (2.15) everything looked fine at the
>>>> first glance, since the top message had the green tick icon and said
>>>> "Analytics tables updated"
>>>> >>
>>>> >> However, everything remained the same, so I looked closer and saw
>>>> that the penultimate message (line 2) indicated the process had failed:
>>>> >>
>>>> >> 2014-05-28 09:03:37 Analytics tables updated
>>>> >> 2014-05-28 09:03:37 Table not valid, aborted update
>>>> >>
>>>> >> --
>>>> >> Knut Staring
>>>> >> Dept. of Informatics, University of Oslo
>>>> >> +4791880522
>>>> >> http://dhis2.org
>>>> >>
>>>> >> _______________________________________________
>>>> >> 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
>>>> >>
>>>> >
>>>>
>>>
>>>
>>
>>
>> --
>> Knut Staring
>> Dept. of Informatics, University of Oslo
>> +4791880522
>> http://dhis2.org
>>
>
>


-- 
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522
http://dhis2.org

Follow ups

References