dhis2-users team mailing list archive

[Marko David Garcia <markodavidgm@xxxxxxxxx>]

Hi Lars.
Thanks for your answer.
The analytics tables are empty.

Before this issue, the analytics process show the error "The
analytics_event_temp_2015_xxxxx already exist".

I created this function to delete the repeated tables :


DECLARE
    row     record;
BEGIN
    FOR row IN
SELECT
            table_schema,
            table_name
        FROM
            information_schema.tables
        WHERE
            table_type = 'BASE TABLE'
        AND table_name like 'analytics_event_temp_2015%'
    LOOP
        EXECUTE 'DROP TABLE ' || quote_ident(row.table_schema) || '.' ||
quote_ident(row.table_name);
        RAISE INFO 'Dropped table: %', quote_ident(row.table_schema) || '.'
|| quote_ident(row.table_name);
    END LOOP;
END;

Can this cause the error?
How can I fix this issue?
Thank you very much.


Cordialmente,

*Marko David Garcia M.*
*Skype: marko_david*

2016-03-14 7:08 GMT-05:00 Lars Helge Øverland <lars@xxxxxxxxx>:

> Hi Marco,
>
> do verify if this is an output problem, can you look in your database for
> tables such as analytics_2015 and see if there is any data records there?
> If yes, you need to follow the above hints for clearing cache.
>
> regards,
>
> Lars
>
>
> On Mon, Mar 14, 2016 at 6:35 AM, Jason Pickering <
> jason.p.pickering@xxxxxxxxx> wrote:
>
>> Hi Marko,
>>
>> I suspect, although am not sure, this may be related to the server side
>> caching of analytics responses. Try setting you "Cache strategy" to "No
>> Cache". The downside here is that the server will need to generate new
>> analytics responses each time you request them. Give that a try and see if
>> it helps. Otherwise, be sure you do not have any caching reverse proxy
>> enabled (or misconfigured) in front of you DHIS2 server.
>>
>> Regards,
>> Jason
>>
>>
>>
>>
>> [image: Inline image 1]
>>
>> On Mon, Mar 14, 2016 at 1:09 AM, Marko David Garcia <
>> markodavidgm@xxxxxxxxx> wrote:
>>
>>> Hi Uwe. Thanks for your answer.
>>> Yes I cleaned the cache, but the error  continue.
>>> Thank you.
>>> El 13/03/2016 09:52, "uwe wahser" <uwe@xxxxxxxxx> escribió:
>>>
>>>> Hi Marco,
>>>>
>>>> did you clear the cache? (App Browser Cache Cleaner & App Data
>>>> Administration - Cache Statistics)
>>>>
>>>> Hope that helps,
>>>>
>>>> Uwe
>>>>
>>>> ---
>>>> Am 13.03.2016 um 17:06 schrieb Marko David Garcia:
>>>>
>>>> Hello all.
>>>>
>>>> The analytics process finish fine, but doesn't load any values.
>>>> Dhis version: 2.21
>>>> Buil revision:21049
>>>>
>>>> Thank you very much.
>>>> Best regards,
>>>>
>>>> *Marko David Garcia M.*
>>>> *Skype: marko_david*
>>>>
>>>>
>>>> _______________________________________________
>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>>>
>>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>> Jason P. Pickering
>> email: jason.p.pickering@xxxxxxxxx
>> tel:+46764147049
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> http://www.dhis2.org <https://www.dhis2.org/>
>
>