← Back to team overview

dhis2-devs team mailing list archive

Re: Error when upgrading to 2.24

 

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 <lars@xxxxxxxxx> 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 <
> jason.p.pickering@xxxxxxxxx> 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(AbstractAutowireCapableBeanFactory.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(
>> Executors.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(A
>> utowiredAnnotationBeanPostProcessor.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(AbstractAutowireCapableBeanFactory.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(A
>> utowiredAnnotationBeanPostProcessor.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(A
>> utowiredAnnotationBeanPostProcessor.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(AbstractAutowireCapableBeanFactory.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(A
>> utowiredAnnotationBeanPostProcessor.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(A
>> utowiredAnnotationBeanPostProcessor.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(AbstractAu
>> towireCapableBeanFactory.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(AbstractAutowireCapableBeanFactory.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(A
>> utowiredAnnotationBeanPostProcessor.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(AbstractAu
>> towireCapableBeanFactory.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(AbstractAutowireCapableBeanFactory.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(AbstractAutowir
>> eCapableBeanFactory.java:1578)
>> at org.springframework.beans.factory.support.AbstractAutowireCa
>> pableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFac
>> tory.java:545)
>> at org.springframework.beans.factory.support.AbstractAutowireCa
>> pableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.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(InformationExtractorJ
>> dbcDatabaseMetaDataImpl.java:241)
>> at org.hibernate.tool.schema.internal.exec.ImprovedDatabaseInfo
>> rmationImpl.getTableInformation(ImprovedDatabaseInformationImpl.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(AbstractAuto
>> wireCapableBeanFactory.java:1637)
>> at org.springframework.beans.factory.support.AbstractAutowireCa
>> pableBeanFactory.initializeBean(AbstractAutowir
>> eCapableBeanFactory.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: jason.p.pickering@xxxxxxxxx
>> tel:+46764147049
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> 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
> lars@xxxxxxxxx
> http://www.dhis2.org <https://www.dhis2.org/>
>
>


-- 
Jason P. Pickering
email: jason.p.pickering@xxxxxxxxx
tel:+46764147049

Follow ups

References