For that sort of error it’s probably most useful for you to first look in the logs for the webserver (are you using Tomcat?).
It’s easier for us to try and help you if you give a bit more information. For example, what version of DHIS2 are you trying to install? what version of the documentation have you followed, and with which options? what database/version are you using? what operating system and version so you have on your laptop? All of these details can have an impact on the sort of issues you might face when setting up the system.
Thanks for your m3ssage. The android app is still not compatible with 2.32. We are testing the new version nd will be released in a few weeks… but for now you need a server between 2.29 and 2.31 to use the app.
Trying to upgrade an instance from version 2.31.3 to 2.32.0, and throws these errors while running the migration scripts. The instance fails to start. What could be the issue? PostgreSQL version 10
Snapshot of the errors:
* INFO 2019-06-13 10:29:39,106 Hibernate configuration loaded: dialect: 'org.hisp.dhis.hibernate.dialect.DhisPostgresDialect', region factory: 'org.hibernate.cache.ehcache.EhCacheRegionFactory', connection pool max size: 80 (DefaultHibernateConfigurationProvider.java [localhost-startStop-1])
* ERROR 2019-06-13 10:56:26,618 Migration of schema "public" to version 2.32.8 - OrgUnit geometry field failed! Changes successfully rolled back. (Slf4jLog.java [localhost-startStop-1])
* WARN 2019-06-13 10:56:26,624 Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'org.hisp.dhis.security.acl.AclService' defined in URL [jar:file:/var/lib/dhis2/trackerdev/webapps/trackerdev/WEB-INF/lib/dhis-service-acl-2.32.0.jar!/META-INF/dhis/beans.xml]: Unsatisfied dependency expressed through constructor parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'org.hisp.dhis.schema.SchemaService' defined in URL [jar:file:/var/lib/dhis2/trackerdev/webapps/trackerdev/WEB-INF/lib/dhis-service-schema-2.32.0.jar!/META-INF/dhis/beans.xml]: Unsatisfied dependency expressed through constructor parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'org.hisp.dhis.schema.PropertyIntrospectorService': Unsatisfied dependency expressed through field 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flyway' defined in URL [jar:file:/var/lib/dhis2/trackerdev/webapps/trackerdev/WEB-INF/lib/dhis-support-db-migration-2.32.0.jar!/META-INF/dhis/beans.xml]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException:
Migration V2_32_8__OrgUnit_geometry_field.sql failed
----------------------------------------------------
SQL State : XX000
Error Code : 0
Message : ERROR: unexpected character (at offset 31)
Location : org/hisp/dhis/db/migration/2.32/V2_32_8__OrgUnit_geometry_field.sql (/var/lib/dhis2/trackerdev/webapps/file:/var/lib/dhis2/myinstance/webapps/trackerdev/WEB-INF/lib/dhis-support-db-migration-2.32.0.jar!/org/hisp/dhis/db/migration/2.32/V2_32_8__OrgUnit_geometry_field.sql)
Line : 5
Statement : -- update the 'geometry' field with existing data from 'coordinates' column (Point type)
update organisationunit
set geometry = ST_SetSRID(ST_GeomFromGeoJSON('{"type":"Point", "coordinates":' || coordinates || '}'), 4326)
where featuretype = 'POINT'
(AbstractApplicationContext.java [localhost-startStop-1])
…
Caused by: org.flywaydb.core.internal.sqlscript.FlywaySqlScriptException:
Migration V2_32_8__OrgUnit_geometry_field.sql failed
----------------------------------------------------
SQL State : XX000
Error Code : 0
Message : ERROR: unexpected character (at offset 31)
Location : org/hisp/dhis/db/migration/2.32/V2_32_8__OrgUnit_geometry_field.sql (/var/lib/dhis2/trackerdev/webapps/file:/var/lib/dhis2/trackerdev/webapps/trackerdev/WEB-INF/lib/dhis-support-db-migration-2.32.0.jar!/org/hisp/dhis/db/migration/2.32/V2_32_8__OrgUnit_geometry_field.sql)
Line : 5
Statement : -- update the 'geometry' field with existing data from 'coordinates' column (Point type)
update organisationunit
set geometry = ST_SetSRID(ST_GeomFromGeoJSON('{"type":"Point", "coordinates":' || coordinates || '}'), 4326)
where featuretype = 'POINT'
at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.handleException(DefaultSqlScriptExecutor.java:249)
at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.executeStatement(DefaultSqlScriptExecutor.java:202)
at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.execute(DefaultSqlScriptExecutor.java:125)
at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:77)
at org.flywaydb.core.internal.command.DbMigrate.doMigrateGroup(DbMigrate.java:367)
... 92 more
Caused by: org.postgresql.util.PSQLException: ERROR: unexpected character (at offset 31)
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:266)
at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:75)
at org.flywaydb.core.internal.jdbc.JdbcTemplate.executeStatement(JdbcTemplate.java:235)
at org.flywaydb.core.internal.sqlscript.StandardSqlStatement.execute(StandardSqlStatement.java:42)
at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.executeStatement(DefaultSqlScriptExecutor.java:189)
... 95 more
@banga The issue is that the existing data in the coordinates column of organisationunit table is corrupted. It could be just one row that is corrupted or a set of rows. Another user had asked this which is similar , check this thread . Please let us know how it goes and if you need further assistance.
I can confirm that for my, Joe, the functionality is as you are mentioning. I did notice that, along these lines, the app(s) being filtered as you type are not pre-highlighted, nor could they be selected by the arrow keys for quicker access
UPDATE: I just saw that this was already brought up above and that you can select tab to start this no-mouse experience. Works fine for me.
Thanks Philip for your feedback.These are the versions that am using:
apache-tomcat-9.0.21
dhis.war v2.32
jdk-8u211-windows-x64
postgresql-11.4-1-windows-x64
Windows 10
As you are running on windows, I would suggest you first take a look at this thread (Installing DHIS2 on a Windows Local Server) which has several links from the community aimed at running on Windows and avoiding the 404 error.