dhis2-devs team mailing list archive

Thread
Date

DHIS with postgres 9.6

To: dhis2-devs <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
From: Aamer Mohammed <aamerm@xxxxxxxxxxxxxxxx>
Date: Tue, 29 Nov 2016 17:24:49 +0530
Cc: Theo Krommydakis <theo.krommydakis@xxxxxxxxxxxxxx>, twoca <twoca@xxxxxxxxxxxxxxxx>, Claes-Philip Staiger <claes-philip@xxxxxxxxxx>

Hi devs,

We are getting error as attached when using dhis with postgres 9.6. With
9.5 it seems to be working fine. Any ideas?


Thanks
Aamer.

* INFO  2016-11-28 11:06:54,698 System property dhis2.home not set (DefaultLocationManager.java [localhost-startStop-1])
* INFO  2016-11-28 11:06:54,701 Environment variable DHIS2_HOME points to /root/dhis2_home (DefaultLocationManager.java [localhost-startStop-1])
* INFO  2016-11-28 11:06:54,706 File /root/dhis2_home/dhis-google-auth.json does not exist (DefaultLocationManager.java [localhost-startStop-1])
* INFO  2016-11-28 11:06:54,706 Could not find dhis-google-auth.json (DefaultDhisConfigurationProvider.java [localhost-startStop-1])
* INFO  2016-11-28 11:06:54,707 File /root/dhis2_home/dhis-google-auth.json does not exist (DefaultLocationManager.java [localhost-startStop-1])
* INFO  2016-11-28 11:06:54,707 Could not find dhis-google-auth.json (DefaultDhisConfigurationProvider.java [localhost-startStop-1])
* INFO  2016-11-28 11:06:56,064 Hibernate configuration loaded, using dialect: org.hibernate.dialect.PostgreSQLDialect (DefaultHibernateConfigurationProvider.java [localhost-startStop-1])
* WARN  2016-11-28 11:06:57,583 HHH90000003: Use of DOM4J entity-mode is considered deprecated (ModelBinder.java [localhost-startStop-1])
* WARN  2016-11-28 11:06:57,584 HHH90000003: Use of DOM4J entity-mode is considered deprecated (ModelBinder.java [localhost-startStop-1])
* WARN  2016-11-28 11:06:57,584 HHH90000003: Use of DOM4J entity-mode is considered deprecated (ModelBinder.java [localhost-startStop-1])
* WARN  2016-11-28 11:06:57,584 HHH90000003: Use of DOM4J entity-mode is considered deprecated (ModelBinder.java [localhost-startStop-1])
* WARN  2016-11-28 11:06:57,609 HHH90000003: Use of DOM4J entity-mode is considered deprecated (ModelBinder.java [localhost-startStop-1])
* WARN  2016-11-28 11:06:57,610 HHH90000003: Use of DOM4J entity-mode is considered deprecated (ModelBinder.java [localhost-startStop-1])
* WARN  2016-11-28 11:06:57,639 HHH90000003: Use of DOM4J entity-mode is considered deprecated (ModelBinder.java [localhost-startStop-1])
* WARN  2016-11-28 11:06:57,652 HHH90000003: Use of DOM4J entity-mode is considered deprecated (ModelBinder.java [localhost-startStop-1])
* WARN  2016-11-28 11:06:57,652 HHH90000003: Use of DOM4J entity-mode is considered deprecated (ModelBinder.java [localhost-startStop-1])
* WARN  2016-11-28 11:06:57,670 HHH90000003: Use of DOM4J entity-mode is considered deprecated (ModelBinder.java [localhost-startStop-1])
* WARN  2016-11-28 11:06:57,670 HHH90000003: Use of DOM4J entity-mode is considered deprecated (ModelBinder.java [localhost-startStop-1])
* WARN  2016-11-28 11:06:57,671 HHH90000003: Use of DOM4J entity-mode is considered deprecated (ModelBinder.java [localhost-startStop-1])
* WARN  2016-11-28 11:06:57,671 HHH90000003: Use of DOM4J entity-mode is considered deprecated (ModelBinder.java [localhost-startStop-1])
* WARN  2016-11-28 11:06:57,672 HHH90000003: Use of DOM4J entity-mode is considered deprecated (ModelBinder.java [localhost-startStop-1])
* WARN  2016-11-28 11:07:08,355 SQL Error: 0, SQLState: 42703 (SqlExceptionHelper.java [localhost-startStop-1])
* ERROR 2016-11-28 11:07:08,356 ERROR: column am.amcanorder does not exist
  Position: 427 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2016-11-28 11:07:08,361 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:/opt/apache-tomcat-8.5.6/webapps/ROOT/WEB-INF/lib/dhis-support-hibernate-2.25.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:/opt/apache-tomcat-8.5.6/webapps/ROOT/WEB-INF/lib/dhis-support-hibernate-2.25.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:/opt/apache-tomcat-8.5.6/webapps/ROOT/WEB-INF/lib/dhis-support-hibernate-2.25.jar!/META-INF/dhis/beans.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: Error accessing index information: public.attribute (AbstractApplicationContext.java [localhost-startStop-1])
