dhis2-devs team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

Hi,

I think its quite logical that if you set up a server cache and ask the
system to cache until next morning, it will return the same result even if
the upstream server content changes.

The cache under data admin is referring to the hibernate dhis application
cache, not the nginx server cache. There is no way that dhis running in
tomcat could clear all caches in front of it.

The reason for  "Table not valid, aborted update" probably happened for the
event analytics, and just means that there is no event data so we cannot
generate event analytics tables.

regards,

Lars



On Wed, May 28, 2014 at 3:30 PM, Knut Staring <knutst@xxxxxxxxx> wrote:

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