← Back to team overview

dhis2-devs team mailing list archive

[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