organunit Error

Hello,

I have a problem with the units of organizations. When I try to add a unit of organization, I have an error message shows as image attachment.

I changed version of the system. 2.13 A 2.14, nothing works. I did the maintenance operations, nothing works.

image

···


Riddy NDOMA
Software Developer
Skype: riddyndoma, G+: riddyndoma, FB: riddy ndoma

Twitter: riddyndoma, LinkedIn: riddy ndoma
Blog: http://riddyndoma.blogspot.com/

Vous servir est mon désire (Serving you is my desire)

Riddy,

Can you send along the log file which will give us more insight into what is happening?

Thank you,

Dan

Dan Cocos
BAO Systemswww.baosystems.com

T: +1 202-352-2671 | skype: dancocos

···

On Mar 16, 2014, at 10:32 AM, riddy ndoma riddyndoma@gmail.com wrote:

Hello,

I have a problem with the units of organizations. When I try to add a unit of organization, I have an error message shows as image attachment.

I changed version of the system. 2.13 A 2.14, nothing works. I did the maintenance operations, nothing works.


Riddy NDOMA
Software Developer
Skype: riddyndoma, G+: riddyndoma, FB: riddy ndoma

Twitter: riddyndoma, LinkedIn: riddy ndoma
Blog: http://riddyndoma.blogspot.com/

Vous servir est mon désire (Serving you is my desire)

<2014-03-16 15_28_02-.png>_______________________________________________
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

Hello,

I have a problem with the units of organizations. When I try to add a unit of organization, I have an error message shows as image attachment.

I changed version of the system. 2.13 A 2.14, nothing works. I did the maintenance operations, nothing works.

image

···


Riddy NDOMA
Software Developer
Skype: riddyndoma, G+: riddyndoma, FB: riddy ndoma

Twitter: riddyndoma, LinkedIn: riddy ndoma
Blog: http://riddyndoma.blogspot.com/

Vous servir est mon désire (Serving you is my desire)

Hi @Dan Cocos,
This is the log in attachment

dhis.log (38.8 KB)

···

2014-03-16 16:36 GMT+01:00 Dan Cocos dan@dancocos.com:

Riddy,

Can you send along the log file which will give us more insight into what is happening?

Thank you,

Dan

Dan Cocos
BAO Systems www.baosystems.com

T: +1 202-352-2671 | skype: dancocos

On Mar 16, 2014, at 10:32 AM, riddy ndoma riddyndoma@gmail.com wrote:

Hello,

I have a problem with the units of organizations. When I try to add a unit of organization, I have an error message shows as image attachment.

I changed version of the system. 2.13 A 2.14, nothing works. I did the maintenance operations, nothing works.


Riddy NDOMA
Software Developer
Skype: riddyndoma, G+: riddyndoma, FB: riddy ndoma

Twitter: riddyndoma, LinkedIn: riddy ndoma
Blog: http://riddyndoma.blogspot.com/

Vous servir est mon désire (Serving you is my desire)

<2014-03-16 15_28_02-.png>_______________________________________________
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


Riddy NDOMA
Software Developer
Skype: riddyndoma, G+: riddyndoma, FB: riddy ndoma
Twitter: riddyndoma, LinkedIn: riddy ndoma

Blog: http://riddyndoma.blogspot.com/

Vous servir est mon désire (Serving you is my desire)

Hi Riddy,

There are a couple of clues to the problem:

Caused by: org.hibernate.exception.ConstraintViolationException: could not execute statement

Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint “organisationunit_pkey”

Caused by: java.lang.OutOfMemoryError: Java heap space

Caused by: java.lang.OutOfMemoryError: Java heap space

Is it possible that you had imported meta data into the database directly without using the nextval function? If yes, then you have to update your Hibernate_Sequence number to start at the current value of the highest id in your organisation unit table. This might be affecting the memory as well but you might also want to have a look at you JAVA-OPTS settings.

Best regards,

Busoye

···

