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
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@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
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@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 <vgarciabnz@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 <jlungo@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: DHIS 2 developers in Launchpad
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : DHIS 2 developers in Launchpad
> More help : ListHelp - Launchpad Help
>