Hi
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
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?
regards,
Lars
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.
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).
Thanks!
Hi all,
We have the same problem.
We have the 36.4 version and everything works untill we try to run the analytics tables. We are doing this manually.
I attached the log file.
Hope you can help us,
Thank you
log_analytics_tables_error.docx (66.9 KB)
After reading the log file you shared, it seems like one of the âsub-selectâ statements is returning more than one row when we are expecting only one. Having more than one row could be a data issue.
As we are inserting one value for each column, we must have one unique value (from the âsub-selectâ) per column.
You can see all the âsub-selectâ statements that I could isolate from the log in the file attached.
Do you think you or someone in your team would be able to identify which of those âsub-selectâ queries are returning two (or more) or rows? This will help to narrow the problem.
Thanks,
Maikel
sub-selects.pdf (29.1 KB)
Thank you very much, @maikel
Your comment has been very usefull. After you told us it could be a data isue, we decided to delete all the data we had. Afortunately, we are in a test server.
We have made a metadata export/import to another empty instance and now it works.
Thank you again!
Youâre very welcome @cristina.barrena. Iâm glad you could fix the issue =)
Cheers,
Maikel