Re: [Dhis2-users] Analytics errror

2016-03-15 Thread Lars Helge Øverland 
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 
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_x 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 :
>
>> 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"  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 
>>
>>
>


-- 
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
http://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

Re: [Dhis2-users] Analytics errror

2016-03-14 Thread Marko David Garcia 
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_x 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 :

> 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"  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 
>
>
___
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

Re: [Dhis2-users] Analytics errror

2016-03-14 Thread Lars Helge Øverland 
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"  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 
___
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

Re: [Dhis2-users] Analytics errror

2016-03-13 Thread Jason Pickering 
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 
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"  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

Re: [Dhis2-users] Analytics errror

2016-03-13 Thread Marko David Garcia 
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"  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

Re: [Dhis2-users] Analytics errror

2016-03-13 Thread uwe wahser 

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