dhis2-devs team mailing list archive

[Victor Garcia <vgarciabnz@xxxxxxxxx>]

Hi,

we have experienced the same problem in our dhis instances (using
version 2.18), and also about 10th August. We have no idea about the
reason, but it would be good to find it out so we can know if it is
going to happen again in the future.

To solve the issue, try with:

1. In Data Administration -> Maintenance, execute Prune Periods.
2. In Data Administration -> Cache Statistics, execute Clear Cache.
3. Try to generate resource tables again.

Hope this helps.

On 23 August 2015 at 02:59, Juma Lungo <jlungo@xxxxxxxxx> wrote:
> 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
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>