Error when running analytics

Support - Assistance technique
2

Hi @Esumohleb,

this seems to be an issue related to table partitioning which we use for analytics in DHIS2. This seems to be a bug, so I have created a bug issue for it on Jira: [DHIS2-7236] - Jira

In the meantime, I will give you some potential workarounds:

  • Upgrade DHIS2 to a newer version
    This does not seem to be an issue in newer versions of DHIS2, so upgrading should solve your issue.

  • Drop tables causing issues
    Tables with names starting with “analytics_” are generated by running analytics and are safe to drop since they can be recreated. That means you can drop the problematic tables manually using this sql:

  1. (1 table at the time) DROP TABLE <table_name>;
  2. (1 table and all depending tables) DROP TABLE <table_name> CASCADE;

Hope this solves your issue.

1 Like