dhis2-devs team mailing list archive

["Elmarie Claasen" <elmarie@xxxxxxxx>]

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.

 

Regards,

 

Elmarie Claasen

Hisp logo

Project Manager

Health Information Systems Program

Tel:      041-367 1027

Cell:     082 374 2209

E-mail:  <mailto:elmarie@xxxxxxxx> elmarie@xxxxxxxx

Skype:  elmarie.claasen52 

 

 

This message and any attachments are subject to a disclaimer published at  <http://www.hisp.org/policies.html#comms_disclaimer> 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  <mailto:disclaimer@xxxxxxxx> disclaimer@xxxxxxxx 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: Jason Pickering [mailto:jason.p.pickering@xxxxxxxxx] 
Sent: 25 January 2016 09:35 AM
To: Elmarie Claasen
Cc: Alex Tumwesigye; Ola Hodne Titlestad; brendon@xxxxxxxx; 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@xxxxxxxx> 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:  <mailto:elmarie@xxxxxxxx> elmarie@xxxxxxxx

Skype:  elmarie.claasen52 

 

 

This message and any attachments are subject to a disclaimer published at  <http://www.hisp.org/policies.html#comms_disclaimer> 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  <mailto:disclaimer@xxxxxxxx> disclaimer@xxxxxxxx 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@xxxxxxxxx] 
Sent: 25 January 2016 09:13 AM
To: Ola Hodne Titlestad
Cc: Elmarie Claasen; dhis2-devs; brendon@xxxxxxxx; 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@xxxxxxxxxx> 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@xxxxxxxx> 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:  <mailto:elmarie@xxxxxxxx> elmarie@xxxxxxxx

Skype:  elmarie.claasen52 

 

 

This message and any attachments are subject to a disclaimer published at  <http://www.hisp.org/policies.html#comms_disclaimer> 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  <mailto:disclaimer@xxxxxxxx> disclaimer@xxxxxxxx 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@xxxxxxxxx] 
Sent: 22 January 2016 06:11 AM
To: Alex Tumwesigye
Cc: Elmarie Claasen; brendon@xxxxxxxx; 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@xxxxxxxxx> 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@xxxxxxxx> 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:  <mailto:elmarie@xxxxxxxx> elmarie@xxxxxxxx

Skype:  elmarie.claasen52 

 

 

This message and any attachments are subject to a disclaimer published at  <http://www.hisp.org/policies.html#comms_disclaimer> 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  <mailto:disclaimer@xxxxxxxx> disclaimer@xxxxxxxx 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@xxxxxxxxx] 
Sent: 21 January 2016 01:34 PM
To: Elmarie Claasen
Cc: DHIS 2 developers; brendon@xxxxxxxx
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@xxxxxxxx> 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@xxxxxxxx] 
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@xxxxxxxx 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@xxxxxxxx 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@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp





 

-- 

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522 <tel:%2B4791880522> 

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@xxxxxxxx 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@xxxxxxxxxxxxxxxxxxx
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 <tel:%2B%20256%20759%20800161> 


"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@xxxxxxxxxxxxxxxxxxx
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@xxxxxxxx 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@xxxxxxxxxxxxxxxxxxx
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 <tel:%2B%20256%20759%20800161> 


"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@xxxxxxxx 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@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp





 

-- 

Jason P. Pickering
email: jason.p.pickering@xxxxxxxxx
tel:+46764147049


-- 


*This message and any attachments are subject to a disclaimer published at 
http://www.hisp.org/policies.html#comms_disclaimer 
<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@xxxxxxxx 
<disclaimer@xxxxxxxx> 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.*