dhis2-devs team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

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 <https://www.dhis2.org>