Thanks Lars. So this could be a good reason to think about moving to 2.19. regards,
Víctor On 24 August 2015 at 09:10, Lars Helge Øverland <larshe...@gmail.com> wrote: > Hi Victor, > > we believe this error is related to the calendar solution and the server > timezone settings. > > We have made a fix for this in 2.19 so you should be good by upgrading your > instance. > > regards, > > Lars > > > On Mon, Aug 24, 2015 at 4:03 PM, Victor Garcia <vgarcia...@gmail.com> wrote: >> >> 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 <jlu...@yahoo.com> 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@lists.launchpad.net >> > Unsubscribe : https://launchpad.net/~dhis2-devs >> > More help : https://help.launchpad.net/ListHelp >> > >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~dhis2-devs >> Post to : dhis2-devs@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-devs >> More help : https://help.launchpad.net/ListHelp > > > > > -- > Lars Helge Øverland > Lead developer, DHIS 2 > University of Oslo > Skype: larshelgeoverland > http://www.dhis2.org > _______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp