I have a running instance of DHIS2 2.33.6. The problem rises when I start running analytics it returns an error.
Server spec. Ubuntu [20.04 , 18.04] PostgreSQL [13 , 12 , 9.6]
The database backup was taken from another running dhis2 instance 2.33.6 (analytics works perfect there!).
I have also experienced the same behavior with sample data
It seems that you have a duplicate UID ‘dateperiod’ (see line 25). Maybe this occured when you imported the backup.
After db import, I checked the table for any duplicate UID and there was no duplicate. Also,
I have tried importing from DHIS2 sample databases, same error occurred!
@Gassim
Even if no backup is imported (i.e. working on clean/empty database) the error still occurs.
The issue was solved by upgrading to a newer version (> 2.34). But, there are still some unanswered questions, like why running Analytics, more specifically generating resource tables, fails on empty databases!!?
Hi @mkannan ,
The errors you are seeing on an empty DB sound like a potential bug.
However, if this is only happening on 2.33, which is no longer maintained, and since you are able to use a later, maintained, version, it sounds like it has already been resolved. Additionally, if we can only reproduce this on an empty DB, then it is unlikely that we would prioritise this fix for an unmaintained version.
If this is a real blocking issue for someone, on a database with data, and they cannot upgrade/update for some reason, then they can reach out to us for further support.
Kind regards,
Phil
