Difficulty editing + creating new programs

Hi!
Trying to edit programs but forms not visible ..same effect trying to
create new programs.

Platform currently running on Tomcat 7 + (log attached) PostgreSQL 10
+ newest WAR-file on the DHIS2 website. (Using the Sierra Leone test
data for now ...running on Windows 10 x64 version.)

Tomcat log file:

https://cdn.fbsbx.com/v/t59.2708-21/36611084_10204811029353030_2000401054134435840_n.log/catalina.2018-07-10.log?_nc_cat=0&oh=6da4441a6ce1de6edd0e7df7b1831154&oe=5B493D87&dl=1

3 error msgs so far:

Job 'File resource clean up' failed
Message: could not execute statement; SQL [n/a]; constraint
[fk_document_fileresourceid]; nested exception is
org.hibernate.exception.ConstraintViolationException: could not
execute statement

Cause: org.hibernate.exception.ConstraintViolationException: could not
execute statement

at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:112)

The error message continues with many exceptions down the line.

Job 'Dataset notification' failed

Job 'Data statistics' failed

Any insight much appreciated.
Thanks!

···

---------- Forwarded message ----------
From: Kristina Ishimwe <kristina.ishimwe@gmail.com>
Date: Thu, Jul 12, 2018 at 3:00 PM
Subject: Fwd: Difficulty editing + creating new programs
To: Viljar Bakken <viljar.bakken@gmail.com>

Sent from my iPhone

Hi Viljar,

I am assuming your problems are related to the maintenance app in DHIS 2? This is where you create or edit metadata, including programs.

You say the form is not visible when you edit or create a program - does that mean someone else have created the programs you want to edit? Could you elaborate on what you mean the form is not visible? Screenshots would be appreciated.

When you are looking at the page where you encounter the problem, could you open the developer tools in your browser and attach a screenshot of the messages listed (if any)? Most browsers has this option, for example in chrome or firefox, you can right click on the page you are on, and choose “inspect”. You will get a window with multiple tabs, and the information I am interested in can be found under “console”.

···

On Thu, Jul 12, 2018 at 3:09 PM, Viljar Bakken viljar.bakken@gmail.com wrote:

---------- Forwarded message ----------

From: Kristina Ishimwe kristina.ishimwe@gmail.com

Date: Thu, Jul 12, 2018 at 3:00 PM

Subject: Fwd: Difficulty editing + creating new programs

To: Viljar Bakken viljar.bakken@gmail.com

Hi!

Trying to edit programs but forms not visible …same effect trying to

create new programs.

Platform currently running on Tomcat 7 + (log attached) PostgreSQL 10

  • newest WAR-file on the DHIS2 website. (Using the Sierra Leone test

data for now …running on Windows 10 x64 version.)

Tomcat log file:

https://cdn.fbsbx.com/v/t59.2708-21/36611084_10204811029353030_2000401054134435840_n.log/catalina.2018-07-10.log?_nc_cat=0&oh=6da4441a6ce1de6edd0e7df7b1831154&oe=5B493D87&dl=1

3 error msgs so far:

Job ‘File resource clean up’ failed

Message: could not execute statement; SQL [n/a]; constraint

[fk_document_fileresourceid]; nested exception is

org.hibernate.exception.ConstraintViolationException: could not

execute statement

Cause: org.hibernate.exception.ConstraintViolationException: could not

execute statement

at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:112)

The error message continues with many exceptions down the line.

Job ‘Dataset notification’ failed

Job ‘Data statistics’ failed

Any insight much appreciated.

Thanks!

Sent from my iPhone


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

Stian Sandvold
Software developer, DHIS2

University of Oslo

http://www.dhis2.org

Hello Stian, thank you for the quick reply.

The noresponse.PNG shows a screenshot of the unresponsive webpage
after we try to edit a program.

The error.PNG shows what the console message is saying after the
webpage fails to load.

···

---------- Forwarded message ----------
From: Viljar Bakken <viljar.bakken@gmail.com>
Date: Thu, Jul 12, 2018 at 6:21 PM
Subject: Re: [Dhis2-users] Fwd: Difficulty editing + creating new programs
To: Stian Sandvold <stian@dhis2.org>

On Thu, Jul 12, 2018 at 3:33 PM, Stian Sandvold <stian@dhis2.org> wrote:

Hi Viljar,

I am assuming your problems are related to the maintenance app in DHIS 2?
This is where you create or edit metadata, including programs.

