Re: [Dhis2-users] Resource Table error

2016-04-07 Thread channara rin
dear alex, how can i do for remove duplicate period? Yes, right knut. by the way, if i upgrade to v2.20, that version doesn't have individual record function, so my problem is i don't want to run aggregate data automatic. On Thu, Apr 7, 2016 at 11:29 PM, Knut Staring wrote: > Agree with Alex tha

Re: [Dhis2-users] Resource Table error

2016-04-07 Thread Knut Staring
Agree with Alex that you should really try to do an upgrade - just please make sure to back up everything first! However, I notice you had the same problem in October? Was it solve then and now it has come back - or have you had the problem now for 6 months? https://lists.launchpad.net/dhis2-user

Re: [Dhis2-users] Resource Table error

2016-04-07 Thread Alex Tumwesigye
Channara, The issue is related to timezone and was fixed. Upgrade to at least 2.20 or 2.21 but you have to first remove the duplicate period. Alex On Thu, Apr 7, 2016 at 7:08 PM, Knut Staring wrote: > Hi Channara, > > It seems to me that the problem is that the _dateperiodstructure table > has

Re: [Dhis2-users] Resource Table error

2016-04-07 Thread Knut Staring
Hi Channara, It seems to me that the problem is that the _dateperiodstructure table has not been dropped (not sure why). Then when you try to regenerate it, it tries to insert the same values, starting from 1975-01-01 (which is the first row in the table) On Thu, Apr 7, 2016 at 6:01 PM, channara

Re: [Dhis2-users] Resource Table error

2016-04-07 Thread channara rin
dear Alex, what you mean was fixed? i currently using: Version:2.19Build revision:19251Build date:2015-07-01 02:04 On Thu, Apr 7, 2016 at 10:46 PM, Alex Tumwesigye wrote: > Dear Channara, > > I think this bug was fixed. > The date "1975-01-01" is duplicated. > check your period table for any ano

Re: [Dhis2-users] Resource Table error

2016-04-07 Thread Alex Tumwesigye
Dear Channara, I think this bug was fixed. The date "1975-01-01" is duplicated. check your period table for any anomaly for that date. Alex On Thu, Apr 7, 2016 at 6:02 PM, channara rin wrote: > Dear friend, > when i run analytic, i always got error like below. how to fix this > problem? > > ==

[Dhis2-users] Resource Table error

2016-04-07 Thread channara rin
Dear friend, when i run analytic, i always got error like below. how to fix this problem? == Resource table process failed Resource table process failed, please check the logs. Time: 2016-04-07T21:45:16.145+07:00. Message: PreparedStatementCallback; SQL [ins