← Back to team overview

dhis2-devs team mailing list archive

Re: Error when upgrading to 2.24

 

Hi Lars,
I managed to find the problem after looking for additional schemas, per
your suggestion.

dhis2=# \dn
  List of schemas
  Name   |  Owner
---------+----------
 private | postgres
 public  | postgres
(2 rows)

showed two schemas, and inside of the "private" schema, was a table called
"organisationunit", which apparently was causing the error.

I deleted that table in the private schema,and things seem to work.

Best regards,
Jason


On Thu, Oct 13, 2016 at 10:46 AM, Jason Pickering <
jason.p.pickering@xxxxxxxxx> wrote:

> sorry for the typo. I mean, "shows only these two tables which appear to
> potentially match that pattern."
>
> On Thu, Oct 13, 2016 at 10:45 AM, Jason Pickering <
> 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(AbstractAutowireCapableBeanFacto
>>>> ry.java:482)
>>>> at org.springframework.beans.factory.support.AbstractBeanFactor
>>>> y$1.getObject(AbstractBeanFactory.java:306)
>>>> at org.springframework.beans.factory.support.DefaultSingletonBe
>>>> anRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
>>>> at org.springframework.beans.factory.support.AbstractBeanFactor
>>>> y.doGetBean(AbstractBeanFactory.java:302)
>>>> at org.springframework.beans.factory.support.AbstractBeanFactor
>>>> y.getBean(AbstractBeanFactory.java:197)
>>>> at org.springframework.beans.factory.support.DefaultListableBea
>>>> nFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:772)
>>>> at org.springframework.context.support.AbstractApplicationConte
>>>> xt.finishBeanFactoryInitialization(AbstractApplicationContext.java:839)
>>>> at org.springframework.context.support.AbstractApplicationConte
>>>> xt.refresh(AbstractApplicationContext.java:538)
>>>> at org.springframework.web.context.ContextLoader.configureAndRe
>>>> freshWebApplicationContext(ContextLoader.java:444)
>>>> at org.springframework.web.context.ContextLoader.initWebApplica
>>>> tionContext(ContextLoader.java:326)
>>>> at org.springframework.web.context.ContextLoaderListener.contex
>>>> tInitialized(ContextLoaderListener.java:107)
>>>> at org.apache.catalina.core.StandardContext.listenerStart(Stand
>>>> ardContext.java:5068)
>>>> at org.apache.catalina.core.StandardContext.startInternal(Stand
>>>> ardContext.java:5584)
>>>> at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:147)
>>>> at org.apache.catalina.core.ContainerBase.addChildInternal(Cont
>>>> ainerBase.java:899)
>>>> at org.apache.catalina.core.ContainerBase.addChild(ContainerBas
>>>> e.java:875)
>>>> at org.apache.catalina.core.StandardHost.addChild(StandardHost.
>>>> java:652)
>>>> at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.
>>>> java:1091)
>>>> at org.apache.catalina.startup.HostConfig$DeployWar.run(HostCon
>>>> fig.java:1980)
>>>> at java.util.concurrent.Executors$RunnableAdapter.call(Executor
>>>> s.java:511)
>>>> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
>>>> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPool
>>>> Executor.java:1142)
>>>> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoo
>>>> lExecutor.java:617)
>>>> at java.lang.Thread.run(Thread.java:745)
>>>> Caused by: org.springframework.beans.factory.BeanCreationException:
>>>> Could not autowire field: private org.hisp.dhis.appmanager.AppManager
>>>> org.hisp.dhis.appstore.DefaultAppStoreManager.appManager; nested
>>>> exception is org.springframework.beans.factory.BeanCreationException:
>>>> Error creating bean with name 'org.hisp.dhis.appmanager.AppManager':
>>>> Injection of autowired dependencies failed; nested exception is
>>>> org.springframework.beans.factory.BeanCreationException: Could not
>>>> autowire field: private org.hisp.dhis.setting.SystemSettingManager
>>>> org.hisp.dhis.appmanager.DefaultAppManager.appSettingManager; nested
>>>> exception is org.springframework.beans.factory.BeanCreationException:
>>>> Error creating bean with name 'org.hisp.dhis.setting.SystemSettingManager':
>>>> Injection of autowired dependencies failed; nested exception is
>>>> org.springframework.beans.factory.BeanCreationException: Could not
>>>> autowire field: private org.springframework.transaction.support.TransactionTemplate
>>>> org.hisp.dhis.setting.DefaultSystemSettingManager.transactionTemplate;
>>>> nested exception is org.springframework.beans.factory.BeanCreationException:
>>>> Error creating bean with name 'transactionTemplate' defined in URL
>>>> [jar:file:/home/dhis/tomcat-dhis/webapps/ROOT/WEB-INF/lib/dh
>>>> is-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Cannot
>>>> resolve reference to bean 'transactionManager' while setting bean property
>>>> 'transactionManager'; nested exception is org.springframework.beans.factory.BeanCreationException:
>>>> Error creating bean with name 'transactionManager' defined in URL
>>>> [jar:file:/home/dhis/tomcat-dhis/webapps/ROOT/WEB-INF/lib/dh
>>>> is-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Cannot
>>>> resolve reference to bean 'sessionFactory' while setting bean property
>>>> 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException:
>>>> Error creating bean with name 'sessionFactory' defined in URL
>>>> [jar:file:/home/dhis/tomcat-dhis/webapps/ROOT/WEB-INF/lib/dh
>>>> is-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Invocation of
>>>> init method failed; nested exception is org.hibernate.tool.schema.extr
>>>> act.spi.SchemaExtractionException: More than one table found in
>>>> namespace (, ) : organisationunit
>>>> at org.springframework.beans.factory.annotation.AutowiredAnnota
>>>> tionBeanPostProcessor$AutowiredFieldElement.inject(Autowired
>>>> AnnotationBeanPostProcessor.java:573)
>>>> at org.springframework.beans.factory.annotation.InjectionMetada
>>>> ta.inject(InjectionMetadata.java:88)
>>>> at org.springframework.beans.factory.annotation.AutowiredAnnota
>>>> tionBeanPostProcessor.postProcessPropertyValues(AutowiredAnn
>>>> otationBeanPostProcessor.java:331)
>>>> ... 26 more
>>>> Caused by: org.springframework.beans.factory.BeanCreationException:
>>>> Error creating bean with name 'org.hisp.dhis.appmanager.AppManager':
>>>> Injection of autowired dependencies failed; nested exception is
>>>> org.springframework.beans.factory.BeanCreationException: Could not
>>>> autowire field: private org.hisp.dhis.setting.SystemSettingManager
>>>> org.hisp.dhis.appmanager.DefaultAppManager.appSettingManager; nested
>>>> exception is org.springframework.beans.factory.BeanCreationException:
>>>> Error creating bean with name 'org.hisp.dhis.setting.SystemSettingManager':
>>>> Injection of autowired dependencies failed; nested exception is
>>>> org.springframework.beans.factory.BeanCreationException: Could not
>>>> autowire field: private org.springframework.transaction.support.TransactionTemplate
>>>> org.hisp.dhis.setting.DefaultSystemSettingManager.transactionTemplate;
>>>> nested exception is org.springframework.beans.factory.BeanCreationException:
>>>> Error creating bean with name 'transactionTemplate' defined in URL
>>>> [jar:file:/home/dhis/tomcat-dhis/webapps/ROOT/WEB-INF/lib/dh
>>>> is-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Cannot
>>>> resolve reference to bean 'transactionManager' while setting bean property
>>>> 'transactionManager'; nested exception is org.springframework.beans.factory.BeanCreationException:
>>>> Error creating bean with name 'transactionManager' defined in URL
>>>> [jar:file:/home/dhis/tomcat-dhis/webapps/ROOT/WEB-INF/lib/dh
>>>> is-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Cannot
>>>> resolve reference to bean 'sessionFactory' while setting bean property
>>>> 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException:
>>>> Error creating bean with name 'sessionFactory' defined in URL
>>>> [jar:file:/home/dhis/tomcat-dhis/webapps/ROOT/WEB-INF/lib/dh
>>>> is-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Invocation of
>>>> init method failed; nested exception is org.hibernate.tool.schema.extr
>>>> act.spi.SchemaExtractionException: More than one table found in
>>>> namespace (, ) : organisationunit
>>>> at org.springframework.beans.factory.annotation.AutowiredAnnota
>>>> tionBeanPostProcessor.postProcessPropertyValues(AutowiredAnn
>>>> otationBeanPostProcessor.java:334)
>>>> at org.springframework.beans.factory.support.AbstractAutowireCa
>>>> pableBeanFactory.populateBean(AbstractAutowireCapableBeanFac
>>>> tory.java:1214)
>>>> at org.springframework.beans.factory.support.AbstractAutowireCa
>>>> pableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFac
>>>> tory.java:543)
>>>> at org.springframework.beans.factory.support.AbstractAutowireCa
>>>> pableBeanFactory.createBean(AbstractAutowireCapableBeanFacto
>>>> ry.java:482)
>>>> at org.springframework.beans.factory.support.AbstractBeanFactor
>>>> y$1.getObject(AbstractBeanFactory.java:306)
>>>> at org.springframework.beans.factory.support.DefaultSingletonBe
>>>> anRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
>>>> at org.springframework.beans.factory.support.AbstractBeanFactor
>>>> y.doGetBean(AbstractBeanFactory.java:302)
>>>> at org.springframework.beans.factory.support.AbstractBeanFactor
>>>> y.getBean(AbstractBeanFactory.java:197)
>>>> at org.springframework.beans.factory.support.DefaultListableBea
>>>> nFactory.findAutowireCandidates(DefaultListableBeanFactory.java:1192)
>>>> at org.springframework.beans.factory.support.DefaultListableBea
>>>> nFactory.doResolveDependency(DefaultListableBeanFactory.java:1116)
>>>> at org.springframework.beans.factory.support.DefaultListableBea
>>>> nFactory.resolveDependency(DefaultListableBeanFactory.java:1014)
>>>> at org.springframework.beans.factory.annotation.AutowiredAnnota
>>>> tionBeanPostProcessor$AutowiredFieldElement.inject(Autowired
>>>> AnnotationBeanPostProcessor.java:545)
>>>> ... 28 more
>>>> Caused by: org.springframework.beans.factory.BeanCreationException:
>>>> Could not autowire field: private org.hisp.dhis.setting.SystemSettingManager
>>>> org.hisp.dhis.appmanager.DefaultAppManager.appSettingManager; nested
>>>> exception is org.springframework.beans.factory.BeanCreationException:
>>>> Error creating bean with name 'org.hisp.dhis.setting.SystemSettingManager':
>>>> Injection of autowired dependencies failed; nested exception is
>>>> org.springframework.beans.factory.BeanCreationException: Could not
>>>> autowire field: private org.springframework.transaction.support.TransactionTemplate
>>>> org.hisp.dhis.setting.DefaultSystemSettingManager.transactionTemplate;
>>>> nested exception is org.springframework.beans.factory.BeanCreationException:
>>>> Error creating bean with name 'transactionTemplate' defined in URL
>>>> [jar:file:/home/dhis/tomcat-dhis/webapps/ROOT/WEB-INF/lib/dh
>>>> is-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Cannot
>>>> resolve reference to bean 'transactionManager' while setting bean property
>>>> 'transactionManager'; nested exception is org.springframework.beans.factory.BeanCreationException:
>>>> Error creating bean with name 'transactionManager' defined in URL
>>>> [jar:file:/home/dhis/tomcat-dhis/webapps/ROOT/WEB-INF/lib/dh
>>>> is-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Cannot
>>>> resolve reference to bean 'sessionFactory' while setting bean property
>>>> 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException:
>>>> Error creating bean with name 'sessionFactory' defined in URL
>>>> [jar:file:/home/dhis/tomcat-dhis/webapps/ROOT/WEB-INF/lib/dh
>>>> is-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Invocation of
>>>> init method failed; nested exception is org.hibernate.tool.schema.extr
>>>> act.spi.SchemaExtractionException: More than one table found in
>>>> namespace (, ) : organisationunit
>>>> at org.springframework.beans.factory.annotation.AutowiredAnnota
>>>> tionBeanPostProcessor$AutowiredFieldElement.inject(Autowired
>>>> AnnotationBeanPostProcessor.java:573)
>>>> at org.springframework.beans.factory.annotation.InjectionMetada
>>>> ta.inject(InjectionMetadata.java:88)
>>>> at org.springframework.beans.factory.annotation.AutowiredAnnota
>>>> tionBeanPostProcessor.postProcessPropertyValues(AutowiredAnn
>>>> otationBeanPostProcessor.java:331)
>>>> ... 39 more
>>>> Caused by: org.springframework.beans.factory.BeanCreationException:
>>>> Error creating bean with name 'org.hisp.dhis.setting.SystemSettingManager':
>>>> Injection of autowired dependencies failed; nested exception is
>>>> org.springframework.beans.factory.BeanCreationException: Could not
>>>> autowire field: private org.springframework.transaction.support.TransactionTemplate
>>>> org.hisp.dhis.setting.DefaultSystemSettingManager.transactionTemplate;
>>>> nested exception is org.springframework.beans.factory.BeanCreationException:
>>>> Error creating bean with name 'transactionTemplate' defined in URL
>>>> [jar:file:/home/dhis/tomcat-dhis/webapps/ROOT/WEB-INF/lib/dh
>>>> is-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Cannot
>>>> resolve reference to bean 'transactionManager' while setting bean property
>>>> 'transactionManager'; nested exception is org.springframework.beans.factory.BeanCreationException:
>>>> Error creating bean with name 'transactionManager' defined in URL
>>>> [jar:file:/home/dhis/tomcat-dhis/webapps/ROOT/WEB-INF/lib/dh
>>>> is-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Cannot
>>>> resolve reference to bean 'sessionFactory' while setting bean property
>>>> 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException:
>>>> Error creating bean with name 'sessionFactory' defined in URL
>>>> [jar:file:/home/dhis/tomcat-dhis/webapps/ROOT/WEB-INF/lib/dh
>>>> is-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Invocation of
>>>> init method failed; nested exception is org.hibernate.tool.schema.extr
>>>> act.spi.SchemaExtractionException: More than one table found in
>>>> namespace (, ) : organisationunit
>>>> at org.springframework.beans.factory.annotation.AutowiredAnnota
>>>> tionBeanPostProcessor.postProcessPropertyValues(AutowiredAnn
>>>> otationBeanPostProcessor.java:334)
>>>> at org.springframework.beans.factory.support.AbstractAutowireCa
>>>> pableBeanFactory.populateBean(AbstractAutowireCapableBeanFac
>>>> tory.java:1214)
>>>> at org.springframework.beans.factory.support.AbstractAutowireCa
>>>> pableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFac
>>>> tory.java:543)
>>>> at org.springframework.beans.factory.support.AbstractAutowireCa
>>>> pableBeanFactory.createBean(AbstractAutowireCapableBeanFacto
>>>> ry.java:482)
>>>> at org.springframework.beans.factory.support.AbstractBeanFactor
>>>> y$1.getObject(AbstractBeanFactory.java:306)
>>>> at org.springframework.beans.factory.support.DefaultSingletonBe
>>>> anRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
>>>> at org.springframework.beans.factory.support.AbstractBeanFactor
>>>> y.doGetBean(AbstractBeanFactory.java:302)
>>>> at org.springframework.beans.factory.support.AbstractBeanFactor
>>>> y.getBean(AbstractBeanFactory.java:197)
>>>> at org.springframework.beans.factory.support.DefaultListableBea
>>>> nFactory.findAutowireCandidates(DefaultListableBeanFactory.java:1192)
>>>> at org.springframework.beans.factory.support.DefaultListableBea
>>>> nFactory.doResolveDependency(DefaultListableBeanFactory.java:1116)
>>>> at org.springframework.beans.factory.support.DefaultListableBea
>>>> nFactory.resolveDependency(DefaultListableBeanFactory.java:1014)
>>>> at org.springframework.beans.factory.annotation.AutowiredAnnota
>>>> tionBeanPostProcessor$AutowiredFieldElement.inject(Autowired
>>>> AnnotationBeanPostProcessor.java:545)
>>>> ... 41 more
>>>> Caused by: org.springframework.beans.factory.BeanCreationException:
>>>> Could not autowire field: private org.springframework.transaction.support.TransactionTemplate
>>>> org.hisp.dhis.setting.DefaultSystemSettingManager.transactionTemplate;
>>>> nested exception is org.springframework.beans.factory.BeanCreationException:
>>>> Error creating bean with name 'transactionTemplate' defined in URL
>>>> [jar:file:/home/dhis/tomcat-dhis/webapps/ROOT/WEB-INF/lib/dh
>>>> is-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Cannot
>>>> resolve reference to bean 'transactionManager' while setting bean property
>>>> 'transactionManager'; nested exception is org.springframework.beans.factory.BeanCreationException:
>>>> Error creating bean with name 'transactionManager' defined in URL
>>>> [jar:file:/home/dhis/tomcat-dhis/webapps/ROOT/WEB-INF/lib/dh
>>>> is-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Cannot
>>>> resolve reference to bean 'sessionFactory' while setting bean property
>>>> 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException:
>>>> Error creating bean with name 'sessionFactory' defined in URL
>>>> [jar:file:/home/dhis/tomcat-dhis/webapps/ROOT/WEB-INF/lib/dh
>>>> is-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Invocation of
>>>> init method failed; nested exception is org.hibernate.tool.schema.extr
>>>> act.spi.SchemaExtractionException: More than one table found in
>>>> namespace (, ) : organisationunit
>>>> at org.springframework.beans.factory.annotation.AutowiredAnnota
>>>> tionBeanPostProcessor$AutowiredFieldElement.inject(Autowired
>>>> AnnotationBeanPostProcessor.java:573)
>>>> at org.springframework.beans.factory.annotation.InjectionMetada
>>>> ta.inject(InjectionMetadata.java:88)
>>>> at org.springframework.beans.factory.annotation.AutowiredAnnota
>>>> tionBeanPostProcessor.postProcessPropertyValues(AutowiredAnn
>>>> otationBeanPostProcessor.java:331)
>>>> ... 52 more
>>>> Caused by: org.springframework.beans.factory.BeanCreationException:
>>>> Error creating bean with name 'transactionTemplate' defined in URL
>>>> [jar:file:/home/dhis/tomcat-dhis/webapps/ROOT/WEB-INF/lib/dh
>>>> is-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Cannot
>>>> resolve reference to bean 'transactionManager' while setting bean property
>>>> 'transactionManager'; nested exception is org.springframework.beans.factory.BeanCreationException:
>>>> Error creating bean with name 'transactionManager' defined in URL
>>>> [jar:file:/home/dhis/tomcat-dhis/webapps/ROOT/WEB-INF/lib/dh
>>>> is-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Cannot
>>>> resolve reference to bean 'sessionFactory' while setting bean property
>>>> 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException:
>>>> Error creating bean with name 'sessionFactory' defined in URL
>>>> [jar:file:/home/dhis/tomcat-dhis/webapps/ROOT/WEB-INF/lib/dh
>>>> is-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Invocation of
>>>> init method failed; nested exception is org.hibernate.tool.schema.extr
>>>> act.spi.SchemaExtractionException: More than one table found in
>>>> namespace (, ) : organisationunit
>>>> at org.springframework.beans.factory.support.BeanDefinitionValu
>>>> eResolver.resolveReference(BeanDefinitionValueResolver.java:359)
>>>> at org.springframework.beans.factory.support.BeanDefinitionValu
>>>> eResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
>>>> at org.springframework.beans.factory.support.AbstractAutowireCa
>>>> pableBeanFactory.applyPropertyValues(AbstractAutowireCapable
>>>> BeanFactory.java:1481)
>>>> at org.springframework.beans.factory.support.AbstractAutowireCa
>>>> pableBeanFactory.populateBean(AbstractAutowireCapableBeanFac
>>>> tory.java:1226)
>>>> at org.springframework.beans.factory.support.AbstractAutowireCa
>>>> pableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFac
>>>> tory.java:543)
>>>> at org.springframework.beans.factory.support.AbstractAutowireCa
>>>> pableBeanFactory.createBean(AbstractAutowireCapableBeanFacto
>>>> ry.java:482)
>>>> at org.springframework.beans.factory.support.AbstractBeanFactor
>>>> y$1.getObject(AbstractBeanFactory.java:306)
>>>> at org.springframework.beans.factory.support.DefaultSingletonBe
>>>> anRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
>>>> at org.springframework.beans.factory.support.AbstractBeanFactor
>>>> y.doGetBean(AbstractBeanFactory.java:302)
>>>> at org.springframework.beans.factory.support.AbstractBeanFactor
>>>> y.getBean(AbstractBeanFactory.java:197)
>>>> at org.springframework.beans.factory.support.DefaultListableBea
>>>> nFactory.findAutowireCandidates(DefaultListableBeanFactory.java:1192)
>>>> at org.springframework.beans.factory.support.DefaultListableBea
>>>> nFactory.doResolveDependency(DefaultListableBeanFactory.java:1116)
>>>> at org.springframework.beans.factory.support.DefaultListableBea
>>>> nFactory.resolveDependency(DefaultListableBeanFactory.java:1014)
>>>> at org.springframework.beans.factory.annotation.AutowiredAnnota
>>>> tionBeanPostProcessor$AutowiredFieldElement.inject(Autowired
>>>> AnnotationBeanPostProcessor.java:545)
>>>> ... 54 more
>>>> Caused by: org.springframework.beans.factory.BeanCreationException:
>>>> Error creating bean with name 'transactionManager' defined in URL
>>>> [jar:file:/home/dhis/tomcat-dhis/webapps/ROOT/WEB-INF/lib/dh
>>>> is-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Cannot
>>>> resolve reference to bean 'sessionFactory' while setting bean property
>>>> 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException:
>>>> Error creating bean with name 'sessionFactory' defined in URL
>>>> [jar:file:/home/dhis/tomcat-dhis/webapps/ROOT/WEB-INF/lib/dh
>>>> is-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Invocation of
>>>> init method failed; nested exception is org.hibernate.tool.schema.extr
>>>> act.spi.SchemaExtractionException: More than one table found in
>>>> namespace (, ) : organisationunit
>>>> at org.springframework.beans.factory.support.BeanDefinitionValu
>>>> eResolver.resolveReference(BeanDefinitionValueResolver.java:359)
>>>> at org.springframework.beans.factory.support.BeanDefinitionValu
>>>> eResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
>>>> at org.springframework.beans.factory.support.AbstractAutowireCa
>>>> pableBeanFactory.applyPropertyValues(AbstractAutowireCapable
>>>> BeanFactory.java:1481)
>>>> at org.springframework.beans.factory.support.AbstractAutowireCa
>>>> pableBeanFactory.populateBean(AbstractAutowireCapableBeanFac
>>>> tory.java:1226)
>>>> at org.springframework.beans.factory.support.AbstractAutowireCa
>>>> pableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFac
>>>> tory.java:543)
>>>> at org.springframework.beans.factory.support.AbstractAutowireCa
>>>> pableBeanFactory.createBean(AbstractAutowireCapableBeanFacto
>>>> ry.java:482)
>>>> at org.springframework.beans.factory.support.AbstractBeanFactor
>>>> y$1.getObject(AbstractBeanFactory.java:306)
>>>> at org.springframework.beans.factory.support.DefaultSingletonBe
>>>> anRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
>>>> at org.springframework.beans.factory.support.AbstractBeanFactor
>>>> y.doGetBean(AbstractBeanFactory.java:302)
>>>> at org.springframework.beans.factory.support.AbstractBeanFactor
>>>> y.getBean(AbstractBeanFactory.java:197)
>>>> at org.springframework.beans.factory.support.BeanDefinitionValu
>>>> eResolver.resolveReference(BeanDefinitionValueResolver.java:351)
>>>> ... 67 more
>>>> Caused by: org.springframework.beans.factory.BeanCreationException:
>>>> Error creating bean with name 'sessionFactory' defined in URL
>>>> [jar:file:/home/dhis/tomcat-dhis/webapps/ROOT/WEB-INF/lib/dh
>>>> is-support-hibernate-2.24.jar!/META-INF/dhis/beans.xml]: Invocation of
>>>> init method failed; nested exception is org.hibernate.tool.schema.extr
>>>> act.spi.SchemaExtractionException: More than one table found in
>>>> namespace (, ) : organisationunit
>>>> at org.springframework.beans.factory.support.AbstractAutowireCa
>>>> pableBeanFactory.initializeBean(AbstractAutowireCapableBeanF
>>>> actory.java:1578)
>>>> at org.springframework.beans.factory.support.AbstractAutowireCa
>>>> pableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFac
>>>> tory.java:545)
>>>> at org.springframework.beans.factory.support.AbstractAutowireCa
>>>> pableBeanFactory.createBean(AbstractAutowireCapableBeanFacto
>>>> ry.java:482)
>>>> at org.springframework.beans.factory.support.AbstractBeanFactor
>>>> y$1.getObject(AbstractBeanFactory.java:306)
>>>> at org.springframework.beans.factory.support.DefaultSingletonBe
>>>> anRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
>>>> at org.springframework.beans.factory.support.AbstractBeanFactor
>>>> y.doGetBean(AbstractBeanFactory.java:302)
>>>> at org.springframework.beans.factory.support.AbstractBeanFactor
>>>> y.getBean(AbstractBeanFactory.java:197)
>>>> at org.springframework.beans.factory.support.BeanDefinitionValu
>>>> eResolver.resolveReference(BeanDefinitionValueResolver.java:351)
>>>> ... 77 more
>>>> Caused by: org.hibernate.tool.schema.extract.spi.SchemaExtractionException:
>>>> More than one table found in namespace (, ) : organisationunit
>>>> at org.hibernate.tool.schema.extract.internal.InformationExtrac
>>>> torJdbcDatabaseMetaDataImpl.processGetTableResults(Informati
>>>> onExtractorJdbcDatabaseMetaDataImpl.java:381)
>>>> at org.hibernate.tool.schema.extract.internal.InformationExtrac
>>>> torJdbcDatabaseMetaDataImpl.locateTableInNamespace(Informati
>>>> onExtractorJdbcDatabaseMetaDataImpl.java:346)
>>>> at org.hibernate.tool.schema.extract.internal.InformationExtrac
>>>> torJdbcDatabaseMetaDataImpl.getTable(InformationExtractorJdb
>>>> cDatabaseMetaDataImpl.java:241)
>>>> at org.hibernate.tool.schema.internal.exec.ImprovedDatabaseInfo
>>>> rmationImpl.getTableInformation(ImprovedDatabaseInformationI
>>>> mpl.java:109)
>>>> at org.hibernate.tool.schema.internal.SchemaMigratorImpl.perfor
>>>> mMigration(SchemaMigratorImpl.java:252)
>>>> at org.hibernate.tool.schema.internal.SchemaMigratorImpl.doMigr
>>>> ation(SchemaMigratorImpl.java:137)
>>>> at org.hibernate.tool.schema.internal.SchemaMigratorImpl.doMigr
>>>> ation(SchemaMigratorImpl.java:110)
>>>> at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinato
>>>> r.performDatabaseAction(SchemaManagementToolCoordinator.java:176)
>>>> at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinato
>>>> r.process(SchemaManagementToolCoordinator.java:64)
>>>> at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFact
>>>> oryImpl.java:458)
>>>> at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(
>>>> SessionFactoryBuilderImpl.java:465)
>>>> at org.hibernate.cfg.Configuration.buildSessionFactory(Configur
>>>> ation.java:708)
>>>> at org.hibernate.cfg.Configuration.buildSessionFactory(Configur
>>>> ation.java:724)
>>>> at org.springframework.orm.hibernate5.LocalSessionFactoryBean.b
>>>> uildSessionFactory(LocalSessionFactoryBean.java:416)
>>>> at org.springframework.orm.hibernate5.LocalSessionFactoryBean.a
>>>> fterPropertiesSet(LocalSessionFactoryBean.java:401)
>>>> at org.springframework.beans.factory.support.AbstractAutowireCa
>>>> pableBeanFactory.invokeInitMethods(AbstractAutowireCapableBe
>>>> anFactory.java:1637)
>>>> at org.springframework.beans.factory.support.AbstractAutowireCa
>>>> pableBeanFactory.initializeBean(AbstractAutowireCapableBeanF
>>>> actory.java:1574)
>>>> ... 84 more
>>>> Oct 13, 2016 8:34:33 AM org.apache.catalina.core.StandardContext
>>>> startInternal
>>>> SEVERE: One or more listeners failed to start. Full details will be
>>>> found in the appropriate container log file
>>>> Oct 13, 2016 8:34:33 AM org.apache.catalina.core.StandardContext
>>>> startInternal
>>>> SEVERE: Context [] startup failed due to previous errors
>>>> * INFO  2016-10-13 08:34:33,076 De-registering jdbc driver:
>>>> org.postgresql.Driver@25acca30 (StartupListener.java
>>>> [localhost-startStop-1])
>>>> Oct 13, 2016 8:34:33 AM org.apache.catalina.loader.WebappClassLoaderBase
>>>> clearReferencesThreads
>>>> SEVERE: The web application [] appears to have started a thread named
>>>> [__DEFAULT__] but has failed to stop it. This is very likely to create a
>>>> memory leak.
>>>> Oct 13, 2016 8:34:33 AM org.apache.catalina.loader.WebappClassLoaderBase
>>>> clearReferencesThreads
>>>> SEVERE: The web application [] appears to have started a thread named
>>>> [Statistics Thread-__DEFAULT__-1] but has failed to stop it. This is very
>>>> likely to create a memory leak.
>>>> Oct 13, 2016 8:34:33 AM org.apache.catalina.loader.WebappClassLoaderBase
>>>> checkThreadLocalMapForLeaks
>>>> SEVERE: The web application [] created a ThreadLocal with key of type
>>>> [java.lang.ThreadLocal] (value [java.lang.ThreadLocal@4d8fd5cd]) and a
>>>> value of type [org.hibernate.boot.internal.MetadataImpl] (value
>>>> [org.hibernate.boot.internal.MetadataImpl@30dad794]) but failed to
>>>> remove it when the web application was stopped. Threads are going to be
>>>> renewed over time to try and avoid a probable memory leak.
>>>> Oct 13, 2016 8:34:33 AM org.apache.catalina.startup.HostConfig
>>>> deployWAR
>>>> INFO: Deployment of web application archive
>>>> /home/dhis/tomcat-dhis/webapps/ROOT.war has finished in 26,416 ms
>>>> Oct 13, 2016 8:34:33 AM org.apache.coyote.AbstractProtocol start
>>>> INFO: Starting ProtocolHandler ["http-bio-127.0.0.1-8090"]
>>>> Oct 13, 2016 8:34:33 AM org.apache.catalina.startup.Catalina start
>>>> INFO: Server startup in 26505 ms
>>>>
>>>>
>>>> --
>>>> Jason P. Pickering
>>>> email: 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
>



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

References