dhis2-users team mailing list archive

[Lars Helge Øverland <lars@xxxxxxxxx>]

Hi Marko,

yes please try to delete all tables in the database starting with
analytics, then try again.

Lars

On Mon, Mar 14, 2016 at 9:10 PM, Marko David Garcia <markodavidgm@xxxxxxxxx>
wrote:

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


-- 
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
http://www.dhis2.org <https://www.dhis2.org/>