Resource table update failed

Hi all,

I’m using the DHIS2 version 2.26.

I tried running resource tables for first time, after data entry. It gave me following error.

Tried ‘clear analytic tables’ in maintanance, and it didn’t help.

Also I checked the _dateperiodstructure_temp table, and it has dates upto 2002-09-31, but there is no value of ‘2002-10-05’

2017-08-08 10:15:14
Process failed: PreparedStatementCallback; SQL [insert into _dateperiodstructure_temp values (?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR: duplicate key value violates unique constraint “_dateperiodstructure_temp_pkey” Detail: Key (dateperiod)=(2002-10-05) already exists.; nested exception is org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint “_dateperiodstructure_temp_pkey” Detail: Key (dateperiod)=(2002-10-05) already exists.
2017-08-08 10:14:57
Updating resource tables
2017-08-08 10:14:57
Analytics table update process started

Kindly expect an advice, to resolve this matter. Thanks a lot for your time.

Best Regards,

Tharanga