dhis2-devs team mailing list archive

Thread
Date

Error when upload war file in tomcat7

To: DHIS 2 Users list <dhis2-users@xxxxxxxxxxxxxxxxxxx>, DHIS 2 Developers list <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
From: channara rin <rin.channara@xxxxxxxxx>
Date: Mon, 30 Jun 2014 09:04:42 +0700

Hi dev, users
When i upload dhis2 v2.15.war file into tomcat 7. that my database is:
PostgreSQL, i got the error in tomcat console. plz look attached file.
Do you know what is the problem? how can i fix it?

Thank you
Channara

Jun 30, 2014 1:45:46 AM org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performanc
e in production environments was not found on the java.library.path: C:\tomcat7\
bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\Program Files (x86
)\NVIDIA Corporation\PhysX\Common;C:\Windows\system32;C:\Windows;C:\Windows\Syst
em32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;.
Jun 30, 2014 1:45:46 AM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["http-bio-8080"]
Jun 30, 2014 1:45:46 AM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["ajp-bio-8009"]
Jun 30, 2014 1:45:46 AM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 909 ms
Jun 30, 2014 1:45:46 AM org.apache.catalina.core.StandardService startInternal
INFO: Starting service Catalina
Jun 30, 2014 1:45:46 AM org.apache.catalina.core.StandardEngine startInternal
INFO: Starting Servlet Engine: Apache Tomcat/7.0.54
Jun 30, 2014 1:45:46 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\tomcat7\webapps\docs
Jun 30, 2014 1:45:47 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deployment of web application directory C:\tomcat7\webapps\docs has finish
ed in 780 ms
Jun 30, 2014 1:45:47 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\tomcat7\webapps\host-manager
Jun 30, 2014 1:45:47 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deployment of web application directory C:\tomcat7\webapps\host-manager ha
s finished in 140 ms
Jun 30, 2014 1:45:47 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\tomcat7\webapps\manager
Jun 30, 2014 1:45:47 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deployment of web application directory C:\tomcat7\webapps\manager has fin
ished in 139 ms
Jun 30, 2014 1:45:47 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\tomcat7\webapps\ROOT
Jun 30, 2014 1:45:47 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deployment of web application directory C:\tomcat7\webapps\ROOT has finish
ed in 91 ms
Jun 30, 2014 1:45:47 AM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["http-bio-8080"]
Jun 30, 2014 1:45:47 AM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["ajp-bio-8009"]
Jun 30, 2014 1:45:47 AM org.apache.catalina.startup.Catalina start
INFO: Server startup in 1264 ms
Jun 30, 2014 1:46:28 AM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive C:\tomcat7\webapps\dhis.2.15-old.war
* INFO  2014-06-30 01:47:52,268 System property dhis2.home not set (DefaultLocat
ionManager.java [http-bio-8080-exec-3])
* INFO  2014-06-30 01:47:52,273 Environment variable DHIS2_HOME points to C:\DHI
S2_HOME (DefaultLocationManager.java [http-bio-8080-exec-3])
* INFO  2014-06-30 01:47:55,255 Hibernate configuration loaded, using dialect: o
rg.hibernate.dialect.PostgreSQLDialect (DefaultHibernateConfigurationProvider.ja
va [http-bio-8080-exec-3])
* INFO  2014-06-30 01:48:10,864 Found the following message senders: [org.hisp.d
his.message.EmailMessageSender@172aa81b, org.hisp.dhis.sms.SmsMessageSender@7182
907e] (DefaultMessageService.java [http-bio-8080-exec-3])
* WARN  2014-06-30 01:48:22,602 SQL Error: 0, SQLState: 42P01 (SqlExceptionHelpe
r.java [http-bio-8080-exec-3])
* ERROR 2014-06-30 01:48:22,603 ERROR: relation "systemsetting" does not exist
  Position: 113 (SqlExceptionHelper.java [http-bio-8080-exec-3])
* ERROR 2014-06-30 01:48:22,785 Context initialization failed (ContextLoader.jav
a [http-bio-8080-exec-3])
org.springframework.beans.factory.BeanCreationException: Error creating bean wit
h name 'org.hisp.dhis.appmanager.AppManager': Invocation of init method failed;
nested exception is org.hibernate.exception.SQLGrammarException: could not extra
ct ResultSet
        at org.springframework.beans.factory.annotation.InitDestroyAnnotationBea
nPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProc
essor.java:133)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanF
actory.java:396)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.initializeBean(AbstractAutowireCapableBeanFactory.java:1505)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.doCreateBean(AbstractAutowireCapableBeanFactory.java:521)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.createBean(AbstractAutowireCapableBeanFactory.java:458)
        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getOb
ject(AbstractBeanFactory.java:296)
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistr
y.getSingleton(DefaultSingletonBeanRegistry.java:223)
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBe
an(AbstractBeanFactory.java:293)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:194)
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.
preInstantiateSingletons(DefaultListableBeanFactory.java:628)
        at org.springframework.context.support.AbstractApplicationContext.finish
BeanFactoryInitialization(AbstractApplicationContext.java:932)
        at org.springframework.context.support.AbstractApplicationContext.refres
h(AbstractApplicationContext.java:479)
        at org.springframework.web.context.ContextLoader.configureAndRefreshWebA
