dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #41513
[Bug 1518380] Re: upgrade to 2.21 database error and how we solved it
Better is the following, fixed it in our case
UPDATE dataelement set aggregationtype = 'AVERAGE' where aggregationtype
= 'AVG';
--
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1518380
Title:
upgrade to 2.21 database error and how we solved it
Status in DHIS:
New
Bug description:
When changing the dhis.war file from 2.20 to 2.21 we received a database error message related to AVG aggregation type. We could not even go into dhis2 anymore.
We solved it by going back to 2.20 restoring the database and doing an update sql statement on table dataelement and setting aggregationtype to 'SUM' after that we did the upgrade again to 2.21 and now it went fine.
relevant part of the error message was:
* ERROR 2015-11-20 16:42:02,919 java.lang.IllegalArgumentException: Unknown name value [AVG] for enum class [org.hisp.dhis.analytics.AggregationType]
at org.hibernate.type.EnumType$NamedEnumValueMapper.fromName(EnumType.java:467)
at org.hibernate.type.EnumType$NamedEnumValueMapper.getValue(EnumType.java:452)
at org.hibernate.type.EnumType.nullSafeGet(EnumType.java:107)
.....
Hope this is any usefull
To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1518380/+subscriptions
References