dhis2-devs team mailing list archive

Thread
Date
Re: Error when upgrading to 2.24

To: Jason Pickering <jason.p.pickering@xxxxxxxxx>
From: Lars Helge Øverland <lars@xxxxxxxxx>
Date: Thu, 13 Oct 2016 09:33:04 +0200
Cc: dhis2-devs <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
In-reply-to: <CADsNmhvCL4yCsvrg9LNtcpfi3xubb_7_E_v53UnZ4exOfv6xag@mail.gmail.com>
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/
> dhis-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/
> dhis-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/
> dhis-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Invocation of
> init method failed; nested exception is org.hibernate.tool.schema.
> extract.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/
> dhis-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/
> dhis-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/
> dhis-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Invocation of
> init method failed; nested exception is org.hibernate.tool.schema.
> extract.spi.SchemaExtractionException: More than one table found in
> namespace (, ) : organisationunit
> at org.springframework.beans.factory.annotation.
> AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(
> AutowiredAnnotationBeanPostProcessor.java:334)
> at org.springframework.beans.factory.support.
> AbstractAutowireCapableBeanFactory.populateBean(
> AbstractAutowireCapableBeanFactory.java:1214)
> at org.springframework.beans.factory.support.
> AbstractAutowireCapableBeanFactory.doCreateBean(
> AbstractAutowireCapableBeanFactory.java:543)
> at org.springframework.beans.factory.support.
> AbstractAutowireCapableBeanFactory.createBean(
> AbstractAutowireCapableBeanFactory.java:482)
> at org.springframework.beans.factory.support.AbstractBeanFactory$1.
> getObject(AbstractBeanFactory.java:306)
> at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.
> getSingleton(DefaultSingletonBeanRegistry.java:230)
> at org.springframework.beans.factory.support.
> AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
> at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(
> AbstractBeanFactory.java:197)
> at org.springframework.beans.factory.support.DefaultListableBeanFactory.
> preInstantiateSingletons(DefaultListableBeanFactory.java:772)
> at org.springframework.context.support.AbstractApplicationContext.
> finishBeanFactoryInitialization(AbstractApplicationContext.java:839)
> at org.springframework.context.support.AbstractApplicationContext.refresh(
> AbstractApplicationContext.java:538)
> at org.springframework.web.context.ContextLoader.
> configureAndRefreshWebApplicationContext(ContextLoader.java:444)
> at org.springframework.web.context.ContextLoader.
> initWebApplicationContext(ContextLoader.java:326)
> at org.springframework.web.context.ContextLoaderListener.
> contextInitialized(ContextLoaderListener.java:107)
> at org.apache.catalina.core.StandardContext.listenerStart(
> StandardContext.java:5068)
> at org.apache.catalina.core.StandardContext.startInternal(
> StandardContext.java:5584)
> at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:147)
> at org.apache.catalina.core.ContainerBase.addChildInternal(
> ContainerBase.java:899)
> at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.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(
> HostConfig.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(
> ThreadPoolExecutor.java:1142)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(
> ThreadPoolExecutor.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/
> dhis-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/
> dhis-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/
> dhis-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Invocation of
> init method failed; nested exception is org.hibernate.tool.schema.
> extract.spi.SchemaExtractionException: More than one table found in
> namespace (, ) : organisationunit
> at org.springframework.beans.factory.annotation.
> AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(
> AutowiredAnnotationBeanPostProcessor.java:573)
> at org.springframework.beans.factory.annotation.InjectionMetadata.inject(
> InjectionMetadata.java:88)
> at org.springframework.beans.factory.annotation.
> AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(
> AutowiredAnnotationBeanPostProcessor.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/
> dhis-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/
> dhis-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/
> dhis-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Invocation of
> init method failed; nested exception is org.hibernate.tool.schema.
> extract.spi.SchemaExtractionException: More than one table found in
> namespace (, ) : organisationunit
> at org.springframework.beans.factory.annotation.
> AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(
> AutowiredAnnotationBeanPostProcessor.java:334)
> at org.springframework.beans.factory.support.
> AbstractAutowireCapableBeanFactory.populateBean(
> AbstractAutowireCapableBeanFactory.java:1214)
> at org.springframework.beans.factory.support.
> AbstractAutowireCapableBeanFactory.doCreateBean(
> AbstractAutowireCapableBeanFactory.java:543)
> at org.springframework.beans.factory.support.
> AbstractAutowireCapableBeanFactory.createBean(
> AbstractAutowireCapableBeanFactory.java:482)
> at org.springframework.beans.factory.support.AbstractBeanFactory$1.
> getObject(AbstractBeanFactory.java:306)
> at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.
> getSingleton(DefaultSingletonBeanRegistry.java:230)
> at org.springframework.beans.factory.support.
> AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
> at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(
> AbstractBeanFactory.java:197)
> at org.springframework.beans.factory.support.DefaultListableBeanFactory.
> findAutowireCandidates(DefaultListableBeanFactory.java:1192)
> at org.springframework.beans.factory.support.DefaultListableBeanFactory.
> doResolveDependency(DefaultListableBeanFactory.java:1116)
> at org.springframework.beans.factory.support.DefaultListableBeanFactory.
> resolveDependency(DefaultListableBeanFactory.java:1014)
> at org.springframework.beans.factory.annotation.
> AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(
> AutowiredAnnotationBeanPostProcessor.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/
> dhis-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/
> dhis-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/
> dhis-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Invocation of
> init method failed; nested exception is org.hibernate.tool.schema.
> extract.spi.SchemaExtractionException: More than one table found in
> namespace (, ) : organisationunit
> at org.springframework.beans.factory.annotation.
> AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(
> AutowiredAnnotationBeanPostProcessor.java:573)
> at org.springframework.beans.factory.annotation.InjectionMetadata.inject(
> InjectionMetadata.java:88)
> at org.springframework.beans.factory.annotation.
> AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(
> AutowiredAnnotationBeanPostProcessor.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/
> dhis-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/
> dhis-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/
> dhis-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Invocation of
> init method failed; nested exception is org.hibernate.tool.schema.
> extract.spi.SchemaExtractionException: More than one table found in
> namespace (, ) : organisationunit
> at org.springframework.beans.factory.annotation.
> AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(
> AutowiredAnnotationBeanPostProcessor.java:334)
> at org.springframework.beans.factory.support.
> AbstractAutowireCapableBeanFactory.populateBean(
> AbstractAutowireCapableBeanFactory.java:1214)
> at org.springframework.beans.factory.support.
> AbstractAutowireCapableBeanFactory.doCreateBean(
> AbstractAutowireCapableBeanFactory.java:543)
> at org.springframework.beans.factory.support.
> AbstractAutowireCapableBeanFactory.createBean(
> AbstractAutowireCapableBeanFactory.java:482)
> at org.springframework.beans.factory.support.AbstractBeanFactory$1.
> getObject(AbstractBeanFactory.java:306)
> at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.
> getSingleton(DefaultSingletonBeanRegistry.java:230)
> at org.springframework.beans.factory.support.
> AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
> at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(
> AbstractBeanFactory.java:197)
> at org.springframework.beans.factory.support.DefaultListableBeanFactory.
> findAutowireCandidates(DefaultListableBeanFactory.java:1192)
> at org.springframework.beans.factory.support.DefaultListableBeanFactory.
> doResolveDependency(DefaultListableBeanFactory.java:1116)
> at org.springframework.beans.factory.support.DefaultListableBeanFactory.
> resolveDependency(DefaultListableBeanFactory.java:1014)
> at org.springframework.beans.factory.annotation.
> AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(
> AutowiredAnnotationBeanPostProcessor.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/
> dhis-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/
> dhis-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/
> dhis-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Invocation of
> init method failed; nested exception is org.hibernate.tool.schema.
> extract.spi.SchemaExtractionException: More than one table found in
> namespace (, ) : organisationunit
> at org.springframework.beans.factory.annotation.
> AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(
> AutowiredAnnotationBeanPostProcessor.java:573)
> at org.springframework.beans.factory.annotation.InjectionMetadata.inject(
> InjectionMetadata.java:88)
> at org.springframework.beans.factory.annotation.
> AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(
> AutowiredAnnotationBeanPostProcessor.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/
> dhis-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/
> dhis-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/
> dhis-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Invocation of
> init method failed; nested exception is org.hibernate.tool.schema.
> extract.spi.SchemaExtractionException: More than one table found in
> namespace (, ) : organisationunit
> at org.springframework.beans.factory.support.BeanDefinitionValueResolver.
> resolveReference(BeanDefinitionValueResolver.java:359)
> at org.springframework.beans.factory.support.BeanDefinitionValueResolver.
> resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
> at org.springframework.beans.factory.support.
> AbstractAutowireCapableBeanFactory.applyPropertyValues(
> AbstractAutowireCapableBeanFactory.java:1481)
> at org.springframework.beans.factory.support.
> AbstractAutowireCapableBeanFactory.populateBean(
> AbstractAutowireCapableBeanFactory.java:1226)
> at org.springframework.beans.factory.support.
> AbstractAutowireCapableBeanFactory.doCreateBean(
> AbstractAutowireCapableBeanFactory.java:543)
> at org.springframework.beans.factory.support.
> AbstractAutowireCapableBeanFactory.createBean(
> AbstractAutowireCapableBeanFactory.java:482)
> at org.springframework.beans.factory.support.AbstractBeanFactory$1.
> getObject(AbstractBeanFactory.java:306)
> at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.
> getSingleton(DefaultSingletonBeanRegistry.java:230)
> at org.springframework.beans.factory.support.
> AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
> at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(
> AbstractBeanFactory.java:197)
> at org.springframework.beans.factory.support.DefaultListableBeanFactory.
> findAutowireCandidates(DefaultListableBeanFactory.java:1192)
> at org.springframework.beans.factory.support.DefaultListableBeanFactory.
> doResolveDependency(DefaultListableBeanFactory.java:1116)
> at org.springframework.beans.factory.support.DefaultListableBeanFactory.
> resolveDependency(DefaultListableBeanFactory.java:1014)
> at org.springframework.beans.factory.annotation.
> AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(
> AutowiredAnnotationBeanPostProcessor.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/
> dhis-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/
> dhis-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Invocation of
> init method failed; nested exception is org.hibernate.tool.schema.
> extract.spi.SchemaExtractionException: More than one table found in
> namespace (, ) : organisationunit
> at org.springframework.beans.factory.support.BeanDefinitionValueResolver.
> resolveReference(BeanDefinitionValueResolver.java:359)
> at org.springframework.beans.factory.support.BeanDefinitionValueResolver.
> resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
> at org.springframework.beans.factory.support.
> AbstractAutowireCapableBeanFactory.applyPropertyValues(
> AbstractAutowireCapableBeanFactory.java:1481)
> at org.springframework.beans.factory.support.
> AbstractAutowireCapableBeanFactory.populateBean(
> AbstractAutowireCapableBeanFactory.java:1226)
> at org.springframework.beans.factory.support.
> AbstractAutowireCapableBeanFactory.doCreateBean(
> AbstractAutowireCapableBeanFactory.java:543)
> at org.springframework.beans.factory.support.
> AbstractAutowireCapableBeanFactory.createBean(
> AbstractAutowireCapableBeanFactory.java:482)
> at org.springframework.beans.factory.support.AbstractBeanFactory$1.
> getObject(AbstractBeanFactory.java:306)
> at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.
> getSingleton(DefaultSingletonBeanRegistry.java:230)
> at org.springframework.beans.factory.support.
> AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
> at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(
> AbstractBeanFactory.java:197)
> at org.springframework.beans.factory.support.BeanDefinitionValueResolver.
> 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/
> dhis-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Invocation of
> init method failed; nested exception is org.hibernate.tool.schema.
> extract.spi.SchemaExtractionException: More than one table found in
> namespace (, ) : organisationunit
> at org.springframework.beans.factory.support.
> AbstractAutowireCapableBeanFactory.initializeBean(
> AbstractAutowireCapableBeanFactory.java:1578)
> at org.springframework.beans.factory.support.
> AbstractAutowireCapableBeanFactory.doCreateBean(
> AbstractAutowireCapableBeanFactory.java:545)
> at org.springframework.beans.factory.support.
> AbstractAutowireCapableBeanFactory.createBean(
> AbstractAutowireCapableBeanFactory.java:482)
> at org.springframework.beans.factory.support.AbstractBeanFactory$1.
> getObject(AbstractBeanFactory.java:306)
> at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.
> getSingleton(DefaultSingletonBeanRegistry.java:230)
> at org.springframework.beans.factory.support.
> AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
> at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(
> AbstractBeanFactory.java:197)
> at org.springframework.beans.factory.support.BeanDefinitionValueResolver.
> 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.
> InformationExtractorJdbcDatabaseMetaDataImpl.processGetTableResults(
> InformationExtractorJdbcDatabaseMetaDataImpl.java:381)
> at org.hibernate.tool.schema.extract.internal.
> InformationExtractorJdbcDatabaseMetaDataImpl.locateTableInNamespace(
> InformationExtractorJdbcDatabaseMetaDataImpl.java:346)
> at org.hibernate.tool.schema.extract.internal.
> InformationExtractorJdbcDatabaseMetaDataImpl.getTable(
> InformationExtractorJdbcDatabaseMetaDataImpl.java:241)
> at org.hibernate.tool.schema.internal.exec.ImprovedDatabaseInformationImp
> l.getTableInformation(ImprovedDatabaseInformationImpl.java:109)
> at org.hibernate.tool.schema.internal.SchemaMigratorImpl.performMigration(
> SchemaMigratorImpl.java:252)
> at org.hibernate.tool.schema.internal.SchemaMigratorImpl.doMigration(
> SchemaMigratorImpl.java:137)
> at org.hibernate.tool.schema.internal.SchemaMigratorImpl.doMigration(
> SchemaMigratorImpl.java:110)
> at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinato
> r.performDatabaseAction(SchemaManagementToolCoordinator.java:176)
> at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(
> SchemaManagementToolCoordinator.java:64)
> at org.hibernate.internal.SessionFactoryImpl.<init>(
> SessionFactoryImpl.java:458)
> at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(
> SessionFactoryBuilderImpl.java:465)
> at org.hibernate.cfg.Configuration.buildSessionFactory(
> Configuration.java:708)
> at org.hibernate.cfg.Configuration.buildSessionFactory(
> Configuration.java:724)
> at org.springframework.orm.hibernate5.LocalSessionFactoryBean.
> buildSessionFactory(LocalSessionFactoryBean.java:416)
> at org.springframework.orm.hibernate5.LocalSessionFactoryBean.
> afterPropertiesSet(LocalSessionFactoryBean.java:401)
> at org.springframework.beans.factory.support.
> AbstractAutowireCapableBeanFactory.invokeInitMethods(
> AbstractAutowireCapableBeanFactory.java:1637)
> at org.springframework.beans.factory.support.
> AbstractAutowireCapableBeanFactory.initializeBean(
> AbstractAutowireCapableBeanFactory.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/>
Follow ups

Re: Error when upgrading to 2.24
From: Jason Pickering, 2016-10-13
References

Error when upgrading to 2.24
From: Jason Pickering, 2016-10-13