Process failed: Exception during execution

Iam trying to run analytics , and iam experiecing this issue on v.2.34

I have attached the log file for your reference. Please advise on how to resolve thiscatalina.doc (99.2 KB)

Hi @dguambe,

seems this is the culprit:

org.postgresql.util.PSQLException: ERROR: relation "analytics_temp_2019" does not exist

Hard to say how this should happen. Some theories:

  • Could you simply try again? Make sure no other interfering processes are being run, like clearing analytics tables under maintenance.

  • Could you look in your PostgreSQL database, and make sure the database user which runs DHIS 2 is the owner of all tables, including whichever analytics tables you have?



1 Like

The same problem just occured on our dhis2 instance. v 2.36.3 running on ubuntu 20.04.

Any one would like to suggest any solution ??

Hey @ahmed685,

My best bet is to review @Lars answer for the same topic:

Please let me know if you were able to resolve the issue after those instructions (if not then possibly share the logs, please). Thank you!

Hello, I have the same problem in my DHIS2 App, and i have tread to apply your instructions, bout it didn’t resolve.
Is there any anther solution.

1 Like

Welcome to the community @Mohammad_Alyamani! (:

I think we need more info to understand the issue and find a solution. Please post more details about the issue, DHIS2 instance version number, and what app you are using? What steps are you taking when the error appears?

It will help if you’d share the Catalina.out log (without the sensitive info) and a screenshot of the Network tab in the developer’s console (F12).