Analytics errror

Hello all.

The analytics process finish fine, but doesn’t load any values.

Dhis version: 2.21

Buil revision:21049

Thank you very much.

catalina.out (195 KB)

image

image

···

Best regards,

Marko David Garcia M.

Skype: marko_david

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

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@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](https://launchpad.net/~dhis2-users)
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : [https://launchpad.net/~dhis2-users](https://launchpad.net/~dhis2-users)
More help : [https://help.launchpad.net/ListHelp](https://help.launchpad.net/ListHelp)

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

···

On Mon, Mar 14, 2016 at 1:09 AM, Marko David Garcia markodavidgm@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” uwe@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](https://launchpad.net/~dhis2-users)
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : [https://launchpad.net/~dhis2-users](https://launchpad.net/~dhis2-users)
More help : [https://help.launchpad.net/ListHelp](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.pickering@gmail.com
tel:+46764147049

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

image

···

On Mon, Mar 14, 2016 at 6:35 AM, Jason Pickering jason.p.pickering@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


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

On Mon, Mar 14, 2016 at 1:09 AM, Marko David Garcia markodavidgm@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” uwe@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](https://launchpad.net/~dhis2-users)
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : [https://launchpad.net/~dhis2-users](https://launchpad.net/~dhis2-users)
More help : [https://help.launchpad.net/ListHelp](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.pickering@gmail.com
tel:+46764147049

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

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.

image

···

2016-03-14 7:08 GMT-05:00 Lars Helge Øverland lars@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

Cordialmente,

Marko David Garcia M.

Skype: marko_david

On Mon, Mar 14, 2016 at 6:35 AM, Jason Pickering jason.p.pickering@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


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

On Mon, Mar 14, 2016 at 1:09 AM, Marko David Garcia markodavidgm@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” uwe@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](https://launchpad.net/~dhis2-users)
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : [https://launchpad.net/~dhis2-users](https://launchpad.net/~dhis2-users)
More help : [https://help.launchpad.net/ListHelp](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.pickering@gmail.com
tel:+46764147049

DHIS2 Event capture downloaded from play store is failing to display organisation units. Anyone come across this issue?

Regards

Simon Muyambo

__________ Information from ESET NOD32 Antivirus, version of virus signature database 13177 (20160314) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

Hi Simon,

You need to assign the org units to the user account under Data capture and maintenance org units. See snapshot below.
Apps >> Users

-Ese

···

On Mon, Mar 14, 2016 at 11:09 PM, Simon Muyambo smmuyambo@gmail.com wrote:

DHIS2 Event capture downloaded from play store is failing to display organisation units. Anyone come across this issue?

Regards

Simon Muyambo

__________ Information from ESET NOD32 Antivirus, version of virus signature database 13177 (20160314) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com


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

DHIS2 Event capture downloaded from play store is failing to display organisation units. Anyone come across this issue?

Regards

Simon Muyambo

Hi Marko,

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

Lars

image

···

On Mon, Mar 14, 2016 at 9:10 PM, Marko David Garcia markodavidgm@gmail.com 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@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.pickering@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


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

On Mon, Mar 14, 2016 at 1:09 AM, Marko David Garcia markodavidgm@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” uwe@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](https://launchpad.net/~dhis2-users)
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : [https://launchpad.net/~dhis2-users](https://launchpad.net/~dhis2-users)
More help : [https://help.launchpad.net/ListHelp](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.pickering@gmail.com
tel:+46764147049

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

Hi Araz

I am running DHIS2 version 2.22

Build revision: 21915

And android version 4.4.4 with DHIS2 event capture mobile 4.0

I have managed to get it to run by upgrading the software. Unfortunately the DHIS2 event capture continually fails and is quite unstable. Just says the application has stopped

Regards

Simon Muyambo

···

From: Araz Abishov [mailto:araz@dhis2.org]
Sent: 15 March 2016 10:00
To: dhis2-users@lists.launchpad.net; Simon Muyambo
Subject: Re: [Dhis2-users] DHIS2 event capture app

Hi Simon,

Which version of EventCapture (android app) and DHIS2 are you running?

Best Regards,

Araz Abishov

On March 14, 2016 at 11:09:29 PM, Simon Muyambo (smmuyambo@gmail.com) wrote:

DHIS2 Event capture downloaded from play store is failing to display organisation units. Anyone come across this issue?

Regards

Simon Muyambo

__________ Information from ESET NOD32 Antivirus, version of virus signature database 13177 (20160314) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com


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

__________ Information from ESET NOD32 Antivirus, version of virus signature database 13179 (20160315) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

__________ Information from ESET NOD32 Antivirus, version of virus signature database 13180 (20160315) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

Hi Simon,

Did you manage to see the organisation units and programs?

Do you know what you are doing that is causing the crash?

Regards,

Erling - DHIS2 Android Team

···

On Tue, Mar 15, 2016 at 9:57 PM, Simon Muyambo smmuyambo@gmail.com wrote:

Hi Araz

I am running DHIS2 version 2.22

Build revision: 21915

And android version 4.4.4 with DHIS2 event capture mobile 4.0

I have managed to get it to run by upgrading the software. Unfortunately the DHIS2 event capture continually fails and is quite unstable. Just says the application has stopped

Regards

Simon Muyambo

From: Araz Abishov [mailto:araz@dhis2.org]
Sent: 15 March 2016 10:00
To: dhis2-users@lists.launchpad.net; Simon Muyambo
Subject: Re: [Dhis2-users] DHIS2 event capture app

Hi Simon,

Which version of EventCapture (android app) and DHIS2 are you running?

Best Regards,

Araz Abishov

On March 14, 2016 at 11:09:29 PM, Simon Muyambo (smmuyambo@gmail.com) wrote:

DHIS2 Event capture downloaded from play store is failing to display organisation units. Anyone come across this issue?

Regards

Simon Muyambo

__________ Information from ESET NOD32 Antivirus, version of virus signature database 13177 (20160314) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com


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

__________ Information from ESET NOD32 Antivirus, version of virus signature database 13179 (20160315) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

__________ Information from ESET NOD32 Antivirus, version of virus signature database 13180 (20160315) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com


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

Hi simon,
Can you send the screenshort?

···

2016-03-15 22:47 GMT+01:00 Erling Fjeldstad erling@dhis2.org:

Hi Simon,

Did you manage to see the organisation units and programs?

Do you know what you are doing that is causing the crash?

Regards,

Erling - DHIS2 Android Team


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

On Tue, Mar 15, 2016 at 9:57 PM, Simon Muyambo smmuyambo@gmail.com wrote:

Hi Araz

I am running DHIS2 version 2.22

Build revision: 21915

And android version 4.4.4 with DHIS2 event capture mobile 4.0

I have managed to get it to run by upgrading the software. Unfortunately the DHIS2 event capture continually fails and is quite unstable. Just says the application has stopped

Regards

Simon Muyambo

From: Araz Abishov [mailto:araz@dhis2.org]
Sent: 15 March 2016 10:00
To: dhis2-users@lists.launchpad.net; Simon Muyambo
Subject: Re: [Dhis2-users] DHIS2 event capture app

Hi Simon,

Which version of EventCapture (android app) and DHIS2 are you running?

Best Regards,

Araz Abishov

On March 14, 2016 at 11:09:29 PM, Simon Muyambo (smmuyambo@gmail.com) wrote:

DHIS2 Event capture downloaded from play store is failing to display organisation units. Anyone come across this issue?

Regards

Simon Muyambo

__________ Information from ESET NOD32 Antivirus, version of virus signature database 13177 (20160314) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com


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

__________ Information from ESET NOD32 Antivirus, version of virus signature database 13179 (20160315) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

__________ Information from ESET NOD32 Antivirus, version of virus signature database 13180 (20160315) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com


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

Riddy NDOMA

Software Developer
Skype: riddyndoma, G+: riddyndoma, FB: riddy ndoma
Twitter: riddyndoma, LinkedIn: riddy ndoma
Blog: http://riddyndoma.blogspot.com/
Vous servir est mon désire (Serving you is my desire)