Problems in generating Resource Tables

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

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: 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

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: 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

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: 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

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@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 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.
  1. In Data Administration -> Cache Statistics, execute Clear Cache.
  1. 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: 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