Users have been complaining that after running the analytics (we run it at specific times everyday) the pivot tables show odd values when looking at past entered data in tracker.
We have implemented a tracker that users enter data daily. We also have created program indicators that allow the users to pivot tables to do reports.
We run analytics 3 times a day (01AM, 11AM and 02PM), this is scheduled in Scheduler app. In the server (Ubuntu Server 18.04), we created a cronjob that clears the analytics table 5 minutes before Dhis2 runs the scheduled analytics
The issue is, after running the analytics, the users complain that the data for previous dates are odd:
For instance let us suppose we are on a Friday, if we check the program indicators for that data inserted on Monday, and compare it to what we saw on Tuesday, Wednesday and so on, but for Monday data, the returned values are very different.
But this is solved if we mannualy clear the analytics table and run analytics.
It seems to be an issue with the scheduled analytics.
I went to the terminal to check if everything is working accordingly and as far as I can say, the logs for analytics do not return an error.
I’m kinda lost on what to do because it seems everythings is functioning perfectly but the users keep complaining.
I’m using DHIS2 2.33.9