Hi DHIS team,
I’m stuck on an issue with 2.20. Since upgrading from 2.18 to 2.20, the analytics tables have failed to generate.
There are some records in the analytics_2015 table, but not as many as there should be (roughly 2000 instead of the 19000 we had in 2.18). Pivot tables have no data. The analytics_2014, analytics _2013, etc. tables are empty, even though we do have data for those years. It seems like the analytics tables are failing to generate partway through.
I have tried running maintenance, restarting Tomcat, and re-running analytics. There is no error in the catalina.out log (attached). Any ideas?
Thanks,
Becky
Postgres log:
Becky Smith
Development-Operations Specialist
ICAP at Columbia University
Tel: 212.304.7115
Email: rs3524@cumc.columbia.edu
postgres9.3-main.log (1.97 KB)
catalina.out.txt (32.4 KB)