Generating analytics issue

Support - Assistance technique
,
1

Hello team,

We are experiencing an issue with the generation of analytics on our server. Our DHIS2 version is 2.40.5. The problem is that generating the analytics tables takes a very long time. The size of our database without analytics is 50 GB, but it can grow up to 1 TB with the analytics.

The issue is that sometimes the generation works, but other times it fails. We have a task scheduler set to run this generation every day, but we had to temporarily stop it to avoid disrupting our users. Additionally, we have noticed that some tables, which should be automatically created during the generation process, are not being created.
Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics_completenesstarget" does not exist Position: 57
We are also encountering 504 errors, which always seem to be related to these analytics.

Thanks in advance for your help
Best

1 Like
2

Hi @mira

Welcome to the DHIS2 Community! Thank you for reaching out and for your patience - sorry for the delay here. It might help more to get the complete Catalina.out log (without sensitive info) rather than one generic error. Additionally, could this also be caused by system configuration or limited resources in your environment?

What are the 504 errors you are encountering and how?

Did you upgrade or update this instance before these issues? Would you like to test in a clone instance for experimental purpose (not on the production instance) to update to the latest version (40.6)?