dhis2-users team mailing list archive

Thread
Date
Re: Issue with Settings App after upgrade to 2.22

To: Morten Olav Hansen <mortenoh@xxxxxxxxx>
From: Ese Egerega <egerega@xxxxxxxxx>
Date: Sat, 23 Jan 2016 22:29:50 +0100
Cc: dhis2-users <dhis2-users@xxxxxxxxxxxxxxxxxxx>
In-reply-to: <CANeRaUhS=GrXN+KkOTT78RZgWeLo66Z-zDtmgePckgXA7--6Mw@mail.gmail.com>
Dear Morten, Knut;

Am thinking that the problem has to do with my database. I just setup a new
instance of dhis2 on the same server and the Settings Apps worked fine. It
stopped working again once I connected to the old database.

The database was originally on dhis 2.18 and over time I upgraded to 2.19
and then to 2.20 and 2.21 and I ran the upgrade scripts at each level so am
wondering what could be wrong with the database?

Thanks,
Ese
On Jan 23, 2016 6:28 PM, "Ese Egerega" <egerega@xxxxxxxxx> wrote:

> Hi Morten,
>
> I used tail /catalina.out -f to see the log real-time but nothing shows up
> when loading the settings app. I have copied everything in catalina.out
> file below.
>
> Between, after hours of loading the settings app, the pages displays *D2
> initialization error: Unable to get schemas from the DHIS2 API*
>
>
> Jan 23, 2016 5:02:36 PM org.apache.catalina.core.StandardServer await
> INFO: A valid shutdown command was received via the shutdown port.
> Stopping the Server instance.
> Jan 23, 2016 5:02:36 PM org.apache.coyote.AbstractProtocol pause
> INFO: Pausing ProtocolHandler ["http-bio-8080"]
> Jan 23, 2016 5:02:36 PM org.apache.coyote.AbstractProtocol pause
> INFO: Pausing ProtocolHandler ["ajp-bio-8009"]
> Jan 23, 2016 5:02:36 PM org.apache.catalina.core.StandardService
> stopInternal
> INFO: Stopping service Catalina
> * INFO  2016-01-23 17:02:36,833 De-registering jdbc driver:
> org.postgresql.Driver@4c019ec8 (StartupListener.java
> [localhost-startStop-2])
> Jan 23, 2016 5:02:36 PM org.apache.catalina.loader.WebappClassLoaderBase
> clearReferencesThreads
> SEVERE: The web application [/dhis] appears to have started a thread named
> [com.google.inject.internal.util.$Finalizer] but has failed to stop it.
> This is very likely to create a memory leak.
> Jan 23, 2016 5:02:36 PM org.apache.catalina.loader.WebappClassLoaderBase
> clearReferencesThreads
> SEVERE: The web application [/dhis] appears to have started a thread named
> [GT authority factory disposer] but has failed to stop it. This is very
> likely to create a memory leak.
> Jan 23, 2016 5:02:36 PM org.apache.catalina.loader.WebappClassLoaderBase
> clearReferencesThreads
> SEVERE: The web application [/dhis] appears to have started a thread named
> [WeakCollectionCleaner] but has failed to stop it. This is very likely to
> create a memory leak.
> Jan 23, 2016 5:02:36 PM org.apache.coyote.AbstractProtocol stop
> INFO: Stopping ProtocolHandler ["http-bio-8080"]
> Jan 23, 2016 5:02:36 PM org.apache.coyote.AbstractProtocol stop
> INFO: Stopping ProtocolHandler ["ajp-bio-8009"]
> Jan 23, 2016 5:02:36 PM org.apache.coyote.AbstractProtocol destroy
> INFO: Destroying ProtocolHandler ["http-bio-8080"]
> Jan 23, 2016 5:02:36 PM org.apache.coyote.AbstractProtocol destroy
> INFO: Destroying ProtocolHandler ["ajp-bio-8009"]
> Jan 23, 2016 5:02:42 PM org.apache.catalina.startup.VersionLoggerListener
> log
> INFO: Server version:        Apache Tomcat/7.0.67
> Jan 23, 2016 5:02:42 PM org.apache.catalina.startup.VersionLoggerListener
> log
> INFO: Server built:          Dec 7 2015 13:07:11 UTC
> Jan 23, 2016 5:02:42 PM org.apache.catalina.startup.VersionLoggerListener
> log
> INFO: Server number:         7.0.67.0
> Jan 23, 2016 5:02:42 PM org.apache.catalina.startup.VersionLoggerListener
> log
> INFO: OS Name:               Linux
> Jan 23, 2016 5:02:42 PM org.apache.catalina.startup.VersionLoggerListener
> log
> INFO: OS Version:            3.13.0-36-generic
> Jan 23, 2016 5:02:42 PM org.apache.catalina.startup.VersionLoggerListener
> log
> INFO: Architecture:          amd64
> Jan 23, 2016 5:02:42 PM org.apache.catalina.startup.VersionLoggerListener
> log
> INFO: Java Home:             /usr/lib/jvm/java-8-oracle/jre
> Jan 23, 2016 5:02:42 PM org.apache.catalina.startup.VersionLoggerListener
> log
> INFO: JVM Version:           1.8.0_66-b17
> Jan 23, 2016 5:02:42 PM org.apache.catalina.startup.VersionLoggerListener
> log
> INFO: JVM Vendor:            Oracle Corporation
> Jan 23, 2016 5:02:42 PM org.apache.catalina.startup.VersionLoggerListener
> log
> INFO: CATALINA_BASE:         /home/ubuntu/tomcat-dhis
> Jan 23, 2016 5:02:42 PM org.apache.catalina.startup.VersionLoggerListener
> log
> INFO: CATALINA_HOME:         /home/ubuntu/tomcat-dhis
> Jan 23, 2016 5:02:42 PM org.apache.catalina.startup.VersionLoggerListener
> log
> INFO: Command line argument:
> -Djava.util.logging.config.file=/home/ubuntu/tomcat-dhis/conf/logging.properties
> Jan 23, 2016 5:02:42 PM org.apache.catalina.startup.VersionLoggerListener
> log
> INFO: Command line argument:
> -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
> Jan 23, 2016 5:02:42 PM org.apache.catalina.startup.VersionLoggerListener
> log
> INFO: Command line argument: -Xmx7500m
> Jan 23, 2016 5:02:42 PM org.apache.catalina.startup.VersionLoggerListener
> log
> INFO: Command line argument: -Xms3000m
> Jan 23, 2016 5:02:42 PM org.apache.catalina.startup.VersionLoggerListener
> log
> INFO: Command line argument:
> -Djava.endorsed.dirs=/home/ubuntu/tomcat-dhis/endorsed
> Jan 23, 2016 5:02:42 PM org.apache.catalina.startup.VersionLoggerListener
> log
> INFO: Command line argument: -Dcatalina.base=/home/ubuntu/tomcat-dhis
> Jan 23, 2016 5:02:42 PM org.apache.catalina.startup.VersionLoggerListener
> log
> INFO: Command line argument: -Dcatalina.home=/home/ubuntu/tomcat-dhis
> Jan 23, 2016 5:02:42 PM org.apache.catalina.startup.VersionLoggerListener
> log
> INFO: Command line argument: -Djava.io.tmpdir=/home/ubuntu/tomcat-dhis/temp
> Jan 23, 2016 5:02:42 PM org.apache.catalina.core.AprLifecycleListener
> lifecycleEvent
> INFO: The APR based Apache Tomcat Native library which allows optimal
> performance in production environments was not found on the
> java.library.path:
> /usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib
> Jan 23, 2016 5:02:42 PM org.apache.coyote.AbstractProtocol init
> INFO: Initializing ProtocolHandler ["http-bio-8080"]
> Jan 23, 2016 5:02:42 PM org.apache.coyote.AbstractProtocol init
> INFO: Initializing ProtocolHandler ["ajp-bio-8009"]
> Jan 23, 2016 5:02:42 PM org.apache.catalina.startup.Catalina load
> INFO: Initialization processed in 648 ms
> Jan 23, 2016 5:02:42 PM org.apache.catalina.core.StandardService
> startInternal
> INFO: Starting service Catalina
> Jan 23, 2016 5:02:42 PM org.apache.catalina.core.StandardEngine
> startInternal
> INFO: Starting Servlet Engine: Apache Tomcat/7.0.67
> Jan 23, 2016 5:02:42 PM org.apache.catalina.startup.HostConfig deployWAR
> INFO: Deploying web application archive
> /home/ubuntu/apache-tomcat-7.0.67/webapps/dhis.war
> Jan 23, 2016 5:02:48 PM org.apache.catalina.startup.TldConfig execute
> INFO: At least one JAR was scanned for TLDs yet contained no TLDs. Enable
> debug logging for this logger for a complete list of JARs that were scanned
> but no TLDs were found in them. Skipping unneeded JARs during scanning can
> improve startup time and JSP compilation time.
> * INFO  2016-01-23 17:02:53,301 System property dhis2.home not set
> (DefaultLocationManager.java [localhost-startStop-1])
> * INFO  2016-01-23 17:02:53,305 Environment variable DHIS2_HOME points to
> /home/ubuntu/config (DefaultLocationManager.java [localhost-startStop-1])
> * INFO  2016-01-23 17:02:54,714 Hibernate configuration loaded, using
> dialect: org.hibernate.dialect.PostgreSQLDialect
> (DefaultHibernateConfigurationProvider.java [localhost-startStop-1])
> * INFO  2016-01-23 17:03:24,486 File store configured with provider
> 'filesystem' and container 'files'.  (JCloudsFileResourceContentStore.java
> [localhost-startStop-1])
> * INFO  2016-01-23 17:03:24,594 Scheduled task with key:
> fileResourceCleanupTask and cron: 0 0 2 * * ? (SpringScheduler.java
> [localhost-startStop-1])
> * INFO  2016-01-23 17:03:26,348 Detected apps: [] (DefaultAppManager.java
> [localhost-startStop-1])
> * INFO  2016-01-23 17:03:26,875 Listeners registered are
> [org.hisp.dhis.sms.listener.DataValueSMSListener@7369a633,
> org.hisp.dhis.sms.listener.J2MEDataValueSMSListener@777e8ab,
> org.hisp.dhis.sms.listener.UnregisteredSMSListener@49376276,
> org.hisp.dhis.sms.listener.DHISMessageAlertListener@687532ed,
> org.hisp.dhis.sms.listener.TrackedEntityRegistrationSMSListener@561359ee]
> (SmsConsumerThread.java [localhost-startStop-1])
> * INFO  2016-01-23 17:03:26,884 Found the following message senders:
> [org.hisp.dhis.message.EmailMessageSender@5dec916e,
> org.hisp.dhis.sms.SmsMessageSender@1ccf3a40] (DefaultMessageService.java
> [localhost-startStop-1])
>
>
> On Sat, Jan 23, 2016 at 5:49 PM, Morten Olav Hansen <mortenoh@xxxxxxxxx>
> wrote:
>
>>
>> On Sat, Jan 23, 2016 at 11:17 PM, Ese Egerega <egerega@xxxxxxxxx> wrote:
>>
>>> GET http://localhost/dhis/api/systemSettings 500 (Internal Server Error)
>>>
>>
>> This should have produced a log on your server (it should give what we
>> call a stack trace), can you have a look in your catalina.out file and send
>> us the error that is produced during loading of the settings app?
>>
>> --
>> Morten
>>
>
>
References

Issue with Settings App after upgrade to 2.22
From: Ese Egerega, 2016-01-23
Re: Issue with Settings App after upgrade to 2.22
From: Knut Staring, 2016-01-23
Re: Issue with Settings App after upgrade to 2.22
From: Ese Egerega, 2016-01-23
Re: Issue with Settings App after upgrade to 2.22
From: Morten Olav Hansen, 2016-01-23
Re: Issue with Settings App after upgrade to 2.22
From: Ese Egerega, 2016-01-23