I have upgraded my DHIS2 from 2.27 to 2.29 but when I try to upgrade to 2.30, I do not see any data. I tried the upgrade process and everything (data element, org units etc.) are available but the actual event data does not show. I opened analytics and started it and get an error about creating duplicate values. I have also tried import/export and brought over everything but the data is not showi…

Upgrading DHIS2 from older versions to the latest requires careful planning and an incremental approach Please share your catalina.out logs here so we can address the issues one by one. Additionally, focus on cleanup and database preparation as these are crucial steps in the upgrade process. based on my practices please ensure following steps: you can refer to the [image] …

2.30 is good start but you’ll need much more effort to reach a supported version I guess you had data quality issue or missing constraint in the history of this server. Can you share the exact error message when you launched the analytics process so we can help you more ? (I already saw in past a lot of issues around categoryCombo with several “default”)

Here is the error plus the log from apache Error.doc (20.4 KB)

so you get duplicate for the period 1993-02-06 ERROR 2024-09-04 13:26:20,646 Analytics table process failed: org.springframework.dao.DuplicateKeyException: PreparedStatementCallback; SQL [insert into _dateperiodstructure_temp values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR: duplicate key value violates unique constraint "_dateperiodstructure_temp_pkey" Detail: Key (dateperiod)=(1993-02-06)…

I found a few entries Emergency! problems for dhis2.32/33: duplicate key value violates unique Duplicate key value in period table Analytics failing after upgrade to 2.27 build e33b34d but no clear solution sadly

Thanks Stephan. It must be a bug because I did a fresh instance with no data and got the same error when I ran analytics. Second my data was entered from 2019 but it is showing 1993 as the date period. And there is no patch for it.

Dear @Collin.Dosunmu , if you run this SQL “select * from categoryoptioncombo where name like ‘default’;” and find out that you have two defaults then that may be the contributing factor as @Stephan_Mestach mentioned.

Thanks Daniel, I ran the SQL and it returned only one default so I can rule it out as a source of my problem. I do not have any data yet if I run the Analytics, I still get the error. I saw someone mention something about the time/ time zone. Do you know if this could be an issue?

Hi [image] Collin Dosunmu: fresh instance with no data What version of DHIS2 was the instance you used to test this? Would it be possible if you please try to upgrade to one of the latest supported versions instead of 2.30? Thank you!

Hi! My problem is I am trying to upgrade to the latest from version 2.27 but in order to do so I have to upgrade to 2.28 then 2.29 then 2.30 and then I can upgrade to which version I want. I can upgrade to version 2.29 and still have all my data working but once I upgrade to 2.30 I cannot access the data.

Thank you for your response. I removed all the SQL views and that solved the problem. I can now view my data in versions 2.29 and 2.30

I need help upgrading DHIS2 from version 2.29 to 2.30

Support - Assistance technique

Stephan_Mestach (Stéphan Mestach) 4 September 2024 19:40 5

I found a few entries

Emergency! problems for dhis2.32/33: duplicate key value violates unique
Duplicate key value in period table
Analytics failing after upgrade to 2.27 build e33b34d

but no clear solution sadly