Hello Lars,ran this command again on pgadmin on a new server that i am
trying to set up,but nothing seems to be working.This is the error
message it gives:
RROR: column “datadimension” does not exist
LINE 1: …taelementcategory set datadimension = false where datadimens…
^
********** Error **********
ERROR: column “datadimension” does not exist
SQL state: 42703
Character: 60
****THIS THE OUTPUT FROM THE TOMCAT SERVER:
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4939)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5434)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:633)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:976)
at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1653)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724)
Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException:
A ResourcePool could not acquire a resource from its primary factory
or source.
at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1319)
at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557)
at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525)
... 440 more
- INFO 2016-04-20 14:44:37,026 Found the following message senders:
[org.hisp.dhis.message.EmailMessageSender@5e290f8,
org.hisp.dhis.sms.SmsMessageSender@16a959c2]
(DefaultMessageService.java [localhost-startStop-1])
- WARN 2016-04-20 14:45:11,660
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@704cc3ff –
Acquisition Attempt Failed!!! Clearing pending acquires. While trying
to acquire a needed new resource, we failed to succeed more than the
maximum number of allowed acquisition attempts (30). Last acquisition
attempt exception: (BasicResourcePool.java
[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1])
org.postgresql.util.PSQLException: Connection refused. Check that the
hostname and port are correct and that the postmaster is accepting
TCP/IP connections.
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:215)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:64)
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:144)
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:29)
at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:21)
at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:31)
at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:410)
at org.postgresql.Driver.connect(Driver.java:280)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
Caused by: java.net.ConnectException: Connection refused
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:579)
at org.postgresql.core.PGStream.<init>(PGStream.java:61)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:109)
... 16 more
- WARN 2016-04-20 14:45:11,660
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@729bd59c –
Acquisition Attempt Failed!!! Clearing pending acquires. While trying
to acquire a needed new resource, we failed to succeed more than the
maximum number of allowed acquisition attempts (30). Last acquisition
attempt exception: (BasicResourcePool.java
[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2])
org.postgresql.util.PSQLException: Connection refused. Check that the
hostname and port are correct and that the postmaster is accepting
TCP/IP connections.
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:215)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:64)
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:144)
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:29)
at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:21)
at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:31)
at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:410)
at org.postgresql.Driver.connect(Driver.java:280)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
Caused by: java.net.ConnectException: Connection refused
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:579)
at org.postgresql.core.PGStream.<init>(PGStream.java:61)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:109)
... 16 more
- WARN 2016-04-20 14:45:11,660
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@3fd7d3f2 –
Acquisition Attempt Failed!!! Clearing pending acquires. While trying
to acquire a needed new resource, we failed to succeed more than the
maximum number of allowed acquisition attempts (30). Last acquisition
attempt exception: (BasicResourcePool.java
[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0])
org.postgresql.util.PSQLException: Connection refused. Check that the
hostname and port are correct and that the postmaster is accepting
TCP/IP connections.
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:215)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:64)
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:144)
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:29)
at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:21)
at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:31)
at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:410)
at org.postgresql.Driver.connect(Driver.java:280)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
Caused by: java.net.ConnectException: Connection refused
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:579)
at org.postgresql.core.PGStream.<init>(PGStream.java:61)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:109)
... 16 more
- WARN 2016-04-20 14:45:11,662 SQL Error: 0, SQLState: null
(SqlExceptionHelper.java [localhost-startStop-1])
- ERROR 2016-04-20 14:45:11,665 Connections could not be acquired from
the underlying database! (SqlExceptionHelper.java
[localhost-startStop-1])
- WARN 2016-04-20 14:45:11,678 Exception encountered during context
initialization - cancelling refresh attempt
(AbstractApplicationContext.java [localhost-startStop-1])
org.springframework.beans.factory.BeanCreationException: Error
creating bean with name ‘org.hisp.dhis.appmanager.AppManager’:
Invocation of init method failed; nested exception is
org.springframework.transaction.CannotCreateTransactionException:
Could not open Hibernate Session for transaction; nested exception is
org.hibernate.exception.GenericJDBCException: Could not open
connection
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:136)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:408)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1566)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:755)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:757)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:480)
at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:403)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:106)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4939)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5434)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:633)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:976)
at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1653)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724)
Caused by: org.springframework.transaction.CannotCreateTransactionException:
Could not open Hibernate Session for transaction; nested exception is
org.hibernate.exception.GenericJDBCException: Could not open
connection
at org.springframework.orm.hibernate4.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:544)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373)
at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:463)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:276)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
at com.sun.proxy.$Proxy39.getSystemSetting(Unknown Source)
at org.hisp.dhis.appmanager.DefaultAppManager.getAppFolderPath(DefaultAppManager.java:212)
at org.hisp.dhis.appmanager.DefaultAppManager.reloadApps(DefaultAppManager.java:275)
at org.hisp.dhis.appmanager.DefaultAppManager.init(DefaultAppManager.java:71)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:349)
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:300)
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:133)
... 28 more
Caused by: org.hibernate.exception.GenericJDBCException: Could not
open connection
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:124)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)
at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:221)
at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.getConnection(LogicalConnectionImpl.java:157)
at org.hibernate.internal.SessionImpl.connection(SessionImpl.java:427)
at org.springframework.orm.hibernate4.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:450)
... 45 more
Caused by: java.sql.SQLException: Connections could not be acquired
from the underlying database!
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:529)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:134)
at org.hibernate.service.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:141)
at org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.obtainConnection(AbstractSessionImpl.java:301)
at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:214)
... 48 more
Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException:
A ResourcePool could not acquire a resource from its primary factory
or source.
at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1319)
at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557)
at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525)
... 52 more
- ERROR 2016-04-20 14:45:11,737 Context initialization failed
(ContextLoader.java [localhost-startStop-1])
org.springframework.beans.factory.BeanCreationException: Error
creating bean with name ‘org.hisp.dhis.appmanager.AppManager’:
Invocation of init method failed; nested exception is
org.springframework.transaction.CannotCreateTransactionException:
Could not open Hibernate Session for transaction; nested exception is
org.hibernate.exception.GenericJDBCException: Could not open
connection
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:136)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:408)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1566)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:755)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:757)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:480)
at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:403)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:106)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4939)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5434)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:633)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:976)
at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1653)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724)
Caused by: org.springframework.transaction.CannotCreateTransactionException:
Could not open Hibernate Session for transaction; nested exception is
org.hibernate.exception.GenericJDBCException: Could not open
connection
at org.springframework.orm.hibernate4.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:544)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373)
at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:463)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:276)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
at com.sun.proxy.$Proxy39.getSystemSetting(Unknown Source)
at org.hisp.dhis.appmanager.DefaultAppManager.getAppFolderPath(DefaultAppManager.java:212)
at org.hisp.dhis.appmanager.DefaultAppManager.reloadApps(DefaultAppManager.java:275)
at org.hisp.dhis.appmanager.DefaultAppManager.init(DefaultAppManager.java:71)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:349)
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:300)
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:133)
... 28 more
Caused by: org.hibernate.exception.GenericJDBCException: Could not
open connection
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:124)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)
at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:221)
at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.getConnection(LogicalConnectionImpl.java:157)
at org.hibernate.internal.SessionImpl.connection(SessionImpl.java:427)
at org.springframework.orm.hibernate4.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:450)
... 45 more
Caused by: java.sql.SQLException: Connections could not be acquired
from the underlying database!
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:529)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:134)
at org.hibernate.service.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:141)
at org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.obtainConnection(AbstractSessionImpl.java:301)
at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:214)
... 48 more
Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException:
A ResourcePool could not acquire a resource from its primary factory
or source.
at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1319)
at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557)
at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525)
... 52 more
Apr 20, 2016 2:45:11 PM org.apache.catalina.core.StandardContext startInternal
SEVERE: Error listenerStart
Apr 20, 2016 2:45:11 PM org.apache.catalina.core.StandardContext startInternal
SEVERE: Context [/dhis] startup failed due to previous errors
- INFO 2016-04-20 14:45:11,747 De-registering jdbc driver:
sun.jdbc.odbc.JdbcOdbcDriver@1629bc56 (StartupListener.java
[localhost-startStop-1])
- INFO 2016-04-20 14:45:11,747 De-registering jdbc driver:
org.postgresql.Driver@2dcba52d (StartupListener.java
[localhost-startStop-1])
Apr 20, 2016 2:45:11 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory /usr/apache-tomcat-7.0.42/webapps/ROOT
Apr 20, 2016 2:45:11 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory
/usr/apache-tomcat-7.0.42/webapps/examples
Apr 20, 2016 2:45:11 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory
/usr/apache-tomcat-7.0.42/webapps/host-manager
Apr 20, 2016 2:45:11 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory
/usr/apache-tomcat-7.0.42/webapps/manager
Apr 20, 2016 2:45:11 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory /usr/apache-tomcat-7.0.42/webapps/docs
Apr 20, 2016 2:45:11 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler [“http-bio-8080”]
Apr 20, 2016 2:45:11 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler [“ajp-bio-8009”]
Apr 20, 2016 2:45:11 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 110858 ms
Please respond its very urgent.Thank you.
On 8/25/15, Lars Helge Øverland larshelge@gmail.com wrote:
Hi Mohamed,
there is a column which maps to a java boolean field which has a null value
for en existing row. Try this SQL:
update dataelementcategory set datadimension = false where datadimension is
null;
Then restart the server.
Lars
On Tue, Aug 25, 2015 at 4:17 AM, Mohamed Bangura mbangs87@gmail.com
wrote:
can someone please help me with this issue?.It’s really frustrating
because i think that i have done the right thing yet still i am not
receiving the desired result.
Waiting for your response please,it’s urgent.Thanks in advance for your
help.
–
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1487121
Title:
tomcat is not displaying dhis on web browser
Status in DHIS:
New
Bug description:
Hello all,
I am trying to install Dhis on ubuntu desktop 14.04.I av installed
tomcat,java and copied the war file to webapps.The tomcat starts well
and deploys the war file.
But when i try to access the dhis from my webbrowser,it gives the
error below
HTTP Status 404 - /dhis
type Status report
message /dhis
description The requested resource is not available.
Apache Tomcat/7.0.42
I have tried it on several browsers,its the same thing.Can someone
please help me ?
This is a snap shot of the catalina.out result of the tomcat
Aug 20, 2015 4:21:00 PM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler [“ajp-bio-8009”]
Aug 20, 2015 4:21:00 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 375 ms
Aug 20, 2015 4:21:01 PM org.apache.catalina.core.StandardService
startInternal
INFO: Starting service Catalina
Aug 20, 2015 4:21:01 PM org.apache.catalina.core.StandardEngine
startInternal
INFO: Starting Servlet Engine: Apache Tomcat/7.0.42
Aug 20, 2015 4:21:01 PM org.apache.catalina.startup.HostConfig
deployWAR
INFO: Deploying web application archive
/usr/share/apache-tomcat-7.0.42/webapps/dhis.war
- INFO 2015-08-20 16:21:11,055 System property dhis2.home not set
(DefaultLocationManager.java [localhost-startStop-1])
- INFO 2015-08-20 16:21:11,057 Environment variable DHIS2_HOME points
to /home/inveneo/DHIS2_HOME/dhis (DefaultLocationManager.java
[localhost-startStop-1])
- INFO 2015-08-20 16:21:12,083 Hibernate configuration loaded, using
dialect: org.hibernate.dialect.PostgreSQLDialect
(DefaultHibernateConfigurationProvider.java [localhost-startStop-1])
- ERROR 2015-08-20 16:21:22,179 HHH000388: Unsuccessful: alter table
completedatasetregistration add column attributeoptioncomboid int4 not
null
(SchemaUpdate.java [localhost-startStop-1])
- ERROR 2015-08-20 16:21:22,181 ERROR: column “attributeoptioncomboid”
contains null values (SchemaUpdate.java [localhost-startStop-1])
- ERROR 2015-08-20 16:21:22,185 HHH000388: Unsuccessful: alter table
datavalue add column attributeoptioncomboid int4 not null
(SchemaUpdate.java [localhost-startStop-1])
- ERROR 2015-08-20 16:21:22,187 ERROR: column “attributeoptioncomboid”
contains null values (SchemaUpdate.java [localhost-startStop-1])
- ERROR 2015-08-20 16:21:22,190 HHH000388: Unsuccessful: alter table
minmaxdataelement add column minimumvalue int4 not null
(SchemaUpdate.java
[localhost-startStop-1])
- ERROR 2015-08-20 16:21:22,191 ERROR: column “minimumvalue” contains
null values (SchemaUpdate.java [localhost-startStop-1])
- ERROR 2015-08-20 16:21:22,194 HHH000388: Unsuccessful: alter table
minmaxdataelement add column maximumvalue int4 not null
(SchemaUpdate.java
[localhost-startStop-1])
- ERROR 2015-08-20 16:21:22,195 ERROR: column “maximumvalue” contains
null values (SchemaUpdate.java [localhost-startStop-1])
- ERROR 2015-08-20 16:21:22,199 HHH000388: Unsuccessful: alter table
translation add column translationid int4 not null (SchemaUpdate.java
[localhost-startStop-1])
- ERROR 2015-08-20 16:21:22,199 ERROR: column “translationid” contains
null values (SchemaUpdate.java [localhost-startStop-1])
- ERROR 2015-08-20 16:21:22,202 HHH000388: Unsuccessful: alter table
completedatasetregistration add constraint
fk_completedatasetregistration_attributeoptioncomboid foreign key
(attributeoptioncomboid) references categoryoptioncombo
(SchemaUpdate.java
[localhost-startStop-1])
- ERROR 2015-08-20 16:21:22,203 ERROR: column “attributeoptioncomboid”
referenced in foreign key constraint does not exist (SchemaUpdate.java
[localhost-startStop-1])
- ERROR 2015-08-20 16:21:22,206 HHH000388: Unsuccessful: alter table
datavalue add constraint fk_datavalue_attributeoptioncomboid foreign key
(attributeoptioncomboid) references categoryoptioncombo
(SchemaUpdate.java
[localhost-startStop-1])
- ERROR 2015-08-20 16:21:22,208 ERROR: column “attributeoptioncomboid”
referenced in foreign key constraint does not exist (SchemaUpdate.java
[localhost-startStop-1])
- ERROR 2015-08-20 16:21:22,210 HHH000388: Unsuccessful: alter table
programstage add constraint fk_programstage_dataentryform foreign key
(dataentryformid) references dataentryform (SchemaUpdate.java
[localhost-startStop-1])
- ERROR 2015-08-20 16:21:22,211 ERROR: constraint
“fk_programstage_dataentryform” for relation “programstage” already
exists
(SchemaUpdate.java [localhost-startStop-1])
- ERROR 2015-08-20 16:21:22,215 HHH000388: Unsuccessful: alter table
sqlviewusergroupaccesses add constraint FK_ftn43gpevax8by169pld7dl5d
foreign key (sqlviewid) references sqlview (SchemaUpdate.java
[localhost-startStop-1])
- ERROR 2015-08-20 16:21:22,216 ERROR: constraint
“fk_ftn43gpevax8by169pld7dl5d” for relation “sqlviewusergroupaccesses”
already exists (SchemaUpdate.java [localhost-startStop-1])
- ERROR 2015-08-20 16:21:22,219 HHH000388: Unsuccessful: alter table
validationrulegroupmembers add constraint
fk_validationrulegroupmembers_validationrulegroupid foreign key
(validationgroupid) references validationrulegroup (SchemaUpdate.java
[localhost-startStop-1])
- ERROR 2015-08-20 16:21:22,221 ERROR: constraint
“fk_validationrulegroupmembers_validationrulegroupid” for relation
“validationrulegroupmembers” already exists (SchemaUpdate.java
[localhost-startStop-1])
- ERROR 2015-08-20 16:21:22,224 HHH000388: Unsuccessful: alter table
validationrulegroupusergroupaccesses add constraint
FK_932w5l8vbyvybhsrwwadjd3cp foreign key (validationrulegroupid)
references
validationrulegroup (SchemaUpdate.java [localhost-startStop-1])
- ERROR 2015-08-20 16:21:22,225 ERROR: constraint
“fk_932w5l8vbyvybhsrwwadjd3cp” for relation
“validationrulegroupusergroupaccesses” already exists (SchemaUpdate.java
[localhost-startStop-1])
- ERROR 2015-08-20 16:21:22,228 HHH000388: Unsuccessful: alter table
validationrulegroupusergroupstoalert add constraint
fk_validationrulegroupusergroupstoalert_validationgroupid foreign key
(validationgroupid) references validationrulegroup (SchemaUpdate.java
[localhost-startStop-1])
- ERROR 2015-08-20 16:21:22,229 ERROR: constraint
“fk_validationrulegroupusergroupstoalert_validationgroupid” for relation
“validationrulegroupusergroupstoalert” already exists (SchemaUpdate.java
[localhost-startStop-1])
- INFO 2015-08-20 16:21:26,000 Found the following message senders:
[org.hisp.dhis.message.EmailMessageSender@7c267dd0,
org.hisp.dhis.sms.SmsMessageSender@615318b9] (DefaultMessageService.java
[localhost-startStop-1])
- INFO 2015-08-20 16:21:31,908 Detected apps:
(DefaultAppManager.java [localhost-startStop-1])
- INFO 2015-08-20 16:21:33,190 Added logger:
org.hisp.dhis.resourcetable using file:
/home/inveneo/DHIS2_HOME/dhis/logs/dhis-analytics-table.log
(Log4JLogConfigInitializer.java [localhost-startStop-1])
- INFO 2015-08-20 16:21:33,191 Added logger:
org.hisp.dhis.analytics.table using file:
/home/inveneo/DHIS2_HOME/dhis/logs/dhis-analytics-table.log
(Log4JLogConfigInitializer.java [localhost-startStop-1])
- INFO 2015-08-20 16:21:33,191 Added logger: org.hisp.dhis.dxf2 using
file: /home/inveneo/DHIS2_HOME/dhis/logs/dhis-data-exchange.log
(Log4JLogConfigInitializer.java [localhost-startStop-1])
- INFO 2015-08-20 16:21:33,191 Added logger: org.hisp.dhis.dxf2.synch
using file: /home/inveneo/DHIS2_HOME/dhis/logs/dhis-data-sync.log
(Log4JLogConfigInitializer.java [localhost-startStop-1])
- INFO 2015-08-20 16:21:33,192 Added root logger using file:
/home/inveneo/DHIS2_HOME/dhis/logs/dhis.log
(Log4JLogConfigInitializer.java
[localhost-startStop-1])
- WARN 2015-08-20 16:21:33,724 RP discovery / realm validation
disabled; (RealmVerifier.java [localhost-startStop-1])
- INFO 2015-08-20 16:21:34,751 Executing startup routine [1 of 14,
runlevel 1]: InitTableAlteror (DefaultStartupRoutineExecutor.java
[localhost-startStop-1])
- INFO 2015-08-20 16:21:34,950 Upgraded program stage data elements
(InitTableAlteror.java [localhost-startStop-1])
- INFO 2015-08-20 16:21:34,951 Executing startup routine [2 of 14,
runlevel 2]: PeriodTypePopulator (DefaultStartupRoutineExecutor.java
[localhost-startStop-1])
- INFO 2015-08-20 16:21:34,969 Executing startup routine [3 of 14,
runlevel 2]: DataElementDefaultDimensionPopulator
(DefaultStartupRoutineExecutor.java [localhost-startStop-1])
- ERROR 2015-08-20 16:21:34,986 org.hibernate.PropertyAccessException:
Null value was assigned to a property of primitive type setter of
org.hisp.dhis.common.BaseDimensionalObject.dataDimension
at
org.hibernate.property.BasicPropertyAccessor$BasicSetter.set(BasicPropertyAccessor.java:108)
at
org.hibernate.tuple.entity.AbstractEntityTuplizer.setPropertyValues(AbstractEntityTuplizer.java:710)
at
org.hibernate.tuple.entity.PojoEntityTuplizer.setPropertyValues(PojoEntityTuplizer.java:379)
at
org.hibernate.persister.entity.AbstractEntityPersister.setPropertyValues(AbstractEntityPersister.java:4522)
at
org.hibernate.engine.internal.TwoPhaseLoad.doInitializeEntity(TwoPhaseLoad.java:186)
at
org.hibernate.engine.internal.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:137)
at
org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:1112)
at org.hibernate.loader.Loader.processResultSet(Loader.java:969)
at org.hibernate.loader.Loader.doQuery(Loader.java:917)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:348)
at org.hibernate.loader.Loader.doList(Loader.java:2550)
at
org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2395)
at org.hibernate.loader.Loader.list(Loader.java:2358)
at
org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:124)
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1623)
at
org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:374)
at
org.hisp.dhis.common.hibernate.HibernateIdentifiableObjectStore.getAllEqName(HibernateIdentifiableObjectStore.java:180)
at
org.hisp.dhis.dataelement.DefaultDataElementCategoryService.getDataElementCategoryByName(DefaultDataElementCategoryService.java:212)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at
org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
at
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at
org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
at com.sun.proxy.$Proxy38.getDataElementCategoryByName(Unknown
Source)
at
org.hisp.dhis.dataelement.DataElementDefaultDimensionPopulator.execute(DataElementDefaultDimensionPopulator.java:82)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at
org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
at
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
at com.sun.proxy.$Proxy84.execute(Unknown Source)
at
org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:119)
at
org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:88)
at
org.hisp.dhis.system.startup.StartupListener.contextInitialized(StartupListener.java:68)
at
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4939)
at
org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5434)
at
org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
at
org.apache.catalina.core.StandardHost.addChild(StandardHost.java:633)
at
org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:976)
at
org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1653)
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724)
Caused by: java.lang.IllegalArgumentException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at
org.hibernate.property.BasicPropertyAccessor$BasicSetter.set(BasicPropertyAccessor.java:65)
... 63 more
(StartupListener.java [localhost-startStop-1])
Aug 20, 2015 4:21:34 PM org.apache.catalina.core.StandardContext
startInternal
SEVERE: Error listenerStart
Aug 20, 2015 4:21:34 PM org.apache.catalina.core.StandardContext
startInternal
SEVERE: Context [/dhis] startup failed due to previous errors
- INFO 2015-08-20 16:21:34,993 De-registering jdbc driver:
sun.jdbc.odbc.JdbcOdbcDriver@1629bc56 (StartupListener.java
[localhost-startStop-1])
- INFO 2015-08-20 16:21:34,993 De-registering jdbc driver:
org.postgresql.Driver@14c944d8 (StartupListener.java
[localhost-startStop-1])
Aug 20, 2015 4:21:35 PM org.apache.catalina.loader.WebappClassLoader
checkThreadLocalMapForLeaks
SEVERE: The web application [/dhis] created a ThreadLocal with key of
type [java.lang.ThreadLocal] (value [java.lang.ThreadLocal@726b1eee]) and
a value of type
[org.springframework.security.core.context.SecurityContextImpl] (value
[org.springframework.security.core.context.SecurityContextImpl@ffffffff:
Null authentication]) but failed to remove it when the web application
was
stopped. Threads are going to be renewed over time to try and avoid a
probable memory leak.
Aug 20, 2015 4:21:35 PM org.apache.catalina.startup.HostConfig
deployDirectory
INFO: Deploying web application directory
/usr/share/apache-tomcat-7.0.42/webapps/ROOT
Aug 20, 2015 4:21:35 PM org.apache.catalina.startup.HostConfig
deployDirectory
INFO: Deploying web application directory
/usr/share/apache-tomcat-7.0.42/webapps/host-manager
Aug 20, 2015 4:21:35 PM org.apache.catalina.startup.HostConfig
deployDirectory
INFO: Deploying web application directory
/usr/share/apache-tomcat-7.0.42/webapps/examples
Aug 20, 2015 4:21:35 PM org.apache.catalina.startup.HostConfig
deployDirectory
INFO: Deploying web application directory
/usr/share/apache-tomcat-7.0.42/webapps/manager
Aug 20, 2015 4:21:35 PM org.apache.catalina.startup.HostConfig
deployDirectory
INFO: Deploying web application directory
/usr/share/apache-tomcat-7.0.42/webapps/docs
Aug 20, 2015 4:21:35 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler [“http-bio-8080”]
Aug 20, 2015 4:21:35 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler [“ajp-bio-8009”]
Aug 20, 2015 4:21:35 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 34288 ms
To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1487121/+subscriptions
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
–
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
http://www.dhis2.org <https://www.dhis2.org>
–
You received this bug notification because you are subscribed to the bug
report.
https://bugs.launchpad.net/bugs/1487121
Title:
tomcat is not displaying dhis on web browser
Status in DHIS:
New
Bug description:
Hello all,
I am trying to install Dhis on ubuntu desktop 14.04.I av installed
tomcat,java and copied the war file to webapps.The tomcat starts well
and deploys the war file.
But when i try to access the dhis from my webbrowser,it gives the
error below
HTTP Status 404 - /dhis
type Status report
message /dhis
description The requested resource is not available.
Apache Tomcat/7.0.42
I have tried it on several browsers,its the same thing.Can someone
please help me ?
This is a snap shot of the catalina.out result of the tomcat
Aug 20, 2015 4:21:00 PM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler [“ajp-bio-8009”]
Aug 20, 2015 4:21:00 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 375 ms
Aug 20, 2015 4:21:01 PM org.apache.catalina.core.StandardService
startInternal
INFO: Starting service Catalina
Aug 20, 2015 4:21:01 PM org.apache.catalina.core.StandardEngine
startInternal
INFO: Starting Servlet Engine: Apache Tomcat/7.0.42
Aug 20, 2015 4:21:01 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive
/usr/share/apache-tomcat-7.0.42/webapps/dhis.war
- INFO 2015-08-20 16:21:11,055 System property dhis2.home not set
(DefaultLocationManager.java [localhost-startStop-1])
- INFO 2015-08-20 16:21:11,057 Environment variable DHIS2_HOME points to
/home/inveneo/DHIS2_HOME/dhis (DefaultLocationManager.java
[localhost-startStop-1])
- INFO 2015-08-20 16:21:12,083 Hibernate configuration loaded, using
dialect: org.hibernate.dialect.PostgreSQLDialect
(DefaultHibernateConfigurationProvider.java [localhost-startStop-1])
- ERROR 2015-08-20 16:21:22,179 HHH000388: Unsuccessful: alter table
completedatasetregistration add column attributeoptioncomboid int4 not null
(SchemaUpdate.java [localhost-startStop-1])
- ERROR 2015-08-20 16:21:22,181 ERROR: column “attributeoptioncomboid”
contains null values (SchemaUpdate.java [localhost-startStop-1])
- ERROR 2015-08-20 16:21:22,185 HHH000388: Unsuccessful: alter table
datavalue add column attributeoptioncomboid int4 not null (SchemaUpdate.java
[localhost-startStop-1])
- ERROR 2015-08-20 16:21:22,187 ERROR: column “attributeoptioncomboid”
contains null values (SchemaUpdate.java [localhost-startStop-1])
- ERROR 2015-08-20 16:21:22,190 HHH000388: Unsuccessful: alter table
minmaxdataelement add column minimumvalue int4 not null (SchemaUpdate.java
[localhost-startStop-1])
- ERROR 2015-08-20 16:21:22,191 ERROR: column “minimumvalue” contains null
values (SchemaUpdate.java [localhost-startStop-1])
- ERROR 2015-08-20 16:21:22,194 HHH000388: Unsuccessful: alter table
minmaxdataelement add column maximumvalue int4 not null (SchemaUpdate.java
[localhost-startStop-1])
- ERROR 2015-08-20 16:21:22,195 ERROR: column “maximumvalue” contains null
values (SchemaUpdate.java [localhost-startStop-1])
- ERROR 2015-08-20 16:21:22,199 HHH000388: Unsuccessful: alter table
translation add column translationid int4 not null (SchemaUpdate.java
[localhost-startStop-1])
- ERROR 2015-08-20 16:21:22,199 ERROR: column “translationid” contains
null values (SchemaUpdate.java [localhost-startStop-1])
- ERROR 2015-08-20 16:21:22,202 HHH000388: Unsuccessful: alter table
completedatasetregistration add constraint
fk_completedatasetregistration_attributeoptioncomboid foreign key
(attributeoptioncomboid) references categoryoptioncombo (SchemaUpdate.java
[localhost-startStop-1])
- ERROR 2015-08-20 16:21:22,203 ERROR: column “attributeoptioncomboid”
referenced in foreign key constraint does not exist (SchemaUpdate.java
[localhost-startStop-1])
- ERROR 2015-08-20 16:21:22,206 HHH000388: Unsuccessful: alter table
datavalue add constraint fk_datavalue_attributeoptioncomboid foreign key
(attributeoptioncomboid) references categoryoptioncombo (SchemaUpdate.java
[localhost-startStop-1])
- ERROR 2015-08-20 16:21:22,208 ERROR: column “attributeoptioncomboid”
referenced in foreign key constraint does not exist (SchemaUpdate.java
[localhost-startStop-1])
- ERROR 2015-08-20 16:21:22,210 HHH000388: Unsuccessful: alter table
programstage add constraint fk_programstage_dataentryform foreign key
(dataentryformid) references dataentryform (SchemaUpdate.java
[localhost-startStop-1])
- ERROR 2015-08-20 16:21:22,211 ERROR: constraint
“fk_programstage_dataentryform” for relation “programstage” already exists
(SchemaUpdate.java [localhost-startStop-1])
- ERROR 2015-08-20 16:21:22,215 HHH000388: Unsuccessful: alter table
sqlviewusergroupaccesses add constraint FK_ftn43gpevax8by169pld7dl5d foreign
key (sqlviewid) references sqlview (SchemaUpdate.java
[localhost-startStop-1])
- ERROR 2015-08-20 16:21:22,216 ERROR: constraint
“fk_ftn43gpevax8by169pld7dl5d” for relation “sqlviewusergroupaccesses”
already exists (SchemaUpdate.java [localhost-startStop-1])
- ERROR 2015-08-20 16:21:22,219 HHH000388: Unsuccessful: alter table
validationrulegroupmembers add constraint
fk_validationrulegroupmembers_validationrulegroupid foreign key
(validationgroupid) references validationrulegroup (SchemaUpdate.java
[localhost-startStop-1])
- ERROR 2015-08-20 16:21:22,221 ERROR: constraint
“fk_validationrulegroupmembers_validationrulegroupid” for relation
“validationrulegroupmembers” already exists (SchemaUpdate.java
[localhost-startStop-1])
- ERROR 2015-08-20 16:21:22,224 HHH000388: Unsuccessful: alter table
validationrulegroupusergroupaccesses add constraint
FK_932w5l8vbyvybhsrwwadjd3cp foreign key (validationrulegroupid) references
validationrulegroup (SchemaUpdate.java [localhost-startStop-1])
- ERROR 2015-08-20 16:21:22,225 ERROR: constraint
“fk_932w5l8vbyvybhsrwwadjd3cp” for relation
“validationrulegroupusergroupaccesses” already exists (SchemaUpdate.java
[localhost-startStop-1])
- ERROR 2015-08-20 16:21:22,228 HHH000388: Unsuccessful: alter table
validationrulegroupusergroupstoalert add constraint
fk_validationrulegroupusergroupstoalert_validationgroupid foreign key
(validationgroupid) references validationrulegroup (SchemaUpdate.java
[localhost-startStop-1])
- ERROR 2015-08-20 16:21:22,229 ERROR: constraint
“fk_validationrulegroupusergroupstoalert_validationgroupid” for relation
“validationrulegroupusergroupstoalert” already exists (SchemaUpdate.java
[localhost-startStop-1])
- INFO 2015-08-20 16:21:26,000 Found the following message senders:
[org.hisp.dhis.message.EmailMessageSender@7c267dd0,
org.hisp.dhis.sms.SmsMessageSender@615318b9] (DefaultMessageService.java
[localhost-startStop-1])
- INFO 2015-08-20 16:21:31,908 Detected apps: (DefaultAppManager.java
[localhost-startStop-1])
- INFO 2015-08-20 16:21:33,190 Added logger: org.hisp.dhis.resourcetable
using file: /home/inveneo/DHIS2_HOME/dhis/logs/dhis-analytics-table.log
(Log4JLogConfigInitializer.java [localhost-startStop-1])
- INFO 2015-08-20 16:21:33,191 Added logger:
org.hisp.dhis.analytics.table using file:
/home/inveneo/DHIS2_HOME/dhis/logs/dhis-analytics-table.log
(Log4JLogConfigInitializer.java [localhost-startStop-1])
- INFO 2015-08-20 16:21:33,191 Added logger: org.hisp.dhis.dxf2 using
file: /home/inveneo/DHIS2_HOME/dhis/logs/dhis-data-exchange.log
(Log4JLogConfigInitializer.java [localhost-startStop-1])
- INFO 2015-08-20 16:21:33,191 Added logger: org.hisp.dhis.dxf2.synch
using file: /home/inveneo/DHIS2_HOME/dhis/logs/dhis-data-sync.log
(Log4JLogConfigInitializer.java [localhost-startStop-1])
- INFO 2015-08-20 16:21:33,192 Added root logger using file:
/home/inveneo/DHIS2_HOME/dhis/logs/dhis.log (Log4JLogConfigInitializer.java
[localhost-startStop-1])
- WARN 2015-08-20 16:21:33,724 RP discovery / realm validation disabled;
(RealmVerifier.java [localhost-startStop-1])
- INFO 2015-08-20 16:21:34,751 Executing startup routine [1 of 14,
runlevel 1]: InitTableAlteror (DefaultStartupRoutineExecutor.java
[localhost-startStop-1])
- INFO 2015-08-20 16:21:34,950 Upgraded program stage data elements
(InitTableAlteror.java [localhost-startStop-1])
- INFO 2015-08-20 16:21:34,951 Executing startup routine [2 of 14,
runlevel 2]: PeriodTypePopulator (DefaultStartupRoutineExecutor.java
[localhost-startStop-1])
- INFO 2015-08-20 16:21:34,969 Executing startup routine [3 of 14,
runlevel 2]: DataElementDefaultDimensionPopulator
(DefaultStartupRoutineExecutor.java [localhost-startStop-1])
- ERROR 2015-08-20 16:21:34,986 org.hibernate.PropertyAccessException:
Null value was assigned to a property of primitive type setter of
org.hisp.dhis.common.BaseDimensionalObject.dataDimension
at
org.hibernate.property.BasicPropertyAccessor$BasicSetter.set(BasicPropertyAccessor.java:108)
at
org.hibernate.tuple.entity.AbstractEntityTuplizer.setPropertyValues(AbstractEntityTuplizer.java:710)
at
org.hibernate.tuple.entity.PojoEntityTuplizer.setPropertyValues(PojoEntityTuplizer.java:379)
at
org.hibernate.persister.entity.AbstractEntityPersister.setPropertyValues(AbstractEntityPersister.java:4522)
at
org.hibernate.engine.internal.TwoPhaseLoad.doInitializeEntity(TwoPhaseLoad.java:186)
at
org.hibernate.engine.internal.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:137)
at
org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:1112)
at org.hibernate.loader.Loader.processResultSet(Loader.java:969)
at org.hibernate.loader.Loader.doQuery(Loader.java:917)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:348)
at org.hibernate.loader.Loader.doList(Loader.java:2550)
at org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2395)
at org.hibernate.loader.Loader.list(Loader.java:2358)
at
org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:124)
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1623)
at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:374)
at
org.hisp.dhis.common.hibernate.HibernateIdentifiableObjectStore.getAllEqName(HibernateIdentifiableObjectStore.java:180)
at
org.hisp.dhis.dataelement.DefaultDataElementCategoryService.getDataElementCategoryByName(DefaultDataElementCategoryService.java:212)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at
org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
at
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at
org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
at com.sun.proxy.$Proxy38.getDataElementCategoryByName(Unknown Source)
at
org.hisp.dhis.dataelement.DataElementDefaultDimensionPopulator.execute(DataElementDefaultDimensionPopulator.java:82)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at
org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
at
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
at com.sun.proxy.$Proxy84.execute(Unknown Source)
at
org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:119)
at
org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:88)
at
org.hisp.dhis.system.startup.StartupListener.contextInitialized(StartupListener.java:68)
at
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4939)
at
org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5434)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:633)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:976)
at
org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1653)
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724)
Caused by: java.lang.IllegalArgumentException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at
org.hibernate.property.BasicPropertyAccessor$BasicSetter.set(BasicPropertyAccessor.java:65)
... 63 more
(StartupListener.java [localhost-startStop-1])
Aug 20, 2015 4:21:34 PM org.apache.catalina.core.StandardContext
startInternal
SEVERE: Error listenerStart
Aug 20, 2015 4:21:34 PM org.apache.catalina.core.StandardContext
startInternal
SEVERE: Context [/dhis] startup failed due to previous errors
- INFO 2015-08-20 16:21:34,993 De-registering jdbc driver:
sun.jdbc.odbc.JdbcOdbcDriver@1629bc56 (StartupListener.java
[localhost-startStop-1])
- INFO 2015-08-20 16:21:34,993 De-registering jdbc driver:
org.postgresql.Driver@14c944d8 (StartupListener.java
[localhost-startStop-1])
Aug 20, 2015 4:21:35 PM org.apache.catalina.loader.WebappClassLoader
checkThreadLocalMapForLeaks
SEVERE: The web application [/dhis] created a ThreadLocal with key of type
[java.lang.ThreadLocal] (value [java.lang.ThreadLocal@726b1eee]) and a value
of type [org.springframework.security.core.context.SecurityContextImpl]
(value
[org.springframework.security.core.context.SecurityContextImpl@ffffffff:
Null authentication]) but failed to remove it when the web application was
stopped. Threads are going to be renewed over time to try and avoid a
probable memory leak.
Aug 20, 2015 4:21:35 PM org.apache.catalina.startup.HostConfig
deployDirectory
INFO: Deploying web application directory
/usr/share/apache-tomcat-7.0.42/webapps/ROOT
Aug 20, 2015 4:21:35 PM org.apache.catalina.startup.HostConfig
deployDirectory
INFO: Deploying web application directory
/usr/share/apache-tomcat-7.0.42/webapps/host-manager
Aug 20, 2015 4:21:35 PM org.apache.catalina.startup.HostConfig
deployDirectory
INFO: Deploying web application directory
/usr/share/apache-tomcat-7.0.42/webapps/examples
Aug 20, 2015 4:21:35 PM org.apache.catalina.startup.HostConfig
deployDirectory
INFO: Deploying web application directory
/usr/share/apache-tomcat-7.0.42/webapps/manager
Aug 20, 2015 4:21:35 PM org.apache.catalina.startup.HostConfig
deployDirectory
INFO: Deploying web application directory
/usr/share/apache-tomcat-7.0.42/webapps/docs
Aug 20, 2015 4:21:35 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler [“http-bio-8080”]
Aug 20, 2015 4:21:35 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler [“ajp-bio-8009”]
Aug 20, 2015 4:21:35 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 34288 ms
To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1487121/+subscriptions
–
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1487121
Title:
tomcat is not displaying dhis on web browser
Status in DHIS:
Fix Released
Bug description:
Hello all,
I am trying to install Dhis on ubuntu desktop 14.04.I av installed
tomcat,java and copied the war file to webapps.The tomcat starts well
and deploys the war file.
But when i try to access the dhis from my webbrowser,it gives the
error below
HTTP Status 404 - /dhis
type Status report
message /dhis
description The requested resource is not available.
Apache Tomcat/7.0.42
I have tried it on several browsers,its the same thing.Can someone
please help me ?
This is a snap shot of the catalina.out result of the tomcat
Aug 20, 2015 4:21:00 PM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler [“ajp-bio-8009”]
Aug 20, 2015 4:21:00 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 375 ms
Aug 20, 2015 4:21:01 PM org.apache.catalina.core.StandardService startInternal
INFO: Starting service Catalina
Aug 20, 2015 4:21:01 PM org.apache.catalina.core.StandardEngine startInternal
INFO: Starting Servlet Engine: Apache Tomcat/7.0.42
Aug 20, 2015 4:21:01 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive /usr/share/apache-tomcat-7.0.42/webapps/dhis.war
-
INFO 2015-08-20 16:21:11,055 System property dhis2.home not set (DefaultLocationManager.java [localhost-startStop-1])
-
INFO 2015-08-20 16:21:11,057 Environment variable DHIS2_HOME points to /home/inveneo/DHIS2_HOME/dhis (DefaultLocationManager.java [localhost-startStop-1])
-
INFO 2015-08-20 16:21:12,083 Hibernate configuration loaded, using dialect: org.hibernate.dialect.PostgreSQLDialect (DefaultHibernateConfigurationProvider.java [localhost-startStop-1])
-
ERROR 2015-08-20 16:21:22,179 HHH000388: Unsuccessful: alter table completedatasetregistration add column attributeoptioncomboid int4 not null (SchemaUpdate.java [localhost-startStop-1])
-
ERROR 2015-08-20 16:21:22,181 ERROR: column “attributeoptioncomboid” contains null values (SchemaUpdate.java [localhost-startStop-1])
-
ERROR 2015-08-20 16:21:22,185 HHH000388: Unsuccessful: alter table datavalue add column attributeoptioncomboid int4 not null (SchemaUpdate.java [localhost-startStop-1])
-
ERROR 2015-08-20 16:21:22,187 ERROR: column “attributeoptioncomboid” contains null values (SchemaUpdate.java [localhost-startStop-1])
-
ERROR 2015-08-20 16:21:22,190 HHH000388: Unsuccessful: alter table minmaxdataelement add column minimumvalue int4 not null (SchemaUpdate.java [localhost-startStop-1])
-
ERROR 2015-08-20 16:21:22,191 ERROR: column “minimumvalue” contains null values (SchemaUpdate.java [localhost-startStop-1])
-
ERROR 2015-08-20 16:21:22,194 HHH000388: Unsuccessful: alter table minmaxdataelement add column maximumvalue int4 not null (SchemaUpdate.java [localhost-startStop-1])
-
ERROR 2015-08-20 16:21:22,195 ERROR: column “maximumvalue” contains null values (SchemaUpdate.java [localhost-startStop-1])
-
ERROR 2015-08-20 16:21:22,199 HHH000388: Unsuccessful: alter table translation add column translationid int4 not null (SchemaUpdate.java [localhost-startStop-1])
-
ERROR 2015-08-20 16:21:22,199 ERROR: column “translationid” contains null values (SchemaUpdate.java [localhost-startStop-1])
-
ERROR 2015-08-20 16:21:22,202 HHH000388: Unsuccessful: alter table completedatasetregistration add constraint fk_completedatasetregistration_attributeoptioncomboid foreign key (attributeoptioncomboid) references categoryoptioncombo (SchemaUpdate.java [localhost-startStop-1])
-
ERROR 2015-08-20 16:21:22,203 ERROR: column “attributeoptioncomboid” referenced in foreign key constraint does not exist (SchemaUpdate.java [localhost-startStop-1])
-
ERROR 2015-08-20 16:21:22,206 HHH000388: Unsuccessful: alter table datavalue add constraint fk_datavalue_attributeoptioncomboid foreign key (attributeoptioncomboid) references categoryoptioncombo (SchemaUpdate.java [localhost-startStop-1])
-
ERROR 2015-08-20 16:21:22,208 ERROR: column “attributeoptioncomboid” referenced in foreign key constraint does not exist (SchemaUpdate.java [localhost-startStop-1])
-
ERROR 2015-08-20 16:21:22,210 HHH000388: Unsuccessful: alter table programstage add constraint fk_programstage_dataentryform foreign key (dataentryformid) references dataentryform (SchemaUpdate.java [localhost-startStop-1])
-
ERROR 2015-08-20 16:21:22,211 ERROR: constraint “fk_programstage_dataentryform” for relation “programstage” already exists (SchemaUpdate.java [localhost-startStop-1])
-
ERROR 2015-08-20 16:21:22,215 HHH000388: Unsuccessful: alter table sqlviewusergroupaccesses add constraint FK_ftn43gpevax8by169pld7dl5d foreign key (sqlviewid) references sqlview (SchemaUpdate.java [localhost-startStop-1])
-
ERROR 2015-08-20 16:21:22,216 ERROR: constraint “fk_ftn43gpevax8by169pld7dl5d” for relation “sqlviewusergroupaccesses” already exists (SchemaUpdate.java [localhost-startStop-1])
-
ERROR 2015-08-20 16:21:22,219 HHH000388: Unsuccessful: alter table validationrulegroupmembers add constraint fk_validationrulegroupmembers_validationrulegroupid foreign key (validationgroupid) references validationrulegroup (SchemaUpdate.java [localhost-startStop-1])
-
ERROR 2015-08-20 16:21:22,221 ERROR: constraint “fk_validationrulegroupmembers_validationrulegroupid” for relation “validationrulegroupmembers” already exists (SchemaUpdate.java [localhost-startStop-1])
-
ERROR 2015-08-20 16:21:22,224 HHH000388: Unsuccessful: alter table validationrulegroupusergroupaccesses add constraint FK_932w5l8vbyvybhsrwwadjd3cp foreign key (validationrulegroupid) references validationrulegroup (SchemaUpdate.java [localhost-startStop-1])
-
ERROR 2015-08-20 16:21:22,225 ERROR: constraint “fk_932w5l8vbyvybhsrwwadjd3cp” for relation “validationrulegroupusergroupaccesses” already exists (SchemaUpdate.java [localhost-startStop-1])
-
ERROR 2015-08-20 16:21:22,228 HHH000388: Unsuccessful: alter table validationrulegroupusergroupstoalert add constraint fk_validationrulegroupusergroupstoalert_validationgroupid foreign key (validationgroupid) references validationrulegroup (SchemaUpdate.java [localhost-startStop-1])
-
ERROR 2015-08-20 16:21:22,229 ERROR: constraint “fk_validationrulegroupusergroupstoalert_validationgroupid” for relation “validationrulegroupusergroupstoalert” already exists (SchemaUpdate.java [localhost-startStop-1])
-
INFO 2015-08-20 16:21:26,000 Found the following message senders: [org.hisp.dhis.message.EmailMessageSender@7c267dd0, org.hisp.dhis.sms.SmsMessageSender@615318b9] (DefaultMessageService.java [localhost-startStop-1])
-
INFO 2015-08-20 16:21:31,908 Detected apps: (DefaultAppManager.java [localhost-startStop-1])
-
INFO 2015-08-20 16:21:33,190 Added logger: org.hisp.dhis.resourcetable using file: /home/inveneo/DHIS2_HOME/dhis/logs/dhis-analytics-table.log (Log4JLogConfigInitializer.java [localhost-startStop-1])
-
INFO 2015-08-20 16:21:33,191 Added logger: org.hisp.dhis.analytics.table using file: /home/inveneo/DHIS2_HOME/dhis/logs/dhis-analytics-table.log (Log4JLogConfigInitializer.java [localhost-startStop-1])
-
INFO 2015-08-20 16:21:33,191 Added logger: org.hisp.dhis.dxf2 using file: /home/inveneo/DHIS2_HOME/dhis/logs/dhis-data-exchange.log (Log4JLogConfigInitializer.java [localhost-startStop-1])
-
INFO 2015-08-20 16:21:33,191 Added logger: org.hisp.dhis.dxf2.synch using file: /home/inveneo/DHIS2_HOME/dhis/logs/dhis-data-sync.log (Log4JLogConfigInitializer.java [localhost-startStop-1])
-
INFO 2015-08-20 16:21:33,192 Added root logger using file: /home/inveneo/DHIS2_HOME/dhis/logs/dhis.log (Log4JLogConfigInitializer.java [localhost-startStop-1])
-
WARN 2015-08-20 16:21:33,724 RP discovery / realm validation disabled; (RealmVerifier.java [localhost-startStop-1])
-
INFO 2015-08-20 16:21:34,751 Executing startup routine [1 of 14, runlevel 1]: InitTableAlteror (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
-
INFO 2015-08-20 16:21:34,950 Upgraded program stage data elements (InitTableAlteror.java [localhost-startStop-1])
-
INFO 2015-08-20 16:21:34,951 Executing startup routine [2 of 14, runlevel 2]: PeriodTypePopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
-
INFO 2015-08-20 16:21:34,969 Executing startup routine [3 of 14, runlevel 2]: DataElementDefaultDimensionPopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
-
ERROR 2015-08-20 16:21:34,986 org.hibernate.PropertyAccessException: Null value was assigned to a property of primitive type setter of org.hisp.dhis.common.BaseDimensionalObject.dataDimension
at org.hibernate.property.BasicPropertyAccessor$BasicSetter.set(BasicPropertyAccessor.java:108)
at org.hibernate.tuple.entity.AbstractEntityTuplizer.setPropertyValues(AbstractEntityTuplizer.java:710)
at org.hibernate.tuple.entity.PojoEntityTuplizer.setPropertyValues(PojoEntityTuplizer.java:379)
at org.hibernate.persister.entity.AbstractEntityPersister.setPropertyValues(AbstractEntityPersister.java:4522)
at org.hibernate.engine.internal.TwoPhaseLoad.doInitializeEntity(TwoPhaseLoad.java:186)
at org.hibernate.engine.internal.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:137)
at org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:1112)
at org.hibernate.loader.Loader.processResultSet(Loader.java:969)
at org.hibernate.loader.Loader.doQuery(Loader.java:917)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:348)
at org.hibernate.loader.Loader.doList(Loader.java:2550)
at org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2395)
at org.hibernate.loader.Loader.list(Loader.java:2358)
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:124)
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1623)
at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:374)
at org.hisp.dhis.common.hibernate.HibernateIdentifiableObjectStore.getAllEqName(HibernateIdentifiableObjectStore.java:180)
at org.hisp.dhis.dataelement.DefaultDataElementCategoryService.getDataElementCategoryByName(DefaultDataElementCategoryService.java:212)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
at com.sun.proxy.$Proxy38.getDataElementCategoryByName(Unknown Source)
at org.hisp.dhis.dataelement.DataElementDefaultDimensionPopulator.execute(DataElementDefaultDimensionPopulator.java:82)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
at com.sun.proxy.$Proxy84.execute(Unknown Source)
at org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:119)
at org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:88)
at org.hisp.dhis.system.startup.StartupListener.contextInitialized(StartupListener.java:68)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4939)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5434)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:633)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:976)
at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1653)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724)
Caused by: java.lang.IllegalArgumentException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.hibernate.property.BasicPropertyAccessor$BasicSetter.set(BasicPropertyAccessor.java:65)
... 63 more
(StartupListener.java [localhost-startStop-1])
Aug 20, 2015 4:21:34 PM org.apache.catalina.core.StandardContext startInternal
SEVERE: Error listenerStart
Aug 20, 2015 4:21:34 PM org.apache.catalina.core.StandardContext startInternal
SEVERE: Context [/dhis] startup failed due to previous errors
-
INFO 2015-08-20 16:21:34,993 De-registering jdbc driver: sun.jdbc.odbc.JdbcOdbcDriver@1629bc56 (StartupListener.java [localhost-startStop-1])
-
INFO 2015-08-20 16:21:34,993 De-registering jdbc driver: org.postgresql.Driver@14c944d8 (StartupListener.java [localhost-startStop-1])
Aug 20, 2015 4:21:35 PM org.apache.catalina.loader.WebappClassLoader checkThreadLocalMapForLeaks
SEVERE: The web application [/dhis] created a ThreadLocal with key of type [java.lang.ThreadLocal] (value [java.lang.ThreadLocal@726b1eee]) and a value of type [org.springframework.security.core.context.SecurityContextImpl] (value [org.springframework.security.core.context.SecurityContextImpl@ffffffff: Null authentication]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak.
Aug 20, 2015 4:21:35 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory /usr/share/apache-tomcat-7.0.42/webapps/ROOT
Aug 20, 2015 4:21:35 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory /usr/share/apache-tomcat-7.0.42/webapps/host-manager
Aug 20, 2015 4:21:35 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory /usr/share/apache-tomcat-7.0.42/webapps/examples
Aug 20, 2015 4:21:35 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory /usr/share/apache-tomcat-7.0.42/webapps/manager
Aug 20, 2015 4:21:35 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory /usr/share/apache-tomcat-7.0.42/webapps/docs
Aug 20, 2015 4:21:35 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler [“http-bio-8080”]
Aug 20, 2015 4:21:35 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler [“ajp-bio-8009”]
Aug 20, 2015 4:21:35 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 34288 ms
To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1487121/+subscriptions
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
Dept. of Informatics, University of Oslo