← Back to team overview

dhis2-users team mailing list archive

Re: [Dhis2-devs] Event report is showing data after deleting all events also

 

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 Wed, Jun 6, 2018, 09:16 Rajeswari Gottipati <rajeswag@xxxxxxxxxxxxxxxx>
wrote:

> Thanks Markus. I have raised Jira ticket
> <https://jira.dhis2.org/browse/DHIS2-3927> for this issue.
>
> On Tue, Jun 5, 2018 at 7:07 PM, Markus Bekken <markus.bekken@xxxxxxxxx>
> 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
>>
>> 5. jun. 2018 kl. 13:45 skrev Rajeswari Gottipati <
>> rajeswag@xxxxxxxxxxxxxxxx>:
>>
>> 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@xxxxxxxxx> 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@xxxxxxxxxxxxxxxx> wrote:
>>>
>>>> Hi Markus,
>>>>
>>>> Do you think it is an issue in DHIS?
>>>>
>>>> On Tue, Jun 5, 2018 at 2:43 PM, Rajeswari Gottipati <
>>>> rajeswag@xxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxx> 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@xxxxxxxxx> 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
>>>>>>>
>>>>>>> 5. jun. 2018 kl. 08:27 skrev Rajeswari Gottipati <
>>>>>>> rajeswag@xxxxxxxxxxxxxxxx>:
>>>>>>>
>>>>>>> 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@xxxxxxxxxxxxxxxx
>>>>>>> Telephone +91 9949292931 <+91%209949292931>
>>>>>>> [image: ThoughtWorks]
>>>>>>> <http://www.thoughtworks.com/?utm_campaign=rajeswari-gottipati-signature&utm_medium=email&utm_source=thoughtworks-email-signature-generator>
>>>>>>> _______________________________________________
>>>>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>>>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>>>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> Rajeswari Gottipati
>>>>>> Sr Consultant
>>>>>> Email rajeswag@xxxxxxxxxxxxxxxx
>>>>>> Telephone +91 9949292931 <+91%209949292931>
>>>>>> [image: ThoughtWorks]
>>>>>> <http://www.thoughtworks.com/?utm_campaign=rajeswari-gottipati-signature&utm_medium=email&utm_source=thoughtworks-email-signature-generator>
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Rajeswari Gottipati
>>>>> Sr Consultant
>>>>> Email rajeswag@xxxxxxxxxxxxxxxx
>>>>> Telephone +91 9949292931 <+91%209949292931>
>>>>> [image: ThoughtWorks]
>>>>> <http://www.thoughtworks.com/?utm_campaign=rajeswari-gottipati-signature&utm_medium=email&utm_source=thoughtworks-email-signature-generator>
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Rajeswari Gottipati
>>>> Sr Consultant
>>>> Email rajeswag@xxxxxxxxxxxxxxxx
>>>> Telephone +91 9949292931 <+91%209949292931>
>>>> [image: ThoughtWorks]
>>>> <http://www.thoughtworks.com/?utm_campaign=rajeswari-gottipati-signature&utm_medium=email&utm_source=thoughtworks-email-signature-generator>
>>>>
>>>> _______________________________________________
>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>>>
>>>
>>>
>>> --
>>> Jason P. Pickering
>>> email: jason.p.pickering@xxxxxxxxx
>>> tel:+46764147049 <+46764147049>
>>>
>>
>>
>>
>> --
>> Rajeswari Gottipati
>> Sr Consultant
>> Email rajeswag@xxxxxxxxxxxxxxxx
>> Telephone +91 9949292931 <+91%209949292931>
>> [image: ThoughtWorks]
>> <http://www.thoughtworks.com/?utm_campaign=rajeswari-gottipati-signature&utm_medium=email&utm_source=thoughtworks-email-signature-generator>
>>
>>
>>
>
>
> --
> Rajeswari Gottipati
> Sr Consultant
> Email rajeswag@xxxxxxxxxxxxxxxx
> Telephone +91 9949292931 <+91%209949292931>
> [image: ThoughtWorks]
> <http://www.thoughtworks.com/?utm_campaign=rajeswari-gottipati-signature&utm_medium=email&utm_source=thoughtworks-email-signature-generator>
> _______________________________________________
> 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
>

References