: Problem starting DHIS@ using sample PostgreSQL db - HTTP ERROR: 503 I downloaded the dhis2-db-sierra-leone.sql db and imported it into PostreSQL 9.4 running on Windows 8.1. I have configured the
I downloaded the dhis2-db-sierra-leone.sql db and imported it into PostreSQL 9.4 running on Windows 8.1. I have configured the dhis.conf as:
#hibernate .dialect = org.hibernate.dialect.H2Dialect #hibernate .connection.driver_class = org.h2.Driver #hibernate .connection.url = jdbc:h2:./database/dhis2;AUTO_SERVER=TRUE;DB_CLOSE_ON_EXIT=FALSE
#hibernate.connection.username = sa
#hibernate.connection.password =
hibernate.dialect = org.hibernate.dialect.PostgreSQLDialect
hibernate.connection.driver_class = org.postgresql.Driver
hibernate.connection.url = jdbc:postgresql:dhis2
hibernate.connection.username = dhis
hibernate.connection.password = dhis
hibernate.hbm2ddl.auto = update
When I run the start I get 503 error:
HTTP ERROR: 503
Problem accessing /. Reason:
Service Unavailable
Powered by Jetty://
In the log file, I'm getting this:
* INFO 2016-12-22 15:27:01,449 'system-process' update org.hisp.dhis.dataelement.DataElementCategory, name: default, uid: vGs6omsRekv (AuditLogUtil.java [Thread-2])
* ERROR 2016-12-22 15:27:01,544 java.lang.IllegalArgumentException: Unknown name value [ORGANISATION_UNIT] for enum class [org.hisp.dhis.common.ValueType]
at org.hibernate.type.EnumType$NamedEnumValueMapper.fromName(EnumType.java:433)
Any ideas?
More posts by @Jamie184
1 Comments
Sorted by latest first Latest Oldest Best
You have an invalid value in the "dataelement" and/or "trackedentityattribute" tables for the valuetype column. The valid values are these:
TEXT
LONG_TEXT,
LETTER,
PHONE_NUMBER,
EMAIL,
BOOLEAN,
TRUE_ONLY,
DATE,
DATETIME,
TIME,
NUMBER,
UNIT_INTERVAL,
PERCENTAGE,
INTEGER,
INTEGER_POSITIVE,
INTEGER_NEGATIVE,
INTEGER_ZERO_OR_POSITIVE,
TRACKER_ASSOCIATE,
USERNAME,
FILE_RESOURCE,
COORDINATE,
ORGANISATION_UNIT,
AGE
Replace all values which are not among these.
Terms of Use Create Support ticket Your support tickets Stock Market News! © vmapp.org2024 All Rights reserved.