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 <l...@dhis2.org>: > 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.picker...@gmail.com> 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 < >> markodavi...@gmail.com> 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" <u...@wahser.de> 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@lists.launchpad.net >>>> Unsubscribe : https://launchpad.net/~dhis2-users >>>> More help : https://help.launchpad.net/ListHelp >>>> >>>> >>>> >>> _______________________________________________ >>> Mailing list: https://launchpad.net/~dhis2-users >>> Post to : dhis2-users@lists.launchpad.net >>> Unsubscribe : https://launchpad.net/~dhis2-users >>> More help : https://help.launchpad.net/ListHelp >>> >>> >> >> >> -- >> Jason P. Pickering >> email: jason.p.picker...@gmail.com >> tel:+46764147049 >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~dhis2-users >> Post to : dhis2-users@lists.launchpad.net >> 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/> > >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp