Event report is showing data after deleting all events also

Hi DHIS Team,

We have deleted all events for specific orgunit, ran analytics and cleared browser cache. Observed that there is no data in Event Capture app.

But still we are seeing numbers in Event Reports app as below

image

We have observed the same for other Orgunits also. Could you please let us know why event report still showing numbers.

···

Rajeswari Gottipati
Sr Consultant
Email
rajeswag@thoughtworks.com
Telephone
+91 9949292931
ThoughtWorks

Hi Markus,

We are using DHIS 2.27. We will perform the action items what ever you mentioned and will update you soon.

···

On Tue, Jun 5, 2018 at 12:20 PM, Markus Bekken markus.bekken@abaris.no wrote:

Hey there,
which version are you using? This seems to be a bug. Can you try and delete the analytics tables called analytics_event_*, then run analytics again? Alternatively, try to add one event for 2016, run analytics again and see if the number of events in the event report goes down from 149 to 1.

Best regards

Markus

  1. jun. 2018 kl. 08:27 skrev Rajeswari Gottipati rajeswag@thoughtworks.com:

Hi DHIS Team,

We have deleted all events for specific orgunit, ran analytics and cleared browser cache. Observed that there is no data in Event Capture app.

<Screen Shot 2018-06-05 at 11.55.46 AM.png>

But still we are seeing numbers in Event Reports app as below

<Screen Shot 2018-06-05 at 11.55.27 AM.png>

We have observed the same for other Orgunits also. Could you please let us know why event report still showing numbers.


Rajeswari Gottipati
Sr Consultant
Email
rajeswag@thoughtworks.com
Telephone
+91 9949292931
ThoughtWorks


Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

Rajeswari Gottipati
Sr Consultant
Email
rajeswag@thoughtworks.com
Telephone
+91 9949292931
ThoughtWorks

Hi Markus,

We have tried alternative i.e created a case in 2016 and ran analytics. Now in Event Reports we are able to see 1 case under 2016. We will try the first option also and let you know the result soon.

···

On Tue, Jun 5, 2018 at 12:38 PM, Rajeswari Gottipati rajeswag@thoughtworks.com wrote:

Hi Markus,

We are using DHIS 2.27. We will perform the action items what ever you mentioned and will update you soon.

On Tue, Jun 5, 2018 at 12:20 PM, Markus Bekken markus.bekken@abaris.no wrote:

Hey there,
which version are you using? This seems to be a bug. Can you try and delete the analytics tables called analytics_event_*, then run analytics again? Alternatively, try to add one event for 2016, run analytics again and see if the number of events in the event report goes down from 149 to 1.

Best regards

Markus

  1. jun. 2018 kl. 08:27 skrev Rajeswari Gottipati rajeswag@thoughtworks.com:

Hi DHIS Team,

We have deleted all events for specific orgunit, ran analytics and cleared browser cache. Observed that there is no data in Event Capture app.

<Screen Shot 2018-06-05 at 11.55.46 AM.png>

But still we are seeing numbers in Event Reports app as below

<Screen Shot 2018-06-05 at 11.55.27 AM.png>

We have observed the same for other Orgunits also. Could you please let us know why event report still showing numbers.


Rajeswari Gottipati
Sr Consultant
Email
rajeswag@thoughtworks.com
Telephone
+91 9949292931
ThoughtWorks


Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp


Rajeswari Gottipati
Sr Consultant
Email
rajeswag@thoughtworks.com
Telephone
+91 9949292931
ThoughtWorks

Rajeswari Gottipati
Sr Consultant
Email
rajeswag@thoughtworks.com
Telephone
+91 9949292931
ThoughtWorks

Hi Markus,

Do you think it is an issue in DHIS?

···

On Tue, Jun 5, 2018 at 2:43 PM, Rajeswari Gottipati rajeswag@thoughtworks.com wrote:

Hi Markus,

We have tried alternative i.e created a case in 2016 and ran analytics. Now in Event Reports we are able to see 1 case under 2016. We will try the first option also and let you know the result soon.

On Tue, Jun 5, 2018 at 12:38 PM, Rajeswari Gottipati rajeswag@thoughtworks.com wrote:

Hi Markus,

We are using DHIS 2.27. We will perform the action items what ever you mentioned and will update you soon.


Rajeswari Gottipati
Sr Consultant
Email
rajeswag@thoughtworks.com
Telephone
+91 9949292931
ThoughtWorks

On Tue, Jun 5, 2018 at 12:20 PM, Markus Bekken markus.bekken@abaris.no wrote:

Hey there,
which version are you using? This seems to be a bug. Can you try and delete the analytics tables called analytics_event_*, then run analytics again? Alternatively, try to add one event for 2016, run analytics again and see if the number of events in the event report goes down from 149 to 1.

Best regards

Markus

  1. jun. 2018 kl. 08:27 skrev Rajeswari Gottipati rajeswag@thoughtworks.com:

Hi DHIS Team,

We have deleted all events for specific orgunit, ran analytics and cleared browser cache. Observed that there is no data in Event Capture app.

<Screen Shot 2018-06-05 at 11.55.46 AM.png>

But still we are seeing numbers in Event Reports app as below

<Screen Shot 2018-06-05 at 11.55.27 AM.png>

We have observed the same for other Orgunits also. Could you please let us know why event report still showing numbers.


Rajeswari Gottipati
Sr Consultant
Email
rajeswag@thoughtworks.com
Telephone
+91 9949292931
ThoughtWorks


Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp


Rajeswari Gottipati
Sr Consultant
Email
rajeswag@thoughtworks.com
Telephone
+91 9949292931
ThoughtWorks

Rajeswari Gottipati
Sr Consultant
Email
rajeswag@thoughtworks.com
Telephone
+91 9949292931
ThoughtWorks

Do you have any server caching active?

Were you able to reproduce this in incognito mode?

Regards,

Jason

···

On Tue, Jun 5, 2018 at 12:52 PM, Rajeswari Gottipati rajeswag@thoughtworks.com wrote:

Hi Markus,

Do you think it is an issue in DHIS?


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

On Tue, Jun 5, 2018 at 2:43 PM, Rajeswari Gottipati rajeswag@thoughtworks.com wrote:

Hi Markus,

We have tried alternative i.e created a case in 2016 and ran analytics. Now in Event Reports we are able to see 1 case under 2016. We will try the first option also and let you know the result soon.


Rajeswari Gottipati
Sr Consultant
Email
rajeswag@thoughtworks.com
Telephone
+91 9949292931
ThoughtWorks

On Tue, Jun 5, 2018 at 12:38 PM, Rajeswari Gottipati rajeswag@thoughtworks.com wrote:

Hi Markus,

We are using DHIS 2.27. We will perform the action items what ever you mentioned and will update you soon.


Rajeswari Gottipati
Sr Consultant
Email
rajeswag@thoughtworks.com
Telephone
+91 9949292931
ThoughtWorks

On Tue, Jun 5, 2018 at 12:20 PM, Markus Bekken markus.bekken@abaris.no wrote:

Hey there,
which version are you using? This seems to be a bug. Can you try and delete the analytics tables called analytics_event_*, then run analytics again? Alternatively, try to add one event for 2016, run analytics again and see if the number of events in the event report goes down from 149 to 1.

Best regards

Markus

  1. jun. 2018 kl. 08:27 skrev Rajeswari Gottipati rajeswag@thoughtworks.com:

Hi DHIS Team,

We have deleted all events for specific orgunit, ran analytics and cleared browser cache. Observed that there is no data in Event Capture app.

<Screen Shot 2018-06-05 at 11.55.46 AM.png>

But still we are seeing numbers in Event Reports app as below

<Screen Shot 2018-06-05 at 11.55.27 AM.png>

We have observed the same for other Orgunits also. Could you please let us know why event report still showing numbers.


Rajeswari Gottipati
Sr Consultant
Email
rajeswag@thoughtworks.com
Telephone
+91 9949292931
ThoughtWorks


Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp


Rajeswari Gottipati
Sr Consultant
Email
rajeswag@thoughtworks.com
Telephone
+91 9949292931
ThoughtWorks

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

Yes I was able to reproduce this in different browsers and in incognito mode also.

···

On Tue, Jun 5, 2018 at 5:08 PM, Jason Pickering jason.p.pickering@gmail.com wrote:

Do you have any server caching active?

Were you able to reproduce this in incognito mode?

Regards,

Jason

On Tue, Jun 5, 2018 at 12:52 PM, Rajeswari Gottipati rajeswag@thoughtworks.com wrote:

Hi Markus,

Do you think it is an issue in DHIS?


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

On Tue, Jun 5, 2018 at 2:43 PM, Rajeswari Gottipati rajeswag@thoughtworks.com wrote:

Hi Markus,

We have tried alternative i.e created a case in 2016 and ran analytics. Now in Event Reports we are able to see 1 case under 2016. We will try the first option also and let you know the result soon.


Rajeswari Gottipati
Sr Consultant
Email
rajeswag@thoughtworks.com
Telephone
+91 9949292931
ThoughtWorks

On Tue, Jun 5, 2018 at 12:38 PM, Rajeswari Gottipati rajeswag@thoughtworks.com wrote:

Hi Markus,

We are using DHIS 2.27. We will perform the action items what ever you mentioned and will update you soon.


Rajeswari Gottipati
Sr Consultant
Email
rajeswag@thoughtworks.com
Telephone
+91 9949292931
ThoughtWorks

On Tue, Jun 5, 2018 at 12:20 PM, Markus Bekken markus.bekken@abaris.no wrote:

Hey there,
which version are you using? This seems to be a bug. Can you try and delete the analytics tables called analytics_event_*, then run analytics again? Alternatively, try to add one event for 2016, run analytics again and see if the number of events in the event report goes down from 149 to 1.

Best regards

Markus

  1. jun. 2018 kl. 08:27 skrev Rajeswari Gottipati rajeswag@thoughtworks.com:

Hi DHIS Team,

We have deleted all events for specific orgunit, ran analytics and cleared browser cache. Observed that there is no data in Event Capture app.

<Screen Shot 2018-06-05 at 11.55.46 AM.png>

But still we are seeing numbers in Event Reports app as below

<Screen Shot 2018-06-05 at 11.55.27 AM.png>

We have observed the same for other Orgunits also. Could you please let us know why event report still showing numbers.


Rajeswari Gottipati
Sr Consultant
Email
rajeswag@thoughtworks.com
Telephone
+91 9949292931
ThoughtWorks


Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp


Rajeswari Gottipati
Sr Consultant
Email
rajeswag@thoughtworks.com
Telephone
+91 9949292931
ThoughtWorks

Rajeswari Gottipati
Sr Consultant
Email
rajeswag@thoughtworks.com
Telephone
+91 9949292931
ThoughtWorks

Thanks Markus. I have raised Jira ticket for this issue.

···

On Tue, Jun 5, 2018 at 7:07 PM, Markus Bekken markus.bekken@abaris.no wrote:

Hi,
based on the behavior you see, my guess is that when you have no rows in the database for one year, we are not clearing out the analytics table for that event and year as part of the analytics run. We should have cleared out analytics tables that would be empty at this stage. I will guess that deleting the analytics_event_* tables will be a workaround for you.

This seems like a bug, it is great if you can file a Jira issue for it.

Markus

  1. jun. 2018 kl. 13:45 skrev Rajeswari Gottipati rajeswag@thoughtworks.com:

Yes I was able to reproduce this in different browsers and in incognito mode also.

On Tue, Jun 5, 2018 at 5:08 PM, Jason Pickering jason.p.pickering@gmail.com wrote:

Do you have any server caching active?

Were you able to reproduce this in incognito mode?

Regards,

Jason


Rajeswari Gottipati
Sr Consultant
Email
rajeswag@thoughtworks.com
Telephone
+91 9949292931
ThoughtWorks

On Tue, Jun 5, 2018 at 12:52 PM, Rajeswari Gottipati rajeswag@thoughtworks.com wrote:

Hi Markus,

Do you think it is an issue in DHIS?


Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

On Tue, Jun 5, 2018 at 2:43 PM, Rajeswari Gottipati rajeswag@thoughtworks.com wrote:

Hi Markus,

We have tried alternative i.e created a case in 2016 and ran analytics. Now in Event Reports we are able to see 1 case under 2016. We will try the first option also and let you know the result soon.


Rajeswari Gottipati
Sr Consultant
Email
rajeswag@thoughtworks.com
Telephone
+91 9949292931
ThoughtWorks

On Tue, Jun 5, 2018 at 12:38 PM, Rajeswari Gottipati rajeswag@thoughtworks.com wrote:

Hi Markus,

We are using DHIS 2.27. We will perform the action items what ever you mentioned and will update you soon.


Rajeswari Gottipati
Sr Consultant
Email
rajeswag@thoughtworks.com
Telephone
+91 9949292931
ThoughtWorks

On Tue, Jun 5, 2018 at 12:20 PM, Markus Bekken markus.bekken@abaris.no wrote:

Hey there,
which version are you using? This seems to be a bug. Can you try and delete the analytics tables called analytics_event_*, then run analytics again? Alternatively, try to add one event for 2016, run analytics again and see if the number of events in the event report goes down from 149 to 1.

Best regards

Markus

  1. jun. 2018 kl. 08:27 skrev Rajeswari Gottipati rajeswag@thoughtworks.com:

Hi DHIS Team,

We have deleted all events for specific orgunit, ran analytics and cleared browser cache. Observed that there is no data in Event Capture app.

<Screen Shot 2018-06-05 at 11.55.46 AM.png>

But still we are seeing numbers in Event Reports app as below

<Screen Shot 2018-06-05 at 11.55.27 AM.png>

We have observed the same for other Orgunits also. Could you please let us know why event report still showing numbers.


Rajeswari Gottipati
Sr Consultant
Email
rajeswag@thoughtworks.com
Telephone
+91 9949292931
ThoughtWorks


Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp


Rajeswari Gottipati
Sr Consultant
Email
rajeswag@thoughtworks.com
Telephone
+91 9949292931
ThoughtWorks

Rajeswari Gottipati
Sr Consultant
Email
rajeswag@thoughtworks.com
Telephone
+91 9949292931
ThoughtWorks

Hi, just incase you haven’t tried, could you try to parmanently delete the records. From the events interface, you can only soft delete.

Maintainance and select permanently delete …

···

On Tue, Jun 5, 2018 at 7:07 PM, Markus Bekken markus.bekken@abaris.no wrote:

Hi,
based on the behavior you see, my guess is that when you have no rows in the database for one year, we are not clearing out the analytics table for that event and year as part of the analytics run. We should have cleared out analytics tables that would be empty at this stage. I will guess that deleting the analytics_event_* tables will be a workaround for you.

This seems like a bug, it is great if you can file a Jira issue for it.

Markus

  1. jun. 2018 kl. 13:45 skrev Rajeswari Gottipati rajeswag@thoughtworks.com:

Yes I was able to reproduce this in different browsers and in incognito mode also.


Rajeswari Gottipati
Sr Consultant
Email
rajeswag@thoughtworks.com
Telephone
+91 9949292931
ThoughtWorks

On Tue, Jun 5, 2018 at 5:08 PM, Jason Pickering jason.p.pickering@gmail.com wrote:

Do you have any server caching active?

Were you able to reproduce this in incognito mode?

Regards,

Jason


Rajeswari Gottipati
Sr Consultant
Email
rajeswag@thoughtworks.com
Telephone
+91 9949292931
ThoughtWorks

On Tue, Jun 5, 2018 at 12:52 PM, Rajeswari Gottipati rajeswag@thoughtworks.com wrote:

Hi Markus,

Do you think it is an issue in DHIS?


Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

On Tue, Jun 5, 2018 at 2:43 PM, Rajeswari Gottipati rajeswag@thoughtworks.com wrote:

Hi Markus,

We have tried alternative i.e created a case in 2016 and ran analytics. Now in Event Reports we are able to see 1 case under 2016. We will try the first option also and let you know the result soon.


Rajeswari Gottipati
Sr Consultant
Email
rajeswag@thoughtworks.com
Telephone
+91 9949292931
ThoughtWorks

On Tue, Jun 5, 2018 at 12:38 PM, Rajeswari Gottipati rajeswag@thoughtworks.com wrote:

Hi Markus,

We are using DHIS 2.27. We will perform the action items what ever you mentioned and will update you soon.


Rajeswari Gottipati
Sr Consultant
Email
rajeswag@thoughtworks.com
Telephone
+91 9949292931
ThoughtWorks

On Tue, Jun 5, 2018 at 12:20 PM, Markus Bekken markus.bekken@abaris.no wrote:

Hey there,
which version are you using? This seems to be a bug. Can you try and delete the analytics tables called analytics_event_*, then run analytics again? Alternatively, try to add one event for 2016, run analytics again and see if the number of events in the event report goes down from 149 to 1.

Best regards

Markus

  1. jun. 2018 kl. 08:27 skrev Rajeswari Gottipati rajeswag@thoughtworks.com:

Hi DHIS Team,

We have deleted all events for specific orgunit, ran analytics and cleared browser cache. Observed that there is no data in Event Capture app.

<Screen Shot 2018-06-05 at 11.55.46 AM.png>

But still we are seeing numbers in Event Reports app as below

<Screen Shot 2018-06-05 at 11.55.27 AM.png>

We have observed the same for other Orgunits also. Could you please let us know why event report still showing numbers.


Rajeswari Gottipati
Sr Consultant
Email
rajeswag@thoughtworks.com
Telephone
+91 9949292931
ThoughtWorks


Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp


Rajeswari Gottipati
Sr Consultant
Email
rajeswag@thoughtworks.com
Telephone
+91 9949292931
ThoughtWorks