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.)
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>
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”.
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.)
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.
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.