You say the form is not visible when you edit or create a program - does
that mean someone else have created the programs you want to edit? Could you
elaborate on what you mean the form is not visible? Screenshots would be
appreciated.

When you are looking at the page where you encounter the problem, could you
open the developer tools in your browser and attach a screenshot of the
messages listed (if any)? Most browsers has this option, for example in
chrome or firefox, you can right click on the page you are on, and choose
"inspect". You will get a window with multiple tabs, and the information I
am interested in can be found under "console".

On Thu, Jul 12, 2018 at 3:09 PM, Viljar Bakken <viljar.bakken@gmail.com> > wrote:

---------- Forwarded message ----------
From: Kristina Ishimwe <kristina.ishimwe@gmail.com>
Date: Thu, Jul 12, 2018 at 3:00 PM
Subject: Fwd: Difficulty editing + creating new programs
To: Viljar Bakken <viljar.bakken@gmail.com>

Hi!
Trying to edit programs but forms not visible ..same effect trying to
create new programs.

Platform currently running on Tomcat 7 + (log attached) PostgreSQL 10
+ newest WAR-file on the DHIS2 website. (Using the Sierra Leone test
data for now ...running on Windows 10 x64 version.)

Tomcat log file:

https://cdn.fbsbx.com/v/t59.2708-21/36611084_10204811029353030_2000401054134435840_n.log/catalina.2018-07-10.log?_nc_cat=0&oh=6da4441a6ce1de6edd0e7df7b1831154&oe=5B493D87&dl=1

3 error msgs so far:

Job 'File resource clean up' failed
Message: could not execute statement; SQL [n/a]; constraint
[fk_document_fileresourceid]; nested exception is
org.hibernate.exception.ConstraintViolationException: could not
execute statement

Cause: org.hibernate.exception.ConstraintViolationException: could not
execute statement

at
org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:112)

The error message continues with many exceptions down the line.

Job 'Dataset notification' failed

Job 'Data statistics' failed

Any insight much appreciated.
Thanks!
>
>

Sent from my iPhone

_______________________________________________
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

--
Stian Sandvold
Software developer, DHIS2
University of Oslo
http://www.dhis2.org

Hi Viljar

The web console here only shows the tip of the iceberg. Can you provide the server logs? there should be some kind of stack trace in it… regarding this request. That said it throwing something that should have been caught by the D2js ilbrary, so hopefully they can fix that.

···

On Mon, Jul 16, 2018 at 3:04 PM, Viljar Bakken viljar.bakken@gmail.com wrote:

---------- Forwarded message ----------

From: Viljar Bakken viljar.bakken@gmail.com

Date: Thu, Jul 12, 2018 at 6:21 PM

Subject: Re: [Dhis2-users] Fwd: Difficulty editing + creating new programs

To: Stian Sandvold stian@dhis2.org

Hello Stian, thank you for the quick reply.

The noresponse.PNG shows a screenshot of the unresponsive webpage

after we try to edit a program.

The error.PNG shows what the console message is saying after the

webpage fails to load.

On Thu, Jul 12, 2018 at 3:33 PM, Stian Sandvold stian@dhis2.org wrote:

Hi Viljar,

I am assuming your problems are related to the maintenance app in DHIS 2?

This is where you create or edit metadata, including programs.

You say the form is not visible when you edit or create a program - does

that mean someone else have created the programs you want to edit? Could you

elaborate on what you mean the form is not visible? Screenshots would be

appreciated.

When you are looking at the page where you encounter the problem, could you

open the developer tools in your browser and attach a screenshot of the

messages listed (if any)? Most browsers has this option, for example in

chrome or firefox, you can right click on the page you are on, and choose

“inspect”. You will get a window with multiple tabs, and the information I

am interested in can be found under “console”.

On Thu, Jul 12, 2018 at 3:09 PM, Viljar Bakken viljar.bakken@gmail.com

wrote:

---------- Forwarded message ----------

From: Kristina Ishimwe kristina.ishimwe@gmail.com

Date: Thu, Jul 12, 2018 at 3:00 PM

Subject: Fwd: Difficulty editing + creating new programs

To: Viljar Bakken viljar.bakken@gmail.com

Hi!

Trying to edit programs but forms not visible …same effect trying to

create new programs.

Platform currently running on Tomcat 7 + (log attached) PostgreSQL 10

  • newest WAR-file on the DHIS2 website. (Using the Sierra Leone test

data for now …running on Windows 10 x64 version.)

Tomcat log file:

