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
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
