dhis2-devs team mailing list archive

[Juma Lungo <jlungo@xxxxxxxxx>]

Hi
DHIS2 v2.18 is failing to generate Resource Tables. The instance has been working fine for a year - since August 2014. However, It has stopped generating these tables on the 10th August 2015. As a result, all newly entered data can not be seen in the reports.
Please help. Should I just delete the duplicating records in the "_periodstructure" table?


Here is the error message.
2015-08-23 06:59:49    Process failed: PreparedStatementCallback; SQL [insert into _periodstructure values (?,?,?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR: duplicate key value violates unique constraint "in_periodstructure_iso" Detail: Key (iso)=(2014Q3) already exists.; nested exception is org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "in_periodstructure_iso" Detail: Key (iso)=(2014Q3) already exists. 
2015-08-23 06:59:44    Generating resource tables