Thanks everyone we did find out what the problem was – it was sql views related to the upgrade from 2.20 > 2.21.
Our problem is resolved now.
···
From: Jason Pickering [mailto:jason.p.pickering@gmail.com]
Sent: 25 January 2016 09:35 AM
To: Elmarie Claasen
Cc: Alex Tumwesigye; Ola Hodne Titlestad; brendon@hisp.org; dhis2-devs
Subject: Re: [Dhis2-devs] Problem opening settings app after updating to 2.22
Hi Elmarie,
I have also seen some other issues when certain metadata elements are not
configured properly. 2.22 is a bit stricter on medata validity. Please open up your browser and post a copy of the console log there if there are any Javascript errors.
Best regards,
Jason
On Mon, Jan 25, 2016 at 8:24 AM, Elmarie Claasen elmarie@hisp.org wrote:
Thanks we will try this although that specific instance had NO SMS or email settings configured so I doubt that this will be the problem
Regards,
Elmarie Claasen
![Hisp logo]()
Project Manager
Health Information Systems Program
Tel: 041-367 1027
Cell: 082 374 2209
E-mail: elmarie@hisp.org
Skype: elmarie.claasen52
This message and any attachments are subject to a disclaimer published at http://www.hisp.org/policies.html#comms_disclaimer . Please read the disclaimer before opening any attachment or taking any other action in terms of this electronic transmission.
If you cannot access the disclaimer, kindly send an email to disclaimer@hisp.org and a copy will be provided to you. By replying to this e-mail or opening any attachment you agree to be bound by the provisions of the disclaimer.
From: Alex Tumwesigye [mailto:atumwesigye@gmail.com]
Sent: 25 January 2016 09:13 AM
To: Ola Hodne Titlestad
Cc: Elmarie Claasen; dhis2-devs; brendon@hisp.org; Morten Olav Hansen
Subject: Re: [Dhis2-devs] Problem opening settings app after updating to 2.22
Hi,
The SQL statement required is:
delete from systemsetting where name=‘SMS_CONFIG’ or name=‘keySmsConfig’;
Alex
On Mon, Jan 25, 2016 at 9:53 AM, Ola Hodne Titlestad olati@ifi.uio.no wrote:
Hi,
I just heard from Alex and Prosper in Uganda that this problem is caused by a change in the sms gateway configuration in 2.22, so most likely affects all instances that make use of this feature.
Manually deleting the existing sms gateway configuration in the database before upgrading to 2.22 seems to do the trick.
Alex, maybe you could add the sql statement here?
Ola
On 25 Jan 2016 07:38, “Elmarie Claasen” elmarie@hisp.org wrote:
Hi Morten,
Here is the log file from the error we got from starting up the instance on 2.22 and going into Settings App.
Hope this can assist to identify the error. We have no problem opening settings in 2.19, 2.20 and 2.21 for the same instance.
Regards,
Elmarie Claasen
![Hisp logo]()
Project Manager
Health Information Systems Program
Tel: 041-367 1027
Cell: 082 374 2209
E-mail: elmarie@hisp.org
Skype: elmarie.claasen52
This message and any attachments are subject to a disclaimer published at http://www.hisp.org/policies.html#comms_disclaimer . Please read the disclaimer before opening any attachment or taking any other action in terms of this electronic transmission.
If you cannot access the disclaimer, kindly send an email to disclaimer@hisp.org and a copy will be provided to you. By replying to this e-mail or opening any attachment you agree to be bound by the provisions of the disclaimer.
From: Morten Olav Hansen [mailto:mortenoh@gmail.com]
Sent: 22 January 2016 06:11 AM
To: Alex Tumwesigye
Cc: Elmarie Claasen; brendon@hisp.org; DHIS 2 developers
Subject: Re: [Dhis2-devs] Problem opening settings app after updating to 2.22
Hi
This seems to be linked to a wrong configuration in your database…
http://pec.dhis.dhmis.org/staging/api/configuration [HTTP/1.1 500 Internal Server Error 503ms]
There should have been a stack trace on the server side as part of this 500 error, could you provide that? did you by any chance have SMS gateway configured before you upgraded? (there have been some config errors linked to this)
–
Morten
On Thu, Jan 21, 2016 at 7:17 PM, Alex Tumwesigye atumwesigye@gmail.com wrote:
Dear Elmarie/Knut,
We experienced the same. We (Prosper and I) have shared with Markus the error.
Alex
On Thu, Jan 21, 2016 at 2:51 PM, Elmarie Claasen elmarie@hisp.org wrote:
Hi Knut,
Thanks, this seems to be the main error on the browser console – can you assist with what the problem could be?
Failed to load system settings: Object { readyState: 4, getResponseHeader: .ajax/v.getResponseHeader(), getAllResponseHeaders: .ajax/v.getAllResponseHeaders(), setRequestHeader: .ajax/v.setRequestHeader(), overrideMimeType: .ajax/v.overrideMimeType(), statusCode: .ajax/v.statusCode(), abort: .ajax/v.abort(), state: .Deferred/d.state(), always: .Deferred/d.always(), promise: .Deferred/d.promise(), 10 more… }
The full browser console message is attached.
Regards,
Elmarie Claasen
![Hisp logo]()
Project Manager
Health Information Systems Program
Tel: 041-367 1027
Cell: 082 374 2209
E-mail: elmarie@hisp.org
Skype: elmarie.claasen52
This message and any attachments are subject to a disclaimer published at http://www.hisp.org/policies.html#comms_disclaimer . Please read the disclaimer before opening any attachment or taking any other action in terms of this electronic transmission.
If you cannot access the disclaimer, kindly send an email to disclaimer@hisp.org and a copy will be provided to you. By replying to this e-mail or opening any attachment you agree to be bound by the provisions of the disclaimer.
From: Knut Staring [mailto:knutst@gmail.com]
Sent: 21 January 2016 01:34 PM
To: Elmarie Claasen
Cc: DHIS 2 developers; brendon@hisp.org
Subject: Re: [Dhis2-devs] Problem opening settings app after updating to 2.22
Whenever the GUI seems to be hanging/spinning, it is helpful if you open the browser console and look for errors there.
Knut
On Thu, Jan 21, 2016 at 12:14 PM, Elmarie Claasen elmarie@hisp.org wrote:
Hi all,
Please see the email below from our ICT specialist J
Can you please assist with possible cause of this problem or is it a bug although I do see that the Settings page open on the SL Demo.
Thanks
Elmarie Claasen
HISP-SA
From: Brendon Lines [mailto:brendon@hisp.org]
Sent: 21 January 2016 01:09 PM
To: Elmarie Claasen
Subject: Possible 2.22 bug
Hi there,
I am having an issue with bringing up the settings page using war 2.22. The circle just carries on spinning.
I have created the dhis.conf file with the following details and deleted hibernate.properties:
# Hibernate SQL dialect
connection.dialect = org.hibernate.dialect.PostgreSQLDialect
# JDBC driver class
connection.driver_class = org.postgresql.Driver
# JDBC driver connection URL
connection.url = jdbc:postgresql://IP:PORT/DB name
# Database username
connection.username = dhis
# Database password
connection.password = xxxxxxxxxxxxxxxxxxxxxxxxxxxx
# Database schema behavior, can be validate, update, create, create-drop
connection.schema = update
# Encryption password (sensitive)
encryption.password = xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I have added the 2 java policy files under (that being Local_policy and US_export_policy.jar
/usr/lib/jvm/java-8-oracle/jre/lib/security
I upgraded from war / DB 2.19, the process I followed was, ran upgrade script from 2.19 - 2.20 on DB, downloaded war 2.20 and started tomcat, then shutdown tomcat, deleted WAR 2.20 and downloaded WAR 2.21 started tomcat and allowed everything to run, shutdown tomcat, deleted war 2.21, deleted hibernate.properties and created dhis.conf, downloaded 2.22 and started tomcat.
All other aspects of the application open and run, the only issue is opening settings, is there something im missing. There are no errors in the catalina.out log file.
Java Java-8-oracle/jre - 1.8.0.66
Tomcat 8.0.26
O/S: Linux 14.04 amd64
Java opts:
-Xmx1962m -Xms981m -XX:MaxPermSize=500m -XX:PermSize=200m
Build Version: 21773
Build date: 2016/01/21 09:45
Brendon lines
HISP
Cell: 078 4444 568
![hisp_banner]()
This message and any attachments are subject to a disclaimer published at http://www.hisp.org/policies.html#comms_disclaimer. Please read the disclaimer before opening any attachment or taking any other action in terms of this electronic transmission. If you cannot access the disclaimer, kindly send an email to disclaimer@hisp.org and a copy will be provided to you. By replying to this e-mail or opening any attachment you agree to be bound by the provisions of the disclaimer.
This message and any attachments are subject to a disclaimer published at http://www.hisp.org/policies.html#comms_disclaimer. Please read the disclaimer before opening any attachment or taking any other action in terms of this electronic transmission. If you cannot access the disclaimer, kindly send an email to disclaimer@hisp.org and a copy will be provided to you. By replying to this e-mail or opening any attachment you agree to be bound by the provisions of the disclaimer.
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
–
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org
This message and any attachments are subject to a disclaimer published at http://www.hisp.org/policies.html#comms_disclaimer. Please read the disclaimer before opening any attachment or taking any other action in terms of this electronic transmission. If you cannot access the disclaimer, kindly send an email to disclaimer@hisp.org and a copy will be provided to you. By replying to this e-mail or opening any attachment you agree to be bound by the provisions of the disclaimer.
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
–
Alex Tumwesigye
Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET
Kampala
Uganda
IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya
IT Specialist (Servers, Networks and Security, Health Information Systems - DHIS2 ) & Solar Consultant
+256 774149 775, + 256 759 800161
"I don’t want to be anything other than what I have been - one tree hill "
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
This message and any attachments are subject to a disclaimer published at http://www.hisp.org/policies.html#comms_disclaimer. Please read the disclaimer before opening any attachment or taking any other action in terms of this electronic transmission. If you cannot access the disclaimer, kindly send an email to disclaimer@hisp.org and a copy will be provided to you. By replying to this e-mail or opening any attachment you agree to be bound by the provisions of the disclaimer.
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
–
Alex Tumwesigye
Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET
Kampala
Uganda
IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya
IT Specialist (Servers, Networks and Security, Health Information Systems - DHIS2 ) & Solar Consultant
+256 774149 775, + 256 759 800161
"I don’t want to be anything other than what I have been - one tree hill "
This message and any attachments are subject to a disclaimer published at http://www.hisp.org/policies.html#comms_disclaimer. Please read the disclaimer before opening any attachment or taking any other action in terms of this electronic transmission. If you cannot access the disclaimer, kindly send an email to disclaimer@hisp.org and a copy will be provided to you. By replying to this e-mail or opening any attachment you agree to be bound by the provisions of the disclaimer.
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
–
Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049
This message and any attachments are subject to a disclaimer published at http://www.hisp.org/policies.html#comms_disclaimer. Please read the disclaimer before opening any attachment or taking any other action in terms of this electronic transmission. If you cannot access the disclaimer, kindly send an email to disclaimer@hisp.org and a copy will be provided to you. By replying to this e-mail or opening any attachment you agree to be bound by the provisions of the disclaimer.