pplicationContext(ContextLoader.java:389)
        at org.springframework.web.context.ContextLoader.initWebApplicationConte
xt(ContextLoader.java:294)
        at org.springframework.web.context.ContextLoaderListener.contextInitiali
zed(ContextLoaderListener.java:112)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContex
t.java:4973)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContex
t.java:5467)
        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:87
7)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:632)

        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1083
)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:553
)
        at org.apache.catalina.startup.HostConfig.check(HostConfig.java:1671)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at org.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.j
ava:301)
        at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(Unknown
Source)
        at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(Unknown Source)
        at org.apache.catalina.manager.ManagerServlet.check(ManagerServlet.java:
1485)
        at org.apache.catalina.manager.HTMLManagerServlet.upload(HTMLManagerServ
let.java:286)
        at org.apache.catalina.manager.HTMLManagerServlet.doPost(HTMLManagerServ
let.java:206)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:303)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:208)
        at org.apache.catalina.filters.CsrfPreventionFilter.doFilter(CsrfPrevent
ionFilter.java:213)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:241)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:208)
        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52
)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:241)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:208)
        at org.apache.catalina.filters.SetCharacterEncodingFilter.doFilter(SetCh
aracterEncodingFilter.java:108)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:241)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:208)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:220)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:122)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:610)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:171)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:102)
        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:
950)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:116)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:408)
        at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp
11Processor.java:1040)
        at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(
AbstractProtocol.java:607)
        at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoin
t.java:314)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskTh
read.java:61)
        at java.lang.Thread.run(Unknown Source)
Caused by: org.hibernate.exception.SQLGrammarException: could not extract Result
Set
        at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(S
QLStateConversionDelegate.java:122)
        at org.hibernate.exception.internal.StandardSQLExceptionConverter.conver
t(StandardSQLExceptionConverter.java:49)
        at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlException
Helper.java:125)
        at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlException
Helper.java:110)
        at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(Result
SetReturnImpl.java:61)
        at org.hibernate.loader.Loader.getResultSet(Loader.java:2031)
        at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1832)
        at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1811)
        at org.hibernate.loader.Loader.doQuery(Loader.java:899)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Lo
ader.java:341)
        at org.hibernate.loader.Loader.doList(Loader.java:2516)
        at org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2361)
        at org.hibernate.loader.Loader.list(Loader.java:2324)
        at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java
:124)
        at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1661)
        at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:374)
        at org.hibernate.internal.CriteriaImpl.uniqueResult(CriteriaImpl.java:39
6)
        at org.hisp.dhis.setting.hibernate.HibernateSystemSettingStore.getByName
(HibernateSystemSettingStore.java:45)
        at org.hisp.dhis.setting.DefaultSystemSettingManager.getSystemSetting(De
faultSystemSettingManager.java:92)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
on(AopUtils.java:317)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:183)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:150)
        at org.springframework.transaction.interceptor.TransactionInterceptor$1.
proceedWithInvocation(TransactionInterceptor.java:96)
        at org.springframework.transaction.interceptor.TransactionAspectSupport.
invokeWithinTransaction(TransactionAspectSupport.java:260)
        at org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:94)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:172)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:204)
        at com.sun.proxy.$Proxy25.getSystemSetting(Unknown Source)
        at org.hisp.dhis.appmanager.DefaultAppManager.getAppFolderPath(DefaultAp
pManager.java:180)
        at org.hisp.dhis.appmanager.DefaultAppManager.reloadApps(DefaultAppManag
er.java:243)
        at org.hisp.dhis.appmanager.DefaultAppManager.init(DefaultAppManager.jav
a:69)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at org.springframework.beans.factory.annotation.InitDestroyAnnotationBea
nPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.ja
va:344)
        at org.springframework.beans.factory.annotation.InitDestroyAnnotationBea
nPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPost
Processor.java:295)
        at org.springframework.beans.factory.annotation.InitDestroyAnnotationBea
nPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProc
essor.java:130)
        ... 61 more
Caused by: org.postgresql.util.PSQLException: ERROR: relation "systemsetting" do
es not exist
  Position: 113
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx
ecutorImpl.java:2161)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor
Impl.java:1890)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
va:255)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat
ement.java:560)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract
Jdbc2Statement.java:417)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc
2Statement.java:302)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewPr
oxyPreparedStatement.java:76)
        at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(Result
SetReturnImpl.java:56)
        ... 98 more
Jun 30, 2014 1:48:22 AM org.apache.catalina.core.StandardContext startInternal
SEVERE: Error listenerStart
Jun 30, 2014 1:48:22 AM org.apache.catalina.core.StandardContext startInternal
SEVERE: Context [/dhis.2.15-old] startup failed due to previous errors
* INFO  2014-06-30 01:48:22,835 De-registering jdbc driver: sun.jdbc.odbc.JdbcOd
bcDriver@370e652 (StartupListener.java [http-bio-8080-exec-3])
* INFO  2014-06-30 01:48:22,836 De-registering jdbc driver: org.postgresql.Drive
r@41eb650a (StartupListener.java [http-bio-8080-exec-3])
Jun 30, 2014 1:48:22 AM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deployment of web application archive C:\tomcat7\webapps\dhis.2.15-old.war
 has finished in 114,084 ms

Follow ups

Re: Error when upload war file in tomcat7
From: Lars Helge Øverland, 2014-06-30