I need help upgrading DHIS2 from version 2.29 to 2.30

Support - Assistance technique
4

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) already exists.; nested exception is org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "_dateperiodstructure_temp_pkey"
  Detail: Key (dateperiod)=(1993-02-06) already exists.

First make sure you are upgrading to the lastest 2.30 patch ?

I guess it’s not in the aggregate model ?

but you can verify with a query like this

select * from period where startdate = '1993-02-06' or enddate = '1993-02-06'

if it’s in the tracker or event model then it’s probably more a bug in the code.

I don’t remember if it’s available in 2.30 but normally there’s a maintenance task to delete all these _… tables or running the period/ressources tables generation separately

I would search the jira or this forum about similar issue.
or ask @Gassim

1 Like