2.33.4 Analytics tables seem to become empty, and sometimes show duplicated values


I am facing 2 issues with Analytics:

  1. Sometimes Analytics tables show duplicated values for some facilities. I clear Analytics tables, run analytics again and the issue is fixed. Users who face this are a bit mind boggled when they see large duplicated values. Has anyone faced similar issue?

  2. Analytics tables seem to clear on their own sometimes, I am not sure why or when exactly it happened, I only know when users complain that we don’t see any data in Jan, Feb etc. i.e. previous months. Not sure, but it might have happened when I or other users run analytics for just 1 year.

How can I fix these?

Thank you