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