Hello everyone,
I am trying to install dhis2 version 2.26 in my ubuntu 19.10 server. I have followed Installation Guide. I have install postgresql version 12.1. After everything is setting up I tried to run dhis2. It shows the following errors in log file:
- INFO 2019-12-08 11:18:01,167 Environment variable DHIS2_HOME points to /home/dhis/config (DefaultLocationManager.java [localhost-startStop-1])
- INFO 2019-12-08 11:18:01,205 File /home/dhis/config/dhis-google-auth.json does not exist (DefaultLocationManager.java [localhost-startStop-1])
- INFO 2019-12-08 11:18:01,213 Could not find dhis-google-auth.json (DefaultDhisConfigurationProvider.java [localhost-startStop-1])
- INFO 2019-12-08 11:18:01,214 File /home/dhis/config/dhis-google-auth.json does not exist (DefaultLocationManager.java [localhost-startStop-1])
- INFO 2019-12-08 11:18:01,214 Could not find dhis-google-auth.json (DefaultDhisConfigurationProvider.java [localhost-startStop-1])
- INFO 2019-12-08 11:18:03,410 Hibernate configuration loaded, using dialect: org.hibernate.dialect.PostgreSQL82Dialect (DefaultHibernateConfigurationProvider.java [localhost-startStop-1])
WARN 2019-12-08 11:18:11,240 GenerationTarget encountered exception accepting command : Error executing DDL via JDBC Statement (ExceptionHandlerLoggedImpl.java [localhost-startStop-1])
org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL via JDBC Statement
at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
at org.hibernate.tool.schema.internal.SchemaDropperImpl.applySqlString(SchemaDropperImpl.java:373)
at org.hibernate.tool.schema.internal.SchemaDropperImpl.applySqlStrings(SchemaDropperImpl.java:358)
at org.hibernate.tool.schema.internal.SchemaDropperImpl.applyConstraintDropping(SchemaDropperImpl.java:330)
at org.hibernate.tool.schema.internal.SchemaDropperImpl.dropFromMetadata(SchemaDropperImpl.java:229)
at org.hibernate.tool.schema.internal.SchemaDropperImpl.performDrop(SchemaDropperImpl.java:153)
at org.hibernate.tool.schema.internal.SchemaDropperImpl.doDrop(SchemaDropperImpl.java:125)
at org.hibernate.tool.schema.internal.SchemaDropperImpl.doDrop(SchemaDropperImpl.java:111)
at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:137)
at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:65)
at org.hibernate.internal.SessionFactoryImpl.(SessionFactoryImpl.java:459)
at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:465)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:711)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:727)
at org.springframework.orm.hibernate5.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:511)
at org.springframework.orm.hibernate5.LocalSessionFactoryBean.afterPropertiesSet(LocalSessionFactoryBean.java:495)
you can see full log file in detail from below link
https://drive.google.com/open?id=1DHJkLe6F2rNKSmaVnVb1cESemjAcjOLk
Please help me to install dhis2 2.26 version, its very urgent. `
Thanks in advance!