https://cdn.fbsbx.com/v/t59.2708-21/36611084_10204811029353030_2000401054134435840_n.log/catalina.2018-07-10.log?_nc_cat=0&oh=6da4441a6ce1de6edd0e7df7b1831154&oe=5B493D87&dl=1

3 error msgs so far:

Job ‘File resource clean up’ failed

Message: could not execute statement; SQL [n/a]; constraint

[fk_document_fileresourceid]; nested exception is

org.hibernate.exception.ConstraintViolationException: could not

execute statement

Cause: org.hibernate.exception.ConstraintViolationException: could not

execute statement

at

org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:112)

The error message continues with many exceptions down the line.

Job ‘Dataset notification’ failed

Job ‘Data statistics’ failed

Any insight much appreciated.

Thanks!

Sent from my iPhone


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

Stian Sandvold

Software developer, DHIS2

University of Oslo

http://www.dhis2.org


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

Morten Olav Hansen

Senior Engineer, DHIS 2

Team Integration Lead

University of Oslo

http://www.dhis2.org

Hi Viljar,

This issue is related to new version of tomcat (Romain reported last week) and is fixed in two ways.

1- DHIS2 should start encoding all api calls.

2- Add relaxedQueryChars="[]" to tomcat http connector

Alex

···

On Monday, July 16, 2018, Viljar Bakken viljar.bakken@gmail.com wrote:

---------- Forwarded message ----------

From: Viljar Bakken viljar.bakken@gmail.com

Date: Thu, Jul 12, 2018 at 6:21 PM

Subject: Re: [Dhis2-users] Fwd: Difficulty editing + creating new programs

To: Stian Sandvold stian@dhis2.org

Hello Stian, thank you for the quick reply.

The noresponse.PNG shows a screenshot of the unresponsive webpage

after we try to edit a program.

The error.PNG shows what the console message is saying after the

webpage fails to load.

On Thu, Jul 12, 2018 at 3:33 PM, Stian Sandvold stian@dhis2.org wrote:

Hi Viljar,

I am assuming your problems are related to the maintenance app in DHIS 2?

This is where you create or edit metadata, including programs.

You say the form is not visible when you edit or create a program - does

that mean someone else have created the programs you want to edit? Could you

elaborate on what you mean the form is not visible? Screenshots would be

appreciated.

When you are looking at the page where you encounter the problem, could you

open the developer tools in your browser and attach a screenshot of the

messages listed (if any)? Most browsers has this option, for example in

chrome or firefox, you can right click on the page you are on, and choose

“inspect”. You will get a window with multiple tabs, and the information I

am interested in can be found under “console”.

On Thu, Jul 12, 2018 at 3:09 PM, Viljar Bakken viljar.bakken@gmail.com > > > wrote:

---------- Forwarded message ----------

From: Kristina Ishimwe kristina.ishimwe@gmail.com

Date: Thu, Jul 12, 2018 at 3:00 PM

Subject: Fwd: Difficulty editing + creating new programs

To: Viljar Bakken viljar.bakken@gmail.com

Hi!

Trying to edit programs but forms not visible …same effect trying to

create new programs.

Platform currently running on Tomcat 7 + (log attached) PostgreSQL 10

  • newest WAR-file on the DHIS2 website. (Using the Sierra Leone test

data for now …running on Windows 10 x64 version.)

Tomcat log file:

https://cdn.fbsbx.com/v/t59.2708-21/36611084_10204811029353030_2000401054134435840_n.log/catalina.2018-07-10.log?_nc_cat=0&oh=6da4441a6ce1de6edd0e7df7b1831154&oe=5B493D87&dl=1

3 error msgs so far:

Job ‘File resource clean up’ failed

Message: could not execute statement; SQL [n/a]; constraint

[fk_document_fileresourceid]; nested exception is

org.hibernate.exception.ConstraintViolationException: could not

execute statement

Cause: org.hibernate.exception.ConstraintViolationException: could not

execute statement

at

org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:112)

The error message continues with many exceptions down the line.

Job ‘Dataset notification’ failed

Job ‘Data statistics’ failed

Any insight much appreciated.

Thanks!

Sent from my iPhone


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

Stian Sandvold

Software developer, DHIS2

University of Oslo

http://www.dhis2.org


Alex Tumwesigye

Kampala

Uganda
+256 774149 775, + 256 759 800161

Skype ID: talexie

IT Consultant (Servers, Networks and Security, Health Information Systems - DHIS2, Disease Outbreak & Surveillance Systems) & Solar Consultant

"I don’t want to be anything other than what I have been - one tree hill "