dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #39098
Re: Problems in generating Resource Tables
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" <vgarciabnz@xxxxxxxxx> 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 <larshelge@xxxxxxxxx>
> 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 <vgarciabnz@xxxxxxxxx>
> 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 <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
> >> >
> >>
> >> _______________________________________________
> >> 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
> >
> >
> >
> >
> > --
> > Lars Helge Øverland
> > Lead developer, DHIS 2
> > University of Oslo
> > Skype: larshelgeoverland
> > http://www.dhis2.org
> >
>
References