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])
_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : [email protected]
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
