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 <[email protected]> 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" <[email protected]> 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* >> >> [image: Hisp logo] >> >> Project Manager >> >> Health Information Systems Program >> >> Tel: 041-367 1027 >> >> Cell: 082 374 2209 >> >> E-mail: [email protected] >> >> 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 >> [email protected] >> 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:[email protected]] >> *Sent:* 22 January 2016 06:11 AM >> *To:* Alex Tumwesigye >> *Cc:* Elmarie Claasen; [email protected]; 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 <[email protected]> >> 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 <[email protected]> >> 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* >> >> [image: Hisp logo] >> >> Project Manager >> >> Health Information Systems Program >> >> Tel: 041-367 1027 >> >> Cell: 082 374 2209 >> >> E-mail: [email protected] >> >> 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 >> [email protected] >> 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:[email protected]] >> *Sent:* 21 January 2016 01:34 PM >> *To:* Elmarie Claasen >> *Cc:* DHIS 2 developers; [email protected] >> *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 <[email protected]> >> 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:[email protected]] >> *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 >> >> [image: hisp_banner] >> >> >> >> >> >> *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 [email protected] >> <[email protected]> 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 >> <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 [email protected] >> <[email protected]> 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 : [email protected] >> 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 >> <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 [email protected] >> <[email protected]> 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 : [email protected] >> 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 : [email protected] >> 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 >> <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 [email protected] >> <[email protected]> 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 : [email protected] >> 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 : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