2014-03-16 16:36 GMT+01:00 Dan Cocos dan@dancocos.com:

Riddy,

Can you send along the log file which will give us more insight into what is happening?

Thank you,

Dan

Dan Cocos
BAO Systems www.baosystems.com

T: +1 202-352-2671 | skype: dancocos

On Mar 16, 2014, at 10:32 AM, riddy ndoma riddyndoma@gmail.com wrote:

Hello,

I have a problem with the units of organizations. When I try to add a unit of organization, I have an error message shows as image attachment.

I changed version of the system. 2.13 A 2.14, nothing works. I did the maintenance operations, nothing works.


Riddy NDOMA
Software Developer
Skype: riddyndoma, G+: riddyndoma, FB: riddy ndoma

Twitter: riddyndoma, LinkedIn: riddy ndoma
Blog: http://riddyndoma.blogspot.com/

Vous servir est mon désire (Serving you is my desire)

<2014-03-16 15_28_02-.png>_______________________________________________
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


Riddy NDOMA
Software Developer
Skype: riddyndoma, G+: riddyndoma, FB: riddy ndoma
Twitter: riddyndoma, LinkedIn: riddy ndoma

Blog: http://riddyndoma.blogspot.com/

Vous servir est mon désire (Serving you is my desire)

Thank you very much Busoye.

It works. I created a small java class to take in organunit Ms Access to the database postgresql directly to fill automatically because it was a lot. probably the hiernate sequence did not change. I updated the START number.

I wish you a good stay in the DRC

···

2014-03-17 19:11 GMT+01:00 Adebusoye Anifalaje busoye@hisp.org:

Hi Riddy,

There are a couple of clues to the problem:

Caused by: org.hibernate.exception.ConstraintViolationException: could not execute statement

Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint “organisationunit_pkey”

Caused by: java.lang.OutOfMemoryError: Java heap space

Caused by: java.lang.OutOfMemoryError: Java heap space

Is it possible that you had imported meta data into the database directly without using the nextval function? If yes, then you have to update your Hibernate_Sequence number to start at the current value of the highest id in your organisation unit table. This might be affecting the memory as well but you might also want to have a look at you JAVA-OPTS settings.

Best regards,

Busoye

On 17 Mar 2014, at 15:09, riddy ndoma riddyndoma@gmail.com wrote:

Hi @Dan Cocos,
This is the log in attachment

<dhis.log>_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp


Riddy NDOMA
Software Developer
Skype: riddyndoma, G+: riddyndoma, FB: riddy ndoma

Twitter: riddyndoma, LinkedIn: riddy ndoma
Blog: http://riddyndoma.blogspot.com/

Vous servir est mon désire (Serving you is my desire)

2014-03-16 16:36 GMT+01:00 Dan Cocos dan@dancocos.com:

Riddy,

Can you send along the log file which will give us more insight into what is happening?

Thank you,

Dan

Dan Cocos
BAO Systems www.baosystems.com

T: +1 202-352-2671 | skype: dancocos

On Mar 16, 2014, at 10:32 AM, riddy ndoma riddyndoma@gmail.com wrote:

Hello,

I have a problem with the units of organizations. When I try to add a unit of organization, I have an error message shows as image attachment.

I changed version of the system. 2.13 A 2.14, nothing works. I did the maintenance operations, nothing works.


Riddy NDOMA
Software Developer
Skype: riddyndoma, G+: riddyndoma, FB: riddy ndoma

Twitter: riddyndoma, LinkedIn: riddy ndoma
Blog: http://riddyndoma.blogspot.com/

Vous servir est mon désire (Serving you is my desire)

<2014-03-16 15_28_02-.png>_______________________________________________
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


Riddy NDOMA
Software Developer
Skype: riddyndoma, G+: riddyndoma, FB: riddy ndoma
Twitter: riddyndoma, LinkedIn: riddy ndoma

Blog: http://riddyndoma.blogspot.com/

Vous servir est mon désire (Serving you is my desire)