Yes, at least you could set it up on a test server and see if it fixes the problem. On Aug 24, 2015 5:21 PM, "Victor Garcia" <vgarcia...@gmail.com> wrote:
> 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
