← Back to team overview

dhis2-devs team mailing list archive

Re: Error when upgrading to 2.24

 

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 <
jason.p.pickering@xxxxxxxxx> 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 <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(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(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(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(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(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(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(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(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(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(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(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: 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
>



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

Follow ups

References