* ERROR 2016-11-28 11:07:08,401 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:/opt/apache-tomcat-8.5.6/webapps/ROOT/WEB-INF/lib/dhis-support-hibernate-2.25.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:/opt/apache-tomcat-8.5.6/webapps/ROOT/WEB-INF/lib/dhis-support-hibernate-2.25.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:/opt/apache-tomcat-8.5.6/webapps/ROOT/WEB-INF/lib/dhis-support-hibernate-2.25.jar!/META-INF/dhis/beans.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: Error accessing index information: public.attribute
	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:4727)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5189)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:724)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:700)
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
	at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:952)
	at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1823)
	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:/opt/apache-tomcat-8.5.6/webapps/ROOT/WEB-INF/lib/dhis-support-hibernate-2.25.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:/opt/apache-tomcat-8.5.6/webapps/ROOT/WEB-INF/lib/dhis-support-hibernate-2.25.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:/opt/apache-tomcat-8.5.6/webapps/ROOT/WEB-INF/lib/dhis-support-hibernate-2.25.jar!/META-INF/dhis/beans.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: Error accessing index information: public.attribute
	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:/opt/apache-tomcat-8.5.6/webapps/ROOT/WEB-INF/lib/dhis-support-hibernate-2.25.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:/opt/apache-tomcat-8.5.6/webapps/ROOT/WEB-INF/lib/dhis-support-hibernate-2.25.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:/opt/apache-tomcat-8.5.6/webapps/ROOT/WEB-INF/lib/dhis-support-hibernate-2.25.jar!/META-INF/dhis/beans.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: Error accessing index information: public.attribute
	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:/opt/apache-tomcat-8.5.6/webapps/ROOT/WEB-INF/lib/dhis-support-hibernate-2.25.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:/opt/apache-tomcat-8.5.6/webapps/ROOT/WEB-INF/lib/dhis-support-hibernate-2.25.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:/opt/apache-tomcat-8.5.6/webapps/ROOT/WEB-INF/lib/dhis-support-hibernate-2.25.jar!/META-INF/dhis/beans.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: Error accessing index information: public.attribute
	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:/opt/apache-tomcat-8.5.6/webapps/ROOT/WEB-INF/lib/dhis-support-hibernate-2.25.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:/opt/apache-tomcat-8.5.6/webapps/ROOT/WEB-INF/lib/dhis-support-hibernate-2.25.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:/opt/apache-tomcat-8.5.6/webapps/ROOT/WEB-INF/lib/dhis-support-hibernate-2.25.jar!/META-INF/dhis/beans.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: Error accessing index information: public.attribute
	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:/opt/apache-tomcat-8.5.6/webapps/ROOT/WEB-INF/lib/dhis-support-hibernate-2.25.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:/opt/apache-tomcat-8.5.6/webapps/ROOT/WEB-INF/lib/dhis-support-hibernate-2.25.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:/opt/apache-tomcat-8.5.6/webapps/ROOT/WEB-INF/lib/dhis-support-hibernate-2.25.jar!/META-INF/dhis/beans.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: Error accessing index information: public.attribute
	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:/opt/apache-tomcat-8.5.6/webapps/ROOT/WEB-INF/lib/dhis-support-hibernate-2.25.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:/opt/apache-tomcat-8.5.6/webapps/ROOT/WEB-INF/lib/dhis-support-hibernate-2.25.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:/opt/apache-tomcat-8.5.6/webapps/ROOT/WEB-INF/lib/dhis-support-hibernate-2.25.jar!/META-INF/dhis/beans.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: Error accessing index information: public.attribute
	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:/opt/apache-tomcat-8.5.6/webapps/ROOT/WEB-INF/lib/dhis-support-hibernate-2.25.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:/opt/apache-tomcat-8.5.6/webapps/ROOT/WEB-INF/lib/dhis-support-hibernate-2.25.jar!/META-INF/dhis/beans.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: Error accessing index information: public.attribute
	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:/opt/apache-tomcat-8.5.6/webapps/ROOT/WEB-INF/lib/dhis-support-hibernate-2.25.jar!/META-INF/dhis/beans.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: Error accessing index information: public.attribute
	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.exception.SQLGrammarException: Error accessing index information: public.attribute
	at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:106)
	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)
	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)
	at org.hibernate.tool.schema.extract.internal.InformationExtractorJdbcDatabaseMetaDataImpl.convertSQLException(InformationExtractorJdbcDatabaseMetaDataImpl.java:99)
	at org.hibernate.tool.schema.extract.internal.InformationExtractorJdbcDatabaseMetaDataImpl.getIndexes(InformationExtractorJdbcDatabaseMetaDataImpl.java:609)
	at org.hibernate.tool.schema.extract.internal.TableInformationImpl.indexes(TableInformationImpl.java:110)
	at org.hibernate.tool.schema.extract.internal.TableInformationImpl.getIndex(TableInformationImpl.java:121)
	at org.hibernate.tool.schema.internal.SchemaMigratorImpl.applyUniqueKeys(SchemaMigratorImpl.java:437)
	at org.hibernate.tool.schema.internal.SchemaMigratorImpl.performMigration(SchemaMigratorImpl.java:278)
	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.SchemaManagementToolCoordinator.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
Caused by: org.postgresql.util.PSQLException: ERROR: column am.amcanorder does not exist
  Position: 427
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2284)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2003)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:200)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:424)
	at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:321)
	at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:284)
	at org.postgresql.jdbc.PgDatabaseMetaData.getIndexInfo(PgDatabaseMetaData.java:2948)
	at com.mchange.v2.c3p0.impl.NewProxyDatabaseMetaData.getIndexInfo(NewProxyDatabaseMetaData.java:3166)
	at org.hibernate.tool.schema.extract.internal.InformationExtractorJdbcDatabaseMetaDataImpl.getIndexes(InformationExtractorJdbcDatabaseMetaDataImpl.java:567)
	... 100 more
* INFO  2016-11-28 11:07:08,448 De-registering jdbc driver: org.postgresql.Driver@21bd591 (StartupListener.java [localhost-startStop-1])

Follow ups

Re: DHIS with postgres 9.6
From: Morten Olav Hansen, 2016-11-29
Re: DHIS with postgres 9.6
From: Knut Staring, 2016-11-29