Hi Lars, I managed to find the problem after looking for additional schemas, per your suggestion.
dhis2=# \dn List of schemas Name | Owner ---------+---------- private | postgres public | postgres (2 rows) showed two schemas, and inside of the "private" schema, was a table called "organisationunit", which apparently was causing the error. I deleted that table in the private schema,and things seem to work. Best regards, Jason On Thu, Oct 13, 2016 at 10:46 AM, Jason Pickering < [email protected]> wrote: > sorry for the typo. I mean, "shows only these two tables which appear to > potentially match that pattern." > > On Thu, Oct 13, 2016 at 10:45 AM, Jason Pickering < > [email protected]> wrote: > >> Well, I am not seeing anything obvious. Just to be sure, I have dropped >> all views and retested, but that does not seem to help. >> >> dhis2=# \dt organisation* >> List of relations >> Schema | Name | Type | Owner >> --------+---------------------------------+-------+---------- >> public | organisationunit | table | postgres >> public | organisationunitattributevalues | table | postgres >> (2 rows) >> >> shows only these two patters which appear to potentially match that >> pattern. >> >> >> >> >> >> On Thu, Oct 13, 2016 at 9:33 AM, Lars Helge Øverland <[email protected]> >> wrote: >> >>> Hi Jason, >>> >>> hard to say from here but this SO thread >>> <http://stackoverflow.com/questions/36907095/more-than-one-table-found-in-namespace-schemaextractionexception> >>> offers some insight. Best guess: there is a non-dhis table or view in the >>> database with an underscore or other special char such as >>> "organisation_unit" which conflicts with the organisationunit table. >>> Perhaps something got stricter in Hibernat 5 which is what we use in 2.25. >>> >>> best regards, >>> >>> Lars >>> >>> >>> On Thu, Oct 13, 2016 at 8:36 AM, Jason Pickering < >>> [email protected]> wrote: >>> >>>> From the latest 2.24 build. Upgrading from 2.23 I get this. >>>> Any ideas? >>>> >>>> Oct 13, 2016 8:34:06 AM org.apache.coyote.AbstractProtocol init >>>> INFO: Initializing ProtocolHandler ["http-bio-127.0.0.1-8090"] >>>> Oct 13, 2016 8:34:06 AM org.apache.catalina.startup.Catalina load >>>> INFO: Initialization processed in 679 ms >>>> Oct 13, 2016 8:34:06 AM org.apache.catalina.core.StandardService >>>> startInternal >>>> INFO: Starting service Catalina >>>> Oct 13, 2016 8:34:06 AM org.apache.catalina.core.StandardEngine >>>> startInternal >>>> INFO: Starting Servlet Engine: Apache Tomcat/7.0.68 (Ubuntu) >>>> Oct 13, 2016 8:34:06 AM org.apache.catalina.startup.HostConfig >>>> deployWAR >>>> INFO: Deploying web application archive /home/dhis/tomcat-dhis/webapps >>>> /ROOT.war >>>> Oct 13, 2016 8:34:15 AM org.apache.catalina.startup.TldConfig execute >>>> INFO: At least one JAR was scanned for TLDs yet contained no TLDs. >>>> Enable debug logging for this logger for a complete list of JARs that were >>>> scanned but no TLDs were found in them. Skipping unneeded JARs during >>>> scanning can improve startup time and JSP compilation time. >>>> * INFO 2016-10-13 08:34:19,953 System property dhis2.home not set >>>> (DefaultLocationManager.java [localhost-startStop-1]) >>>> * INFO 2016-10-13 08:34:19,957 Environment variable DHIS2_HOME points >>>> to /home/dhis/config (DefaultLocationManager.java [localhost-startStop-1]) >>>> * INFO 2016-10-13 08:34:19,963 File >>>> /home/dhis/config/dhis-google-auth.json >>>> does not exist (DefaultLocationManager.java [localhost-startStop-1]) >>>> * INFO 2016-10-13 08:34:19,964 Could not find dhis-google-auth.json >>>> (DefaultDhisConfigurationProvider.java [localhost-startStop-1]) >>>> * INFO 2016-10-13 08:34:19,965 File >>>> /home/dhis/config/dhis-google-auth.json >>>> does not exist (DefaultLocationManager.java [localhost-startStop-1]) >>>> * INFO 2016-10-13 08:34:19,965 Could not find dhis-google-auth.json >>>> (DefaultDhisConfigurationProvider.java [localhost-startStop-1]) >>>> * INFO 2016-10-13 08:34:21,811 Hibernate configuration loaded, using >>>> dialect: org.hibernate.dialect.PostgreSQLDialect >>>> (DefaultHibernateConfigurationProvider.java [localhost-startStop-1]) >>>> * WARN 2016-10-13 08:34:24,159 HHH90000003: Use of DOM4J entity-mode >>>> is considered deprecated (ModelBinder.java [localhost-startStop-1]) >>>> * WARN 2016-10-13 08:34:24,160 HHH90000003: Use of DOM4J entity-mode >>>> is considered deprecated (ModelBinder.java [localhost-startStop-1]) >>>> * WARN 2016-10-13 08:34:24,160 HHH90000003: Use of DOM4J entity-mode >>>> is considered deprecated (ModelBinder.java [localhost-startStop-1]) >>>> * WARN 2016-10-13 08:34:24,161 HHH90000003: Use of DOM4J entity-mode >>>> is considered deprecated (ModelBinder.java [localhost-startStop-1]) >>>> * WARN 2016-10-13 08:34:24,177 HHH90000003: Use of DOM4J entity-mode >>>> is considered deprecated (ModelBinder.java [localhost-startStop-1]) >>>> * WARN 2016-10-13 08:34:24,178 HHH90000003: Use of DOM4J entity-mode >>>> is considered deprecated (ModelBinder.java [localhost-startStop-1]) >>>> * WARN 2016-10-13 08:34:24,230 HHH90000003: Use of DOM4J entity-mode >>>> is considered deprecated (ModelBinder.java [localhost-startStop-1]) >>>> * WARN 2016-10-13 08:34:24,243 HHH90000003: Use of DOM4J entity-mode >>>> is considered deprecated (ModelBinder.java [localhost-startStop-1]) >>>> * WARN 2016-10-13 08:34:24,243 HHH90000003: Use of DOM4J entity-mode >>>> is considered deprecated (ModelBinder.java [localhost-startStop-1]) >>>> * WARN 2016-10-13 08:34:24,260 HHH90000003: Use of DOM4J entity-mode >>>> is considered deprecated (ModelBinder.java [localhost-startStop-1]) >>>> * WARN 2016-10-13 08:34:24,261 HHH90000003: Use of DOM4J entity-mode >>>> is considered deprecated (ModelBinder.java [localhost-startStop-1]) >>>> * WARN 2016-10-13 08:34:24,261 HHH90000003: Use of DOM4J entity-mode >>>> is considered deprecated (ModelBinder.java [localhost-startStop-1]) >>>> * WARN 2016-10-13 08:34:24,262 HHH90000003: Use of DOM4J entity-mode >>>> is considered deprecated (ModelBinder.java [localhost-startStop-1]) >>>> * WARN 2016-10-13 08:34:24,262 HHH90000003: Use of DOM4J entity-mode >>>> is considered deprecated (ModelBinder.java [localhost-startStop-1]) >>>> * WARN 2016-10-13 08:34:32,971 Exception encountered during context >>>> initialization - cancelling refresh attempt: >>>> org.springframework.beans.factory.BeanCreationException: >>>> Error creating bean with name 'org.hisp.dhis.appstore.AppStoreManager': >>>> Injection of autowired dependencies failed; nested exception is >>>> org.springframework.beans.factory.BeanCreationException: Could not >>>> autowire field: private org.hisp.dhis.appmanager.AppManager >>>> org.hisp.dhis.appstore.DefaultAppStoreManager.appManager; nested >>>> exception is org.springframework.beans.factory.BeanCreationException: >>>> Error creating bean with name 'org.hisp.dhis.appmanager.AppManager': >>>> Injection of autowired dependencies failed; nested exception is >>>> org.springframework.beans.factory.BeanCreationException: Could not >>>> autowire field: private org.hisp.dhis.setting.SystemSettingManager >>>> org.hisp.dhis.appmanager.DefaultAppManager.appSettingManager; nested >>>> exception is org.springframework.beans.factory.BeanCreationException: >>>> Error creating bean with name 'org.hisp.dhis.setting.SystemSettingManager': >>>> Injection of autowired dependencies failed; nested exception is >>>> org.springframework.beans.factory.BeanCreationException: Could not >>>> autowire field: private >>>> org.springframework.transaction.support.TransactionTemplate >>>> org.hisp.dhis.setting.DefaultSystemSettingManager.transactionTemplate; >>>> nested exception is >>>> org.springframework.beans.factory.BeanCreationException: >>>> Error creating bean with name 'transactionTemplate' defined in URL >>>> [jar:file:/home/dhis/tomcat-dhis/webapps/ROOT/WEB-INF/lib/dh >>>> is-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Cannot >>>> resolve reference to bean 'transactionManager' while setting bean property >>>> 'transactionManager'; nested exception is >>>> org.springframework.beans.factory.BeanCreationException: >>>> Error creating bean with name 'transactionManager' defined in URL >>>> [jar:file:/home/dhis/tomcat-dhis/webapps/ROOT/WEB-INF/lib/dh >>>> is-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Cannot >>>> resolve reference to bean 'sessionFactory' while setting bean property >>>> 'sessionFactory'; nested exception is >>>> org.springframework.beans.factory.BeanCreationException: >>>> Error creating bean with name 'sessionFactory' defined in URL >>>> [jar:file:/home/dhis/tomcat-dhis/webapps/ROOT/WEB-INF/lib/dh >>>> is-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Invocation of >>>> init method failed; nested exception is org.hibernate.tool.schema.extr >>>> act.spi.SchemaExtractionException: More than one table found in >>>> namespace (, ) : organisationunit (AbstractApplicationContext.java >>>> [localhost-startStop-1]) >>>> * ERROR 2016-10-13 08:34:33,029 Context initialization failed >>>> (ContextLoader.java [localhost-startStop-1]) >>>> org.springframework.beans.factory.BeanCreationException: Error >>>> creating bean with name 'org.hisp.dhis.appstore.AppStoreManager': >>>> Injection of autowired dependencies failed; nested exception is >>>> org.springframework.beans.factory.BeanCreationException: Could not >>>> autowire field: private org.hisp.dhis.appmanager.AppManager >>>> org.hisp.dhis.appstore.DefaultAppStoreManager.appManager; nested >>>> exception is org.springframework.beans.factory.BeanCreationException: >>>> Error creating bean with name 'org.hisp.dhis.appmanager.AppManager': >>>> Injection of autowired dependencies failed; nested exception is >>>> org.springframework.beans.factory.BeanCreationException: Could not >>>> autowire field: private org.hisp.dhis.setting.SystemSettingManager >>>> org.hisp.dhis.appmanager.DefaultAppManager.appSettingManager; nested >>>> exception is org.springframework.beans.factory.BeanCreationException: >>>> Error creating bean with name 'org.hisp.dhis.setting.SystemSettingManager': >>>> Injection of autowired dependencies failed; nested exception is >>>> org.springframework.beans.factory.BeanCreationException: Could not >>>> autowire field: private >>>> org.springframework.transaction.support.TransactionTemplate >>>> org.hisp.dhis.setting.DefaultSystemSettingManager.transactionTemplate; >>>> nested exception is >>>> org.springframework.beans.factory.BeanCreationException: >>>> Error creating bean with name 'transactionTemplate' defined in URL >>>> [jar:file:/home/dhis/tomcat-dhis/webapps/ROOT/WEB-INF/lib/dh >>>> is-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Cannot >>>> resolve reference to bean 'transactionManager' while setting bean property >>>> 'transactionManager'; nested exception is >>>> org.springframework.beans.factory.BeanCreationException: >>>> Error creating bean with name 'transactionManager' defined in URL >>>> [jar:file:/home/dhis/tomcat-dhis/webapps/ROOT/WEB-INF/lib/dh >>>> is-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Cannot >>>> resolve reference to bean 'sessionFactory' while setting bean property >>>> 'sessionFactory'; nested exception is >>>> org.springframework.beans.factory.BeanCreationException: >>>> Error creating bean with name 'sessionFactory' defined in URL >>>> [jar:file:/home/dhis/tomcat-dhis/webapps/ROOT/WEB-INF/lib/dh >>>> is-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Invocation of >>>> init method failed; nested exception is org.hibernate.tool.schema.extr >>>> act.spi.SchemaExtractionException: More than one table found in >>>> namespace (, ) : organisationunit >>>> at org.springframework.beans.factory.annotation.AutowiredAnnota >>>> tionBeanPostProcessor.postProcessPropertyValues(AutowiredAnn >>>> otationBeanPostProcessor.java:334) >>>> at org.springframework.beans.factory.support.AbstractAutowireCa >>>> pableBeanFactory.populateBean(AbstractAutowireCapableBeanFac >>>> tory.java:1214) >>>> at org.springframework.beans.factory.support.AbstractAutowireCa >>>> pableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFac >>>> tory.java:543) >>>> at org.springframework.beans.factory.support.AbstractAutowireCa >>>> pableBeanFactory.createBean(AbstractAutowireCapableBeanFacto >>>> ry.java:482) >>>> at org.springframework.beans.factory.support.AbstractBeanFactor >>>> y$1.getObject(AbstractBeanFactory.java:306) >>>> at org.springframework.beans.factory.support.DefaultSingletonBe >>>> anRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) >>>> at org.springframework.beans.factory.support.AbstractBeanFactor >>>> y.doGetBean(AbstractBeanFactory.java:302) >>>> at org.springframework.beans.factory.support.AbstractBeanFactor >>>> y.getBean(AbstractBeanFactory.java:197) >>>> at org.springframework.beans.factory.support.DefaultListableBea >>>> nFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:772) >>>> at org.springframework.context.support.AbstractApplicationConte >>>> xt.finishBeanFactoryInitialization(AbstractApplicationContext.java:839) >>>> at org.springframework.context.support.AbstractApplicationConte >>>> xt.refresh(AbstractApplicationContext.java:538) >>>> at org.springframework.web.context.ContextLoader.configureAndRe >>>> freshWebApplicationContext(ContextLoader.java:444) >>>> at org.springframework.web.context.ContextLoader.initWebApplica >>>> tionContext(ContextLoader.java:326) >>>> at org.springframework.web.context.ContextLoaderListener.contex >>>> tInitialized(ContextLoaderListener.java:107) >>>> at org.apache.catalina.core.StandardContext.listenerStart(Stand >>>> ardContext.java:5068) >>>> at org.apache.catalina.core.StandardContext.startInternal(Stand >>>> ardContext.java:5584) >>>> at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:147) >>>> at org.apache.catalina.core.ContainerBase.addChildInternal(Cont >>>> ainerBase.java:899) >>>> at org.apache.catalina.core.ContainerBase.addChild(ContainerBas >>>> e.java:875) >>>> at org.apache.catalina.core.StandardHost.addChild(StandardHost. >>>> java:652) >>>> at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig. >>>> java:1091) >>>> at org.apache.catalina.startup.HostConfig$DeployWar.run(HostCon >>>> fig.java:1980) >>>> at java.util.concurrent.Executors$RunnableAdapter.call(Executor >>>> s.java:511) >>>> at java.util.concurrent.FutureTask.run(FutureTask.java:266) >>>> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPool >>>> Executor.java:1142) >>>> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoo >>>> lExecutor.java:617) >>>> at java.lang.Thread.run(Thread.java:745) >>>> Caused by: org.springframework.beans.factory.BeanCreationException: >>>> Could not autowire field: private org.hisp.dhis.appmanager.AppManager >>>> org.hisp.dhis.appstore.DefaultAppStoreManager.appManager; nested >>>> exception is org.springframework.beans.factory.BeanCreationException: >>>> Error creating bean with name 'org.hisp.dhis.appmanager.AppManager': >>>> Injection of autowired dependencies failed; nested exception is >>>> org.springframework.beans.factory.BeanCreationException: Could not >>>> autowire field: private org.hisp.dhis.setting.SystemSettingManager >>>> org.hisp.dhis.appmanager.DefaultAppManager.appSettingManager; nested >>>> exception is org.springframework.beans.factory.BeanCreationException: >>>> Error creating bean with name 'org.hisp.dhis.setting.SystemSettingManager': >>>> Injection of autowired dependencies failed; nested exception is >>>> org.springframework.beans.factory.BeanCreationException: Could not >>>> autowire field: private >>>> org.springframework.transaction.support.TransactionTemplate >>>> org.hisp.dhis.setting.DefaultSystemSettingManager.transactionTemplate; >>>> nested exception is >>>> org.springframework.beans.factory.BeanCreationException: >>>> Error creating bean with name 'transactionTemplate' defined in URL >>>> [jar:file:/home/dhis/tomcat-dhis/webapps/ROOT/WEB-INF/lib/dh >>>> is-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Cannot >>>> resolve reference to bean 'transactionManager' while setting bean property >>>> 'transactionManager'; nested exception is >>>> org.springframework.beans.factory.BeanCreationException: >>>> Error creating bean with name 'transactionManager' defined in URL >>>> [jar:file:/home/dhis/tomcat-dhis/webapps/ROOT/WEB-INF/lib/dh >>>> is-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Cannot >>>> resolve reference to bean 'sessionFactory' while setting bean property >>>> 'sessionFactory'; nested exception is >>>> org.springframework.beans.factory.BeanCreationException: >>>> Error creating bean with name 'sessionFactory' defined in URL >>>> [jar:file:/home/dhis/tomcat-dhis/webapps/ROOT/WEB-INF/lib/dh >>>> is-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Invocation of >>>> init method failed; nested exception is org.hibernate.tool.schema.extr >>>> act.spi.SchemaExtractionException: More than one table found in >>>> namespace (, ) : organisationunit >>>> at org.springframework.beans.factory.annotation.AutowiredAnnota >>>> tionBeanPostProcessor$AutowiredFieldElement.inject(Autowired >>>> AnnotationBeanPostProcessor.java:573) >>>> at org.springframework.beans.factory.annotation.InjectionMetada >>>> ta.inject(InjectionMetadata.java:88) >>>> at org.springframework.beans.factory.annotation.AutowiredAnnota >>>> tionBeanPostProcessor.postProcessPropertyValues(AutowiredAnn >>>> otationBeanPostProcessor.java:331) >>>> ... 26 more >>>> Caused by: org.springframework.beans.factory.BeanCreationException: >>>> Error creating bean with name 'org.hisp.dhis.appmanager.AppManager': >>>> Injection of autowired dependencies failed; nested exception is >>>> org.springframework.beans.factory.BeanCreationException: Could not >>>> autowire field: private org.hisp.dhis.setting.SystemSettingManager >>>> org.hisp.dhis.appmanager.DefaultAppManager.appSettingManager; nested >>>> exception is org.springframework.beans.factory.BeanCreationException: >>>> Error creating bean with name 'org.hisp.dhis.setting.SystemSettingManager': >>>> Injection of autowired dependencies failed; nested exception is >>>> org.springframework.beans.factory.BeanCreationException: Could not >>>> autowire field: private >>>> org.springframework.transaction.support.TransactionTemplate >>>> org.hisp.dhis.setting.DefaultSystemSettingManager.transactionTemplate; >>>> nested exception is >>>> org.springframework.beans.factory.BeanCreationException: >>>> Error creating bean with name 'transactionTemplate' defined in URL >>>> [jar:file:/home/dhis/tomcat-dhis/webapps/ROOT/WEB-INF/lib/dh >>>> is-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Cannot >>>> resolve reference to bean 'transactionManager' while setting bean property >>>> 'transactionManager'; nested exception is >>>> org.springframework.beans.factory.BeanCreationException: >>>> Error creating bean with name 'transactionManager' defined in URL >>>> [jar:file:/home/dhis/tomcat-dhis/webapps/ROOT/WEB-INF/lib/dh >>>> is-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Cannot >>>> resolve reference to bean 'sessionFactory' while setting bean property >>>> 'sessionFactory'; nested exception is >>>> org.springframework.beans.factory.BeanCreationException: >>>> Error creating bean with name 'sessionFactory' defined in URL >>>> [jar:file:/home/dhis/tomcat-dhis/webapps/ROOT/WEB-INF/lib/dh >>>> is-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Invocation of >>>> init method failed; nested exception is org.hibernate.tool.schema.extr >>>> act.spi.SchemaExtractionException: More than one table found in >>>> namespace (, ) : organisationunit >>>> at org.springframework.beans.factory.annotation.AutowiredAnnota >>>> tionBeanPostProcessor.postProcessPropertyValues(AutowiredAnn >>>> otationBeanPostProcessor.java:334) >>>> at org.springframework.beans.factory.support.AbstractAutowireCa >>>> pableBeanFactory.populateBean(AbstractAutowireCapableBeanFac >>>> tory.java:1214) >>>> at org.springframework.beans.factory.support.AbstractAutowireCa >>>> pableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFac >>>> tory.java:543) >>>> at org.springframework.beans.factory.support.AbstractAutowireCa >>>> pableBeanFactory.createBean(AbstractAutowireCapableBeanFacto >>>> ry.java:482) >>>> at org.springframework.beans.factory.support.AbstractBeanFactor >>>> y$1.getObject(AbstractBeanFactory.java:306) >>>> at org.springframework.beans.factory.support.DefaultSingletonBe >>>> anRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) >>>> at org.springframework.beans.factory.support.AbstractBeanFactor >>>> y.doGetBean(AbstractBeanFactory.java:302) >>>> at org.springframework.beans.factory.support.AbstractBeanFactor >>>> y.getBean(AbstractBeanFactory.java:197) >>>> at org.springframework.beans.factory.support.DefaultListableBea >>>> nFactory.findAutowireCandidates(DefaultListableBeanFactory.java:1192) >>>> at org.springframework.beans.factory.support.DefaultListableBea >>>> nFactory.doResolveDependency(DefaultListableBeanFactory.java:1116) >>>> at org.springframework.beans.factory.support.DefaultListableBea >>>> nFactory.resolveDependency(DefaultListableBeanFactory.java:1014) >>>> at org.springframework.beans.factory.annotation.AutowiredAnnota >>>> tionBeanPostProcessor$AutowiredFieldElement.inject(Autowired >>>> AnnotationBeanPostProcessor.java:545) >>>> ... 28 more >>>> Caused by: org.springframework.beans.factory.BeanCreationException: >>>> Could not autowire field: private >>>> org.hisp.dhis.setting.SystemSettingManager >>>> org.hisp.dhis.appmanager.DefaultAppManager.appSettingManager; nested >>>> exception is org.springframework.beans.factory.BeanCreationException: >>>> Error creating bean with name 'org.hisp.dhis.setting.SystemSettingManager': >>>> Injection of autowired dependencies failed; nested exception is >>>> org.springframework.beans.factory.BeanCreationException: Could not >>>> autowire field: private >>>> org.springframework.transaction.support.TransactionTemplate >>>> org.hisp.dhis.setting.DefaultSystemSettingManager.transactionTemplate; >>>> nested exception is >>>> org.springframework.beans.factory.BeanCreationException: >>>> Error creating bean with name 'transactionTemplate' defined in URL >>>> [jar:file:/home/dhis/tomcat-dhis/webapps/ROOT/WEB-INF/lib/dh >>>> is-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Cannot >>>> resolve reference to bean 'transactionManager' while setting bean property >>>> 'transactionManager'; nested exception is >>>> org.springframework.beans.factory.BeanCreationException: >>>> Error creating bean with name 'transactionManager' defined in URL >>>> [jar:file:/home/dhis/tomcat-dhis/webapps/ROOT/WEB-INF/lib/dh >>>> is-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Cannot >>>> resolve reference to bean 'sessionFactory' while setting bean property >>>> 'sessionFactory'; nested exception is >>>> org.springframework.beans.factory.BeanCreationException: >>>> Error creating bean with name 'sessionFactory' defined in URL >>>> [jar:file:/home/dhis/tomcat-dhis/webapps/ROOT/WEB-INF/lib/dh >>>> is-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Invocation of >>>> init method failed; nested exception is org.hibernate.tool.schema.extr >>>> act.spi.SchemaExtractionException: More than one table found in >>>> namespace (, ) : organisationunit >>>> at org.springframework.beans.factory.annotation.AutowiredAnnota >>>> tionBeanPostProcessor$AutowiredFieldElement.inject(Autowired >>>> AnnotationBeanPostProcessor.java:573) >>>> at org.springframework.beans.factory.annotation.InjectionMetada >>>> ta.inject(InjectionMetadata.java:88) >>>> at org.springframework.beans.factory.annotation.AutowiredAnnota >>>> tionBeanPostProcessor.postProcessPropertyValues(AutowiredAnn >>>> otationBeanPostProcessor.java:331) >>>> ... 39 more >>>> Caused by: org.springframework.beans.factory.BeanCreationException: >>>> Error creating bean with name 'org.hisp.dhis.setting.SystemSettingManager': >>>> Injection of autowired dependencies failed; nested exception is >>>> org.springframework.beans.factory.BeanCreationException: Could not >>>> autowire field: private >>>> org.springframework.transaction.support.TransactionTemplate >>>> org.hisp.dhis.setting.DefaultSystemSettingManager.transactionTemplate; >>>> nested exception is >>>> org.springframework.beans.factory.BeanCreationException: >>>> Error creating bean with name 'transactionTemplate' defined in URL >>>> [jar:file:/home/dhis/tomcat-dhis/webapps/ROOT/WEB-INF/lib/dh >>>> is-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Cannot >>>> resolve reference to bean 'transactionManager' while setting bean property >>>> 'transactionManager'; nested exception is >>>> org.springframework.beans.factory.BeanCreationException: >>>> Error creating bean with name 'transactionManager' defined in URL >>>> [jar:file:/home/dhis/tomcat-dhis/webapps/ROOT/WEB-INF/lib/dh >>>> is-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Cannot >>>> resolve reference to bean 'sessionFactory' while setting bean property >>>> 'sessionFactory'; nested exception is >>>> org.springframework.beans.factory.BeanCreationException: >>>> Error creating bean with name 'sessionFactory' defined in URL >>>> [jar:file:/home/dhis/tomcat-dhis/webapps/ROOT/WEB-INF/lib/dh >>>> is-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Invocation of >>>> init method failed; nested exception is org.hibernate.tool.schema.extr >>>> act.spi.SchemaExtractionException: More than one table found in >>>> namespace (, ) : organisationunit >>>> at org.springframework.beans.factory.annotation.AutowiredAnnota >>>> tionBeanPostProcessor.postProcessPropertyValues(AutowiredAnn >>>> otationBeanPostProcessor.java:334) >>>> at org.springframework.beans.factory.support.AbstractAutowireCa >>>> pableBeanFactory.populateBean(AbstractAutowireCapableBeanFac >>>> tory.java:1214) >>>> at org.springframework.beans.factory.support.AbstractAutowireCa >>>> pableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFac >>>> tory.java:543) >>>> at org.springframework.beans.factory.support.AbstractAutowireCa >>>> pableBeanFactory.createBean(AbstractAutowireCapableBeanFacto >>>> ry.java:482) >>>> at org.springframework.beans.factory.support.AbstractBeanFactor >>>> y$1.getObject(AbstractBeanFactory.java:306) >>>> at org.springframework.beans.factory.support.DefaultSingletonBe >>>> anRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) >>>> at org.springframework.beans.factory.support.AbstractBeanFactor >>>> y.doGetBean(AbstractBeanFactory.java:302) >>>> at org.springframework.beans.factory.support.AbstractBeanFactor >>>> y.getBean(AbstractBeanFactory.java:197) >>>> at org.springframework.beans.factory.support.DefaultListableBea >>>> nFactory.findAutowireCandidates(DefaultListableBeanFactory.java:1192) >>>> at org.springframework.beans.factory.support.DefaultListableBea >>>> nFactory.doResolveDependency(DefaultListableBeanFactory.java:1116) >>>> at org.springframework.beans.factory.support.DefaultListableBea >>>> nFactory.resolveDependency(DefaultListableBeanFactory.java:1014) >>>> at org.springframework.beans.factory.annotation.AutowiredAnnota >>>> tionBeanPostProcessor$AutowiredFieldElement.inject(Autowired >>>> AnnotationBeanPostProcessor.java:545) >>>> ... 41 more >>>> Caused by: org.springframework.beans.factory.BeanCreationException: >>>> Could not autowire field: private >>>> org.springframework.transaction.support.TransactionTemplate >>>> org.hisp.dhis.setting.DefaultSystemSettingManager.transactionTemplate; >>>> nested exception is >>>> org.springframework.beans.factory.BeanCreationException: >>>> Error creating bean with name 'transactionTemplate' defined in URL >>>> [jar:file:/home/dhis/tomcat-dhis/webapps/ROOT/WEB-INF/lib/dh >>>> is-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Cannot >>>> resolve reference to bean 'transactionManager' while setting bean property >>>> 'transactionManager'; nested exception is >>>> org.springframework.beans.factory.BeanCreationException: >>>> Error creating bean with name 'transactionManager' defined in URL >>>> [jar:file:/home/dhis/tomcat-dhis/webapps/ROOT/WEB-INF/lib/dh >>>> is-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Cannot >>>> resolve reference to bean 'sessionFactory' while setting bean property >>>> 'sessionFactory'; nested exception is >>>> org.springframework.beans.factory.BeanCreationException: >>>> Error creating bean with name 'sessionFactory' defined in URL >>>> [jar:file:/home/dhis/tomcat-dhis/webapps/ROOT/WEB-INF/lib/dh >>>> is-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Invocation of >>>> init method failed; nested exception is org.hibernate.tool.schema.extr >>>> act.spi.SchemaExtractionException: More than one table found in >>>> namespace (, ) : organisationunit >>>> at org.springframework.beans.factory.annotation.AutowiredAnnota >>>> tionBeanPostProcessor$AutowiredFieldElement.inject(Autowired >>>> AnnotationBeanPostProcessor.java:573) >>>> at org.springframework.beans.factory.annotation.InjectionMetada >>>> ta.inject(InjectionMetadata.java:88) >>>> at org.springframework.beans.factory.annotation.AutowiredAnnota >>>> tionBeanPostProcessor.postProcessPropertyValues(AutowiredAnn >>>> otationBeanPostProcessor.java:331) >>>> ... 52 more >>>> Caused by: org.springframework.beans.factory.BeanCreationException: >>>> Error creating bean with name 'transactionTemplate' defined in URL >>>> [jar:file:/home/dhis/tomcat-dhis/webapps/ROOT/WEB-INF/lib/dh >>>> is-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Cannot >>>> resolve reference to bean 'transactionManager' while setting bean property >>>> 'transactionManager'; nested exception is >>>> org.springframework.beans.factory.BeanCreationException: >>>> Error creating bean with name 'transactionManager' defined in URL >>>> [jar:file:/home/dhis/tomcat-dhis/webapps/ROOT/WEB-INF/lib/dh >>>> is-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Cannot >>>> resolve reference to bean 'sessionFactory' while setting bean property >>>> 'sessionFactory'; nested exception is >>>> org.springframework.beans.factory.BeanCreationException: >>>> Error creating bean with name 'sessionFactory' defined in URL >>>> [jar:file:/home/dhis/tomcat-dhis/webapps/ROOT/WEB-INF/lib/dh >>>> is-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Invocation of >>>> init method failed; nested exception is org.hibernate.tool.schema.extr >>>> act.spi.SchemaExtractionException: More than one table found in >>>> namespace (, ) : organisationunit >>>> at org.springframework.beans.factory.support.BeanDefinitionValu >>>> eResolver.resolveReference(BeanDefinitionValueResolver.java:359) >>>> at org.springframework.beans.factory.support.BeanDefinitionValu >>>> eResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108) >>>> at org.springframework.beans.factory.support.AbstractAutowireCa >>>> pableBeanFactory.applyPropertyValues(AbstractAutowireCapable >>>> BeanFactory.java:1481) >>>> at org.springframework.beans.factory.support.AbstractAutowireCa >>>> pableBeanFactory.populateBean(AbstractAutowireCapableBeanFac >>>> tory.java:1226) >>>> at org.springframework.beans.factory.support.AbstractAutowireCa >>>> pableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFac >>>> tory.java:543) >>>> at org.springframework.beans.factory.support.AbstractAutowireCa >>>> pableBeanFactory.createBean(AbstractAutowireCapableBeanFacto >>>> ry.java:482) >>>> at org.springframework.beans.factory.support.AbstractBeanFactor >>>> y$1.getObject(AbstractBeanFactory.java:306) >>>> at org.springframework.beans.factory.support.DefaultSingletonBe >>>> anRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) >>>> at org.springframework.beans.factory.support.AbstractBeanFactor >>>> y.doGetBean(AbstractBeanFactory.java:302) >>>> at org.springframework.beans.factory.support.AbstractBeanFactor >>>> y.getBean(AbstractBeanFactory.java:197) >>>> at org.springframework.beans.factory.support.DefaultListableBea >>>> nFactory.findAutowireCandidates(DefaultListableBeanFactory.java:1192) >>>> at org.springframework.beans.factory.support.DefaultListableBea >>>> nFactory.doResolveDependency(DefaultListableBeanFactory.java:1116) >>>> at org.springframework.beans.factory.support.DefaultListableBea >>>> nFactory.resolveDependency(DefaultListableBeanFactory.java:1014) >>>> at org.springframework.beans.factory.annotation.AutowiredAnnota >>>> tionBeanPostProcessor$AutowiredFieldElement.inject(Autowired >>>> AnnotationBeanPostProcessor.java:545) >>>> ... 54 more >>>> Caused by: org.springframework.beans.factory.BeanCreationException: >>>> Error creating bean with name 'transactionManager' defined in URL >>>> [jar:file:/home/dhis/tomcat-dhis/webapps/ROOT/WEB-INF/lib/dh >>>> is-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Cannot >>>> resolve reference to bean 'sessionFactory' while setting bean property >>>> 'sessionFactory'; nested exception is >>>> org.springframework.beans.factory.BeanCreationException: >>>> Error creating bean with name 'sessionFactory' defined in URL >>>> [jar:file:/home/dhis/tomcat-dhis/webapps/ROOT/WEB-INF/lib/dh >>>> is-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Invocation of >>>> init method failed; nested exception is org.hibernate.tool.schema.extr >>>> act.spi.SchemaExtractionException: More than one table found in >>>> namespace (, ) : organisationunit >>>> at org.springframework.beans.factory.support.BeanDefinitionValu >>>> eResolver.resolveReference(BeanDefinitionValueResolver.java:359) >>>> at org.springframework.beans.factory.support.BeanDefinitionValu >>>> eResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108) >>>> at org.springframework.beans.factory.support.AbstractAutowireCa >>>> pableBeanFactory.applyPropertyValues(AbstractAutowireCapable >>>> BeanFactory.java:1481) >>>> at org.springframework.beans.factory.support.AbstractAutowireCa >>>> pableBeanFactory.populateBean(AbstractAutowireCapableBeanFac >>>> tory.java:1226) >>>> at org.springframework.beans.factory.support.AbstractAutowireCa >>>> pableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFac >>>> tory.java:543) >>>> at org.springframework.beans.factory.support.AbstractAutowireCa >>>> pableBeanFactory.createBean(AbstractAutowireCapableBeanFacto >>>> ry.java:482) >>>> at org.springframework.beans.factory.support.AbstractBeanFactor >>>> y$1.getObject(AbstractBeanFactory.java:306) >>>> at org.springframework.beans.factory.support.DefaultSingletonBe >>>> anRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) >>>> at org.springframework.beans.factory.support.AbstractBeanFactor >>>> y.doGetBean(AbstractBeanFactory.java:302) >>>> at org.springframework.beans.factory.support.AbstractBeanFactor >>>> y.getBean(AbstractBeanFactory.java:197) >>>> at org.springframework.beans.factory.support.BeanDefinitionValu >>>> eResolver.resolveReference(BeanDefinitionValueResolver.java:351) >>>> ... 67 more >>>> Caused by: org.springframework.beans.factory.BeanCreationException: >>>> Error creating bean with name 'sessionFactory' defined in URL >>>> [jar:file:/home/dhis/tomcat-dhis/webapps/ROOT/WEB-INF/lib/dh >>>> is-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Invocation of >>>> init method failed; nested exception is org.hibernate.tool.schema.extr >>>> act.spi.SchemaExtractionException: More than one table found in >>>> namespace (, ) : organisationunit >>>> at org.springframework.beans.factory.support.AbstractAutowireCa >>>> pableBeanFactory.initializeBean(AbstractAutowireCapableBeanF >>>> actory.java:1578) >>>> at org.springframework.beans.factory.support.AbstractAutowireCa >>>> pableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFac >>>> tory.java:545) >>>> at org.springframework.beans.factory.support.AbstractAutowireCa >>>> pableBeanFactory.createBean(AbstractAutowireCapableBeanFacto >>>> ry.java:482) >>>> at org.springframework.beans.factory.support.AbstractBeanFactor >>>> y$1.getObject(AbstractBeanFactory.java:306) >>>> at org.springframework.beans.factory.support.DefaultSingletonBe >>>> anRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) >>>> at org.springframework.beans.factory.support.AbstractBeanFactor >>>> y.doGetBean(AbstractBeanFactory.java:302) >>>> at org.springframework.beans.factory.support.AbstractBeanFactor >>>> y.getBean(AbstractBeanFactory.java:197) >>>> at org.springframework.beans.factory.support.BeanDefinitionValu >>>> eResolver.resolveReference(BeanDefinitionValueResolver.java:351) >>>> ... 77 more >>>> Caused by: org.hibernate.tool.schema.extract.spi.SchemaExtractionException: >>>> More than one table found in namespace (, ) : organisationunit >>>> at org.hibernate.tool.schema.extract.internal.InformationExtrac >>>> torJdbcDatabaseMetaDataImpl.processGetTableResults(Informati >>>> onExtractorJdbcDatabaseMetaDataImpl.java:381) >>>> at org.hibernate.tool.schema.extract.internal.InformationExtrac >>>> torJdbcDatabaseMetaDataImpl.locateTableInNamespace(Informati >>>> onExtractorJdbcDatabaseMetaDataImpl.java:346) >>>> at org.hibernate.tool.schema.extract.internal.InformationExtrac >>>> torJdbcDatabaseMetaDataImpl.getTable(InformationExtractorJdb >>>> cDatabaseMetaDataImpl.java:241) >>>> at org.hibernate.tool.schema.internal.exec.ImprovedDatabaseInfo >>>> rmationImpl.getTableInformation(ImprovedDatabaseInformationI >>>> mpl.java:109) >>>> at org.hibernate.tool.schema.internal.SchemaMigratorImpl.perfor >>>> mMigration(SchemaMigratorImpl.java:252) >>>> at org.hibernate.tool.schema.internal.SchemaMigratorImpl.doMigr >>>> ation(SchemaMigratorImpl.java:137) >>>> at org.hibernate.tool.schema.internal.SchemaMigratorImpl.doMigr >>>> ation(SchemaMigratorImpl.java:110) >>>> at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinato >>>> r.performDatabaseAction(SchemaManagementToolCoordinator.java:176) >>>> at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinato >>>> r.process(SchemaManagementToolCoordinator.java:64) >>>> at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFact >>>> oryImpl.java:458) >>>> at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build( >>>> SessionFactoryBuilderImpl.java:465) >>>> at org.hibernate.cfg.Configuration.buildSessionFactory(Configur >>>> ation.java:708) >>>> at org.hibernate.cfg.Configuration.buildSessionFactory(Configur >>>> ation.java:724) >>>> at org.springframework.orm.hibernate5.LocalSessionFactoryBean.b >>>> uildSessionFactory(LocalSessionFactoryBean.java:416) >>>> at org.springframework.orm.hibernate5.LocalSessionFactoryBean.a >>>> fterPropertiesSet(LocalSessionFactoryBean.java:401) >>>> at org.springframework.beans.factory.support.AbstractAutowireCa >>>> pableBeanFactory.invokeInitMethods(AbstractAutowireCapableBe >>>> anFactory.java:1637) >>>> at org.springframework.beans.factory.support.AbstractAutowireCa >>>> pableBeanFactory.initializeBean(AbstractAutowireCapableBeanF >>>> actory.java:1574) >>>> ... 84 more >>>> Oct 13, 2016 8:34:33 AM org.apache.catalina.core.StandardContext >>>> startInternal >>>> SEVERE: One or more listeners failed to start. Full details will be >>>> found in the appropriate container log file >>>> Oct 13, 2016 8:34:33 AM org.apache.catalina.core.StandardContext >>>> startInternal >>>> SEVERE: Context [] startup failed due to previous errors >>>> * INFO 2016-10-13 08:34:33,076 De-registering jdbc driver: >>>> org.postgresql.Driver@25acca30 (StartupListener.java >>>> [localhost-startStop-1]) >>>> Oct 13, 2016 8:34:33 AM org.apache.catalina.loader.WebappClassLoaderBase >>>> clearReferencesThreads >>>> SEVERE: The web application [] appears to have started a thread named >>>> [__DEFAULT__] but has failed to stop it. This is very likely to create a >>>> memory leak. >>>> Oct 13, 2016 8:34:33 AM org.apache.catalina.loader.WebappClassLoaderBase >>>> clearReferencesThreads >>>> SEVERE: The web application [] appears to have started a thread named >>>> [Statistics Thread-__DEFAULT__-1] but has failed to stop it. This is very >>>> likely to create a memory leak. >>>> Oct 13, 2016 8:34:33 AM org.apache.catalina.loader.WebappClassLoaderBase >>>> checkThreadLocalMapForLeaks >>>> SEVERE: The web application [] created a ThreadLocal with key of type >>>> [java.lang.ThreadLocal] (value [java.lang.ThreadLocal@4d8fd5cd]) and a >>>> value of type [org.hibernate.boot.internal.MetadataImpl] (value >>>> [org.hibernate.boot.internal.MetadataImpl@30dad794]) 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. >>>> Oct 13, 2016 8:34:33 AM org.apache.catalina.startup.HostConfig >>>> deployWAR >>>> INFO: Deployment of web application archive >>>> /home/dhis/tomcat-dhis/webapps/ROOT.war has finished in 26,416 ms >>>> Oct 13, 2016 8:34:33 AM org.apache.coyote.AbstractProtocol start >>>> INFO: Starting ProtocolHandler ["http-bio-127.0.0.1-8090"] >>>> Oct 13, 2016 8:34:33 AM org.apache.catalina.startup.Catalina start >>>> INFO: Server startup in 26505 ms >>>> >>>> >>>> -- >>>> Jason P. Pickering >>>> email: [email protected] >>>> tel:+46764147049 >>>> >>>> _______________________________________________ >>>> Mailing list: https://launchpad.net/~dhis2-devs >>>> Post to : [email protected] >>>> 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 >>> [email protected] >>> http://www.dhis2.org <https://www.dhis2.org/> >>> >>> >> >> >> -- >> Jason P. Pickering >> email: [email protected] >> tel:+46764147049 >> > > > > -- > Jason P. Pickering > email: [email protected] > tel:+46764147049 > -- Jason P. Pickering email: [email protected] tel:+46764147049
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
